PHPize Online / SQLize Online  /  SQLtest Online

<?php //https://dev.to/rozhnev/new-in-php-82-mysqliexecutequery-mysqliexecutequery-4g2h //https://phpize.online/sql/mysql57/aa112b7fe80016d72860c6346cd2a3e6/php/php82/8975cd8ea679e87b07fd99d23f885b3c //https://stackoverflow.com/questions/14624509/single-result-from-database-using-mysqli $a = "Aachen"; $b = "nordrhein-Westfalen"; $query = "SELECT * FROM City WHERE Name=? AND District=? ORDER BY Name LIMIT 5"; //$data = $mysqli->execute_query($query, [$a, $b]); $data = mysqli_query($query, "SELECT * FROM City WHERE Name = 'Aachen' ORDER BY NAME LIMIT 5"); $num_rows = mysqli_num_rows($data); echo "num_rows: " . $num_rows . "\n"; //single result $row = mysqli_fetch_assoc($data); $name = $row['Name']; echo $name . "\n"; echo "Result set has " . $num_rows . " rows\n"; printf("Result set has %d rows.\n", $num_rows); foreach ($data as $row) { //printf("%s \n", $row["Name"]); $name = $row["Name"]; $district = $row['District']; echo $name . "\n"; echo $district . "\n"; }