Export command?

[sveegaard]

Hi again, all

Is it possible to export tables from MySQL to PDF and/or XLS via PHP?
:D

[sciguyryan]

I'm not exactly shure how you can do it but this (http://www.dwalker.co.uk/phpmysqlautobackup/) may help :-)

Cheers,

Ryan Jones

[sveegaard]

Thx, but it's rather complex :D

[sveegaard]

Hmm, I've tried
<?php
$dbhost='localhost';
$dbusername='ODBC';
$dbuserpass='';
$dbname='Some_database';
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die('Cannot select database');
$query = "SELECT * INTO OUTFILE 'test.pdf' FROM users";
mysql_query($query) or die(mysql_error());

?>
but Reader won't accept it (headers, perhaps?). Excel can however open it as xls.

[sciguyryan]

It maybe because the MySQL files are normally exported with a .sql extension...

Cheers,

Ryan Jones

[CornedBee]

No, this kind goes under comma separated value, CSV. That's why Excel can open it.

[sveegaard]

Any ideas, then?
Cheers

[CornedBee]

Sure.
http://www.php.net/manual/en/faq.using.php#faq.using.freepdf