You can even create a whole new database from PHP. Here's an example, where we're creating a database named foods using the CREATE DATABASE command: $query = "CREATE DATABASE IF NOT EXISTS foods"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); And we'll add a new table to this database, snacks: $db = mysql_select_db("foods", $connection) or die ("Couldn't select database"); $query = "CREATE TABLE snacks (name VARCHAR(20), number VARCHAR(20))"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); All it takes now is some INSERT statements in phpdatacreatedb.php, Example 8-6. Example 8-6. Creating a new database, phpdatacreatedb.php<HTML> <HEAD> <TITLE>Creating a new database</TITLE> </HEAD> <BODY> <CENTER><H1>Creating a new database</H1> <?php $connection = mysql_connect("localhost","root","") or die ("Couldn't connect to server"); $query = "CREATE DATABASE IF NOT EXISTS foods"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); $db = mysql_select_db("foods", $connection) or die ("Couldn't select database"); $query = "CREATE TABLE snacks (name VARCHAR(20), number VARCHAR(20))"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); $query = "INSERT INTO snacks (name, number) VALUES('tacos', '2843')"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); $query = "INSERT INTO snacks (name, number) VALUES('pizza', '1955')"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); $query = "INSERT INTO snacks (name, number) VALUES('cheeseburgers', '849')"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); $query = "SELECT * FROM snacks"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); echo "<TABLE BORDER='1'>"; echo "<TR>"; echo "<TH>Name</TH><TH>Number</TH>"; echo "</TR>"; while ($row = mysql_fetch_array($result)) { echo "<TR>"; echo "<TD>", $row['name'], "</TD><TD>", $row['number'], "</TD>"; echo "</TR>"; } echo "</TABLE>"; mysql_close($connection); ?> </CENTER> </BODY> </HTML> The results, including the new database, appear in Figure 8-6. Outstanding. Figure 8-6. Creating a new database. |