function search($search, $db, $type) { $functies = getHints($search, $db); $querys = array(); if ($type == "R") { foreach ($functies as $functie) { $querys[] = "SELECT * FROM Resources_goed WHERE Functies = (SELECT ID FROM Picklist WHERE functie LIKE \"" . $functie . "\")"; //echo "SELECT * FROM Resources_goed WHERE Functies = (SELECT ID FROM Picklist WHERE functie LIKE \"" . $functie . "\")"; } } else { //echo "Projects"; $Picklist = getPicklist($db); while (list($id, $functie) = mysql_fetch_row($Picklist)) { if (stristr($search, substr($functie, 0, strlen($search))) && strlen($functie) >= strlen($search)) { $query = "SELECT * FROM projecten INNER JOIN functies ON ID = functie_ID WHERE "; for ($i = 1; $i <= 10; $i++) { if ($i != 10) { $query .= "Functie{$i} = {$id} OR "; } else { $query .= "Functie{$i} = {$id}"; } } $querys[] = $query; //echo $query; } } } $results = array(); foreach ($querys as $query) { if (!($result = mysql_query($query, $db))) { echo "Error in query {$query}"; } else { $results[] = $result; //echo $result; } } return $results; }
<?php include_once "db_connect.inc.php"; include_once "searchHelper.php"; $request = $_REQUEST["search"]; $type = $_REQUEST["type"]; if (isset($_REQUEST["search"])) { $return = array(); //Geef een array terug van de namen waar de zoekstring in voorkomt als een javascript object (json, anders kan jquery het niet begrijpen) if ($request != "") { $return[0] = getHints($request, $db); $return[1] = getCount($request, $db, $type); } else { $return[0] = array(); $return[1] = 0; } echo json_encode($return); } function getHints($search, $db) { $hints = array(); $search = strtolower($search); $len = strlen($search); //$query = "SELECT * FROM Picklist"; //$query = "SELECT * FROM picklist WHERE funtie LIKE '$search'"; $result = ""; if (!($result = getPicklist($db))) { echo "Fout in query"; //echo $db; } else { $i = 0;