学步园

首先选择数据库。通过 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