A total of 6 records were found.
SELECT *
FROM php_a04_images
WHERE caption
LIKE "%Kyoto%"
| image_id | filename | caption |
|---|---|---|
| 1 | basin.jpg | Water basin at Ryoanji temple, Kyoto. |
| 3 | kinkakuji.jpg | The Golden Pavilion in Kyoto |
| 4 | maiko.jpg | Maiko—trainee geishas in Kyoto |
| 6 | menu.jpg | Menu outside restaurant in Pontocho, Kyoto |
| 7 | monk.jpg | Monk begging for alms in Kyoto |
| 8 | ryoanji.jpg | 🛕 Autumn leaves at Ryoanji temple, Kyoto |
$_SERVER["SCRIPT_NAME"]
/php/assignments/04-sessions-mysql/20-2.08-mysqli_08.php
print_r($_GET)
Array
(
)
print_r($_POST)
Array
(
)
print_r($_SESSION)
Array
(
)
print_r($_FILES)
Array
(
)
<?php
// Database Connection
require_once('../../includes/connection.php');
// Utility Functions
require_once '../../includes/utility_funcs.php';
// Connect to Database Using MySQL
$conn = dbConnect('read');
// Prepare the SQL query
$sql = 'SELECT *
FROM php_a04_images
WHERE caption
LIKE "%Kyoto%"
';
// Submit the Query and Capture the Result
$result = $conn->query($sql);
// Check For Database Errors
if (!$result) {
$error = $conn->error;
} else {
$numRows = $result->num_rows;
}
$tools = true;
include("../../includes/header.php");
?>
<main>
<h2><?php echo $folder_name; ?><span><?php echo $file_name; ?></span></h2>
<?php
if (isset($error)) {
echo "<p class=\"error\">$error</p>";
} else {
echo "<p class=\"info\">A total of $numRows records were found.</p>";
}
?>
<figure class="code">
<pre class="language-sql"><code><?= $sql ?></code></pre>
</figure>
<table id="output-sql">
<tr>
<th>image_id</th>
<th>filename</th>
<th>caption</th>
</tr>
<?php while ($row = $result->fetch_assoc()) { ?>
<tr>
<td><?php echo $row['image_id']; ?></td>
<td><?php echo $row['filename']; ?></td>
<td><?php echo $row['caption']; ?></td>
</tr>
<?php } ?>
</table>
</main>
<?php
# The side-bar section of the layout use custom path to load from a different folder.
include("../../includes/sidebar.php");
# The footer section of the layout.
include("../../includes/footer.php");
?>