PHP创建数据库与表实例

首先选择数据库。通过 mysql_select_db() 函数选取数据库。使用 mysql_query()函数用于向 MySQL 连接发送查询或命令，向 mysql_query() 函数添加语句。
（一）创建数据库
CREATE DATABASE 语句用于在 MySQL 中创建数据库。
语法：
CREATE DATABASE database_name

（二）创建表
CREATE TABLE 用于在 MySQL 中创建数据库表。
语法：
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
.......
)

例子：
<?php

  $conn = mysql_connect("localhost","root", "");

   if (!$conn){

      die("无法连接--MYSQL: " . mysql_error());

   }else{

         mysql_query("drop  database if exists  datasafe",$conn);

        if (mysql_query("create  database  datasafe",$conn)){

                 echo "数据库创建OK<br/>";

            }else{

                 echo "数据库创建失败: " . mysql_error();

         }

  }

       

 if (mysql_select_db("datasafe", $conn)){

        $sql1 = "create table  config
              (
                   ckey varchar(64),
                   value int
              )";

        $sql2 = "create table  filter_rules
              (
                   type  int,
                   value varchar(32)
              )";

         $sql3 = "create table  password
              (
                   type  int,
                   pw    varchar(64),
                   user  int
              )";

         $sql4 = "create table  policy
              (
                   app    varchar(512),
                   md5    varchar(32),
                   r      bool,
                   w      bool
              )";
         
         $sql5 = "create table  status
              (
                   alive  timestamp,
                   cmd  varchar(32)
              )";

         $sql6 = "create table  log
              (
                   time   timestamp,
                   user   int,
                   level  int,
                   msg    text
              )";
          
         $sql=array("$sql1","$sql2","$sql3","$sql4","$sql5", "$sql6");

         for($i=0;$i<count($sql);$i++){
                 if( mysql_query($sql[$i],$conn)){
                     echo "数据表创建OK"."<br/>";
                 }else{
                     echo "数据表创建ERROR"."<br/>";
                }
         }

         $sqlstr = "insert into policy(app,md5,r,w) values("/usr/bin/brnvim", "e446aae508408d1dfea7264fd26292ef", true, true)";
         mysql_query($sqlstr, $conn);

         $sqlstr = "insert into config(ckey,value) values("password_type", "1")";
         mysql_query($sqlstr, $conn);

         $sqlstr = "insert into config(ckey,value) values("log_level", "1")";
         mysql_query($sqlstr, $conn);

         $sqlstr = "insert into password(type, pw, user) values("1", "124567", "0")";
         mysql_query($sqlstr, $conn);

         $sqlstr = "insert into filter_rules(type, value) values("1", "*.java")";
         mysql_query($sqlstr, $conn);
 }else{

        echo "数据库选择发生异常";
 
 }

   mysql_close($conn);

 
?>

 

转载注明出处：http://blog.csdn.net/ecorefeng