Load Data Infile Code

poscribes

I have put together the following code and currently I am getting back a syntax error. In the doc I have read everything seems to look ok, but obviously it is not.

Any suggestions greatly appreciated.

<?php

@ $db = mysql_pconnect('localhost', 'root', '');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('tapelibrary');

$file = "daily\checkin.txt";
$query = "load data infile $file into table tapes (tape_id, file_id, creation_date) fields terminated by ',' lines terminated by '\n'";
$result = mysql_query($query) or die("Error: ".mysql_error());

if ($result)
echo ' Data Inserted Into The Database.<br>';

Thanks. 🙂

devinemke

I am getting back a syntax error

what's the error?

poscribes

Here's the error:

Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'daily\checkin.txt into table tapes (tape_id, file_id, creation_

devinemke

you need quotes around $file

$query = "load data infile '$file' into table tapes...

also I think you might need an absolute path to your text file

poscribes

Yeah I spotted that after I posted, but even with the quotes and giving it a full path like you suggested devinemke, it gives the same syntax error, something else is missing and I don't know what.

This is my fist attempt at using load data infile and so far I am not having any success.

Anyone have a php/mysql code checker they could run the syntax against?

dave420

What path are you using for the file? I noticed you have a backslash in your code - is it not escaped in real life, or did the forum take off a slash?

poscribes

Sorry, not sure what you mean exactly.

The code contains the path 'daily/checkin.txt'.

Should there be something different such as the full path 'e:\www\webroot\tape\daily\checkin.txt' and do I need to use double backslashes?