国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

medoo數(shù)據(jù)庫(kù)curd練習(xí)

Original 2019-03-27 15:44:32 373
abstract:<?php  //配置mdeoo數(shù)據(jù)庫(kù) require __DIR__.'/vendor/autoload.php'; use Medoo\Medoo; $db = new Medoo( [        'database_type' => 'mysql',    

<?php 

//配置mdeoo數(shù)據(jù)庫(kù)

require __DIR__.'/vendor/autoload.php';


use Medoo\Medoo;


$db = new Medoo(

[

       'database_type' => 'mysql',

       'database_name' => '1603a',

       'server' => 'localhost',

       'username' => 'root',

       'password' => 'root',

]

);


 ?>

<?php 

require __DIR__.'/conet.php';

//添加操作

$table = 'type';


$name = $_GET['name'];

$state = $_GET['state'];

$t_type = $_GET['t_type'];

$data = [

'name'=>$name,

'state'=>$state,

't_type'=>$t_type

];

$db->insert($table,$data);

//獲取最后一個(gè)id

$id = $db->id();


 ?>

<?php


//刪除操作

require __DIR__.'/conet.php';


$table = 'type';


$where = ['id'=>$_GET['id']];


$db->delete($table,$where);


 ?>

<?php 


require __DIR__.'/conet.php';

//修改操作

$table = 'type';


$name = $_GET['name'];

$state = $_GET['state'];

$t_type = $_GET['t_type'];

$data = [

'name'=>$name,

'state'=>$state,

't_type'=>$t_type

];



// var_dump($data);die;

$where =  ['id'=>$_GET['id']];


$con = $db->update($table,$data,$where);


    $cuns=$con->rowCount();


    if ($cuns > 0) {

    echo '成功更新了'.$cuns.'條記錄';

    }

 ?>


Correcting teacher:西門(mén)大官人Correction time:2019-03-28 10:17:54
Teacher's summary:medoo的基本操作很OK,感興趣的話,可以把medoo的數(shù)據(jù)庫(kù)操作進(jìn)一步封裝到一個(gè)類(lèi)中去,方便調(diào)用,而不是每次都要配置

Release Notes

Popular Entries