query("SELECT COUNT(*) FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1'")->fetchColumn(); $limit = 8; //tutoren pro seite $pages = ceil($total / $limit); //seitenanzahl $page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array('options' => array('default' => 1, 'min_range' => 1,),)));//auf welcher seite sind wir jetzt $offset = ($page - 1) * $limit; $start = $offset + 1; $end = min(($offset + $limit), $total); if($_GET['sort'] === "preisn"){ $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `preis` ASC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "preish"){ $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `preis` DESC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "neu") { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `erstellt` DESC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "alt") { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `erstellt` ASC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "top"){ $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "not") { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` ASC LIMIT :limit OFFSET :offset"); } else { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` DESC LIMIT :limit OFFSET :offset"); } $sql->bindParam(':limit', $limit, PDO::PARAM_INT); $sql->bindParam(':offset', $offset, PDO::PARAM_INT); $sql->execute(); if($sql->rowCount() > 0){ while($row = $sql->fetchObject()){ ?>

"; } ?>

name." ".$row->nachname[0].".";?>

prepare("SELECT COUNT(punkte) AS punkteANZ FROM bewertungen WHERE user_id = :uid AND submit = '1'"); $sqlANZ->bindParam(':uid', $row->id); $sqlANZ->execute(); $rowANZ = $sqlANZ->fetchObject(); if(!empty($rowANZ->punkteANZ)){ $sqlADD = $pdo->prepare("SELECT SUM(punkte) AS punkteADD FROM bewertungen WHERE user_id = :uid AND submit = '1'"); $sqlADD->bindParam(':uid', $row->id); $sqlADD->execute(); $rowADD = $sqlADD->fetchObject(); $bewertung = round(($rowADD->punkteADD)/($rowANZ->punkteANZ)); ?>

preis; ?>€ pro Stunde

geb); $heute = new DateTime(); $differenz = $heute->diff($gb); $alter = $differenz->y; echo $alter; ?> Jahre alt

fach); $fachX = explode(", ", $abkz_fach); $fach_unique = array_unique($fachX); $fach_array = array_values($fach_unique); $fach_count = count($fach_array); if($fach_count===1){ echo $fach_array[0]; } elseif($fach_count===2){ echo $fach_array[0]." und ".$fach_array[1]; } elseif($fach_count===3){ echo $fach_array[0].", "; echo $fach_array[1]." und "; echo $fach_array[2]; } elseif($fach_count>=4){ echo $fach_array[0].", "; echo $fach_array[1].", "; echo $fach_array[2]." +"; echo $fach_count-3; } ?>

"; //closing projects row echo "

"; //closing container echo "

"; //closing projects-horizontal $prevlink = ($page > 1) ? '« ‹' : '« ‹'; // The "forward" link $nextlink = ($page < $pages) ? '› »' : '› »'; if($total > 8){ echo"

Seite ".$page." von ".$pages."
".$start."-".$end." von ".$total." Tutoren

"; } else { echo"

".$start."-".$end." von ".$total." Tutoren

Leider sind für deine Kriterien noch keine Tutoren tätig

query("SELECT COUNT(*) FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1'")->fetchColumn(); $limit = 8; //tutoren pro seite $pages = ceil($total / $limit); //seitenanzahl $page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array('options' => array('default' => 1, 'min_range' => 1,),)));//auf welcher seite sind wir jetzt $offset = ($page - 1) * $limit; $start = $offset + 1; $end = min(($offset + $limit), $total); if($_GET['sort'] === "preisn"){ $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `preis` ASC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "preish"){ $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `preis` DESC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "neu") { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `erstellt` DESC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "alt") { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `erstellt` ASC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "top"){ $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "not") { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` ASC LIMIT :limit OFFSET :offset"); } else { $sql = $pdo->prepare("SELECT * FROM user WHERE fach LIKE '%$sFach%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` DESC LIMIT :limit OFFSET :offset"); } $sql->bindParam(':limit', $limit, PDO::PARAM_INT); $sql->bindParam(':offset', $offset, PDO::PARAM_INT); $sql->execute(); if ($sql->rowCount() > 0) { while($row = $sql->fetchObject()){ ?>

img)){echo "

";} else{echo "

";} ?>

name." ".$row->nachname[0].".";?>

preis; ?>€ pro Stunde

geb); $heute = new DateTime(); $differenz = $heute->diff($gb); $alter = $differenz->y; echo $alter; ?> Jahre alt

"; //closing projects row echo "

"; //closing container echo "

"; //closing projects-horizontal $prevlink = ($page > 1) ? '« ‹' : '« ‹'; // The "forward" link $nextlink = ($page < $pages) ? '› »' : '› »'; if($total > 8){ echo"

Seite ".$page." von ".$pages."
".$start."-".$end." von ".$total." Tutoren

"; } else { echo"

".$start."-".$end." von ".$total." Tutoren

Leider keine Ergebnisse

