一.DB门面 1.insert DB::insert('insert into table(`name`) value(?)', ['test']); 2.update DB::update('update into table set name=? where id=?', ['test', 10]); 3.delete DB::delete('delete from tb where id=?', [1]); 4.select DB:select('select * from tb'); 二
<?php namespace App\Http\Controllers; use App\Student; use Illuminate\Support\Facades\DB; class StudentController extends Controller { //DB facade原始SQL语句 public function test1() { $students = DB::select('select * from student'); //var_dump($students)
1:设置mysql原生分页 # 监控系统首页显示分页 def MyPagination(limitid,offsetid): limitid =str(limitid) offsetid =str(offsetid) # 这里是mysql原生代码 show_goods = "select dal_keywordtable.* from (select asin, min(ranking) as minRanking from `dal_keywordtable` GROUP BY asin) t
1. 数组,没有键名 但只查询出第一个结果 $conn = $this->getDoctrine()->getConnection(); $data = $conn->fetchArray('SELECT * FROM user where id < 3'); // 或者 // $data = $conn->fetchArray('SELECT * FROM user where id < ?', [3]); print($data);die; 上面结果是数组 Arra
reSetData(dataList,num) { let arr = []; let len = dataList.length; for (let i = 0; i < len; i += num) { arr.push(dataList.slice(i, i + num)); } return arr;}