<?php // 建立使用者資料庫與資料表

header("Content-Type:text/html; charset=utf-8");

$mysqli = new mysqli('localhost','root','admin');

$sql = "create database folder DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;";

$mysqli -> query($sql);

$mysqli = new mysqli('localhost','root','admin','folder'); // 連接到 folder 資料庫

$sql = "create table files (id integer auto_increment primary key, name varchar(64), filename varchar(64), comment varchar(250), folder_id int(11), INDEX (folder_id))"; // 建立 files 資料表

$mysqli -> query($sql);

$sql = "create table folder (id integer primary key, name varchar(256), owner varchar(32))"; // 建立 folder 資料表

$mysqli -> query($sql);

$sql = "create table user (sid integer auto_increment primary key, account varchar(32), password varchar(250), name char(32))"; // 建立 user 資料表

if($mysqli -> query($sql)){

echo "新增 user 資料表成功<br/>";

}else{ echo "新增 user 資料表失敗<br/>"; }

$mysqli->close();

?>

請參考登入系統與加密亂數的運用之密碼加解密範例 (不可逆加密與可逆加密混合應用)。