留言本
假设现在有数据库:test表:mess字段:id,name,message
1、html页面,填写留言:
<form method="post" action="post.php">
留言者:<input type="text"name="name" />
留言内容:<input type="text"name="message" />
<input type="submit" value="提交" />
</form>
2、post.php页面,处理留言:
$name = $_POST['name'];
$message = $_POST['message'];
Try{
$dsn = ''mysql:host=localhost;dbname=test;
$pdo = new PDO($dsn,'root','112233');
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$pdo->query('set names utf8');
$sql = "insert into test(name,message)values('$name','$message')";
$result = $pdo->exec($sql);
If($result){
Echo ‘留言成功’;
}else{
Echo '留言失败';
}
}catch(PDOException $e){
Echo $e->getCode().' : '.$e->getMessage();