LOAD INFILE
| From: | John Boy | Date: | Mon, 30 Mar 2009 11:37:11 +0000 |
| Subject: | LOAD INFILE | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290816@lists.php.net to get a copy of this message | ||
Hi
I want to upload a .csv file from my local pc to a mysql server. My local
machine is XP2. I have used the following but the file does not upload. When
using php MyAdmin it returns the error 'file not found'. Can anyone help?
<?php
// Include our login information
include('db_login_master.php');
// Connect - note: 'false' is 'no new link use existing' parameter and
'128'
enables LOAD DATA
$connection = mysql_connect($db_host, $db_username, $db_password,false,128);
if (!$connection){
die ("Could not connect to the database:
<br />". mysql_error());
}
// Select the database
$db_select=mysql_select_db($db_database);
if (!$db_select)
{
die ("Could not select the database:
<br />". mysql_error());
}
// Import new avaiability data from local CSV file
$sql2 = 'LOAD DATA LOCAL INFILE \'C:\\\\EXPORT.CSV\' INTO TABLE
availability
FIELDS TERMINATED BY \';\' ENCLOSED BY \'"\' ESCAPED BY \'\\\\\'
LINES TERMINATED BY \'\\r\\n\'';
// echo $sql2;
mysql_query($sql2);
echo '<p align="center"><font face="Verdana"
color="#0000FF">';
mysql_query($sql0);
printf("Records added: %d\n", mysql_affected_rows());
echo '<p align="center"><B>UPDATE COMPLETE</B></p>';
?>
--
John
UK