PHP開發(fā)之留言板發(fā)布留言
我們?cè)赑HP頁(yè)面處理html傳過來數(shù)據(jù),首先要判斷傳過來的數(shù)據(jù)是不是為空,驗(yàn)證碼是不是正確,然后再是往數(shù)據(jù)庫(kù)里面插入我們html傳過來的數(shù)據(jù)
代碼如下
<?php session_start(); header("content-type:text/html;charset=utf-8"); $name=$_POST['name']; $email=$_POST['email']; $content=$_POST['content']; $vcode=$_POST['vcode']; if($name==''){ echo "<script>alert('請(qǐng)輸入你的姓名');location='" . $_SERVER['HTTP_REFERER'] . "'</script>"; exit; } if($content==''){ echo "<script>alert('留言內(nèi)容不能為空');location='" . $_SERVER['HTTP_REFERER'] . "'</script>"; exit; } if($vcode!=$_SESSION['VCODE']){ echo"<script>alert('你的驗(yàn)證碼不正確,請(qǐng)重新輸入');location='".$_SERVER['HTTP_REFERER']. "'</script>"; exit; } $conn=mysqli_connect('localhost','root','root','ressage'); mysqli_set_charset($conn,'utf8'); //設(shè)定字符集 if($conn){ $sql=mysqli_prepare($conn,"insert into ressage_user(name,email,content,ressage_time) VALUES (?,?,?,now())"); $param=mysqli_stmt_bind_param($sql,'sss',$name,$email,$content); $result=mysqli_stmt_execute($sql); if($result){ echo "<script>alert('留言成功');location.href='ressage.php';</script>"; }else{ echo"<script>alert('你的留言失敗,請(qǐng)稍后重試');location.href='ressage.php';</script>"; exit; } }else{ die("數(shù)據(jù)庫(kù)連接失敗". mysqli_connect_error()); }