IT工程師數位筆記本

<?php
/*
默認建立的數據庫為test,數據表為admin,管理員只需要修改DB_PWD（即本地的服務器密碼）即可，用戶密碼采用md5加密
*/
define(DB_HOST,"localhost");
define(DB_USER,"root");
define(DB_PWD,"yuyouwen");
define(DB_NAME,"test");

$con=mysql_connect(DB_HOST,DB_USER,DB_PWD)or die("無法連接數據庫服務器！");
mysql_select_db(DB_NAME,$con);
// Create database
if(!mysql_select_db(DB_NAME,$con)) {
    mysql_query("CREATE DATABASE test");
    if(mysql_select_db(DB_NAME,$con)){
    $query="CREATE table admin (
          `id` smallint(5) NOT NULL auto_increment,
          `username` varchar(35) NOT NULL,
          `password` varchar(35) NOT NULL,
          `email` varchar(35) NOT NULL,
          `regTime` varchar(35) NOT NULL,
          PRIMARY KEY  (`id`)
         )";
        mysql_query($query);        
    }
    }
?>