留言板--PHP+MySQL开发_tkcms-优快云博客

本文链接：https://blog.youkuaiyun.com/tk86935367/article/details/8271795

经过一段时间的测试，终于搞定一个留言板系统的开发。做个记录，以便能再次学习。

一、创建数据库，保存留言信息

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>