Simply Create a DB

[Diablo3k]

Could someone (in a non-flame type of way), please give me an example of simply creating a sql db?

Another question, this will work with sokkit, and mysql installed on a localhost correct? Thanks in advance 😃

[laserlight]

It could be as simple as:

CREATE DATABASE foo

[Diablo3k]

Originally posted by laserlight
It could be as simple as:

CREATE DATABASE foo

Wow, so helpful , and i couldnt figure out if you were calling me foo or not o.O. Ill deffinately be comming back to phpbuilders for their friendly forum help. pfft back to the php irc.

[Diablo3k]

Check that out foo

mysql_create_db(): This function is deprecated, please use mysql_query() to issue a SQL CREATE DATABASE statement instead

Does anyone know how to effectively create a database using php?

[yelvington]

I'm not sure why this is confusing, but here's an example.

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}

$result = mysql_query('create database foo');

if (!$result) 
   die('Invalid query: ' . mysql_error());

else echo 'You dunnit.';

mysql_close($link);
?>

After the DB is created you can go about the process of creating tables and inserting data.