Ukazka k php
Vyhledavani
Home
Write
hledani ";
$search_select = $_GET["search_select"];
$search_text = $_GET["search_text"];
//provedu upraveny příkaz pro vyhledaávání
//$sql = "SELECT * FROM mock_data_doucko WHERE $search_select='$search_text'";
$sql = "SELECT * FROM mock_data_doucko WHERE $search_select LIKE '$search_text%'";
echo $sql;
}
// querry -> vykoná SQL příkaz uložený v proměnné $sql
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// vypis pro tabulku pokud neni prázdná
echo '
';
echo "";
echo " ";
echo ' | # | ';
echo ' First | ';
echo ' Last | ';
echo ' E-mail | ';
echo ' Gender | ';
echo ' IP-adress | ';
echo ' status | ';
echo "
";
echo "";
echo "";
;
//vypis pro každý záznam
while($row = mysqli_fetch_assoc($result)) {
// echo $row["id"];
$testik= $row["last_name"];
if(substr($testik, 0, 1 ) === "M") {
echo '';
} else {
echo "
";
}
echo '| '.$row["id"].' | ';
echo "". $row["first_name"] . " | ";
echo "". $row["last_name"] . " | ";
echo "". $row["email"] . " | ";
//echo "". $row["gender"] . " | ";
if ($row["gender"] != "Male" && $row["gender"] != "Female") {
echo ''. $row["gender"] . " | ";
} else {
echo "". $row["gender"] . " | ";
}
echo "". $row["ip_address"] . " | ";
// echo "". $row["status"] . " | ";
if ($row["status"] == "Available") {
echo ''. $row["status"] . " | ";
}
elseif ($row["status"] == "do not distrurb") {
echo ''. $row["status"] . " | ";
}
elseif ($row["status"] == "busy") {
echo ''. $row["status"] . " | ";
}
elseif ($row["status"] == "offline") {
echo ''. $row["status"] . " | ";
} else {
echo "". $row["status"] . " | ";
}
echo"
";
}
echo "
";
} else {
echo "0 results";
}
mysqli_close($conn);
?>