DROP DATABASE IF EXISTS

Objectives:

• mysql_select_db function
• Primary Key
• Default set-up for Database Engine
• Both command line and with PHP

<?php
// Connect to mysql
// ----------------------------------
$connect = mysql_connect("localhost", "root","")
or die("could not connect");
echo "<b>CONNECTED TO ------ <br>";
$sql = "DROP DATABASE IF EXISTS wineproject";
$create= mysql_query( $sql, $connect );
echo "database wineproject is dropped <br>";
$sql = mysql_query("CREATE DATABASE IF NOT EXISTS wineproject") or die(mysql_error());
echo "database wineproject is CREATED";
//use the active and designated one
mysql_select_db("wineproject");
$drop_table=("DROP TABLE prouder IF EXISTS") OR die(mysql_error());
$reasult=mysql_query($drop_table);
echo "---table producer dropped---";
$create_table=("DROP TABLE proudcer IF EXISTS") OR die(mysql_error());
$producer="CREATE Table producer (
p_id int(11) not null auto_increment,
p_name varchar(50) not null,
p_address varchar(100),
p_country varchar(10) not null,
PRIMARY KEY (p_id)
)";
$results= mysql_query($producer) or die(mysql_error());
echo "<br>Table producer is created" ;

?>