prepare($sql);    $st->bindParam(':title', $title);    $st->bindParam(':tid', $tid);    $st->bindParam(':mid', $mid);    $st->bindParam(':uname', $uname);    $st->bindParam(':email', $email);    $st->bindParam(':homepage', $homepage);    $st->bindParam(':qq', $qq);    $st->bindParam(':face', $face, PDO::PARAM_STR);    $st->bindParam(':msg', $msg, PDO::PARAM_STR, 1000);    $st->bindParam(':ip', $ip);    $st->bindParam(':dtime', $dtime);    $st->bindParam(':ischeck', $ischeck);        $exec_result = $st->execute();        if($exec_result){        return rtn(1, '您已成功发表留言，但需审核后才能显示！');    }else{        return rtn(0, '对不起，发表留言失败，请稍候再试！');    }}$page = $_GET['p'];$page = isset($page) ? $page:1;$page = (int)$page;$page_size = 10;pdo_conn();//页数和记录数$tsql = "select count(1) as c from `{
    $cfg_dbprefix}guestbook` where ischeck=1";$result = $pdo->query($tsql);$tlist = $result->fetchAll();$total = $tlist[0]['c'];if(0==$total%$page_size){    $page_number = (int)($total/$page_size);}else{    $page_number = (int)($total/$page_size + 1);}if($page>$page_number){    $page = $page_number;}if($page<1){    $page = 1;}$start = ($page-1)*$page_size;$sql = "select * from `{
    $cfg_dbprefix}guestbook` where ischeck=1 order by id desc limit {
    $start},{
    $page_size}";$result = $pdo->query($sql);$list = $result->fetchAll();if($page>1){    $up = $page - 1;}else{    $up = 1;}if($page<$page_number){    $down = $page + 1;}else{    $down = $page_number;}$last = $page_number;function pdo_conn(){    global $pdo, $cfg_dbhost, $cfg_dbname, $cfg_dbuser, $cfg_dbpwd;    if(empty($pdo)){        $pdo = new PDO("mysql:host={
    $cfg_dbhost};dbname={
    $cfg_dbname};", $cfg_dbuser, $cfg_dbpwd, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES'utf8';"));        $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    }    return $pdo;}function rtn($status, $msg, $data=''){    $result = array('status'=>$status, 'msg'=>$msg, 'data'=>$data);    echo json_encode($result);}?>

      
      
      
      
      
      
    
       
        
            
       
      
      
  
       
      
        
      
         
          留言板
         
      
         
                     
          
           我要留言
          
          
         
    
        
        
        
      
         
          当前位置：
          主页 > 
          留言板 > 
         
    
         
      
          
$item){            $uname = "guest_".$item['id'];            $ip = $item['ip'];            $ip_arr = explode(".", $ip);            $ip = $ip_arr[0].".".$ip_arr[1].".*.*";            $dtime = $item['dtime'];            $dtime = date('Y-m-d H:i', $dtime);            $msg = $item['msg'];            $face = $item['face'];            if(empty($face)) $face = "01";        ?>        
                              
             
              
               
              
 时间: 
              
             
             
              
              
IP：
                  
              
              
             
            
                                   
      
          
      
          
 
              
 
               首页 
               上一页 
               下一页 
               尾页　共 
                页/
                条留言 转到：
               
                
              
 
            
          
      
          
      
                 
           
                          
              
               
发布留言：
              
              
               
*留言内容：
 (1000字内) 
               
              
              
               
    
              
             
            
      
          
      
         
    
        
      
       
      

Pdo::$instance->beginTransaction(); //开启事务

Pdo::$instance->rollBack(); //回滚

Pdo::$instance->commit(); //提交事务