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

SQL code: Upload dump Copy Format Clear

CREATE TABLE classics ( author VARCHAR(128), title VARCHAR(128), category VARCHAR(16), year SMALLINT, isbn CHAR(13), INDEX(author(20)), INDEX(title(20)), INDEX(category(4)), INDEX(year), PRIMARY KEY (isbn)) ENGINE InnoDB; INSERT INTO classics(author, title, category, year, isbn) VALUES('Mark Twain','The Adventures of Tom Sawyer','Fiction','1876','6578484949'); INSERT INTO classics(author, title, category, year, isbn) VALUES('Jane Austen','Pride and Prejudice','Fiction','1811', '18565645'); INSERT INTO classics(author, title, category, year, isbn) VALUES('Charles Darwin','The Origin of Species','Non-Fiction','1856','47657583'); INSERT INTO classics(author, title, category, year, isbn) VALUES('Charles Dickens','The Old Curiosity Shop','Fiction','1841', '4532924'); INSERT INTO classics(author, title, category, year, isbn) VALUES('William Shakespeare','Romeo and Juliet','Play','1594', '1987655'); SELECT * FROM classics;

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php $sql = "SELECT * classics"; $result = $mysqli->query($sql); echo "<br>"; echo "<table border='1'>"; while ($row = mysqli_fetch_assoc($result)) { // Important line !!! Check summary get row on array .. echo "<tr>"; foreach ($row as $field => $value) { // I you want you can right this line like this: foreach($row as $value) { echo "<td>" . $value . "</td>"; // I just did not use "htmlspecialchars()" function. } echo "</tr>"; } echo "</table>"; ?>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online