Problem with MySQL query...

[nivlaC]

I'm making an install script and I'm trying to read the SQL file then executing it into my database. It isn't doing anything. No errors, nothing.

include '../config.php';

$dbi = mysql_connect ("$server", "$user", "$pass") or die ("Error connecting.");
mysql_select_db ("$db") or die ("Error selecting database.");

$sql_file = file_get_contents("sql/stregis.sql");

$result = "$sql_file";
mysql_query($result, $dbi);

Please help me.

Thank you. 🙂

[mykg4orce]

try to give the full path to the sql file....

[bad_goose]

Yeah

[nivlaC]

Okay, I did that and it still didn't work.

[KevinMG]

add an 'or die("Problem Here")' after your include file. i've run into this many times where that was what was causing the error, but without the 'or die()' after it, the error may not get thrown

so:

include "../config.php" or die("Here is the problem hopefully?");

if that doesn't trigger anything, put or die() after some of the other thing actually executing code.

[MrAlaska]

I have not tried to evoke a script in that manner, I didn't know you could execute a sql file directly with a mysql_query, but this line doesn't make sense to me.

$sql_file = file_get_contents("sql/stregis.sql");
$result = "$sql_file";
mysql_query($result, $dbi);

Why are you reassigning $sql_file, and why put it in quotes? It seems to me like it should look like this:

$sql_file = file_get_contents("sql/stregis.sql");
mysql_query($sql_file, $dbi);

You might also want to put an 'or die("SQL error ".mysql_error()) after your query, and echo back your sql statement.

It appears the file will just load as a multi lined SQL statements. The documentation says you can do that, but I have never had good luck with it. Perhaps I was doing something wrong, if you get it figured out pleas post the results and what you found wrong.

[nivlaC]

Alright, thanks, MrAlaska.

The error is:

SQL error You have an error in your SQL syntax near '; CREATE TABLE admin ( id int(10) NOT NULL auto_increment, username varch' at line 17

I find this extremely weird because the SQL file is from PHPMyAdmin. It works when I execute it in PHPMyAdmin, but not in my script.

Here's the 'error' part:

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
id int(10) NOT NULL auto_increment,
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
email varchar(250) NOT NULL default '',
lastloggedin varchar(30) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

#

Dumping data for table admin

#

INSERT INTO admin VALUES (1, 'Calvin', 'asdf', 'fdsa', 'aa');

[MrAlaska]

Is it choking on the first semicolon after the first SQL statement? That's where my attempts failed, even though the individual statements executed fine. Obviously there is a way to do it, as evinced by all the apps that have built in table installation, but I have never taken the time out the problem.

EDIT: Ooops, reading agian, I guess you are making it past the first statement. You are further than I have made it so far.

[nivlaC]

I still can't fix it.

I don't know what you mean by 'as evinced by all the apps that have built in table installation'.

[MrAlaska]

Originally posted by nivlaC
I don't know what you mean by 'as evinced by all the apps that have built in table installation'.

I mean, for instance, if you upload a forum package you don't need to create the tables yourself, you just go to config.php or something like that and let the PHP pages build the tables. I haven't used PhpMyAdmin, but from your comments it sounds like they might do the same thing? There must be something in the code that is calling the .sql file that is different, but I don't know what.

[nivlaC]

That's what I'm doing except instead of a bunch of queries, I'm trying to get the SQL file into a single query.

[nivlaC]

Who cares, I just did the 'multiple queries' thing. 😉

[MrAlaska]

I was rooting for you! I know I am gonna need to solve this myself in the weeks to come, I was hoping to take have it all figured out by then. The book says you can do it, there must be a way l

[nivlaC]

Well, not saying I'm not going to have to do it. I can leave it for the install.php script, however I'm making a SQL backup execution function and I'll have to find a way to get it to work.

PHPMyAdmin does something similiar to this. I've tried looking at their code, but it's kind of complicated to understand. You know how some programmers are... 🙂

Anyways, thanks for all the replies. I appreciate it.