数据库操作

composer require thefunpower/db_medoo

'user_name[REGEXP]' => '[a-z0-9]*'
'user_name[FIND_IN_SET]'=>(string)10
'user_name[RAW]' => '[a-z0-9]*'

$where = [
	//like查寻
	'product_num[~]' => 379, 
	//等于查寻
	'product_num' => 3669, 
	//大于查寻
	'id[>]' => 1,
	'id[>=]' => 1,
	'id[<]' => 1,
	'id[<=]' => 1,
]; 
$where = []; 
$where['OR'] = [
	'product_num[~]'=>379,
	'product_num[>]'=>366,
];
$where['LIMIT'] = 10;
$where['ORDER'] = ['id'=>'DESC']; 

$date1 = '2022-11-01';
$date2 = '2022-12-14';
db_between_date($field,$date1,$date2)

$date1 = '2022-11';
$date2 = '2022-12';
db_between_month($field,$date1,$date2

$res = db_get_one("products","*",$where);
$res = db_get_one("products",$where);

$res = db_get("products","*",$where);
$res = db_get("products",$where);

$res  = db_pager("products","*",$where);

$res = db()->select("products",['id'],[]); 

$res  = db_get("qr_rule","qr_num",['GROUP'=>'qr_num']);
print_r($res); 

db_insert($table, $data = [],$don_run_action = false)

db_update($table, $data = [], $where = [],$don_run_action = false)

db_get_min($table, $join  = "*", $column = null, $where = null)

db_get_max
db_get_count
db_get_has
db_get_rand
db_get_sum
db_get_avg 

db_del($table, $where)

do_action("db_insert.$table.before", $data);
do_action("db_save.$table.before", $data);

do_action("db_insert.$table.after", $action_data);
do_action("db_save.$table.after", $action_data);

do_action("db_update.$table.before", $data);
do_action("db_save.$table.before", $data);

do_action("db_update.$table.after", $action_data);
do_action("db_save.$table.after", $action_data); 

do_action("db_get_one.$table", $v); 

do_action("db_insert.$table.del", $where);

show_tables($table)

get_table_fields($table, $has_key  = true)

db_allow($table, $data)

database_tables($name = null, $show_markdown = false)

array_order_by($row,$order,SORT_DESC);

is_json($data)

db_query($sql, $raw = null)
do_action("db_query", $all) 

db_action(function()use($data)){

});

db_for_update($table,$id)

db_pager_count($nums = null)

$data = db_pager("do_order",
["[><]do_mini_user" => ["uid" => "id"]],
[
    "do_order.id",
    "do_order.uid",
    "user" => [
        "do_mini_user.nickName",
        "do_mini_user.avatarUrl",
        "do_mini_user.openid",
    ]
],
$where);

$lists = db_get('do_order', [ 
    'count' => 'COUNT(`id`)',
    'total' => 'SUM(`total_fee`)',
    'date'  => "FROM_UNIXTIME(`inserttime`, '%Y-%m-%d')"
],