query("SELECT COUNT(*) FROM user WHERE ort LIKE '%$sOrt%' AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1'")->fetchColumn(); $limit = 8; //tutoren pro seite $pages = ceil($total / $limit); //seitenanzahl $page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array('options' => array('default' => 1, 'min_range' => 1,),)));//auf welcher seite sind wir jetzt $offset = ($page - 1) * $limit; $start = $offset + 1; $end = min(($offset + $limit), $total); if($_GET['sort'] === "preisn"){ $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `preis` ASC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "preish"){ $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `preis` DESC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "neu") { $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `erstellt` DESC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "alt") { $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `erstellt` ASC, `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "top"){ $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` DESC LIMIT :limit OFFSET :offset"); } elseif($_GET['sort'] === "not") { $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` ASC LIMIT :limit OFFSET :offset"); } else { $sql = $pdo->prepare("SELECT * FROM user WHERE ort LIKE '%$sOrt%' AND `fach` IS NOT NULL AND `preis` IS NOT NULL AND `preis` != '' AND `ort` IS NOT NULL AND `fach` IS NOT NULL AND `fach` != '' AND `img` IS NOT NULL AND `img` != '' AND `bio` IS NOT NULL AND `bio` != '' AND `geb` != '0000-00-00' AND `active` = '1' ORDER BY `bewertung` DESC LIMIT :limit OFFSET :offset"); } $sql->bindParam(':limit', $limit, PDO::PARAM_INT); $sql->bindParam(':offset', $offset, PDO::PARAM_INT); $sql->execute(); if($sql->rowCount() > 0){ while($row = $sql->fetchObject()){ ?>

img)){echo "

";} else{echo "

";} ?>

name." ".$row->nachname[0].".";?>

preis; ?>€ pro Stunde

geb); $heute = new DateTime(); $differenz = $heute->diff($gb); $alter = $differenz->y; echo $alter; ?> Jahre alt

"; //closing projects row echo "

"; //closing container echo "

"; //closing projects-horizontal $prevlink = ($page > 1) ? '« ‹' : '« ‹'; // The "forward" link $nextlink = ($page < $pages) ? '› »' : '› »'; if($total > 8){ echo"

Seite ".$page." von ".$pages."
".$start."-".$end." von ".$total." Tutoren

"; } else { echo"

".$start."-".$end." von ".$total." Tutoren

Leider keine Ergebnisse

Finde private Nachhilfe
in deiner Nähe!

Mit Tutoro ganz einfach und schnell Hilfe in diversen Fachbereichen finden!

🏎

Schnelle Suche

Mit Tutoro findest du innerhalb von Sekunden private Nachhilfe, die sich lohnt!

⚙

Stets in Bearbeitung

Tutoro ist stets bemüht, sich zu verbessern und weiterzuentwickeln, um den bestmöglichen Service zu gewährleisten.

🤝

Einfacher Kontakt

Du kannst jederzeit und direkt über unsere Homepage Kontakt mit Tutoren aufnehmen. Diese sind angehalten, sich innerhalb kurzer Zeit bei dir zurückzumelden.

✔

Geprüft

Gelistete Tutoren müssen alle erforderlichen Informationen veröffentlichen, um bei der Suche angezeigt zu werden.

⭐

Bewertungssystem

Durch ein intelligentes Bewertungssystem können alle Tutoren von ihren SchülerInnen bewertet werden.

👍

Unterstütze uns

Dir gefällt Tutoro? Dann hilf uns doch und like/teile unsere Seite auf den sozialen Netzwerken. Danke!

Tutoren in ".htmlspecialchars($_REQUEST['ort'])."

".htmlspecialchars(substr($_REQUEST['fach'],4))." Tutoren

Finde deinen Tutor

name." ".$row->nachname[0].".";?>

Leider sind für deine Kriterien noch keine Tutoren tätig

name." ".$row->nachname[0].".";?>

Leider keine Ergebnisse

name." ".$row->nachname[0].".";?>

Leider keine Ergebnisse

Finde private Nachhilfe
in deiner Nähe!

Schnelle Suche

Stets in Bearbeitung

Einfacher Kontakt

Geprüft

Bewertungssystem

Unterstütze uns

Tutoren in ".htmlspecialchars($_REQUEST['ort'])."

".htmlspecialchars(substr($_REQUEST['fach'],4))." Tutoren

Finde deinen Tutor

name." ".$row->nachname[0].".";?>

Leider sind für deine Kriterien noch keine Tutoren tätig

name." ".$row->nachname[0].".";?>

Leider keine Ergebnisse

name." ".$row->nachname[0].".";?>

Leider keine Ergebnisse

Finde private Nachhilfe in deiner Nähe!

Schnelle Suche

Stets in Bearbeitung

Einfacher Kontakt

Geprüft

Bewertungssystem

Unterstütze uns

Finde private Nachhilfe
in deiner Nähe!