Illegal string offset error

Question

I am getting a couple errors when running my script:

Warning: Illegal string offset 'photo_id' in /var/www/BrandonsBlog/comments.php on line 35
Notice: Undefined offset: 2 in /var/www/BrandonsBlog/comments.php on line 35

My code:

    ini_set("display_errors", TRUE);
    include "Database.php";

    Class Database {
        protected $conn;

        public function setDb($conn){
            $this->conn = $conn;
        }
    }

    Class Images extends Database{
        protected $stmt;

        public function RetrieveImages(){

            $this->stmt = $this->conn->prepare('SELECT * FROM `pictures`');
            $this->stmt->execute();
            $boom = $this->stmt->fetchAll();
            return $boom;
        }
    }

    Class Content extends Images{

    }

    $test = new Images();
    $test->setDb($conn);
    $test2 = $test->RetrieveImages();

    var_dump($test2);
foreach ($test2 as $key => $value) {
    $photo_id = $value[$key]['photo_id'];
    //echo '<div class="hello" id="'.$photo_id.'"></div>';
}

The var_dump($test2); is giving me the following output:

array(3) {
  [0]=>;
  array(4) {
    ["id"]=>;
    string(1) "1"
    [0]=>;
    string(1) "1"
    ["photo_id"]=>;
    string(1) "1"
    [1]=>;
    string(1) "1"
  }
  [1]=>;
  array(4) {
    ["id"]=>;
    string(1) "2"
    [0]=>;
    string(1) "2"
    ["photo_id"]=>;
    string(1) "2"
    [1]=>;
    string(1) "2"
  }
  [2]=>;
  array(4) {
    ["id"]=>;
    string(1) "3"
    [0]=>;
    string(1) "3"
    ["photo_id"]=>;
    string(1) "3"
    [1]=>;
    string(1) "3"
  }
}

This is what my database table looks like that I am retrieving from:

mysql> select * from pictures;
+----+----------+
| id | photo_id |
+----+----------+
|  1 | 1        |
|  2 | 2        |
|  3 | 3        |
+----+----------+
3 rows in set (0.00 sec)

Could anyone tell me why I am getting this error and also in my var_dump() it seems that the values in each row are duplicated for some reason maybe this is causing my error?

You error is very clear. It gives you full information. String index can't be anything, but non-negative integer. Your error contains info - which line it is, so use var_dump() to discover why your index is illegal — Alma Do
– Alma Do, Commented Nov 19, 2013 at 6:39

Pathik Gandhi · Accepted Answer · 2013-11-19 06:41:33Z

1

Foreach give direct array value you dont need to get using key value.

Remove [$key] from the below foreach

foreach ($test2 as $key => $value) {
    $photo_id = $value['photo_id'];
    //echo '<div class="hello" id="'.$photo_id.'"></div>';
}

answered Nov 19, 2013 at 6:41

Pathik Gandhi

1,3441 gold badge18 silver badges37 bronze badges

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

Comments

Adam · Accepted Answer · 2013-11-19 06:41:24Z

1

change this:

$photo_id = $value[$key]['photo_id'];

to this:

$photo_id = $value['photo_id'];

should work

answered Nov 19, 2013 at 6:41

Adam

1,3712 gold badges11 silver badges12 bronze badges

Collectives™ on Stack Overflow

Illegal string offset error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related