PDO在CI框架中的使用

来源：互联网发布：淘宝卖土特产前景分析编辑：程序博客网时间：2024/05/18 00:31

1、在CI中配置文件修改

application/config文件夹下的database.PHP文件

$db['default'] = array(
   'dsn'   => 'mysql:dbname=ci_ecshop;host=127.0.0.1',
   'username' => 'root',
   'password' => '',

'dbdriver' => 'pdo',

//下面是这个配置的例子（反正我是这样配置的）

$db['default'] = array(
   'dsn'   => 'mysql:dbname=seven_month;host=127.0.0.1',
   'hostname' => '',
   'username' => 'root',
   'password' => 'root',
   'database' => '',
   'dbdriver' => 'pdo',
   'dbprefix' => '',
   'pconnect' => FALSE,
   'db_debug' => (ENVIRONMENT !== 'production'),
   'cache_on' => FALSE,
   'cachedir' => '',
   'char_set' => 'utf8',
   'dbcollat' => 'utf8_general_ci',
   'swap_pre' => '',
   'encrypt' => FALSE,
   'compress' => FALSE,
   'stricton' => FALSE,
   'failover' => array(),
   'save_queries' => TRUE
);

2、查询操作

$sql = 'select * from type where type_id = :id';
$sql_array = array(
           ':id' => 1
       );
$stmt=$this->db->conn_id->prepare($sql);//$this->db->conn_id 是一个pdo对象
$stmt->execute($sql_array);      //这句语句会返回true或者false，代表查询是否成功

//$arr_user = $stmt->fetchAll(PDO::FETCH_ASSOC); //返回一个包含结果集中所有行的数组，相当于mysql中的result_array
//$str_user = $stmt->fetch(PDO::FETCH_ASSOC); //从结果集中获取下一行,相当于mysql中的row_array

$stmt->rowCount();
if($stmt->rowCount()>0){
       echo "查询成功";
       }else{
       echo "查询失败";
       }

3、insert 、update、delete 等操作除了sql语句语法不同，查询的方法是一样的

$sql = "update type SET type_name='岳朋' WHERE type_id= :id";
$sql = "INSERT INTO type(`type_name`) VALUES ( :id)";
$sql = "delete from type where type_id= :id";
$sql_array = array(
           ':id' => 1
       );
$stmt=$this->db->conn_id->prepare($sql);//$this->db->conn_id 是一个pdo对象
       $stmt->execute($sql_array);      //这句语句会返回true或者false，代表查询是否成功
       if($stmt->rowCount()>0){
       echo "查询成功";
       }else{
       echo "查询失败";
       }

0 0