Create guestbook table : mysql_select_db « MySQL Database « PHP






Create guestbook table

 
<html>
 
 <head> 
  <title>Create guestbook table</title> 
 </head>
    
 <body>

 <?php

  $conn = @mysql_connect("localhost", "userName", "password") or die("Could not connect to database");
  
  $rs = @mysql_select_db("my_database", $conn) or die("Could not select database");
 
  $query = "id int(4) auto_increment, name varchar(50),";
  $query.= "email varchar(50), comments text, ";
  $query.= "time timestamp(14), primary key(id)";
  $sql = "create table guestbook($query)";
  
  $rs = @mysql_query ($sql);

  if( $rs )
  {
    $msg = "<h3>Created guestbook table</h3>";
  }
  else
  {
    $msg = "<h3>Could not create guestbook table";
    $msg.= "<br>Does it already exist?</h3>";
  }
  echo($msg);
 ?>

 </body>

</html>
  
  








Related examples in the same category

1.Using MySQL with PHP
2.Opening a Connection and Selecting a Database
3.mysql_select_db(): select database
4.mysql_select_db.php
5.mysql_select_db.php