[Resolved] Using PHP to create sql

[ph3n0m]

I am trying to load information from an SQL file into my database via PHP, but i get a strange error when i try to access the sql script (sql.php), please note this script works fine when loaded into mysql outside of PHP.

I receive this 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 'Array' at line 1"

This is the code im using to access it

function getSqlQueries($file)
{
$file = file($file); // Weird line, huh? But it works!
$file = explode(";", $file);
return $file;
}

mysql_connect($_POST['mysql_server'], $_POST['mysql_user'], $_POST['mysql_pass']) or die (mysql_error());

foreach(getSqlQueries('admin/sql.php') as $col => $val)
mysql_query($val) or die(mysql_error());

mysql_close();

and sql.php looks like this:

DROP DATABASE core;
CREATE DATABASE core;
USE core;

CREATE TABLE core_article
(
article_id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(120) NOT NULL,
subtitle VARCHAR(250) NOT NULL,
author_id INT NOT NULL,
cat_id INT NOT NULL,
body TEXT NOT NULL,
enabled SMALLINT NOT NULL,
timestamp INT NOT NULL,
PRIMARY KEY (article_id),
FOREIGN KEY (author_id) REFERENCES core_users(user_ID),
FOREIGN KEY (cat_id) REFERENCES core_article_category(article_categoryID)
)TYPE=MyISAM;

CREATE TABLE core_article_category
(
article_categoryID INT NOT NULL AUTO_INCREMENT,
category_name VARCHAR(200),
PRIMARY KEY (article_categoryID)
)TYPE=MyISAM;

CREATE TABLE core_users
(
user_ID INT NOT NULL AUTO_INCREMENT,
user_name VARCHAR(200) NOT NULL,
user_password VARCHAR(20) NOT NULL,
user_email VARCHAR(100) NOT NULL,
user_join INT,
user_class INT,
PRIMARY KEY (user_ID),
FOREIGN KEY (user_class) REFERENCES core_user_classes(class_id)
)TYPE=MyISAM;

CREATE TABLE core_user_classes
(
class_id INT NOT NULL AUTO_INCREMENT,
class_name VARCHAR(200) NOT NULL,
PRIMARY KEY (class_id)
)TYPE=MyISAM;

CREATE TABLE core_comments
(
comment_id INT NOT NULL AUTO_INCREMENT,
comment_pid INT NOT NULL,
comment_subject VARCHAR(200) NOT NULL,
comment_body TEXT NOT NULL,
comment_author VARCHAR(200) NOT NULL,
comment_author_email VARCHAR(200) NOT NULL,
comment_disabled TINYINT(3) NOT NULL,
PRIMARY KEY (comment_id),
FOREIGN KEY (comment_pid) REFERENCES core_article(article_id)
)TYPE=MyISAM;

CREATE TABLE core_upload
(
upload_id INT NOT NULL AUTO_INCREMENT,
upload_name VARCHAR(200) NOT NULL,
upload_category INT NOT NULL,
upload_description TEXT NOT NULL,
upload_datestamp INT,
PRIMARY KEY (upload_id),
FOREIGN KEY (upload_category) REFERENCES core_upload_cat(upload_catid)
)TYPE=MyISAM;

CREATE TABLE core_upload_cat
(
uploadcat_id INT NOT NULL AUTO_INCREMENT,
uploadcat_name VARCHAR(200) NOT NULL,
PRIMARY KEY (uploadcat_id)
)TYPE=MyISAM;

CREATE TABLE core_forum_topics
(
topic_id INT NOT NULL AUTO_INCREMENT,
topic_title VARCHAR(150) NOT NULL,
topic_timestamp datetime,
topic_author INT,
PRIMARY KEY (topic_id),
FOREIGN KEY (topic_author) REFERENCES core_users(user_ID)
)TYPE=MyISAM;

CREATE TABLE core_forum_posts
(
post_id INT NOT NULL AUTO_INCREMENT,
post_tid INT NOT NULL,
post_body TEXT,
post_timestamp datetime,
post_author INT,
PRIMARY KEY (post_id),
FOREIGN KEY (post_author) REFERENCES core_users(user_ID),
FOREIGN KEY (post_tid) REFERENCES core_forum_topics(topic_id)
)TYPE=MyISAM;

anyone have any ideas?

[tekky]

you are trying t [man]explode/man an array already that [man]file/man already created, you want to try something like [man]file_get_contents/man

you may also want to consider revising your mysql_error() line and change it to something like

die('Error in mysql: ' . $sql . ' -- ' . mysql_error());

and obviously $sql would be whatever variable your query is stored in so you can see exactly what SQL line caused the error and validate that it was good SQL or not.