I was just going to recommend phpmyadmin, you might have to write yourself a simple script to do what you need. That way you can just have the features you want for your boss which should keep it as simple as it can, yet have everything it needs.
Here is an example file you could write to export to CSV:
<?php
$host = 'localhost';
$user = 'mysqlUser';
$pass = 'myUserPass';
$db = 'myDatabase';
$table = 'products_info';
$file = 'export';
$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";
$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "\n";
}
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>
- <?php
- $host = 'localhost';
- $user = 'mysqlUser';
- $pass = 'myUserPass';
- $db = 'myDatabase';
- $table = 'products_info';
- $file = 'export';
-
- $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
- mysql_select_db($db) or die("Can not connect.");
-
- $result = mysql_query("SHOW COLUMNS FROM ".$table."");
- $i = 0;
- if (mysql_num_rows($result) > 0) {
- while ($row = mysql_fetch_assoc($result)) {
- $csv_output .= $row['Field']."; ";
- $i++;
- }
- }
- $csv_output .= "\n";
-
- $values = mysql_query("SELECT * FROM ".$table."");
- while ($rowr = mysql_fetch_row($values)) {
- for ($j=0;$j<$i;$j++) {
- $csv_output .= $rowr[$j]."; ";
- }
- $csv_output .= "\n";
- }
-
- $filename = $file."_".date("Y-m-d_H-i",time());
- header("Content-type: application/vnd.ms-excel");
- header("Content-disposition: csv" . date("Y-m-d") . ".csv");
- header( "Content-disposition: filename=".$filename.".csv");
- print $csv_output;
- exit;
- ?>
I got this from this page:
http://www.tutorial5.com/content/view/159/85/I am sure there are tons of example codes out there like this to allow you to do what you need.
Ozzu Hosting - Want your website on a fast server like Ozzu?
March 29th, 2010, 6:54 pm
