将图像信息从服务器转换为json

Question

Help needed pals, i want to convert the information about the image retrieved from a database into json format. Here is the code that gets the information of the image from the database

// Query for a list of all existing files
$sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM `file`';
$result = $dbLink->query($sql);

// Check if it was successfull
if($result) {
// Make sure there are some files in there
if($result->num_rows == 0) {
    echo '<p>There are no files in the database</p>';
}
else {
    // Print the top of a table
    echo '<table width="100%">
            <tr>
                <td><b>Name</b></td>
                <td><b>Mime</b></td>
                <td><b>Size (bytes)</b></td>
                <td><b>Created</b></td>
                <td><b>&nbsp;</b></td>
            </tr>';

    // Print each file
    while($row = $result->fetch_assoc()) {
        echo "
            <tr>
                <td>{$row['name']}</td>
                <td>{$row['mime']}</td>
                <td>{$row['size']}</td>
                <td>{$row['created']}</td>
                <td><a href='get_file.php?id={$row['id']}'>Download</a></td>
            </tr>";
    }

    // Close table
    echo '</table>';
}

// Free the result
$result->free();
}
else
{
echo 'Error! SQL query failed:';
echo "<pre>{$dbLink->error}</pre>";
}

Here is what am trying to achieve

{
"success": 1,
"message": "images Available",
"images": [
    {
        "Name": "richmahnn",
        "Mime": "ajh544k",
        "Size": "222",
        "Created": "232014",
        "url": "http://localhost/imageUpload/ajh544k.jpg"
    },
    {
        "Name": "john",
        "Mime": "ajh5644k",
        "Size": "15",
        "Created": "232014",
        "url": "http://localhost/imageUpload/ajh5644k.jpg"
    },

so far this is what i get

Answer 1

1. Create a php array with the desired property layout you want in JSON.
2. json_encode($yourarraydata);
3. ????
4. #Win