Aggiornato al = conv_date($rUpdate[0]);?>, ad oggi siamo = $rTotal[0];?> iscritti
">
1){
$query="WHERE (";
foreach($keys as $k=>$value){
if($k>0){$query .= " OR";}
$query .= " first_name LIKE '%$value%' ";
}
$query .= " OR first_name LIKE '%".addslashes($_POST['q'])."%' OR last_name LIKE '%".addslashes($_POST['q'])."%') AND (";
foreach($keys as $k=>$value){
if($k>0){$query .= " OR";}
$query .= " last_name LIKE '%$value%' ";
}
$query .= ") ";
}else{
$query="WHERE first_name LIKE '%".$keys[0]."%' OR last_name LIKE '%".$keys[0]."%'";
}
$q = mysqli_query($conn, "SELECT * FROM board $query ORDER BY last_name");
}
if($getQ[1]=="details"){
$q = mysqli_query($conn, "SELECT * FROM board WHERE id=".$getQ[2]."");
$r = mysqli_fetch_array($q);
?>
= $r['last_name']." ".$r['first_name'];?>
N° iscrizione = $r['id'];?>
Nato/a il = $r['birth_date'];?> a = $r['birth_place'];?>
Iscritto/a il = $r['register_date'];?>
Laurea in = $r['degree'];?> il = $r['degree_date'];?> a = $r['degree_place'];?>
Abilitato/a nel = $r['qualification_date'];?> presso = $r['qualification_place'];?>
".$r['last_name']." ".$r['first_name']." ";
}
}
?>