PHP轻量级数据库操作类Medoo增加、删除、修改、查询例子_php实例

Medoo介绍

Medoo是一款超轻量级的PHP SQL数据库框架，由社交网站Catfan和开源项目Qatrix的创始人黎言卓开发。提供了简单，易学，灵活的API，提升开发Web应用的效率与性能，而且体积只有8KB不到。

特性

轻量级，只有一个文件

简单易学，数据结构一目了然

支持多种SQL语法，以及支持复杂的查询条件

支持多种数据库，包括MySQL, MSSQL, SQLite等等

安全，可防止SQL注入

免费，基于MIT协议

示例代码

增加

<br />$database = new medoo ( "my_database" );</p><p>$last_user_id = $database->insert ( "account", [ <br />  "user_name" => "foo",<br />  "email" => "[email protected]",<br />  "age" => 25,<br />  "lang" => [ <br />    "en",<br />    "fr",<br />    "jp",<br />    "cn" <br />  ] <br />] );<br />

删除

<br />$database = new medoo ( "my_database" );<br />     <br />$database->delete("account", [<br />    "AND" => [<br />    "type" => "business"<br />    "age[ 18<br />    ]<br />]);<br />

修改

<br />$database = new medoo ( "my_database" );</p><p>$database->update ( "account", [ <br />  "type" => "user",<br />  <br />  // All age plus one<br />  "age[+]" => 1,<br />  <br />  // All level subtract 5<br />  "level[-]" => 5,<br />  <br />  "lang" => [ <br />    "en",<br />    "fr",<br />    "jp",<br />    "cn",<br />    "de" <br />  ] <br />], [ <br />  "user_id[ 1000 <br />] );<br />

查询

<br />$database = new medoo ( "my_database" );</p><p>$datas = $database->select ( "account", [ <br />  "user_name",<br />  "email" <br />], [ <br />  "user_id[>]" => 100 <br />] );</p><p>// $datas = array(<br />// [0] => array(<br />// "user_name" => "foo",<br />// "email" => "[email protected]"<br />// ),<br />// [1] => array(<br />// "user_name" => "cat",<br />// "email" => "[email protected]"<br />// )<br />// )</p><p>foreach ( $datas as $data ) {<br /> echo "user_name:" . $data ["user_name"] . " - email:" . $data ["email"] . "<br>";<br />}</p><p>// Select all columns<br />$datas = $database->select ( "account", "*" );</p><p>// Select a column<br />$datas = $database->select ( "account", "user_name" );<br />     <br />    // $da<strong style="color:transparent">9来源gaodai#ma#com搞@代~码$网</strong>搞gaodaima代码tas = array(<br />    // [0] => "foo",<br />    // [1] => "cat"<br />    // )</p><p>

喜欢 (0)赏

[搞代码]

分享 (0)