SQL CREATE TABLE 語法
CREATE TABLE 表名稱
(
列名稱1 數(shù)據(jù)類型,
列名稱2 數(shù)據(jù)類型,
列名稱3 數(shù)據(jù)類型,
....
)

<span style="font-family:Comic Sans MS;font-size:14px;"><?php 
include("head.php"); 
$dbName = "bbs"; 
$conn = @ mysql_connect("localhost", "root", "") or die("數(shù)據(jù)庫鏈接錯誤"); 
$flag = mysql_select_db($dbName, $conn); 
mysql_query("set names 'GBK'"); //使用GBK中文編碼; 
function toHtmlcode($content) 
{ 
return $content = str_replace("\n","<br>",str_replace(" ", "&nbsp;", $content)); 
} 
?></span> 

<span style="font-family:Comic Sans MS;font-size:14px;"><?php 
// 引用之前寫好的連接數(shù)據(jù)庫文件 
include("conn.php"); 
if(@$_POST['submit']){ 
$sql = "insert into message (id,user,title,content,lastdate)" . 
"values ( '','$_POST[userName]','$_POST[title]','$_POST[content]',now())"; 
mysql_query($sql); 
echo "添加成功"; 
} 
?> 
<SCRIPT language=javascript> 
function CheckPost() 
{ 
if (myform.userName.value=="") 
{ 
alert("請?zhí)顚懹脩裘?); 
myform.user.focus(); 
return false; 
} 
if (myform.title.value.length<5) 
{ 
alert("標(biāo)題不能少于5個字符"); 
myform.title.focus(); 
return false; 
} 
if (myform.content.value=="") 
{ 
alert("必須要填寫留言內(nèi)容"); 
myform.content.focus(); 
return false; 
} 
} 
</SCRIPT> 
<form action="addmsg.php" method="post" name = "myform" onsubmit="return CheckPost();"> 
用名:<input type="text" size="10" name="userName" /><br/> 
標(biāo)題:<input type="text" name="title" /><br/> 
內(nèi)容:<textarea name="content" cols="60" rows="9" ></textarea><br/> 
<input type="submit" name="submit" value="提交留言" /> 
</form> 
</span> 

<span style="font-family:Comic Sans MS;font-size:14px;"><?php 
include("conn.php"); 
?> 
<table width=500 border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#add3ef"> 
<?php 
$sql = "SELECT * FROM message order by lastdate desc"; 
$query = mysql_query($sql); 
while($row = mysql_fetch_array($query)){ 
?> 
<tr bgcolor="#eff3ff"> 
<td><b><big> 
標(biāo)題：<?= $row['title']?></big><b/> <b><sub> 
用戶：<?= $row['user']?></sub></b></td> 
</tr> 
<tr bgColor="#ffffff"> 
<td>內(nèi)容：<?= toHtmlcode($row['content'])?></td> 
</tr> 
<?php 
} 
?> 
</table> 
</span>