how to access the field with name?

Question

hello guys. why i cloud to access . when i want to access the file id like blow:

echo $row['id'];

i have to do this blow:

echo $row[0];

{the number of the field} ?? some times it ok ??

i use this code for get data from DB :

$result = mysqli_query($con,"SELECT * FROM members WHERE id=".$number."");
$num=mysqli_num_rows($result);  
$row=mysqli_fetch_row($result);

Your code is vulnerable to [SQL-Injections](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php). Please start using Prepared, Parameterized Queries. — Charlotte Dunois, Aug 13 '16 at 20:03
Try `mysqli_fetch_assoc` instead http://php.net/manual/en/mysqli-result.fetch-assoc.php — Charlotte Dunois, Aug 13 '16 at 20:05
how can i use WHERE id=? in above in your linke for sql injection ?? — Mohammadali Mirhamed, Aug 13 '16 at 20:39

score 0 · Answer 1 · answered Aug 13 '16 at 20:09

0

I have same problem long time ago.

you must use "mysqli_fetch_array($result)" instead of using "mysqli_fetch_row($result)"

answered Aug 13 '16 at 20:09

sadegh

1 Answers1