PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE City ( Name VARCHAR(64), District VARCHAR(64) ); INSERT INTO City VALUES ('Aachen', 'Nordrhein-Westfalen'), ('Augsburg', 'Baijeri'), ('Bergisch Gladbach', 'Nordrhein-Westfalen'), ('Berlin', 'Berliini'), ('Bielefeld', 'Nordrhein-Westfalen');
Copy Clear
Copy Format Clear
<?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]); $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"; }
Show:  
Copy Clear