Getting SQL result into an array

Anonymous User 2659 08 Jul 2013

Hi Developers!

I'm trying to get a MySQL result like "SELECT * FROM sales" into an array that looks like this:

$data = array(

array('Date', 'Sales'),

array('June 25', 12.25),

array('June 26', 8.00)

);

I tried it with a while loop but it didn't work. How can i do this?

Thanks in advance.

Ask by Anonymous User

Updated 08 Jul 2013

1 Answers

AVADHESH PATEL 08 Jul 2013

Hi Garry!

Try this

$query = "SELECT * FROM sales";
$data = array();
$data[] =array('Date', 'Sales');
if ($result = $mysqli->query($query)) 
{        
    while ($line = $result->fetch_assoc()) 
    {        
        // line contain an associative array with "Date" and "Sales"  
        $data[] = array($line['Date'], $line['Sales']);
    }
}
$result->free();

I hope it helpful for you!

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Getting SQL result into an array

Can you answer this question?

1 Answers