[vipernet]

Working on a simple script to create a database using php with mysql server.

I get no connection errors, or creating DB errors, when i execute the script it just says done at the button of browers
Why doesn't this create the table?

PHP Code:

<?php
include 'config.php';
include 'opendb.php';

$query  = "CREATE DATABASE school";
$result = mysql_query($query);

include 'closedb.php';
?>

config.php

PHP Code:

<?php
// Connect to Database
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'DBname';

?>

opendb.php

PHP Code:

<?php
// open database
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
?>

closedb.php

PHP Code:

<?php
mysql_close($conn);
?>

[haswalt]

I see oyu have followed the tutorial here to the letter:
http://www.php-mysql-tutorial.com/cr...e-with-php.php

:P

Are you sure you have priviledges to create a table. if you are on web hosting you usually are not allowed. try adding:

PHP Code:

$result = mysql_query($query,$conn) or die(mysql_error()); 


in place of your current line to test this.

Are you sure you meant database as well not table?

[vipernet]

Error
Access denied for user 'ancientc'@'localhost' to database 'school'

thats what the problem was bud, thanks allot.

SO does this mean i have to create and make all the tables using phpmyadmin or is there a way around it.

Goal is to be able to add tables using a forms post..etc

[haswalt]

no create a database first, say schooll via phpmyadmin.

Then use your script to create tables i that database not databases themselves.

[vipernet]

I'm not sure what this error means "

I created a DB called dt08
now i'm getting an error "

Query was empty

Code:

PHP Code:


<?php
include 'config.php';
include 'opendb.php';


$result = mysql_query($query,$conn) or die(mysql_error()); 

mysql_select_db('dt08') or die('Cannot select database');

$query = 'CREATE TABLE contact( '.
         'cid INT NOT NULL AUTO_INCREMENT, '.
         'cname VARCHAR(20) NOT NULL, '.
         'cemail VARCHAR(50) NOT NULL, '.
         'csubject VARCHAR(30) NOT NULL, '.
         'cmessage TEXT NOT NULL, '.
         'PRIMARY KEY(cid))';

$result = mysql_query($query);

include 'closedb.php';
?>

[vipernet]

never mind figured that part out:

The "
$result = mysql_query($query,$conn) or die(mysql_error());
"
Wasn't needed becuase i had to take out the
$query = 'CREATE DATABASE school';
$result = mysql_query($query);
part becuase won't let me create a DB

[haswalt]

you all sorted now then?