Code: Select all
$query = "SELECT * FROM newletter";
$result = mysql_query($query) or die(mysql_error());
while ($resultr = mysql_fetch_array ($result, MYSQL_ASSOC)){
require_once "excel.php";
$export_file = "xlsfile://./datafran.xls";
$fp = fopen($export_file, "wb");
$assoc = array( $resultr);
// typically this will be generated/read from a database table
/*$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),
);*/
printf("ID: %s Email: %s Ident: %s", $resultr["Id_client"], $resultr["E_mail"], $resultr["Identite"]);
fwrite($fp, serialize($assoc));
}
fclose($fp);