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 $args = [ 'SELECT Name FROM City WHERE District=? ORDER BY Name LIMIT 5', ['Nordrhein-Westfalen'] ]; var_export( $mysqli->execute_query(...$args)->fetch_all(MYSQLI_ASSOC) );
Show:  
Copy Clear