php制作留言板二[源码]

作者: phper
时间: 2015-07-04
分类: php代码

<?php

require_once("inc/connect.php");

$myname =get_value('myname',post);

$mymail =get_value('mymail',post);

$mytel =get_value('mytel',post);

$mybook =get_value('mycontent',post);

//exit($mymail);

if(strlen($myname)>100 || strlen($myname)<1){alert('用户长度1-100','');}

if(!@preg_match("/\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/",$mymail) || strlen($mymail)<6 ){alert('请输入正确的邮箱地址以便我们与你联系！','');}

if(!@preg_match("/\d{3}-\d{8}|\d{4}-\d{7}/",$mytel)){alert('请输入合法的电话如：0731-******','');}

$sql ="select * from tbn where gx_object='$myname' and gx_mail='$mymail'";

$result =mysql_query($sql);

if(mysql_num_rows($result)){

mysql_free_result($result);

alert('提示，你己提交留言，请不要重复提交！','');

}

$sql ="Insert into tbn(gx_content,gx_time,gx_tel,gx_mail,gx_object) value('$mybook','".date('y-m-d')."','$mytel','$mymail','$myname')";

mysql_query($sql) or die(alert('你的留言中有非法数据！',''));

alert('提示：留言成功',$_SERVER['HTTP_REFERER']);

最四步就是显示留言了.

<?php

include("../inc/connect.php");

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>无标题文档</title>

<!--

.STYLE1 {color: #000000}

.STYLE2 {color: #0000FF}

-->

</style>

<!--

function all_(str){

var box_l = document.getElementsByName("box_x[]").length;

for(var j = 0 ; j < box_l ; j++){

document.getElementsByName("box_x[]")[j].checked = str;

}

--></script>

</head>

<body>

<tr>

<td width="100%">你正在管理留言信息... </td>

</tr></form>

</table></td>

</tr> <form id="form1" name="form1" method="post" action="menu_sava.php?action=allbook">

<?php

$result =mysql_query("select * from tbn");

$pagecount=1;

$order=1;

if(isset($_POST['key'])){

$key=str_replace("'","*",$_POST['key']);

}else if(isset($_GET['key'])){

$key=str_replace("'","*",$_GET['key']);

}else{

$key='';

}

$total="select * from tbn";

$sql="select * from tbn";

if(!empty($key) && !is_null($key) && strlen($key)>2 && strlen($key)<50 ){

$total.=" where gx_title like '%$key%' ";

$sql.=" where gx_title like '%$key%' ";

}

$result=mysql_query($total) or die('fail1'.mysql_error());

$rs=mysql_fetch_array($result);

$rdcount=mysql_num_rows($result);

if($rdcount){

$pagesize=15;

$pagecount=($rdcount % $pagesize)?(int)($rdcount / $pagesize)+1:$rdcount/$pagesize;//统计总页面

$page=isset($_GET['page'])?$_GET['page']:1;//取得当前页面

$start=($page>=1 && $page<=$pagecount)?$start=$pagesize*($page-1):$start=1;//取得超始记录

$order=isset($_GET['order'])?$_GET['order']:4;

$sql.=" order by id desc limit $start,$pagesize";

$resulte=mysql_query($sql) or die('fail'.mysql_error());

while ($rs =mysql_fetch_array($resulte) ){

?> <tr>

标题：<?php echo $rs['gx_title']?>

作者：<?php echo $rs['gx_object']?>

电话：<?php echo $rs['gx_tel']?>

时间：<?php echo $rs['gx_time']?>

邮箱：<?php echo $rs['gx_mail']?></td>

 <?php echo $rs['gx_content']?> </td>

<td width="7%" align="center" valign="bottom" class="td_heng"><a href="menu_sava.php?action=delguest&id=<?php echo $rs[0];?>" onclick="javascript:return confirm('确认删除？删除后无法恢复','','');">删除</a></td>

</tr>

<tr>

</tr>

<?php

}

<tr>

<tr>

<?php

$url ="?key=".rawurlencode($key)."&orderby=$order&page=";

pagelist(@$page,$pagecount,$rdcount,$url,@$pagesize);

?></td>

</tr>

</table></td>

</tr> </form>

</table>

</body>

</html>

注:原创文章转载请注明:www.phprm.com

文章地址:http://www.phprm.com/code/b8f7f5395ac22edad4779f8bf9de3bb8.html

转载随意^^请带上本文地址!

标签：none

PHP入门

php制作留言板二[源码]

发表留言