帝国cms之微信小程序api

<?php /** * Created by sjmoban.com 老李. * Date: 2018/1/29 0029 * Time: 下午 12:08 * E-mail: sjmoban@163.com * QQ: 79089679 */ require('../../class/connect.php'); //引入数据库配置文件和公共函数文件 require('../../class/db_sql.php'); //引入数据库操作文件 require('../../data/dbcache/class.php'); //引入栏目缓存文件 $link=db_connect(); //连接MYSQL $empire=new mysqlquery(); //声明数据库操作类 class lsk{ public static function cat_getlist($ta=array()){ //传递过来的参数有pid,page但仿头条，直接读取所有类即可。只有一级分类， global $class_r; $rows=array(); foreach($class_r as $kk=>$row){ $ta['id']=$row['classid']; $ta['title']=$row['classname']; $ta['page']=0; array_push($rows,$ta); } return array('status'=>'success','msg'=>'success','rows'=>$rows); } public static function news_getlist($ta=array()){ global $class_r,$dbtbpre,$empire; $cid=$ta['cid']; $tbname=$class_r[$cid]['tbname']; $mid=$class_r[$cid]['modid']; $page=$ta['page']; $page=empty($page)?1:intval($page); $add=''; if($class_r[$cid]['islast'])//终极栏目 { $add.="classid='$cid'"; } else { $add.=ReturnClass($class_r[$cid][sonclass]); } $perpage=25; // $perpage=$class_r[$cid]['lencord'];//每页显示记录数 $offset=($page-1)*$perpage; $sqlstr="select id,titlepic,title from {$dbtbpre}ecms_".$tbname.' where '.$add.' limit '.$offset.','.$perpage; // $sqlstr="select ".ReturnSqlListF($mid)." from {$dbtbpre}ecms_".$tbname.' where '.$add.' limit 10'; $query=$empire->query($sqlstr); $rows=array(); while($row=$empire->fetch($query)){ $row['page']=0; $row['pictype']=1; if(empty($row['titlepic'])){ $row['pictype']=0; }else{ $row['picurl']=self::picurl($row['titlepic']); } $row['cid']=$cid; $row['title']=stripSlashes($row['title']); $row['clicks']=0; array_push($rows,$row); } if(empty($rows)){ return array('status'=>'failed','msg'=>'没有数据了！'); } return array('status'=>'success','msg'=>'success','rows'=>$rows,'page'=>$page,'picurl'=>self::picurl('dsfsdfsd')); } public static function news_getinfo($ta=array()){ global $class_r,$empire,$dbtbpre; $id=intval($ta['id']); $cid=intval($ta['cid']); $tbname=$class_r[$cid]['tbname']; $mid=$class_r[$cid]['modid']; $sqlstr1="select * from {$dbtbpre}ecms_".$tbname." where id='$id'"; $row=$empire->fetch1($sqlstr1); $sqlstr2="select ".ReturnSqlFtextF($mid)." from {$dbtbpre}ecms_".$tbname."_data_".$row['stb']." where id='$row[id]' limit 1"; $addr=$empire->fetch1($sqlstr2); $row=array_merge($row,$addr); if(!empty($ta['debug'])){ print_r($row); } $row['content_json']=stripSlashes(html_entity_decode(str_replace('&amp;', "&",$row['newstext']))); // $row['content_json']=$row['newstext']; $imglist=array(); $row['title']=stripSlashes($row['title']); $ra=array( 'content_json'=>$row['content_json'], 'id'=>$row['id'], 'title'=>$row['title'] ); return array('status'=>'success','msg'=>'success','row'=>$ra,'imglist'=>$imglist); } public static function picurl($picurl=''){ $picurl=ltrim($picurl,'/'); if(stripos($picurl,'http')===false){//即没找到 $picurl=$_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'].'/'.$picurl; return $picurl; }else{ return $picurl; } } } /* db_close(); //关闭MYSQL链接 $empire=null; //注消操作类变量*/ ?>