Query is sent to MySQL asking to see all the records in the classics table, like this:<\/p>\n\n\n\n
$query = “SELECT * FROM classics”; After that, $rows is set to a value representing the number of rows in the table:<\/p>\n\n\n\n $rows = $result->num_rows;<\/strong><\/p>\n\n\n\n Using the value in $rows, a for loop is then entered to display the contents of each row. Then the program populates the array $row with a row of results by calling the fetch_array method of $result, passing it the constant value MYSQLI_NUM, which forces the return of a numeric (rather than associative) array, like this:<\/p>\n\n\n\n $row = $result->fetch_array(MYSQLI_NUM);<\/p>\n\n\n\n With the data in $row, it\u2019s now a simple matter to display it within the heredoc echo statement that follows, in which I have chosen to use a <pre> tag to line up the display of each record in a pleasing manner. $result->close(); <\/p>\n","protected":false},"excerpt":{"rendered":" Query is sent to MySQL asking to see all the records in the classics table, like this: $query = “SELECT * FROM classics”;$result = $conn->query($query); After that, $rows is set to a value representing the number of rows in the table: $rows = $result->num_rows; Using the value in $rows, a for loop is then entered … Continue reading Querying the Database<\/span>
$result = $conn->query($query);<\/strong><\/p>\n\n\n\n
After the display of each record, there is a second form that also posts to sqltest.php (the program itself) but this time contains two hidden fields: delete and isbn. The delete field is set to yes and isbn to the value held in $row[4], which contains the ISBN for the record.
Then a submit button with the name DELETE RECORD is displayed, and the form is closed. A curly brace then completes the for loop, which will continue until all records have been displayed, at which time the $result and $conn object\u2019s close methods are closed to release resources back to PHP:<\/p>\n\n\n\n
$conn->close();<\/strong><\/p>\n\n\n\n