留言本
假設現在有資料庫: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();