*************

SQL code: Upload 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');

SQL Server: Preserve result

Result: Copy Clear

PHP code: 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"; }

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online