Jump to content

Archived

This topic is now archived and is closed to further replies.

baber_abbasi

creating database on hosting server

Recommended Posts

I have hosting service with database support. There is no database created on the server as yet. I am trying to create one with my script but it is giving me error while on my local machine it executes successfully.

 

The code that I am using is as below;

 

<?php

 

$sqlcrt = mysql_query(\"create database air\");

 

$dbhost = \'localhost\';

$dbusername = \'abc\';

$dbpasswd = \'xyz\';

$database_name = \'air\';

 

$connection = mysql_pconnect(\"$dbhost\",\"$dbusername\",\"$dbpasswd\")

or die (\"Couldn\'t connect to server.\");

 

$db = mysql_select_db(\"$database_name\", $connection)

or die(\"Couldn\'t select database.\");

 

$query = mysql_query(\"CREATE TABLE cities (

id int(10) NOT NULL auto_increment,

name varchar(30) NOT NULL default \'\',

regid int(10) NOT NULL default \'0\',

PRIMARY KEY (id),

UNIQUE KEY id (id)

)\");

 

 

?>

 

The username and password used above are same as used for connecting to server through FTP.

 

Plz give me some hint how to resolve the prob.

 

Thankx for time.

Share this post


Link to post
Share on other sites

u havent said mucha bout the error u get.

 

Are u sure u have the database created in the remote server?

 

now if ur host is a unix server u can try to use

 

exec and try to execute the script as .sql

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.