medoo–高效的轻量级PHP数据库操作类

网址：http://medoo.lvtao.net/

1. /*medoo.php*/
   class medoo
   {
   protected $database_type = ‘mysql’;
   protected $server = ‘localhost’;
   protected $username = ‘your_username’;
   protected $password = ‘your_password’;
   
   }

只需三步！

1. // 引入 Medoo
   require_once ‘medoo.php’;
   // 实例化
   $database = new medoo();
   // 插入数据例子
   $database->insert(‘account’, [
   'user_name' => 'foo'
   'email' => 'foo@bar.com',
   'age' => 25,
   'lang' => ['en', 'fr', 'jp', 'cn']
   ]);
   // 或者
   $database = new medoo([
   'database_type' => 'mysql',
   'database_name' => 'name',
   'server' => 'localhost',
   'username' => 'your_username',
   'password' => 'your_password',
   ]);

* 只有在 PHP 5.4+, 你可以使用[] 作为语法.

 

 

下面是测试

<?php
require_once ‘init.php’;//包含实例化medoo

//var_dump($database);
// $datas = $db->select(“tab1″,”*”);
//$a=$db->query(‘select * from “tab1″ a left join “tab2″ b on a.id=b.pid’)->fetchAll();

$a=$db->select(“tab1″,
array(“[>]tab2″ => array(“id” => “pid”)),
array(
“tab1.id(id1)”,
“tab2.id(id2)”,
“tab1.value(v1)”,
“tab2.value(v2)”,
)
);
var_dump($a);
// var_dump($datas);

echo $db->last_query();