[SOLVED] mysql_query from txt file

[HektoR]

hello everyone.

i have one question.

i want to run mysql query from txt file.

i have txt file on ftp and in it written:

Code: [select]

("INSERT INTO users (name,lastname) VALUES ('xxx','yyy')");

[Lee-Bartlett]

Change file name to php? i am new so might be wrong.

[The Little Guy]

could you elaborate a little more please?

[HektoR]

i want to insert data in mysql from txt file, wich are on my site.

[The Little Guy]

you will need to use fopen and fread

 

then you can convert the mysql to a PHP query and run the mysql_query function on it.

[flyhoney]

<?php
$query = file_get_contents('sql.txt');
?>

[HektoR]

it did not work.

 

 

please help me

[wildteen88]

Whats in stored in sql.txt? An actual sql query or is it just plain text? You'll need to be more specific, also post your code here too.

[HektoR]

in sql.txt :

"INSERT INTO admins(user,pass) VALUES ('zzz','ccc')"
"INSERT INTO admins(user,pass) VALUES ('xxx','yyy')"

and i dont know how make php code :'(

[wildteen88]

So you have multiple sql queries defined within sql.txt and each query is on its own line? In which case you can use

$queries = array_map('trim', file('sql.txt'));

foreach($queries as $query)
{
     mysql_query($query) or die('Query: ' . $query . '<br />Error: ' . mysql_error());
}

[HektoR]

it not works.

Query: "INSERT INTO admins(user,pass) VALUES ('hekt','123456')";
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 '"INSERT INTO admins(user,pass) VALUES ('hekt','123456')"' at line 1

[flyhoney]

Try this:

<?php
$queries = array_map('trim', file('sql.txt'), '"');

foreach($queries as $query)
{
     mysql_query($query) or die('Query: ' . $query . '<br />Error: ' . mysql_error());
}
?>

[HektoR]

again error

Warning: Invalid argument supplied for foreach()
Warning: array_map()

 

[flyhoney]

again error

Warning: Invalid argument supplied for foreach()
Warning: array_map()

 

 

Yeah that was dumb of me to suggest that.  I was thinking that the quotes around the query could be messing things up.  Maybe this?

 

<?php
$queries = array_map('trim', file('sql.txt'));

foreach($queries as $query)
{
     // dumb way of stripping quotes off of beginning and quotes + semicolon off of the end.
     $query = substr($query,1,-2);
     mysql_query($query) or die('Query: ' . $query . '<br />Error: ' . mysql_error());
}
?>

[HektoR]

it works, thank you very very very much , all !