create new database if it doesn't exist

rupertbj

I have a website www.rupertbj.co.uk and i am just learning PHP and MySQL - the question is this:

I have a database and users have to add their e-mail address to this database to view my site. I set up the database initially with phpMyAdmin. I want to be able write the code so that if the database exists to entry is added, and if it doesn't exist, a new database would be created and the entry added.

Thank you in advance for your help - current code as follows:

<?php
if ((!ereg(".+@.+..+", $user)) || (!ereg("^{[a-zA-Z0-9_@.-]+$",} $user)))
{
print "
<body bgcolor=\"#8080FF\">
<b>Invalid Email address! Please <a href=/index.html>register</a> properly!!!</b>
";
exit;
}
else
{
setcookie( "user", $user, "0" );
$db = "register";
$link = mysql_connect( "localhost:/users/rupertbj/domains/rupertbj.co.uk/sql/mysql.sock", "root" );
if ( !$link ) die( "Couldn't connect to MySQL" );
mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
$sql = "INSERT INTO user VALUES ( '$user' )";
if ( mysql_query( $sql, $link ) )
{
echo "";
}
else
{
echo "";
}
mysql_close( $link );
}
?>

piersk

To figure out whether the database exists, you could do the following:

<?php

$server="yourserver";
$user="username";
$password="password";
$dbname="database";

$connect=mysql_connect($server,$user,$password);

if($connect)
{
      if(!(mysql_select_db($dbname,$connect)))
      {
            $query="create database database_name";
            mysql_query($query,$connect);
       }
}

JMJimmy

The question is: why would you want a database per user? Why not just create a table in your database called "users" and enter in any info there.

JMJimmy

piersk

yes, but if there isnt one to start with, he is going to want to create it automatically and if there is one to start with, it will just add the information into the table...

to rupertbj: Dont forget to include the queries to create the tables in the bit where you create the database...

rupertbj

......i just didn't want to have to go creating a database through phpMyAdmin everytime!

thanks for the response.

rupertbj

mrmufin

Alternatively, you could use the mysql_list_dbs() function to show what databases exist on a server...