composer require catfan/medoo
<?php
require './vendor/autoload.php';
use Medoo\Medoo;
class DB {
public function connect()
{
$db = new Medoo([
// 必须配置项
'database_type' => 'mysql',
'database_name' => 'mobile_channel',
'server' => '127.0.0.1',
'username' => 'root',
'password' => '123456',
'charset' => 'utf8mb4',
// 可选参数
'port' => 3306,
// 连接参数扩展, 更多参考 http://www.php.net/manual/en/pdo.setattribute.php
'option' => [
PDO::ATTR_CASE => PDO::CASE_NATURAL
]
]);
return $db;
}
}
$db = new DB();
$ret = $db->connect()->select("table", '*', [
"createtime[<>]" => [$date_from_time, $date_to_time]
]);
更多请查看