PHP代码篇（三）--常用方法

模块下不间断更新，PHP常用方法，欢迎留言！

一、递归删除指定目录下所有文件及文件夹

/**

 * 递归删除指定目录下所有文件及文件夹

 * @param unknown $path,删除路径

 */

function deleteFileWay($path)

{

    //如果是目录则继续

    if(is_dir($path)){

        //扫描一个文件夹内的所有文件夹和文件并返回数组

        $info = scandir($path);

        foreach($info as $k=>$v){

             //排除目录中的.和..

            if($v != '.' && $v != '..'){

                if(is_dir($path.$v)){

                    //子目录中操作删除文件夹和文件

                    deleteFileWay($path.$v.'/');

                    //目录清空后删除空文件夹

                    @rmdir($path.$v.'/');

                }else{

                    //如果是文件直接删除

                    @unlink($path.$v);

                }

            }

        }

    }

}

/**

 * [result14 description]

 * 查找会员下面所有盟主

 * 参数$uid会员id

 * 返回

 * 'status'=>0，没有下级盟主

 * 'status'=>1，'data'=>下级盟主id，数组类型

 */

function result14($uid){

    $cancel_user_list=$uid.',';//下级所有盟主列表列表，用于sqlin语句

    $crt_level_user=pdo_getall('nets_hjk_members', array('from_uid' => $uid), array('type','memberid','level'));

    if (empty($crt_level_user)) {

        return array('status'=>0,'hint'=>"没有需要变更的下级1");

    }

    while (!empty($crt_level_user)) {

        //从当前用户中提取memberid，用于下一次取下级用户

        $crt_level_user_for_sqlin='';

        $crt_level_leader_for_sqlin='';

        foreach ($crt_level_user as $value) {

            $crt_level_user_for_sqlin .= $value['memberid'].',';

                //遍历crt_level_user中所有的行，取出盟主的memberid放在$crt_level_leader_for_sqlin中

            if ($value['type'] == 1) {

                $crt_level_leader_for_sqlin .= $value['memberid'].',';

            }

        }

        $cancel_user_list .= $crt_level_leader_for_sqlin;

        //获取当前层级下级用户

        if(!empty($crt_level_user_for_sqlin)){

            $crt_level_user_for_sqlin=substr($crt_level_user_for_sqlin,0,strlen($crt_level_user_for_sqlin)-1);

        }

        $crt_level_user=pdo_fetchall("SELECT ex.memberid,ex.type FROM ".tablename('nets_hjk_members')." AS ex where from_uid in(". $crt_level_user_for_sqlin.") ");

    }

    $junior_user_list = '';

    $cancel_user_list = substr($cancel_user_list,0,strlen($cancel_user_list)-1);

    $cancel_user_list_arr = explode(",",$cancel_user_list);

    //当下会员下级所有的盟主，数组

    $cancel_user_list_arr = array_splice($cancel_user_list_arr,1);

    if (empty($cancel_user_list_arr)) {

        return array('status'=>0,'hint'=>"没有需要变更的下级2");

    }else{

        return array('status'=>1,'data'=>$cancel_user_list_arr);

    }

}

二、数据库常用操作

//插入一条数据

INSERT INTO ims_stat_rule (rid,hit) VALUES (351,990);

//删除一条数据

DELETE FROM ims_nets_hjk_applyfor WHERE member_id = 49483;

//修改一条数据

update ims_nets_hjk_members set level = 4 where id = 100248;

//查询数据

select * from ims_nets_hjk_members where memberid = 18978;

//格式化时间戳

FROM_UNIXTIME(M1.created_at,'%Y-%m-%d %H:%i:%s') AS created_at;

//SQL中IF的用法，如果表M1时间戳为0则默认为'/'，反之则进行格式化时间戳处理

IF(M1.finish_time = 0,'/',FROM_UNIXTIME(M1.finish_time,'%Y-%m-%d %H:%i:%s')) AS finish_time

三、ThinkPHP5.0常用操作

//查询区间内

$device_string = $db->table('ims_nets_hjk_devices')

                    ->where('device_id',['>=',$k],['<=',$j],'AND')

                    ->where('status',0)

                    ->field('device_id')

                    ->limit(50)

                    ->select();

// 如下为CASE的用法-----------------------------

$level = Db::query("SELECT SUM(1) AS '全部用户',SUM(CASE WHEN type=1 AND level= 0 THEN 1 ELSE 0 END) AS '店主',SUM(CASE WHEN type=1 AND level= 1 THEN 1 ELSE 0 END) AS '高级店主',SUM(CASE WHEN type=1 AND level= 2 THEN 1 ELSE 0 END) AS '特约店主',SUM(CASE WHEN type=0 THEN 1 ELSE 0 END) AS '普通用户',SUM(CASE WHEN is_partner=1 THEN 1 ELSE 0 END) AS '合伙人',SUM(CASE WHEN is_insider=1 THEN 1 ELSE 0 END) AS '内部',SUM(CASE WHEN is_city_agent=1 THEN 1 ELSE 0 END) AS '市级代理' FROM ims_nets_hjk_members");

