mysql_query("CREATE DATABASE IF NOT EXISTS
Check existing database

This example is to check the databases using function...................

It could have been done with one line code when you just create a database that does not exists.

$sql = mysql_query("CREATE DATABASE IF NOT EXISTS wineprogect") or die(mysql_error);
 

Code

<?php
$link = mysql_connect("manas8x", "root", "Manas8");
?>
<html><title> If a database exists</title><body text="#000080" bgcolor="#E6F7F9">
<?php ?>
<form method="post" action="exists_db.php">
<input type="text" name="T1" size="20"><input type="submit" value="Submit" name="B1">
</from><br/>
<?php

$db_list = mysql_list_dbs($link);
$i = 0; $dbn; $db = $_POST['T1'];
while ($row = mysql_fetch_object($db_list)) {
$i++;
echo "DB $i : ".$row->Database . "<br/>";
$dbn[$i] = $row->Database;
if($dbn[$i] == $db) {
$db_found = true;
}

}
echo("-------- <br/><font color='#FF0000'>");
if($db_found) {
echo "Database $db exists";
} else {
echo "Database $db doesn't exist";
}
echo("</font>");
?>
</body>
</html>