PHP PDO get all row names as objects containing value

Question

I have a mySQL database table setup called site.

Rather than qet the column headings to produce a PHP object of values I want to produce data from the rows.

TABLE: site

:::field:::::value:::::

   url       www.example.com
   name      example site
   etc       Example Etcetera

So I want to be able to get this information from the server by calling the column name I want and the row I am after. I want to do this for all fields in site as I don't want to do multiple calls for the various different rows in site; I'd rather store all the information from the beginning in the object:

eg. <? echo $site['url']; ?>

I created this put it appears to be causing an error:.

$sql = "SELECT * FROM `site`"; 
$site[];
foreach($sodh->query($sql) as $sitefield){
    $site[$sitefield['field']] = $sitefield['value'];
}

Obviously I've missed something. ¿Any idea as to what?

xdazz · Accepted Answer · 2012-09-03 15:53:33Z

2

$site[];

should be

$site = array();

answered Sep 3, 2012 at 15:53

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

1 Comment

Walrus Over a year ago

OK but that has not fixed the problem

Collectives™ on Stack Overflow

PHP PDO get all row names as objects containing value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related