One thought on “How do I program in php to interact with my sql database to export the data to a new excel spreadsheet?”

1. Excel can read CSV files; these are very easy to write in PHP:

   $file_handle = fopen("filename.csv", "w");

   $result = mysql_query("SELECT a,b,c FROM table");
   while( $row = mysql_fetch_assoc($result) )
   {
   fwrite($file_handle, $row['a'] . ";" . $row['b'] . ";" . $row['c'] . ";\n");
   }
   mysql_free_result($result);

   fclose($file_handle);