MYSQL Query Result to Arrays

GuardPH

  $user = $_GET["user_name"]; 






$con=mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);






if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); }


















$result = mysqli_query($con,"SELECT data1, data2, FROM datatable"); 








while($row=mysql_fetch_array($result)){










echo $row['data1'];










echo $row['data2'];










echo $row['data3'];






Hi... How do you insert MYSQL Query Result to Arrays	

}

 # 
 $row[] = "data1";
 $row[] = "data2";
 $row[] = "data2";
 $xls->addRow($row); 

 # or multidimentional array
 $row = array();
 $row[] = array(0 =>'data1', 1=>'data2', 2=>'data3');
 $xls->addRow($row);

GuardPH

Opps! I was asking How to insert MYSQL Query Result to Arrays

Weedpacket

That's exactly what you're doing in this line:

while($row=mysql_fetch_array($result)){

That's why it's called "fetch_array".

If that's not your question (and using question marks are good for marking questions), then you'll need to give more information about what you're trying to do and what you're trying to achieve.

And I should warn you that [thread=10387467]you shouldn't be using the MySQL extension[/thread].

GuardPH

I'm trying to insert the result of Query to an Array so that xport-xls.class.php can render the value...

$data = array();
while($row=mysql_fetch_array($result)) {
echo $row['data1'];
echo $row['data2'];
echo $row['data3'];
$data[] = $row;
}

currently the example given is this and this is working... but said we can use data from SQL query as well so thats what i'm trying to do. Thanks!

#add a multi dimension array
$row = array();
$row[] = array(0 =>'Luke', 1=>'6', 2=>'2ft');
$xls->addRow($row);

bradgrafelman

Sounds like you just need to call the addRow() method inside the while() loop (perhaps also utilizing the $resulttype parameter to avoid every column being duplicated in the array).

Bonesnap

One thing I noticed is you're mixing MySQL and MySQLi functions. Choose only one (hint: choose MySQLi - the extra I is for improved!).