Checking For Mysql Database Existance

[satal_keto]

I was wondering would it be possible to check if a MySQL database existed, and if it doesn't to create it then connect to it and if the database does exist just connects to it.

I can do the connecting to the database and I can do the creating the database, but i can't figure out how to check for the existance of the database.

[rincewind456]

This should do it:

<?php
$user = "USER"; //MySQL user name
$pass = "PASSWORD"; //MySQL password
$db = "new_test"; //Name of database

$new_db = 'CREATE DATABASE new_test'; //edit database name so it's the same as  $db

$conn = mysql_connect( "localhost", $user, $pass );

if ( ! $conn ) die( "Couldn't connect to MySQL" );

if (!mysql_select_db( $db )){ mysql_query($new_db, $conn);

print "<p>Successfully created database \"$db\"<P>";
//Then uncomment this next line to connect to it with
//mysql_select_db( $db ) or die ( "Couldn't open $db: ".mysql_error() );
} else {

print '<p>Database already exists</p>';
// your already connected here so change this as required
}

?>