# php-class

**Repository Path**: kaxinwa/php-class

## Basic Information

- **Project Name**: php-class
- **Description**: 自定义封装的有关php的类
- **Primary Language**: PHP
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2016-08-26
- **Last Updated**: 2021-04-15

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#php-class

### 引入类库文件

require_once "./php_class/PDO.php";

### 配置文件格式
$connect = [
    'driver'=>'mysql',
    'db'=>'test',
    'host'=>'127.0.0.1',
    'username'=>'root',
    'password'=>'',
];


$pdo = DB_PDO::getInstance();
$pdo = $pdo->connect($connect);

###根据条件筛选实例
$where['name']  = array('like','%li%');
$map['_complex'] = $where;
$map['age']  = array('>=','25');
$c = $pdo->table('user')->order(['id'=>'asc','age'=>'desc','name'=>'asc'])->select();


###单条插入数据 实例

$data = [
    'name'=>'create-test',
    'age'=>'23'
];

$c = $pdo->table('user')->create($data);



$map['age']  = array('<=','30');
$data = [
    'name'=>'creaewete-t',
    'age'=>'434'
];
$c = $pdo->table('user')->where($map)->update($data);


$c = $pdo->table('user')->delete();
$datas=[
    ['name'=>'a','age'=>23],
    ['name'=>'b','age'=>24],
    ['name'=>'d','age'=>25],
    ['name'=>'e','age'=>26],
];

###事务处理
$pdo->beginTransaction();
$c=$pdo->table('user')->batchInsert($datas);
$pdo->rollBack();
echo $pdo->_lastsql();

###动态切换数据库

$dbh = DB_PDO::getInstance();
$pdo = $dbh->connect($connect);

$users = $pdo->table('user')->select();


$users = $pdo->changeDb('test');
$res = $pdo->table('user')->select();