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;
