Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
exporting Mysql table with php
- Thread starter math
- Start date
I would install phpMyAdmin. It not only lets you export your tables as Excel CSV, but lets your manage your entire MySQL database(s).
if you want you own code
@$sub = fopen("./data/".$filename.".txt","w"
;
if (!$sub) echo "error creating ".$filename.".txt \n ";
@$result = mysql_query("select * from table", $db_connection);
$column_number = mysql_num_fields($result);
if (!$column_number) echo "error reading table header";
/*get column names*/
unset($header);
for($i=0;$i<$column_number;$i++) $header[$i] = mysql_field_name($result, $i);
fputs($sub,"'".implode("','",$header)."'\r\n"
/*get data*/
while($data = mysql_fetch_array($result))
{
unset($to_file);
for($i=0;$i<$column_number;$i++) $to_file[$i] = preg_replace("/\'/","''",stripslashes(trim($data[$header[$i]])));
fputs($sub,"'".implode("','",$to_file)."'\r\n"
}
fclose($sub);
hope this helps
@$sub = fopen("./data/".$filename.".txt","w"
;if (!$sub) echo "error creating ".$filename.".txt \n ";
@$result = mysql_query("select * from table", $db_connection);
$column_number = mysql_num_fields($result);
if (!$column_number) echo "error reading table header";
/*get column names*/
unset($header);
for($i=0;$i<$column_number;$i++) $header[$i] = mysql_field_name($result, $i);
fputs($sub,"'".implode("','",$header)."'\r\n"
;/*get data*/
while($data = mysql_fetch_array($result))
{
unset($to_file);
for($i=0;$i<$column_number;$i++) $to_file[$i] = preg_replace("/\'/","''",stripslashes(trim($data[$header[$i]])));
fputs($sub,"'".implode("','",$to_file)."'\r\n"
;}
fclose($sub);
hope this helps
Try
The freeware Windows program allows you (the site admin) to pop open your MySQL database and tweak it as if you were in Excel. You can import and export all the SQL and CSV files you want.
The freeware Windows program allows you (the site admin) to pop open your MySQL database and tweak it as if you were in Excel. You can import and export all the SQL and CSV files you want.
- Status
