|
[ Autoren gesucht! ]
|
PHP-Homepage.de sucht laufend Autoren für News und Artikel
Interesse?
|
|
 |
|
[Start] [Suche] [Neue Einträge]
| MySQL2Excel |
<?PHP
/*************************************************************************************************************
* MySQL2Excel
* version: v0.0.1 (NOT TO BE CONTINUED...)
* author: e-voc [Uwe Pries]
* mailto: webmaster@judas-price.de
* date: 2000-12-31
*************************************************************************************************************/
$host = "";
$user = "";
$password = "";
$database = "";
$table = "";
$query_text = "SELECT * FROM " . $table;
Header("Content-Type: application/vnd.ms-excel");
$db_link = mysql_connect($host, $user, $password);
mysql_select_db($database, $db_link);
$result = mysql_query($query_text, $db_link);
$fieldcounts = mysql_num_fields($result);
for($i = 0; $i < $fieldcounts; $i++) {
$fieldtype = mysql_fetch_field($result, $i);
if ($i < ($fieldcounts-1)) echo "$fieldtype->name [$fieldtype->type]\t";
else echo "$fieldtype->name [$fieldtype->type]\n";
}
$myrow = mysql_fetch_array($result);
do {
for($i = 0; $i < $fieldcounts; $i++) {
$fieldname = mysql_field_name($result, $i);
if ($i < ($fieldcounts-1)) echo $myrow[$fieldname] . "\t";
else echo $myrow[$fieldname] . "\n";
}
} while ($myrow = mysql_fetch_array($result));
?> |
|