SELECT SUM(CASE WHEN

                     pay_status = 1 AND

                     date_format(from_UNIXTIME(`pay_time`),'%Y-%m-%d') = date_format(now(),'%Y-%m-%d') THEN 1 ELSE 0 END

                     ) AS S1,

                 SUM(CASE WHEN

                     pay_status = 1 AND

                     date_format(from_UNIXTIME(`pay_time`),'%Y-%m-%d') = date_format(now(),'%Y-%m-%d') THEN point ELSE 0 END

                     ) AS S2,

                 SUM(CASE WHEN

                     pay_status = 1 AND

                     order_status = 0 THEN 1 ELSE 0 END

                     ) AS S3

FROM ims_integral_order;

// 优化一个四表联查，以会员表作为临时表--------------------------

$list = Db::query("

                     SELECT

                     M1s.*, M2.avatar AS avatar_is,

                     M2.avatar AS avatar_is,M2.nickname AS nickname_is,M2.pid AS pid_is,

                     M3.integral,M3.asset,M3.wallet,

                     FROM_UNIXTIME(M4.addTime,'%Y-%m-%d %H:%i:%s') AS addTime

                     FROM

                     (

                         SELECT

                             memberid,pid,avatar,nickname,FROM_UNIXTIME(created_at,'%Y-%m-%d %H:%i:%s') AS created_at,level,type,is_city_agent,is_partner,is_insider,realname,mobile,from_uid

                         FROM

                             ims_nets_hjk_members AS M1

                         WHERE ".$whes."

                         ORDER BY

                             created_at DESC

                         LIMIT ".(($pindex - 1) * $psize).",". $psize."

                     ) AS M1s

                     LEFT JOIN ims_nets_hjk_members AS M2 ON M1s.from_uid = M2.memberid

                     LEFT JOIN ims_mc_members AS M3 ON M1s.memberid = M3.uid

                     LEFT JOIN t_fans_log AS M4 ON M1s.memberid = M4.fans_memberId

                     ");

//TP自加和自减

$res = $this->where('single','gt',0)

　　　　->update([

　　　　　　　　'red_fee'=>['INC',$fee],//自加

　　　　　　　　'create_time'=>time(),

　　　　　　　　'count'=>['DEC',1],//自减

　　　　　　　　　]);

//TP大于或者小于

$res = $this->where([

　　　　　　['status','=',1],

　　　　　　['page_id','>',0]

　　　　　　]);

//DB操作批量插入

$res = $db->table('ims_nets_hjk_sogo_licence')->insertAll($sogo_licence);

//查询指定会员已激活的设备，并且不在ims_nets_hjk_sogo_equipment表里面，EXISTS用法

$list = $db->query("SELECT s_id FROM `ims_nets_hjk_devices`

　　　　　　　　　　WHERE active_member_id = ".$uid."

　　　　　　　　　　AND `status` = 1

　　　　　　　　　　AND NOT EXISTS

　　　　　　　　　　　　(SELECT s_id FROM ims_nets_hjk_sogo_equipment WHERE s_id = ims_nets_hjk_devices.s_id )

//打印SQL语句

->buildSql();

四、ThinkPHP5.0常用操作

//模拟url传递数组

$url = 'http://niushop.jingjinglego.com/index.php?s=/admin/We7Config/addIndexAd&type=2&adList[0][sort]=456&adList[0][img]=upad/test/1e.jpg&adList[0][outerUrl]=www.bai.com&adList[0][source]=1&adList[1][sort]=456&adList[1][img]=upad/test/1e.jpg&adList[1][outerUrl]=www.bai.com&adList[1][source]=1';

//调用请求类request写法,接受数组

$ids = request->post('ids/a');

//获取参数

use think\Request;

$request = Request::instance();

$method = $request->method();//获取上传方式

$request->param();//获取所有参数，最全

$get = $request->get();//获取get上传的内容

$post = $request->post();//获取post上传的内容

$request->file('file')//获取文件

//错误和正确提示及跳转error/success

$this->error("抱歉你不是最帅的人", __URL__ . "/wap/We7Store/storeManagement");

// 锁定跳转,url重定向

$redirect = __URL(__URL__ . "/wap/login/userlock");

$this->redirect($redirect);

四、检查字符串是否是URL

//判断是否是url

function is_url($v){

    $pattern="#(http|https)://(.*\.)?.*\..*#i";

    if(preg_match($pattern,$v)){

        return true;

    }else{

        return false;

    }

}

巴特西

PHP代码篇（三）--常用方法

最新文章

热门文章