pdo用法学习笔记

try{

$link = new PDO(‘mysql:host=localhost;dbname=lamp30’,’root’,’111111’);

}catch(PDOException $e){

echo $e->getMessage();

exit(‘连接数据库错误.’);

}

$stmt = $link->prepare(‘select * from user where id=:id’);

$stmt->bindparam(‘:id’, $id, PDO::PARAM_INT);

$id = 2;

$stmt->execute();

$stmt = $link->query(‘select * from user’);

（1）fetch()方法

$pdoStat ->bindColumn(1, $id);                 //第一个参数可以是从1开始的索引值

$pdoStat ->bindColumn(‘name’, $name);    //也可以是列名

$pdoStat ->bindColumn(‘pass’, $pass);

while($row = $stmt ->fetch(PDO::FETCH_BOUND)){

echo $id.’ ’;

echo $name.’ ’;

echo $pass.’<br>’;

}

$result = $stmt ->fetchall();

foreach($result as $row){

echo $row[‘id’].’ ’;

echo $row[‘name’].’ ’;

echo $row[‘pass’].’<br>’;

}

$link = new PDO(‘mysql:host=localhost;dbname=lamp30’);

//1

$link->setattribute(PDO::ATTR_AUTOCOMMIT, false);

//2

$link->begintransaction();

$result = $link->exec(‘insert into user(name,paa) values(‘wsy’,’111’)’);

//3

if($result){

$link->commit();

}else{

$link->rollback();

}

//4

$link->setattribute(PDO::ATTR_AUTOCOMMIT, true);

$link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT)

$link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING)

$link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION)

$link->setAttribute(PDO::ATTR_PERSISTENT, true);

/**
 * 循环实现编码互转
 *
 * @param string $param(字符串，对象，或者数组)，$currCharset当前编码，$toCharset期望编码
 * @return 参数类型
 */
function zhandi_iconv($param,$currCharset,$toCharset){
 if ($currCharset != $toCharset){
  if (is_string($param)){
   return iconv($currCharset, $toCharset, $param);
  }
  elseif (is_array($param)){
   foreach ($param as $key => $value){
    $param[$key] = zhandi_iconv($value);
   }
   return $param;
  }
  elseif (is_object($param)){
   foreach ($param as $key => $value){
    $param->$key = zhandi_iconv($value);
   }
   return $param;
  }
  else{
   return $param;
  }
 }
 return $param;
}

<?php
/************************************************************************************
* 完美分页类，可以自定义分页(比高胖老师的完美哈，O(∩_∩)O哈哈~)                               *
************************************************************************************
* 版权所有 (C) 2011-2012 北海情书-一个程序员博客，并保留所有权利。                 *
                                 *
* **********************************************************************************
* $Author: 北海情书 (hackmyth@163.com) $                                           *
* $Date: 2011-07-18 10:00:00 $                                                     *
* **********************************************************************************/

    class Page{
   
        private $total;         //数据总条数
        private $listRows;      //每页显示条数
        private $limit;         //限制条数
        private $pageNum;       //总页数
        private $page;          //当前页
        private $config=array('head'=>"条记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首页", "last"=>"末页");
     
        /**
         * 构造方法，可以设置分页类的属性
         * @param        int        $total                计算分页的总记录数
         * @param        int        $listRows        可选的，默认每页需要显示的记录数
         *
         */
        public function __construct($total,$listRows=10){
        
                $this->total=$total;
                $this->listRows=$listRows;
                $this->pageNum=ceil($this->total/$this->listRows);   //获取总页数
                if($_GET['page']>$this->pageNum){      //防止过界      
                       $_GET['page']=$this->pageNum;
                }
                $this->page=!empty($_GET['page'])?$_GET['page']:"1"; //当前页
                $this->limit=$this->setPage();         //分页公式
        }

        public function __get($args){
              
                if($args=='limit'){            //过滤非法请求
                        return $this->limit;
                }
                return null;
        }

        //计算分页公式
        private function setPage(){

           return "limit ".($this->page-1)*$this->listRows.",".$this->listRows;
       
        }

        //上一页
        private function prev(){
                return "<a href='?page=".($this->page-1)."'>".$this->config['prev']."</a>";
        }
      
        //下一页
        private function next(){
                return "<a href='?page=".($this->page+1)."'>".$this->config['next']."</a>";
        }

        //首页
        private function first(){
                return "<a href='?page=1'>".$this->config['first']."</a>";
        }

        //尾页
        private function last(){
                return "<a href='?page=".($this->pageNum)."'>".$this->config['last']."</a>";
        }

        //分页列表
       
        private function pagelist(){

                $lists.='';
                for($i=1;$i<$this->pageNum;$i++){

                    $lists.="<a href='?page=".$i."'>$i</a>&nbsp;&nbsp;";
                }
                return $lists;
        }

        public function fpage($display=array(1,2,3,4,5)){
       
             $html[1]= "共有".$this->total.$this->config['head'];       
             $html[2]= $this->prev();  //上一页
             $html[3]= $this->next();  //下一页
             $html[4]= $this->first(); //首页
             $html[5]= $this->last();  //尾页
             $html[6]= $this->pagelist();  //列表
             $fpage='';
             foreach($display as $index){
                       
                  $fpage.=$html[$index];
             }
             return $fpage;
        }
   
   
    }

<?php
function removeDir($dirName)
{
    if(! is_dir($dirName))
    {
        return false;
    }
    $handle = @opendir($dirName);
    while(($file = @readdir($handle)) !== false)
    {
        if($file != '.' && $file != '..')
        {
            $dir = $dirName . '/' . $file;
            is_dir($dir) ? removeDir($dir) : @unlink($dir);
        }
    }
    closedir($handle);
 
    return rmdir($dirName) ;
}
?>