illegall string offset warning while fetching db data

Question

What is wrong here:

$items = '';
$st = $db->query("select code from map where pos = 'home01' limit 1");
$res = $st->fetchColumn();  // result: 1-2-3-4
$arr = explode("-", $res);
foreach($arr as $el) {
    $st = $db->query("select fname from banners where fname = " . $el . " limit 1");
    $row = $st->fetchColumn();
    $items .= "<img class='imgr imgr2' data-fname = '" . $row['fname'] . "' src='../banners/" . $row['fname'] . ".jpg' alt='img'>\n"; // line 88
}
echo $items;

Warning:
Illegal string offset 'fname' ... on line 88

$row = $st->fetchColumn(); I expect it should return array("a", "b", "c") not array('fname' => "a"); — degr
– degr, Commented Oct 3, 2017 at 7:43
var_dump($row) Like @degr said, $row['fname'] does not exist ! — teeyo
– teeyo, Commented Oct 3, 2017 at 7:44
Instead of $row['fname'] just use $row because fetchColumn doesn't return array — Saty
– Saty, Commented Oct 3, 2017 at 7:45

Mureinik · Accepted Answer · 2017-10-03 07:46:34Z

3

fetchColumn returns the next column directly, not an array that represents the row:

$fname = $st->fetchColumn();
$items .= "<img class='imgr imgr2' data-fname = '${fname}' src='../banners/${fname}.jpg' alt='img'>\n";

answered Oct 3, 2017 at 7:46

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

2 Comments

degr Over a year ago

not sure that you are right, because fetchColumn should return column, not cell. If you have limit 1 it should return array with one element, so, proper way to use it will be reset($fname) or $fname[0]

Mureinik Over a year ago

@degr this is the right way to use fetchColumn - check out the examples in the documentation page I linked to.

Collectives™ on Stack Overflow

illegall string offset warning while fetching db data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related