mysql_connect($mysqlserver, $username, $password); $database_select = mysql_select_db($database); // Real escape strings $table = mysql_real_escape_string($table); $query = "SELECT * FROM {$table}"; $query_result = mysql_query($query); $fields_num = MYSQL_NUM_FIELDS($query_result); echo "<table border='1'><tr>"; // printing table headers for ($i = 0; $i < $fields_num; $i++) { $field = MYSQL_FETCH_FIELD($query_result); echo "<td>{$field->name}</td>"; } echo "</tr>\n"; // printing table rows while ($row = MYSQL_FETCH_ROW($query_result)) { echo "<tr>"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach ($row as $cell) { echo "<td>{$cell}</td>"; } echo "</tr>\n"; } MYSQL_FREE_RESULT($query_result); // Close database connection mysql_close(); } else { // Incorrect password $result = "Incorrect password"; }
print "\n----------------------------------------------------\n"; } } else { /* FORMATTING FOR EXCEL DOCUMENTS ('.xls') */ //create title with timestamp: //define separator (defines columns in excel & tabs in word) $sep = "\t"; //tabbed character //start of printing column names as names of MySQL fields for ($i = 0; $i < MYSQL_NUM_FIELDS($result); $i++) { echo MYSQL_FIELD_NAME($result, $i) . "\t"; } print "\n"; //end of printing column names //start while loop to get data while ($row = MYSQL_FETCH_ROW($result)) { //set_time_limit(60); // HaRa $schema_insert = ""; for ($j = 0; $j < mysql_num_fields($result); $j++) { if (!isset($row[$j])) { $schema_insert .= "NULL" . $sep; } elseif ($row[$j] != "") { $schema_insert .= "{$row[$j]}" . $sep; } else { $schema_insert .= "" . $sep; } } $schema_insert = STR_REPLACE($sep . "\$", "", $schema_insert); //following fix suggested by Josue (thanks, Josue!) //this corrects output in excel when table fields contain \n or \r //these two characters are now replaced with a space