infile problem.

Mark_Nordstrom

result page

<? 
//Connect to mysql server 
$con = mysql_connect("localhost","user","pass"); 
mysql_select_db("all-nba_net",$con); 
$result = mysql_db_query('$sql_id',"LOAD DATA LOCAL INFILE 'export_file_name.txt' INTO TABLE stats FIELDS TERMINATED BY ',' ENCLOSED BY '\"'") or die ("Invalid DATA LOAD query");
?>

The form page is html but it could be whats wrong.

<form action="result.php" method="post" name="form1">
  <input type="file" name="file">
  <br>
  <input type="submit" name="Submit" value="Submit">
</form>

Heres the page http://www.all-nba.net/form.php heres result page http://www.all-nba.net/result.php

I get the invalid data load query. I cant see whats wrong.

Kerry_Kobashi

See if anything in here helps, especially in the user comments area:

http://www.mysql.com/doc/en/LOAD_DATA.html

Mark_Nordstrom

again i tryed looking thru there but cant see whats wrong.

Kerry_Kobashi

"Again?"

Where in your first message did you ever say you headed to that URL link? I cannot read your mind.

Irregardless, there is not enough information you are giving us to determine what the problem is. For example, the form stuff you posted has nothing to do with any of this.

How do we know that you are getting a valid database connection with $conn? Or that you are selecting the right database table?

planetsim

you forgot in your form to have

enctype=multipart/form-data

Mark_Nordstrom

see its not the form its the result page. It should load fine without using the form to send data. As in you should get a blank page when you load it.

Also sorry for the again thing just getting frustrated with this. Also it is connecting to the database all them settings are right i have double and triple checked them.

Kerry_Kobashi

Have you tried to open up an existing text file of the same name in the layout desired to prove this works? That is, ruling out the form all together?

Also, what's sql_id. What's the contents of it?

Kerry_Kobashi

Try using $con in the last parameter to my_sql_query...

my_sql_query(whatever, whatever , $con);

Mark_Nordstrom

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/virtual/site13/fst/var/www/html/result.php on line 5

planetsim

try mysql_query

also if this is the database name

mysql_select_db("all-nba_net",$con);

you've called it twice using $con

Mark_Nordstrom

<? 
//Connect to mysql server 
$con = mysql_connect("localhost","user","pass"); 
mysql_select_db("all-nba_net",$con);
$result = mysql_db_query('$sql_id'$con),"LOAD DATA LOCAL INFILE 'export_file_name.txt' INTO TABLE stats FIELDS TERMINATED BY ',' ENCLOSED BY '\"'") or die ("Invalid DATA LOAD query");
?>

i get this error now Parse error: parse error, unexpected T_VARIABLE in /home/virtual/site13/fst/var/www/html/result.php on line 5

Mark_Nordstrom

http://www.all-nba.net/result.php see what it says now

Kerry_Kobashi

I hate to beat a dead horse, but have you proven that $con is correct?

Do this:
$con = mysql_connect("localhost","user","pass");
if ($con == false)
echo "I don't have a connection";

if (mysql_select_db("all-nba_net",$con) == false)
echo "I cannot select the database";

If either of those two lines put up an error, something is wrong prior to your query call. Let us know what happened after you did this.

Mark_Nordstrom

ok now i know its connecting. Put in code you said and no connection errors just the same error. http://www.all-nba.net/result.php

Kerry_Kobashi

Good Mark

Now we have a pretty good idea everything leading up to the query call is ok.

Something in here is messed up:

$result = mysql_db_query('$sql_id'$con),"LOAD DATA LOCAL INFILE 'export_file_name.txt' INTO TABLE stats FIELDS TERMINATED BY ',' ENCLOSED BY '\"'") or die ("Invalid DATA LOAD query");

Something is wrong in your query line as it is jumbled:
$sql_id'$con

The syntax for the mysql_db_query() function is:
mysql_db_query(databaseName, sqlquery, resourceId)

echo out $sql_id for me and determine if this string has valid data in it. It should be the name of your database.

$con should be the last parameter in the function call

$result = mysql_db_query('$sql_id',"LOAD DATA LOCAL INFILE 'export_file_name.txt' INTO TABLE stats FIELDS TERMINATED BY ',' ENCLOSED BY '\"'", $con) or die ("Invalid DATA LOAD query");

Mark_Nordstrom

nope still giving invalid error.

Kerry_Kobashi

Mark,

I was able to get this to work on my end with a test program.

Here is what I did:

1) Create a dummy mySQL database

DbImportCsv.sql

create database Test;
use Test;

create table TestTable
(
title varchar(64) NOT NULL,
author varchar(64) NOT NULL

);

Then create the database by:

c:\mysql\bin\mysql < DbImportCsv.sql

2) Create a comma seperated variable text file called DbImportCsv.txt.

DbImportCsv.txt

Gone with the wind, Shakespeare
The Bible, God
The Jungle, Upton Sinclair

THIS FILE MUST BE STORED IN THE DATABASE DIRECTORY WHERE TEST IS LOCATED

3) Created php code to load the text file into the database

<?php

$dbHost = "localhost";
$dbUser = "";
$dbPassword = "";
$dbName = "Test";

$dbConn = mysql_connect($dbHost, $dbUser, $dbPassword);
if ($dbConn == false)
{
echo "Could not connect to database";
exit(1);
}

if (mysql_select_db($dbName, $dbConn) == false)
{
echo "Could not select database";
exit(2);
}

$sql = "LOAD DATA INFILE 'DbImportCsv.txt' INTO TABLE TestTable FIELDS TERMINATED BY ','";
echo $sql;
if (mysql_query($sql, $dbConn) == false)
{
echo "Could not execute query";
exit(2);
}

mysql_close($dbConn);
exit(0);
?>