\backend\models\core\DB

来源：互联网发布：淘宝网耐克女运动鞋编辑：程序博客网时间：2024/04/29 05:22

对数据库sql的操作。

如果是一些简单的sql操作，可以使用 AR（Active Record）

1.得到默认的db

\backend\models\core\DB::getDefaultDb();

2.查询所有： example: $sql = 'SELECT * FROM sales_flat_quote';

DB::findBySql('select * from sales_order_info where order_id > :order_id' ,[':order_id'=>1 ]);

\backend\models\core\DB::findAllBySql($sql,$data=[],$db='');

3.查询一个

通过sql查看一条记录
example: DB::findOneBySql('select * from sales_order_info where order_id = :order_id' ,[':order_id'=>1 ]);

\backend\models\core\DB::findOneBySql($sql,$data=[],$db='');

4.通过sql插入

$sql     = "insert into sales_order_info (increment_id) values (:increment_id) ";$data  = ['increment_id'=>'eeeeeeeeee'];$dd     = DB::insertBySql($sql,$data);\backend\models\core\DB::insertBySql($sql,$data=[],$db='');

5.通过sql更新

# $sql = "update sales_order_info set increment_id = :iid where increment_id = :increment_id";# $data = ['iid'=>'ddd','increment_id'=>'eeeeeeeeee'];# $dd = DB::insertBySql($sql,$data);\backend\models\core\DB::updateBySql($sql,$data=[],$db='');

#6. 通过sql删除

# $sql = "delete from sales_order_info  where increment_id = :increment_id";# $data = ['increment_id'=>'eeeeeeeeee'];# $dd = DB::insertBySql($sql,$data);\backend\models\core\DB::deleteBySql($sql,$data=[],$db='');

#7. 批量插入数据方式

    # $table         = 'sales_order_info';    # $columnsArr = ['increment_id','order_status'];    # $valueArr     = [    #                 ['Tom', 30],    #                 ['Jane', 20],    #                 ['Linda', 25]    #                 ];    # DB::batchInsert($table,$columnsArr,$valueArr);

\backend\models\core\DB::batchInsert($table,$columnsArr,$valueArr,$db='');

0 0