<html>
<head>
<title>สร้างฐานข้อมูล 1</title>
<link href="./style.css" rel="stylesheet" type="text/css">
</head>
<?
include("config.inc.php");
mysql_connect($host,$user,$passwd) or die("Unable to Connect");
$sql1 ="CREATE TABLE webboard_data (
No int(5) NOT NULL auto_increment,
Category varchar(50) NOT NULL default '',
Question varchar(100) NOT NULL default '',
Note text NOT NULL,
Name varchar(50) NOT NULL default '',
Namer varchar(50) NOT NULL default '',
Member tinyint(1) NOT NULL default '0',
Memberr varchar(50) NOT NULL default '',
IP varchar(15) NOT NULL default '',
Email varchar(50) NOT NULL default '',
Reply int(5) NOT NULL default '0',
ReplyDate varchar(20) NOT NULL default '',
Date datetime default NULL,
nphoto varchar(50) default NULL,
pageview char(3) default '0',
PRIMARY KEY (No)
) ";
$sql2 = "CREATE TABLE webboard_ans (
No int(5) NOT NULL auto_increment,
QuestionNo int(5) NOT NULL default '0',
Name varchar(50) NOT NULL default '',
Namer varchar(50) NOT NULL default '',
Member tinyint(1) NOT NULL default '0',
IP varchar(15) NOT NULL default '',
Email varchar(50) NOT NULL default '',
Msg text NOT NULL,
Date datetime default NULL,
nphoto text,
PRIMARY KEY (No)
)";
$sql3 = "CREATE TABLE webboard_member (
id int(6) NOT NULL auto_increment,
User varchar(10) NOT NULL default '',
Password varchar(10) NOT NULL default '',
Email varchar(30) default NULL,
ICQ varchar(15) default NULL,
WebName varchar(80) default NULL,
URL varchar(80) default NULL,
Date datetime default NULL,
BDdate varchar(20) NOT NULL default '',
Profile text,
memphoto varchar(50) default NULL,
IP varchar(16) default NULL,
icon varchar(8) NOT NULL default '',
PRIMARY KEY (id)
)";
$result1 = mysql_db_query($dbname,$sql1);
$result2 = mysql_db_query($dbname,$sql2);
$result3 = mysql_db_query($dbname,$sql3);
if($result1!=0 && $result2!=0 && $result3!=0) {
echo "<center>";
echo "<table width=60% border=1 bordercolor=#ff69b4 bgcolor=#f0ffff cellpadding=2 cellspacing=0>";
echo "<tr><td align=center>";
echo "<font size=2 face='MS Sans Serif'>";
echo "<font size=3 color=red><b>ได้สร้างฐานข้อมูลแล้ว</b></font><br><br>";
echo "<font color=blue>webboard_ans , webboard_data , webboard_member</font>";
echo "</font></td></tr>";
echo "<tr><td align=center><br>";
echo "<font size=3 color=red><b>ถ้าต้องการงสร้าง table useronline ด้วย</b></font><br>";
echo "<font size=3 color=red> <a href=\"setup2.php\">กด setup2</a> </font><br><br>";
echo "</font></td></tr></table>";
echo "<br><hr width=500 color=blue>";
echo "</center>";
exit();
}
else {
echo "<center>";
echo "<table width=60% border=1 bordercolor=#ff69b4 bgcolor=#f0ffff cellpadding=2 cellspacing=0>";
echo "<tr><td align=center>";
echo "<font size=2 face='MS Sans Serif'>";
echo "<font size=3 color=red><b>ได้สร้างฐานข้อมูล webboard_ans , webboard_data , webboard_member ไปแล้ว</b></font><br><br>";
echo "หรือมีข้อผิดพลาดที่ระบบ<br><br>";
//echo "กรุณาแจ้ง <font color=blue>admin</font> ให้ตรวจสอบด้วยครับ";
echo "</font></td></tr>";
echo "<tr><td align=center><br>";
echo "<font size=3 color=red><b>ถ้าต้องการงสร้าง table useronline ด้วย</b></font><br>";
echo "<font size=3 color=red> <a href=\"setup2.php\">กด setup2</a> </font><br><br>";
echo "</font></td></tr></table>";
echo "<br><hr width=500 color=blue>";
echo "</center>";
exit();
}
?>
</body>
</html>