PHP （TP5）常用内容

success_a
已于 2024-07-30 15:55:32 修改
阅读量2.2k
点赞数 4
文章标签： php
于 2020-09-10 17:53:48 首次发布
本文链接：https://blog.csdn.net/success_a/article/details/108519784
版权
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位字母数字组合的密码!');
        }
        
//按照特定顺序排序
//tp5查询数据不排序 会默认asc 升序排序  不能满足项目逻辑需求 
//1.首先引入Expression类
use think\db\Expression;
$ids="1,3,2,5,7,9";
$exp=new Expression("field(id,$ids)");
// 查询时
$res=Db::table('table')->whereIn('id',$ids)
   ->order($exp)
   ->select();