1. 数组的键值倒序
array_reverse($list,true);
array (size=3)
0 =>
array (size=2)
'id' => string '1' (length=1)
'name' => string 'abc' (length=3)
1 =>
array (size=2)
'id' => string '2' (length=1)
'name' => string 'def' (length=3)
2 =>
array (size=2)
'id' => string '3' (length=1)
'name' => string 'ghi' (length=3)
array (size=3)
2 =>
array (size=2)
'id' => string '3' (length=1)
'name' => string 'ghi' (length=3)
1 =>
array (size=2)
'id' => string '2' (length=1)
'name' => string 'def' (length=3)
0 =>
array (size=2)
'id' => string '1' (length=1)
'name' => string 'abc' (length=3)
2. json_encode 中文 乱码
json_encode($str, JSON_UNESCAPED_SLASHES);
3. mysql 查询时,字段值为varchar的时间
SELECT
*
FROM
tb_desen_guangzhou
WHERE
STR_TO_DATE(unified_time, '%Y-%m-%d') >= '2019-09-30';
4. mysql 查询时,当一个数值与两个字段比较时,可用between
SELECT
*
FROM
tb_channel_code
WHERE
'2019-09-30' BETWEEN start_time
AND end_time;