The following are the actual parameters used by MySQL to CSV Download. A text editor, like Notepad, is used to update the parameters. Multiple copies of MySQL to CSV Download can be used on the same web site.
$database_location = 'localhost';
This works in most cases.
If the database is located on a remote server then
use the domain name or IP address of the remote server.
$database_user = 'dbuser';
Change this to an authorized database user.
$database_user_password = 'dbpassword';
Change this to the database user's password.
$database_name = 'dbname';
The database name
$table_name = 'tablename';
The table with the data. This or SQL_statement must be specified.
$SQL_statement = '';
The SQL statement used to find the data. If this is
specified then $table_name is ignored.
$null_value = 0;
The value to be displayed if a numeric column has a Null value
$output_file_name = '';
The name of the output file, if not specified
the table_name plus ".csv" will used if the
table_name is specified. If both this and table_name
are not specified then the download is named download.csv.
$pword = "";
If specified then the password URL parameter or form input value
will be checked to make sure it matches this value. For example: mypage.php?password=mypassword.
Note: No checking of password attempts is done making this weak security.
$quote_text = 'smart';
Whether text columns are put in quotes or not
Valid values: never, always (does not apply to numeric fields)
, smart (only if a comma is detected in the text, the entire
column will be quoted if any "," are found in the text for that column.
$include_column_names = true;
Use this to include the column names as the 1st line
of the csv file.
Valid values: true (include column names)
false (do not include column names).
$delimiter = ",";
The delimiter used for the file.