04 Sessions Mysql 20 2.05 Mysqli_05

04 Sessions Mysql20 2.05 Mysqli_05

A total of 8 records were found.

SELECT * 
FROM php_a04_images 
ORDER BY caption DESC
ID filename caption
2 fountainsfountainsfountainsfountainsfountainsfountainsfountainsfountainsfountainsfountainsfountainsfountains.jpg 🚀 Fountain's in central Tokyo
8 ryoanji.jpg 🛕 Autumn leaves at Ryoanji temple, Kyoto
1 basin.jpg Water basin at Ryoanji temple, Kyoto.
3 kinkakuji.jpg The Golden Pavilion in Kyoto
7 monk.jpg Monk begging for alms in Kyoto
6 menu.jpg Menu outside restaurant in Pontocho, Kyoto
4 maiko.jpg Maiko—trainee geishas in Kyoto
5 maiko_phone.jpg Every maiko should have one—a mobile, of course 
$_SERVER["SCRIPT_NAME"]
/php/assignments/04-sessions-mysql/20-2.05-mysqli_05.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 
ORDER BY caption DESC
';

// 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>ID</th>
            <th>filename</th>
            <th>caption</th>
        </tr>
        <?php while ($row = $result->fetch_assoc()) { ?>
            <tr>
                <td><?php echo safe($row['image_id']); ?></td>
                <td><?php echo safe($row['filename']); ?></td>
                <td><?php echo safe($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");
?>