creating tables using php on remote server

hackersapien

Php enthusiasts,
I've created a database with 2 tables on my local machine,each of the tables have a total of 30 records.I now need to move this tables to a remote mysql server, unfortunately I do not have remote access to the server.
I have dumped the two tables now I need to create the tables using php and insert the records on the remote server.
How can I do this?

alanzhao

phpMyAdmin

superwormy

mysql_query ("CREATE TABLE... [insert rest of your create table statement here...] ");

mysql_query ("INSERT INTO... [contents of the dump here...]);

hackersapien

Thanks for the help, I used the sql script that was generated when I dumped the database to create the tables in php like this:

$query="CREATE TABLE radiomweb (id int(10) unsigned NOT NULL auto_increment,title char(120) NOT NULL default '',imageurl char(40) NOT NULL default '',PRIMARY KEY  (id)) TYPE=MyISAM;";
	$result=mysql_query($query);]

The only problem came in inserting the records into the table I was not sure on how I was going to run 42 insert statements.

If you have any ideas pliz help me.

Cheers

superwormy

Are they each on their own line?

You could use file() to get the file contents line by line into an array, then loop through the array.

foreach ($array as $value) {

mysql_query ($value) or die (mysql_error());

}

Otherwise, fine another way to break the queries apart, maybe they're seperated by ; or , or somethign, then loop through array made with explode()
www.php.net/explode

hackersapien

Superwormy,
You must be a genius I used the explode() function to break up the insert statements which were separated by a semi-colon ";".The code is below incase anyboy wants to know:

$sql=explode(';',$stmt);
$i=0;
for($val=0;$i<count($sql);$i++)
{
$result=mysql_query($sql[$i]);

}

This is a portion of the sql:

$stmt="INSERT INTO radiomweb VALUES (2,'Background','rd2.jpg');INSERT INTO radiomweb VALUES (3,'Methodology','rd3.jpg');
INSERT INTO radiomweb VALUES (4,'Cost','rd4.jpg');
INSERT INTO radiomweb VALUES (5,'Stations Listened to nowadays','rd6.jpg');
INSERT INTO radiomweb VALUES (6,'Stations listened to most often','rd7.jpg');"

Thanks superwormy.
Cheers