-
數據查詢查看全部
-
// $res = new Admin(); // $res = $res::get(2); // $res = $res->toArray(); // $admin = Loader::model("Admin"); // $res = $admin::get(4); $admin = model("Admin"); $res = $admin::get(7); $res = $res->toArray(); dump($res);查看全部
-
//$db = Db::name('admin'); $res = Db::name('admin') ->where("admin_id",">",1) ->field("name","admin_id") ->order("admin_id DESC") //->limit(3,5) ->page(3,5) ->group("`group`") ->select() ; dump($res);查看全部
-
$db = Db::name('admin'); $res= $db->where([ 'admin_id' => 3 ])->update([ 'name' => 'i1231' ]); $res=$db->where([ 'admin_id' => 3 ])->setField('name','342'); $res=$db->where([ 'admin_id' => 3 ])->setInc('num','6'); $res=$db->where([ 'admin_id' => 3 ])->setDec('name','3'); dump($res);查看全部
-
//dump(config('database')); //$res=Db::table( 'bbs_admin' )->select(); //$res=Db::table( 'bbs_admin' )->find(); // $res=Db::table( 'bbs_admin' )->value('salt'); //$res=Db::table( 'bbs_admin' )->column('admin_id','pwd'); //$res=Db::name( 'admin' )->select(); //$res=db('admin')->select(); // $res = $db->insertGetId([ //'name' => 'foot', // 'pwd' =>'fdsaf' //]); $db=Db::name('admin'); $data = []; for($i=0;$i<10;$i++){ $data[]=[ 'name' => "1foot{$i}", 'pwd' =>md5("insdfj{$i}") ]; } $res = $db->insertAll($data); if($res == $data.lenth){ } dump($res);查看全部
-
數據更新的四種方式:1、更新多個字段update。2、更新一個字段setField。3、字段自增setInc。4、字段自減查看全部
-
數據庫插入的3種方式查看全部
-
數據庫查詢的4種方法查看全部
-
//$res = Db::execute("insert into ice_user set username=?,password=?,email=?",['wang',md5('wang'),'[email protected]']); //dump($res); //$res = Db::query("select * from ice_user"); //$res = Db::table('ice_user')->select(); //$res = Db::table('ice_user')->where(['id'=>10])->find(); //$res =Db::table('ice_user')->value(['username']); //$res = Db::table('ice_user')->column('username'); //$res = Db::name('user')->select(); //dump(config());查看全部
-
dump(config('database')); $res = Db::connect([ 'type' => 'mysql', 'dsn' => '', 'hostname' => '127.0.0.1', 'database' => 'test', 'username' => Env::get('database.username','root'), 'password' => Env::get('database.password','root'), 'hostport' => '', 'params' => [], 'charset' => 'utf8', 'prefix' => '', ]); $res = Db::connect("mysql://root1:[email protected]:3306/test#utf8"); $res = Db::connect("db_config1");查看全部
-
參考文檔手冊查看全部
-
tp連接數據庫 1.通過Db::connect()方法實現,如果參數為空,那么會默認使用database.php中的配置連接 2.也可以通過Db::connect(mysql://[email protected]:3306/databasename#utf8),動態傳入進行配置連接查看全部
-
tp的數據庫操作 1.tp提供Db類,實現對數據庫的操作 2.tp的模型層其實是對Db類的再次封裝,可以更好的操作數據庫,實現數據庫的增刪改查查看全部
-
// $res = User::count(); // $res = User::where("id", ">", 5) // -> count(); // $res = User::max('num'); // $res = User::where("id", "<", 5) // -> max('num'); // $res = User::sum('num'); // $res = User::where("id", "<", 4) // -> sum('num'); // $res = User::avg('num'); // $res = User::where("id", "<", 4) // ->avg('num'); //$res = User::min('num'); $res = User::where("id", ">",5) -> min('num'); dump($res);查看全部
-
destroy對數據庫刪除的操作 $userModel = User::get(7); $res = $userModel->delete();//對數據庫刪除的操作 $res = User::where("1=1") -> delete();//1=1 清空數據庫查看全部
舉報
0/150
提交
取消