.-.-.-.-.-

<?php
require_once 'DAO/DBConnection.php';
require_once 'DAO/settings.config.php';
require_once 'DAO/suspect.php';
try {
 $database = new DBConnection($config);
 $suspectObj = new Suspect($database);
 //echo "post ";
 //print_r($_POST);
 //echo "get ";
 //print_r($_GET);

//dataService.php
 //if (isset($_GET["search"])) {
 //$connect = mysqli_connect("localhost", "root", "", "testing");
 //$request = mysqli_real_escape_string($connect, $_POST["query"]);
 $query = strip_tags($_GET["search"] ?? '');
 $limit = strip_tags($_GET["limit"] ?? 10);
 $offset = strip_tags($_GET["offset"] ?? 0);
 $order = strip_tags($_GET['order'] ?? '');
 $sort = strip_tags($_GET['sort'] ?? '');
 //echo '$query = '.$query.' ';
 //echo '$limit = '.$limit.' ';
 //echo '$offset = '.$offset.' ';
 //echo '$order = '.$order.' ';
 //echo '$sort = '.$sort.' ';

$result = $suspectObj->getSuspectsByQuery($query, $limit, $offset, $order, $sort);
 $count = $suspectObj->getTotalSuspects();
 //print_r($result);
 $data =array();
 $returnresult =array();
 $returnresult = ['totalNotFiltered' => (int)$count, 'total' => count($result)];
 $rows =array();
 if (count($result) > 0) {
 foreach ($result as $row) {
 $data = ["Vorname" => $row["Vorname"],
 "Nachname" => $row["Nachname"],
 "Titel" => $row["Titel"],
 "Beruf" => $row["Beruf"],
 "Strasse" => $row["Strasse"],
 "PLZ" => $row["PLZ"],
 "Ort" => $row["Ort"],
 "Tel-Nr" => $row["Tel-Nr"],
 "Kanton" => $row["Kanton"]] ;
 array_push($rows, $data);
 }
 $returnresult += ['rows' => $rows];
 } else {
 $data = 'No Data Found';
 }
 //print_r($data);
 //$rows = array_unique($rows);
 //echo "count = ".$count.' ';
 //$test = json_encode($returnresult);
 //print_r($returnresult);
 //echo ' ';
 //echo $test.' ';
 echo json_encode($returnresult, JSON_UNESCAPED_UNICODE);

} catch (\Throwable $e) {
 echo 'error : '.$e.' ';
}
//}
//else {
// echo 'search not set';
//}

/home/wirbesti/.cache/../nuernberg2punkt0.ch/src/dataService.php