PHP Cpdo示例

示例#1

文件： cpdo.class.php 项目： ruanwenwu/store-session-with-redis

 /**
 *fetch value action
 */
 private static function fetchAction($fetchAction)
 {
     switch ($fetchAction) {
         case "assoc":
             self::$get_fetch_action = PDO::FETCH_ASSOC;
             //asso array
             break;
         case "num":
             self::$get_fetch_action = PDO::FETCH_NUM;
             //num array
             break;
         case "object":
             self::$get_fetch_action = PDO::FETCH_OBJ;
             //object array
             break;
         case "both":
             self::$get_fetch_action = PDO::FETCH_BOTH;
             //assoc array and num array
             break;
         default:
             self::$get_fetch_action = PDO::FETCH_ASSOC;
             break;
     }
     return self::$get_fetch_action;
 }

示例#2

文件： dologin.php 项目： ruanwenwu/store-session-with-redis

<?php

require "SessionManager.class.php";
require "cpdo.class.php";
$pdo = new Cpdo();
//通过sql语句获得值
//$sql = "select * from `dede_feedback` where `id` < 20";
//$res = $pdo->getValueBySelfCreateSql($sql);
if (false) {
    echo 'haha';
    header("location:./index.php");
    die;
} else {
    $_SESSION['islogin'] = true;
    $_SESSION['username'] = "******";
    $_SESSION['uid'] = 1;
    //获得上一条用户的sessionid,并删除对应的session
    $oldSql = "select * from session_record where uid = 1 order by lastlogin desc";
    $res = $pdo->getValueBySelfCreateSql($oldSql);
    if ($res) {
        $old_session_id = $res[0]['session_id'];
        $sessionManager->destroy($old_session_id);
    }
    //将用户的这条session写入数据库
    $sql = "insert into session_record (session_id,lastlogin,uid,ip) values ('" . session_id() . "','" . time() . "','1','{$_SERVER['REMOTE_ADDR']}')";
    $pdo->exec($sql);
    //成功写入新的登陆记录
    header("location:./index.php");
}