经过一段时间的测试，终于搞定一个留言板系统的开发。做个记录，以便能再次学习。
一、创建数据库，保存留言信息
create TABLE messages(
id INT NOT NULL AUTO_INCREMENT,
subject VARCHAR(150),
body TEXT,
PRIMARY KEY(id)
);
二、新建一个AddMessage.php
<?php
extract($_REQUEST);
if( isset($subject) && isset($body) )
{
mysql_connect("localhost","root","*******");
mysql_select_db("test");
mysql_query("set names gb2312");
mysql_query("INSERT INTO messages(subject,body)"."VALUES('$subject','$body')");
$status = "Message <i>$subject</i> has been post <br />";
}
?>
<html>
<body>
<h1>Post a message</h1>
<string><?= $status ?></strong>
<form action="<?php $_SERVER['PHP_SELF'] ?>" >
Subject <input type="text" name="subject" size="35">
<br /><br />
<textarea name="body" cols="40" rows="15"></textarea>
<br /><br />
<input type="submit" value="Post">
</form>
</body>
</html>
三、新建一个ShowMessages.php
<?php
mysql_connect( "localhost","root","*******");
mysql_select_db( "test" );
mysql_query("set names gb2312");
$result_set = mysql_query( "SELECT * FROM messages" );
$num_messages = mysql_num_rows( $result_set );
?>
<html>
<body align="center">
<h1>留言板</h1>
<i>这里总共有 <?= $num_messages ?> 条留言！</i>
<br /><br />
<div class="boardInfo" style="align:center;">
<?php
while($row = mysql_fetch_assoc( $result_set) )
{
$subject = $row['subject'];
$body = $row['body'];
print "<strong>$subject</strong><br />";
print "$body<br /><br />";
}
?>
</div>
</body>
</html>
