PHP in Linux problem?

[mshen]

Do you think if it is possible to save the MySQL data to a Windows Format file(like Access,Excel) with PHP in Linux system?

Do you have other way to do it? Do you think Java can do this.Thanks.

[hand]

Do you know phpMyAdmin? http://www.phpwizard.net/projects/phpMyAdmin/

On the other hand you can access a mysql database with MS/Access using MyODBC (http://www.mysql.com/downloads/api-myodbc.html) directly

You can create EXCEL Files with the content of a database

<?php
Header("Content-Type: application/vnd.ms-excel");

mysql_connect("localhost", "", "")
      or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

mysql_select_db("YOURdatabase")
      or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

$query_text = "SELECT * FROM YOURtable";

$result = mysql_query($query_text);
$fieldcounts = mysql_num_fields($result);

for($i = 0; $i < $fieldcounts; $i++) {
   $fieldtype = mysql_fetch_field($result, $i);
   echo "$fieldtype->name [$fieldtype->type]\t";
}
echo "\n";

while ($myrow = mysql_fetch_array($result)) {
    for($i = 0; $i < $fieldcounts; $i++) {
       $fieldname = mysql_field_name($result, $i);
       echo "$myrow[$fieldname]\t";
    }
    echo "\n";
}
?>

It depends on what you want to do ...

[mshen]

May I do this in Linux system?How to download the Excel File?Thanks.

I use PHP in Linux now.

[hand]

If you store this script at htdocs directory of your webserver you can run this script via browser (IExplorer or Netscape Navigator) and the excel file will be created dynamically. Try it, you will see.

Customize the script to your needs
o connect informations
o database name
o table name

phpMyAdmin gives you a lot of features and possibilities, it's a great (greatest) web-tool for database handling.

[mshen]

Do you know how to create a Access database with php in linux?Thanks.

I am working in linux.I hope the application can create a windows Access file from MySQL.and the client can download from browser.do you think it is possible.Thanks.

Mark

[mshen]

Do you know how to create a Access database with php in linux?Thanks.

I am working in linux.I hope the application can create a windows Access file from MySQL.and the client can download from browser.do you think it is possible.Thanks.

Mark