now_date() --时间格式
time() -- 时间戳
date('Y-m-d H:i:s',strtotime("-1 day"));//当前时间-1天
//int转number
$float = floatval();
//时间格式转换时间戳
echo strtotime(now_date());
$datetime=time();
date('Y-m-d H:i:s',$datetime);
//unset之后需要在foreach外面重新被定义一下
array_values($list);
//判断数组中有无指定的键
array_key_exists("键名",$arr);
$key = array_column(array_values($list), 'id');
# 第一个参数需要提供二维数组排序依据
# 第二个排序方式 SORT_ASC:正序 SORT_DESC:倒序
# 第三个参数 要排序的二维数组,改动直接操作在该数组上
# 排序能保证key不改变
array_multisort($key,SORT_DESC,$list);
//路径
'http://'.$_SERVER['SERVER_NAME']
//附近商家
$lat = $this->request->param('latitude');//纬度
$lng = $this->request->param('longitude');//经度
$business = db('business')->field('id,shop_title,address,address_info,lat,lng,shop_title_img,(12756.274 * asin(sqrt((1-cos('.$lng.' * pi()/180 - lng*pi()/180)+(1-cos('.$lat.'*pi()/180 - lat*pi()/180))*cos(lng*pi()/180)*cos('.$lng.'*pi()/180))/2))) km')->order('km asc')->select();
$v['km'] = distance($lng,$lat,$v['lng'],$v['lat']);
//通过某个字段给数组排序,如果不方便用sql排序的话可以用这个。
$last_names = array_column($userData,'patrol');
array_multisort($last_names,SORT_DESC,$userData);
$page = Request()->param('page',1);
$pageSize = Request()->param('pageSize',10);
->page($page,$pageSize)
//TP等于查询
$category_id = $this->request->param('category_id');//类目ID
$wheres['category'] = ['eq', $category_id];
db('')->where($where)->select;
//该字段等于1、3
->where('status_goods','in',[1,3])
//等于1或等于3
$map = [
'status' => [['EQ',2],['EQ',3],'or']
];
//检索指定数值
->where("find_in_set($orderInfo[path_id],path_id)")->find();
//mysql替换数据库指定字段字符串
UPDATE ddwx_admin_upload SET url = REPLACE(url, 'https://shang', 'https://xia') WHERE url LIKE '%https://shang%';
//+数值
$nums = 100;
db('user')->where('id',$order['user_id'])
->exp('gold','gold+'.$nums)
->exp('total_gold','total_gold+'.$nums)
->update()
//PHP JSON转数组
json_decode($a,true);
//PHP数组转字符串
implode(',',$base_img)
//字符串转数组
$vegetables = explode(",", $str);
//PHP数组转JSON
$arr = array('a' => 1, 'b' => 2, 'c' => 3, 'd' => 4, 'e' => 5);
echo json_encode($arr);
json_encode($arr,JSON_UNESCAPED_UNICODE);
//百分号转小数
$a = "20.544545%";
echo (float)$a/100;
//随机查询表中的6条数据
->orderRaw('rand()')->limit(6)
//指定查询顺序
->order("field(id,3,6,9,1,2,5,8,7)")
//本月多少天
$date = now_date();
$tian_num = date("t",strtotime($date));
db()->startTrans();//开始
db()->rollback();//中断
db()->commit();//结束
//接受的json数据乱码处理
$goods=htmlspecialchars_decode($goods);
$goodslist=html_entity_decode($goods);
$goodslist= json_decode($goodslist,true);
$goods_list = dataGroup($list,'user_id');
/**对数组进行分组
* @param array $dataArr 数组
* @param string $keyStr 要分组的字段
* @return array
*/
function dataGroup(array $dataArr,string $keyStr)
{
$newArr=[];
foreach ($dataArr as $k => $val) {
$newArr[$val[$keyStr]][] = $val;
}
return $newArr;
}
//隐藏手机号中间几位
$acc = 18615333411;
$str = substr_replace($acc, '****', 3, 4);
$v['user_info']['account'] = substr_replace($str, '****', 3, 4);
//object转数组
function object2array(&$object) {
$object = json_decode( json_encode( $object),true);
return $object;
}
//查询时start_act、end_act字段应为int类型,不然查询不到。
$user_proces = db('user_proces')
->where('start_act','<=',$price)
->where('end_act','>=',$price)
->find();
dump(db('user_proces')->getLastSql());die();
//string(85) "SELECT * FROM `yzz_user_proces` WHERE `start_act` <= 60 AND `end_act` >= 60 LIMIT 1"
//若start_act` <= 60,60带引号则不为int类型,查询不到。
//模糊查询
$where = [];
$name = input('name', '', 'trim');//车辆名称
if(!empty($name)){$where['name'] = ['like',"%$name%"];}
//是否是http
$url = "https://www.baidu.com/";
$preg = "/^http(s)?:\\/\\/.+/";
if(preg_match($preg,$url))
{
echo 'Yes';
}else
{
echo 'No';
}
//修改/添加
public function typesave($id=0)
{
$id = Request()->param('id');
if (isAjaxPost()) {
if ($id > 0) {
//修改
}else{
//添加
}
}
}
{$li.type==1?'专票':'普票'}
{switch name='$li.pay_type'}
{case value='1'}
<span class="label label-info">微信</span>
{/case}
{case value='2'}
<span class="label label-info">支付宝</span>
{/case}
{/switch}
<div class="form-group">
<label class="col-sm-2 control-label">选择会员名称</label>
<div class="col-sm-8">
<select class="input-sm form-control" name="name">
<option value="">请选择会员名称</option>
{foreach name="data" item="son"}
<option value="{$son.id}" {if condition="isset($member_rech.member_id) && $member_rech.member_id eq $son.id"}selected{/if}>|-{$son.name}</option>
{/foreach}
</select>
</div>
</div>
{if condition='$li.delivery_type eq 1 && $li.status eq 2'}
待自提
{else/}
{$state[$li.status]}
{/if}
//判断今天是否签到
$time1 = date('Y-m-d 00:00:00');
$time2 = date('Y-m-d 23:59:59');
if(
db('sign_log')->where([
'user_id'=>$this->uid])->where('add_time','between time',[$time1,$time2])->count()>0
){
return $this->jsonError('今天已经签过到了,请明天再来!');
}
<td>
{if condition='$li.status eq 1'}
待支付
{else/}
{$li.pay_time}
{/if}
</td>
<?php $refund_reason_wap_img = json_decode($info['refund_reason_wap_img'],true); ?>
{volist name='$refund_reason_wap_img' id='v'}
<a target="_blank" href="{$v}"><img style="height: 80px" src="{$v}" /></a>
{/volist}
//解决跨域问题 在入口文件加如家三行代码
header("Access-Control-Allow-Origin:*");
header("Access-Control-Allow-Methods:GET, POST, OPTIONS, DELETE");
header("Access-Control-Allow-Headers:DNT,X-Mx-ReqToken,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type, Accept-Language, Origin, Accept-Encoding");
//替换富文本中返回的图片路径
public function imageUrl($content)
{
$url = "http://".$_SERVER['SERVER_NAME'];
$pregRule = "/<[img|IMG].*?src=[\'|\"](.*?(?:[\.jpg|\.jpeg|\.png|\.gif|\.bmp]))[\'|\"].*?[\/]?>/";
$list = preg_replace($pregRule, '<img src="'.$url.'${1}" style="max-width:100%">', $content);
return $list;
}
$this->more_array_uniques($list);
// 对二维数组进行去重复
public function more_array_uniques($array=[])
{
// 根据 order_id 分组
$grouped = [];
foreach ($array as $item) {
$groupId = $item['name'];
if (!isset($grouped[$groupId])) {
$grouped[$groupId] = [];
}
$grouped[$groupId][] = $item;
}
//dump($grouped);die();
// 输出结果数组
$result = [];
foreach ($grouped as $k => &$v) {
$result[] = $grouped[$k][0];
}
return $result;
}
if (!preg_match('/^(?=.*[a-zA-Z])(?=.*\d)[a-zA-Z\d]{6,}$/', $password)) {
$this->error('请输入最低6位字母数字组合的密码!');
}
PHP (TP5)常用内容
于 2020-09-10 17:53:48 首次发布