Jump to content


Photo

creating database on hosting server


  • Please log in to reply
1 reply to this topic

#1 baber_abbasi

baber_abbasi
  • Members
  • PipPipPip
  • Advanced Member
  • 33 posts
  • LocationPakistan

Posted 02 May 2003 - 01:33 PM

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.
Baber N Abbasi

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 02 May 2003 - 03:07 PM

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
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users