Initializing PHP variable from SQL query

Question

I want to initialize a variable from an entry in an sql table; this entry is one I've queried for.

//Grab user id from users.sql
$quser = $db->query("
    SELECT *
        FROM users //in this table is a column named userident
        WHERE username = '$user' //this where conditional filters to a lone row         
");*/

I tried $var = $quser["ident"]; since this is how I would display table entries in a foreach() loop, but this doesn't seem to work.

There is only one ident entry per user, so when I filter the query with where, it results in one row. Why can't I grab the entry and place in a variable?

Disregard the end-comment at the end; I commented this segment of code out so I could work on other things in the meantime. — gator
– gator, Commented Jan 2, 2013 at 8:17
You say in this table is a column named userident but you use $quser["ident"] — kmkaplan
– kmkaplan, Commented Jan 2, 2013 at 8:18
Sorry, I'm renaming things as I go along. I'm trying to get the entry under ident in the lone row. — gator
– gator, Commented Jan 2, 2013 at 8:20

cjds · Accepted Answer · 2013-01-02 08:20:06Z

2

This is what you need to do

Execute the query
Pick up the first row (as there will be only one row this'll work otherwise do it in a loop)
Get the column from the row produced

Here's an example

    $quser = $db->query("SELECT * FROM users WHERE username = '$user'");
    $first_row=$quser->row();

    $reqdData=$first_row->ident; // Or whateber column you need

answered Jan 2, 2013 at 8:20

cjds

8,47611 gold badges57 silver badges86 bronze badges

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

2 Comments

Varun Bajaj Over a year ago

i think above solution is perfect but one patch i would like to add $reqdData=($first_row->num_rows() > 0)?$first_row->ident :0;

gator Over a year ago

With this I get a Call to undefined method PDOStatement::row() error.

Collectives™ on Stack Overflow

Initializing PHP variable from SQL query

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