漏刻有时多功能php-API接口开发实例【PHP教程】

概述/*06.疑难点位管理*/functiongetDifficult(){global$db,$res;dbc();@$poi_address=get_param("poi_address");@$poi_sn=get_param("poi_sn");@$poi_ins5=$_GET["poi_ins5"];

  /*06.疑难点位管理*/    function getDifficult()    {        global $db, $res;        dbc();        @$poi_address = get_param(\"poi_address\");        @$poi_sn = get_param(\"poi_sn\");        @$poi_ins5 = $_GET[\"poi_ins5\"];        @$p = $_GET[\'page\'] == \"\" ? 1 : $_GET[\'page\'];//获取用户选择的页码        @$pagesize = $_GET[\'limit\'] == \"\" ? 15 : $_GET[\'limit\'];//获取用户选择的每页显示多少条数据        @$limit = ($p - 1) * $pagesize;//偏移量        $sql = \"select a.main_ID,a.poi_ID,a.poi_sn,a.poi_name,a.poi_address,a.poi_difficult,a.poi_md,from_unixtime(a.poi_brdown) as poi_brdown,b.poi_ID,b.poi_ins1,b.poi_ins2,b.poi_ins3,b.poi_ins4,b.poi_bdlng AS poi_lon,b.poi_bdlat AS poi_lat from \" . $db->table(\'maintain\') . \" AS a,\" . $db->table(\'poi\') . \" AS b WHERE a.poi_ID = b.poi_ID\";        $sql .= \" AND a.poi_difficult = 1\";        //编号和名称搜索;        IF ($poi_sn != \"\") {            $sql .= \" AND (a.poi_name like \'%\" . $poi_sn . \"%\' OR a.poi_sn like \'%\" . $poi_sn . \"%\')\";        }        IF ($poi_ins5 != \"\") {            $sql .= \" AND a.poi_ins5 =\'\" . $poi_ins5 . \"\'\";        }        $sql .= \" ORDER BY a.main_ID DESC liMIT \" . $limit . \",\" . $pagesize;        $row = $db->queryall($sql);        $sql_c = \"select a.main_ID,a.poi_ID,a.poi_sn,a.poi_name,a.poi_address,a.poi_difficult,from_unixtime(a.poi_brdown) as poi_brdown,b.poi_ID,b.poi_ins1,b.poi_ins2,b.poi_ins3,b.poi_ins4 from \" . $db->table(\'maintain\') . \" AS a,\" . $db->table(\'poi\') . \" AS b WHERE a.poi_ID = b.poi_ID\";        $sql_c .= \" AND a.poi_difficult = 1\";        //编号和名称搜索;        IF ($poi_sn != \"\") {            $sql_c .= \" AND (a.poi_name like \'%\" . $poi_sn . \"%\' OR a.poi_sn like \'%\" . $poi_sn . \"%\')\";        }        IF ($poi_ins5 != \"\") {            $sql_c .= \" AND a.poi_ins5 =\'\" . $poi_ins5 . \"\'\";        }        $sql_c .= \" ORDER BY a.main_ID DESC liMIT \" . $limit . \",\" . $pagesize;        $row_c = $db->queryall($sql_c);        $res[\'code\'] = 0;        $res[\'count\'] = count($row_c);        $res[\"data\"] = $row;        dIE(Json_encode_lockdata($res));    }

Lockdatav Done!

总结

以上是内存溢出为你收集整理的漏刻有时多功能php-API接口开发实例全部内容，希望文章能够帮你解决漏刻有时多功能php-API接口开发实例所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。