Select blob/image from database returns NULL

Question

Here is a code how I push image into database:

$title = $_REQUEST['title'];
$description = $_REQUEST['description'];
$image = $_REQUEST['image'];
$bdata = addslashes($image);

$query = "insert into Images (title, description, image) values ($title, $description, '$bdata')" or die("Error in the consult.." . mysqli_error($connection));

$result = $connection->query($query);
$connection->close();

I double checked in database and it stores successfully.

Here is a code which gets data from the table:

$query = "select * from Images" or die("Error in the consult.." . mysqli_error($connection));
$result = $connection->query($query);
$events = array();

while ($event = $result->fetch_array(MYSQLI_ASSOC)) {       

    $events[] = $event;
}

header('Content-type: application/json');

echo json_encode($events);

$result->free();
$connection->close();

As result I receive next json:

{
id: "34",
title: "some image",
description: "some description",
image: null
}

As you can see "image" field is null. In phpAdmin I see that there is a data.

Don't use "SELECT *". Name the columns you actually want returned. (We've got no chance otherwise) — Strawberry
– Strawberry, Commented May 11, 2014 at 18:53

Community · Accepted Answer · 2017-05-23 11:50:23Z

1

First: Use prepared statements to get rid of that annoying SQL injection.

JSON has no native support for binary data:

A value can be a string in double quotes, or a number, or true or false or null, or an object or an array.

Use something like Base64, BSON, Smile or UBJSON. See also: Binary Data in JSON String. Something better than Base64

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered May 11, 2014 at 18:58

Markus Malkusch

7,9382 gold badges40 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select blob/image from database returns NULL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related