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

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 // fetchrow.php //cannot break line to rows, only show all in one line //must creat db and table every time using pipize.online. no save. if ($mysqli->ping()) { printf ("Our connection is ok!\n"); } else { printf ("Error: %s\n", $mysqli->error); } if ($mysqli->connect_error) die("Fatal Error"); $query = "SELECT * FROM classics"; $result = $mysqli->query($query); if (!$result) die("Fatal Error"); $rows = $result->num_rows; for ($j = 0 ; $j < $rows ; ++$j) { $row = $result->fetch_array(MYSQLI_ASSOC); echo 'Author: ' . htmlspecialchars($row['author']) . '\r\n'; //echo 'Author: ' . htmlspecialchars($row['author']) . ' '; echo 'Title: ' . htmlspecialchars($row['title']) . ' '; echo 'Category: ' . htmlspecialchars($row['category']) . ' '; echo 'Year: ' . htmlspecialchars($row['year']) . ' '; echo 'ISBN: ' . htmlspecialchars($row['isbn']) . ' '; } //$result->close(); //$conn->close(); ?>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online