[d3iti]

You can try using another type of file (instead of a txt file extension). For security reasons txt files are not allowed on the server.

Also if you have a programming problem it is recommended that you write your question in the forum section for "Web Programming"

[JBGO]

At last !!! Thanks for answering ! I'm testing now !

Could you move the subject in "Web Programming" please Thanks !

PS : What type of file can I use and want path ...

[Firebirds]

It has to be in public_html.
You can use html, css, js, php, and more. 000webhost doesn't let you use txt and asp doesn't work.

[grace1004]

The following code works in my localhost server installed in a linux system:

PHP Code:

<?php
$conn = mysql_connect("localhost", "root", "****");
mysql_select_db("test", $conn);

$sql = "load data infile '/var/www/html/member.txt' into table `load_data`
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (name, password)";  

$result = mysql_query($sql, $conn);
if(!$result) echo "DB error";
?>

I tried a similar code with .dat file (instead of .txt file) in 000webhost.com server, and it did not work
(I got "DB error" message). It might be because a user is not granted with 'file' privilege.

[JBGO]

Much better when I'm in the good section ^^

It might be because a user is not granted with 'file' privilege.

I think too ...

It has to be in public_html.

ok, but what that should I use to go there ?

Best regards,

[JBGO]

Nobody uses Load data infile ? An idea

[chanh]

please read TOS, game script is not allowed on free hosting.

[JBGO]

please read TOS, game script is not allowed on free hosting.

There's NO game script here ! It is a simple file of numbers !