<?php
$dbhost = 'localhost:3306';? // mysql服務(wù)器主機地址
$dbuser = 'root';? ? ? ? ? ? // mysql用戶名
$dbpass = '123456';? ? ? ? ? // mysql用戶名密碼
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
? ? die('連接失敗: ' . mysqli_error($conn));
}
echo '連接成功<br />';
$sql = "CREATE TABLE runoob_tbl( ".
? ? ? ? "runoob_id INT NOT NULL AUTO_INCREMENT, ".
? ? ? ? "runoob_title VARCHAR(100) NOT NULL, ".
? ? ? ? "runoob_author VARCHAR(40) NOT NULL, ".
? ? ? ? "submission_date DATE, ".
? ? ? ? "PRIMARY KEY ( runoob_id ))ENGINE=InnoDB DEFAULT CHARSET=utf8; ";
mysqli_select_db( $conn, 'RUNOOB' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
? ? die('數(shù)據(jù)表創(chuàng)建失敗: ' . mysqli_error($conn));
}
echo "數(shù)據(jù)表創(chuàng)建成功\n";
mysqli_close($conn);
?>
