Creating a Database


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.




    Spring Into PHP 5
    Spring Into PHP 5
    ISBN: 0131498622
    EAN: 2147483647
    Year: 2006
    Pages: 254

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net