[RESOLVED] Associative Arrays

mikanmao

Hi all, currently i am working on a script that write mysql results to excel file. I got a class that handle MSExcel Stream, but the only problem is I dont know how to loop the mysql results into an associative array like what the script do in the example.

Here's the sample code i got, the highlight part is what i want to change:
<?php
require_once "excel.php";
$export_file = "xlsfile://tmp/example.xls";
$fp = fopen($export_file, "wb");
if (!is_resource($fp))
{
die("Cannot open $export_file");
}

$assoc = array(
array("Sales Person" => "Sam Jackson", "Q1" => "$3255", "Q2" => "$3167", "Q3" => 3245, "Q4" => 3943),
array("Sales Person" => "Jim Brown", "Q1" => "$2580", "Q2" => "$2677", "Q3" => 3225, "Q4" => 3410),
array("Sales Person" => "John Hancock", "Q1" => "$9367", "Q2" => "$9875", "Q3" => 9544, "Q4" => 10255),
);

fwrite($fp, serialize($assoc));
fclose($fp);
?>

Anyone can help? Thanks in advance.

Installer

I think this is what you mean:

$query = "SELECT * FROM my_table";
$result = mysql($query);
while ($row = mysql_fetch_assoc($result)) {
    $assoc[] = array('Sales Person' => $row['sales_person'], 'Q1' => $row['q1']);
}

Of course, you would substitute the query, array indexes, and db columns with whatever applies for you.

mikanmao

Thanks Installer for the idea.
The script works now after i do the changes like the following:

$result = mysql_query("Select * from table");
while  ($row = mysql_fetch_assoc($result))
{
$myarr = array ("Col1" => $row['col1'], "Col2" => $row['col2']);
}
$assoc = array ($myarr);

Installer

I glad I could help, although I'm not sure I did. The code you posted won't work. All you will end up with is two separate arrays, the first containing only one element (the contents of one db row) and the second containing the first as its only element.