MYSQL Query Result to Arrays

[GuardPH]

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

  $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'];
  
}
 
 # 
 $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);

[Barand]

Use fetch_assoc() or fetch_row() and not fetch_array() as the latter fetches the data twice.

$data = array();
$result = mysqli_query($con,"SELECT data1, data2, data3 FROM datatable"); 
while($row=mysqli_fetch_assoc($result)){
    $data[] = $row;
}

Edited September 15, 2013 by Barand

[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);

[AbraCadaver]

Should be this simple I would suspect: 

while($row=mysql_fetch_array($result, MYSQL_NUM)) {
    $xls->addRow($row);
}

EDIT: Or looking back at your example:

while($row=mysql_fetch_array($result, MYSQL_NUM)) {
    $data[] = $row;
}
$xls->addRow($data);

Not sure what addRow() is expecting.

Edited September 16, 2013 by AbraCadaver

[GuardPH]

Oh btw, this is the addrow function

	public function addRow($row) {
	#Accepts an array or var which gets added to the spreadsheet body

		if(is_array($row)) {
			#check for multi dim array
			if(is_array($row[0])) {
				foreach($row as $key=>$array) {
					$this->bodyArray[] = $array;
				}
			}
			else
			{
				$this->bodyArray[] = $row;
			}			
		}
		else
		{
			$this->bodyArray[][0] = $row;
		}
	
	}

Ill try this

[GuardPH]

Tried but didn't work... any idea?

Edited September 17, 2013 by GuardPH

[mac_gyver]

unless you copied the mysqli while() loop construct that Barand posted, the loop in your original code (or in post #3) won't ever work because you are mixing mysql_ and mysqli_ functions.

 

do you have php's error_reporting set to E_ALL and display_errors set to ON so that php will help you by reporting and displaying all the errors it detects?

Edited September 17, 2013 by mac_gyver

[priyankagound]

I think you wanted to do this:

while( $row = mysql_fetch_assoc( $result)){
$new_array[] = $row; // Inside while loop
}

Or maybe store id as key too

$new_array[ $row['id']] = $row;

Using the second ways you would be able to address rows directly by their id, such as: $new_array[ 5].

[Barand]

priyankagound, keep up and read the previous reply by mac_gyver

[GuardPH]

Yes did that already...

while($row=mysqli_fetch_array($result, MYSQL_NUM)) {
    $data[] = $row;
}
$xls->addRow($data);

This is the Error:

Undefined offset: 0 in /pathe/export-xls.class.php on line 69

	public function addRow($row) {
	#Accepts an array or var which gets added to the spreadsheet body

		if(is_array($row)) {
			#check for multi dim array
			if(is_array($row[0])) {                                 <================== line 69
				foreach($row as $key=>$array) {
					$this->bodyArray[] = $array;
				}
			}
			else
			{
				$this->bodyArray[] = $row;
			}			
		}
		else
		{
			$this->bodyArray[][0] = $row;
		}
	
	}

[Barand]

try

mysqli_fetch_row()

 

instead of

mysqli_fetch_assoc()