medoo基本操作

Original 2019-03-06 00:47:55 214
abstract:include 'vendor/autoload.php'; $config = [     'database_type' => 'mysql',     'database_name' 
include 'vendor/autoload.php';

$config = [
    'database_type' => 'mysql',
    'database_name' => 'myphp',
    'server' => '127.0.0.1',
    'username' => 'root',
    'password' => 'root',
    // [optional]
    'charset' => 'utf8',
    'port' => 3306,
];
$db = new Medoo\Medoo($config);

//查
$db->select('user',['name','age'],['sex'=>0]);
//增
$db->insert('user',['name'=>"大雕",'sex'=>0,'status'=>1]);
//改
$db->update('user',
    ['email'=>'dd@php.cn','password'=>sha1('123456'),'create_time'=>time()],['name'=>'大雕']);
//删
$db->delete('user',['id'=>12]);


Correcting teacher:查无此人Correction time:2019-03-06 09:20:13
Teacher's summary:完成的不错。增删查改是数据库操作最基础的,不论怎么操作,都是对mysql语句进行封装。继续加油。

Release Notes

Popular Entries