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(); ?>