Passing php variables as arguments in php mysql

Question

I am new in php.Instead of using

$result=mysql_fetch_assoc($qry)
$result['id'];

i want to pass a variable instead of id like this

$id='id';
$result=mysql_fetch_assoc($qry)
    $result[$id];

I have tried like this but not working.How can i pass a variable as argument to fetch a value from database

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi. If you choose PDO, here is a good tutorial. — Kevin
– Kevin, Commented Nov 7, 2014 at 7:22
php.net/manual/en/mysqli.query.php that page has all you want to know about it. Also this: php.net/manual/en/mysqli.quickstart.prepared-statements.php — Hanky Panky
– Hanky Panky, Commented Nov 7, 2014 at 7:22
@Root, If you are using PHP5.5 then every function that starts with mysql_ will generates error. — jogesh_pi
– jogesh_pi, Commented Nov 7, 2014 at 7:30

Community · Accepted Answer · 2017-05-23 12:27:18Z

1

mysql_fetch_assoc provides you the multi-dimentional array.

$result = array(
    array('id'=>`some_value`)
);

So you can do like this:

$ID = "id";
foreach($result as $row) {
    echo $row[$ID] . "\n";
}

NOTE:

CommunityBot

11 silver badge

answered Nov 7, 2014 at 7:23

jogesh_pi

9,7725 gold badges40 silver badges65 bronze badges

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