create_table.php

这是php专业项目实例开发一书的源代码,希望对大家有所帮助!

 <?php
                   
    $connection= mysql_connect("localhost","root","") 
        or die("Could not connect to MySQL in localhost !");
    $selectdb=mysql_select_db("Mailinglist") 
        or die("Could not select Mailinglist Database!");
    $sqlquery = "create table if not exists Maildata (Name varchar(50) Not Null, Email varchar(50) Not Null, Secondaryemail varchar(50) Not Null Primary Key)";
    $queryresult = mysql_query($sqlquery) 
	or die(" Query could not be executed.");
  echo " Table Maildata successfully created in the Mailinglist database.";
    ?>