MySQL return array when SELECT FROM row is stated

Question

I have a MySQL query that is not working and I'm not sure why.

Here is my code for selecting the id from the url and using it as a variable so Mysql can return the img_url column.

    <?php
    global $wpdb;            
    $table_name = $wpdb->prefix . "photos";
    $url = (isset($_SERVER['HTTPS']) ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
    $id = basename(parse_url($url, PHP_URL_PATH));
    $image = $wpdb->get_results("SELECT img_url FROM $table_name WHERE id = $id");
    echo $id
    ?>

and then to show my image

 <img src='<?php echo $image; ?>'>

The result I get back from MySQL is "array". I don't know if it matters but the id column is AUTO_INCREMENT PRIMARY KEY. Also, I know "echo $id" does return the the id from the url so I know it works. Any suggestions? Thanks.

Its probably returning array with one row with your img url... try <img src='<?php echo $image['img_url']; ?>' > or check how $image variable is structured with print_r($image); — MapleSyrup
– MapleSyrup, Commented May 3, 2017 at 15:51

Paul Spiegel · Accepted Answer · 2017-05-03 16:25:19Z

2

To return a single value (one column from one row) you can use wpdb::get_var

$image = $wpdb->get_var("SELECT img_url FROM $table_name WHERE id = $id");
$echo $image;

If you use wpdb::get_results you will get an arry of rows. In this case you would need to access the value with $image[0]['img_url'] or with $image[0]->img_url - depending on the fetch mode.

Since the $id is a user input you should also use wpdb::prepare

$query = $wpdb->prepare("SELECT img_url FROM $table_name WHERE id = %d", $id);
$image = $wpdb->get_var($query);
$echo $image;

edited May 3, 2017 at 16:25

answered May 3, 2017 at 16:15

Paul Spiegel

31.9k5 gold badges48 silver badges56 bronze badges

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

Comments

darckcrystale · Accepted Answer · 2017-05-03 16:16:47Z

0

To determine the exact type of a value, you can use:

echo var_export($value, true);

So in your case:

echo var_export($image, true);

With this debug line, you should see that $image is an array and its content.

Update:

It returns array( 0 => stdClass::__set_state(array( 'img_url' => 'wallbate.cc/image/IMG_0026.jpg';, )), )

You probably want the image url, to do so, I think you have to do:

$image_url = $image[0]['img_url']
<img src='<?php echo $image_url; ?>'>

edited May 3, 2017 at 16:16

answered May 3, 2017 at 15:54

darckcrystale

1,7523 gold badges20 silver badges40 bronze badges

1 Comment

Nick Galgay Over a year ago

It returns array ( 0 => stdClass::__set_state(array( 'img_url' => 'wallbate.cc/image/IMG_0026.jpg', )), )

Collectives™ on Stack Overflow

MySQL return array when SELECT FROM row is stated

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related