MYSQL5.5.3-m3 Apache2.2.15 phpMyAdmin3.3.2 前两个直接安装就可以使用，后一个直接解压在Apache2.2.15的htdocs目录下就可以使用
最小最简单php+mysql留言本:
最小最简单php+mysql留言本依据其他留言本程序将原php100留言本视频教程的n多错误修正，经测试通过
1.建立数据库：creatsql.php
<?php
$sqlhost="localhost";
$sqluser="root";
$sqlpass="abc";
$sqldata="abc123";
$con=mysql_connect($sqlhost,$sqluser,$sqlpass);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
if (mysql_query("CREATE DATABASE $sqldata",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_select_db($sqldata, $con);
$sql = "CREATE TABLE message
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
user TEXT,
title TEXT,
content TEXT,
dt DATETIME NOT NULL
)";
mysql_query($sql);
?>
通用调用文件：c.php:
<?php
$sqlhost="localhost";
$sqluser="root";
$sqlpass="abc";
$sqldata="abc123";
$con=mysql_connect($sqlhost,$sqluser,$sqlpass);
mysql_select_db($sqldata, $con);
mysql_query("set names utf-8");
?>
3. 主程序：add.php
<?php
include("c.php");
if($_POST[‘process’]==1)
{
$user = trim($_POST[‘user’]);
$title = trim($_POST[‘title’]);
$content = trim($_POST[‘content’]);
$query = ‘INSERT INTO message SET
user = "’.$user.’",
title = "’.$title.’",
content = "’.$content.’",
dt = NOW()’;
if(mysql_query($query))
{
echo ‘<p style="color:#00F;">发表成功！</p>’;
}
else
{
echo ‘<p style="color:#C00;">对不起，您的留言未能提交！</p>’;
}
}
?>
<form name="message" action="add.php" method="POST">
用户: <input type="text" name="user" /><br>
标题: <input type="text" name="title" /><br/>
内容:<textarea name="content" rows="10" cols="50" ></textarea><br/>
<input type="hidden" name="process" value="1" />
<input type="submit" value="发布留言"
</form>
<?php
$query = ‘SELECT * FROM message ORDER BY dt DESC’;
$result = mysql_query($query);
if(!$result)
{
echo ‘<p style="color:#C00;">无法查看留言！</p>’;
}
else
{
while($row = mysql_fetch_array($result))
{
echo ‘<p>’;
echo ‘<strong>’.$row[‘user’].'<strong><br />’;
echo $row[‘title’].'<br />’;
echo date(‘F j, Y’, strtotime($row[‘dt’])).’ at ‘.date(‘g:i a’, strtotime($row[‘dt’])).'<br />’;
echo $row[‘content’];
echo ‘</p>’;
}
}
?>