How to convert a sql object into a multidimensional array?

Question

I wrote this simple code and I extracted two columns from MySQL table. Then I couldnt convert it into a multidimensional array.

So the table I had,have only 2 rows and what I expected it will give me a output of 2 rows and 2 columns. But instead the array size came out to be 4(instead of 2) and moreover its giving an error for the printing of temp[2] and temp[3]

<?php 
mysql_connect("localhost","root",""); //Connecting to the localhost
mysql_select_db("user"); //Selecting a database
$auth_data = mysql_query("SELECT EMAIL,UNIQUE_ID FROM authentication"); 
#Converting the object to an array
$temp = mysql_fetch_array($auth_data, MYSQL_BOTH);
echo sizeOf($temp);
echo $temp[0];
echo $temp[1];
echo $temp[2];
echo $temp[3];
?>

Error:

[email protected]

Notice: Undefined offset: 2 in C:\xampp\htdocs\test\test.php on line 11

Notice: Undefined offset: 3 in C:\xampp\htdocs\test\test.php on line 12

mysql_fetch_array() only fetches one row (its columns as an array); it then advances the pointer so that the next call will fetch the next row. You need to call it repeatedly, usually in a loop like while ($row = mysql_fetch_array($auth_data)) do_something_with($row);. — eggyal
– eggyal, Commented Apr 11, 2014 at 13:11

moonwave99 · Accepted Answer · 2014-04-11 13:10:56Z

1

You are using MYSQL_BOTH, so you get both numeric and string keys into $temp, which holds just the first result of your query.

Use PDO/mysqli and drop mysql_* please.

answered Apr 11, 2014 at 13:10

moonwave99

22.9k3 gold badges48 silver badges71 bronze badges

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

Comments

Neeraj · Accepted Answer · 2014-04-11 13:47:55Z

0

 you selected only two fields  so output will be two parameter.

> select emailadn uniqueid from tablename. parameter $temp[0]; $temp [1]
> ..................... $temp[2] $temp[3] wrong array

edited Apr 11, 2014 at 13:47

answered Apr 11, 2014 at 13:15

Neeraj

1977 bronze badges

Collectives™ on Stack Overflow

How to convert a sql object into a multidimensional array?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related