create_table.php

来自「《PHP专业项目实例开发》源代码」· PHP 代码 · 共 12 行

 <?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.";
    ?>