set_charset("utf8");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Escape user inputs for security
// $name = $conn->real_escape_string($_REQUEST['name']); // Helyett:
$name = $_REQUEST['name'];
// find record in table
$sql = "SELECT memberid, name, levelofmember FROM videos.members WHERE name LIKE '%".$name."%'";
// $result = $conn->query($sql);
// $results = $conn->multi_query($sql);
echo "Keresési minta: %". $name. "%
";
echo "Az elküldött utasítás: ".$sql."
";
// execute multi_query
if ($conn->multi_query($sql)) {
do {
// store first result set
if ($result = $conn->use_result()) {
while ($row = $result->fetch_assoc()) {
echo "id: " . $row["memberid"]. " - Name: " . $row["name"]. " - Level: " . $row["levelofmember"]. "
";
}
$result->free();
}
// print divider
if ($conn->more_results()) {
echo "
";
}
} while ($conn->next_result());
}
// Close connection
$conn->close();
?>