PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE your_table ( id INT AUTO_INCREMENT, firstname VARCHAR(100), lastname VARCHAR(100), PRIMARY KEY (id) ); INSERT INTO your_table(id, firstname, lastname) VALUES (1, 'Chad', 'One'), (4, 'Ned', 'Two'), (5, 'Dave', 'Three'), (14, 'Newt', 'Four'), (18, 'Bill', 'Five'), (21, 'Norton', 'Six'), (25, 'Alan', 'Seven');
Copy Clear
Copy Format Clear
<?php // $mysqli is already declared as a working database connection by this sandbox foreach ($mysqli->query("SELECT * FROM your_table") as $row) { vprintf("<div>%d: %s %s</div>\n", $row); }
Show:  
Copy Clear