• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP to_sqls函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中to_sqls函数的典型用法代码示例。如果您正苦于以下问题:PHP to_sqls函数的具体用法?PHP to_sqls怎么用?PHP to_sqls使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了to_sqls函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: delete

	/**
	 * 删除队列信息
	 */
	public function delete() {
		$idarr = isset($_POST['id']) ? $_POST['id'] : showmessage(L('illegal_parameters'), HTTP_REFERER);
		$where = to_sqls($idarr, '', 'id');
		if ($this->db->delete($where)) {
			showmessage(L('operation_success'), HTTP_REFERER);
		} else {
			showmessage(L('operation_failure'), HTTP_REFERER);
		}
	}
开发者ID:panhongsheng,项目名称:zl_cms,代码行数:12,代码来源:messagequeue.php


示例2: listinfo

 /**
  * 查询多条数据并分页
  * @param $where
  * @param $order
  * @param $page
  * @param $pagesize
  * @return unknown_type
  */
 public final function listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key = '', $setpages = 10, $urlrule = '', $array = array())
 {
     $where = to_sqls($where);
     $this->number = $this->count($where);
     $page = max(intval($page), 1);
     $offset = $pagesize * ($page - 1);
     $this->pages = pages($this->number, $page, $pagesize, $urlrule, $array, $setpages);
     $array = array();
     return $this->select($where, '*', "{$offset}, {$pagesize}", $order, '', $key);
 }
开发者ID:klj123wan,项目名称:czsz,代码行数:18,代码来源:model.class.php


示例3: listinfo

	/**
	 * 查询多条数据并分页
	 * @param $where
	 * @param $order
	 * @param $page
	 * @param $pagesize
	 * @return unknown_type
	 */
	final public function listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key='', $setpages = 10,$urlrule = '',$array = array(), $data = '*') {
		$where = to_sqls($where);
		$this->number = $this->count($where);
		$page = max(intval($page), 1);
		$offset = $pagesize*($page-1);
		$this->pages = pages($this->number, $page, $pagesize, $urlrule, $array, $setpages);
		$array = array();
		if ($this->number > 0) {
			return $this->select($where, $data, "$offset, $pagesize", $order, '', $key);
		} else {
			return array();
		}
	}
开发者ID:panhongsheng,项目名称:zl_cms,代码行数:21,代码来源:model.class.php


示例4: init

 /**
  * 首页
  */
 public function init()
 {
     if (isset($_POST['dosubmit'])) {
         $denyusername = isset($_POST['denyusername']) ? new_stripslashes(trim($_POST['denyusername'])) : '';
         $denyemail = isset($_POST['denyemail']) ? new_stripslashes(trim($_POST['denyemail'])) : '';
         $denyemaildata = array2string(explode("\r\n", $denyemail));
         $denyusernamedata = array2string(explode("\r\n", $denyusername));
         $this->db->insert(array('name' => 'denyemail', 'data' => $denyemaildata), 1, 1);
         $this->db->insert(array('name' => 'denyusername', 'data' => $denyusernamedata), 1, 1);
         /*写入缓存*/
         setcache('settings', array('denyemail' => explode("\r\n", $denyemail), 'denyusername' => explode("\r\n", $denyusername)));
         showmessage(L('operation_success'), HTTP_REFERER);
     }
     $where = to_sqls(array('denyemail', 'denyusername'), '', 'name');
     $settingarr = $this->db->listinfo($where);
     foreach ($settingarr as $v) {
         $setting[$v['name']] = string2array($v['data']);
     }
     include $this->admin_tpl('system');
 }
开发者ID:jiangwuzhang,项目名称:phpcms,代码行数:23,代码来源:system.php


示例5: get_all

 public final function get_all($data = '*', $from = '', $where = '', $order = '', $limit = '')
 {
     if (!$from) {
         $from = $this->table_name;
     }
     $sql = 'SELECT ' . $data . ' FROM ' . $from;
     if ($where) {
         $where = to_sqls($where);
         $sql .= ' WHERE ' . $where;
     }
     if ($order) {
         $sql .= ' ORDER BY ' . $order;
     }
     if ($limit) {
         $limitNums = explode(',', $limit);
         $sql .= ' LIMIT ' . intval($limitNums[0]) . ',' . $limitNums[1];
     }
     $arr = $this->selectBySql($sql);
     return $arr;
 }
开发者ID:liuguogen,项目名称:weixin,代码行数:20,代码来源:model.class.php


示例6: my_listinfo

 public final function my_listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key = '', $setpages = 10, $urlrule = '', $array = array())
 {
     if (is_array($where)) {
         $number = $this->query('select count(*) as num ' . substr($where['sql'], strpos($where['sql'], 'from')));
         $num = $this->fetch_array($number);
         $this->number = $num[0]['num'];
     } else {
         $where = to_sqls($where);
         $this->number = $this->count($where);
     }
     $page = max(intval($page), 1);
     $offset = $pagesize * ($page - 1);
     $this->pages = my_pages($this->number, $page, $pagesize, $urlrule, $array, $setpages);
     $array = array();
     if ($this->number > 0) {
         if (is_array($where)) {
             return $this->queryAll($where['sql'] . " order by {$order} limit {$offset}, {$pagesize}");
         } else {
             return $this->select($where, '*', "{$offset}, {$pagesize}", $order, '', $key);
         }
     } else {
         return array();
     }
 }
开发者ID:cfhb,项目名称:MIS,代码行数:24,代码来源:model.class.php


示例7: getSql

 function getSql($avs, $siteID)
 {
     //properties
     $num = intval($avs['totalNum']);
     $start = $avs['startNum'] == null ? 0 : intval($avs['startNum']) - 1;
     $channelSql = '';
     if ($avs['channelIndex']) {
         $channelObj = bpBase::loadAppClass('channelObj', 'channel', 1);
         $thisChannel = $channelObj->getChannelByIndex($avs['channelIndex'], 1);
         $channelids = array();
         if (intval($thisChannel->id)) {
             $channelSql = ' AND A.channel_id=' . $thisChannel->id;
             array_push($channelids, $thisChannel->id);
             if ($avs['scope'] && $avs['scope'] == 'children') {
                 $channels = $channelObj->getChannelsByParentID($thisChannel->id);
                 if ($channels) {
                     foreach ($channels as $c) {
                         array_push($channelids, $c->id);
                     }
                 }
             }
             $channelSql = ' AND ' . to_sqls($channelids, '', 'A.channel_id');
         }
         //
     }
     if (!intval($avs['city'])) {
         return 'SELECT A.autoid,A.id,A.site,A.link,A.externallink,A.thumb,CC.title,CC.title AS subtitle,A.title AS atitle,A.subtitle AS asubtitle,A.intro,A.source,A.author,A.time,A.keywords,A.pagecount FROM ' . TABLE_PREFIX . 'contentgroup_content CC,' . TABLE_PREFIX . 'article A WHERE groupid=' . $avs['id'] . ' AND A.id=CC.contentid' . $channelSql . ' AND A.time<{sysTime} ORDER BY CC.taxis DESC LIMIT ' . $start . ',' . $num;
     } else {
         return 'SELECT A.autoid,A.id,A.site,A.link,A.externallink,A.thumb,CC.title,CC.title AS subtitle,A.title AS atitle,A.subtitle AS asubtitle,A.intro,A.source,A.author,A.time,A.keywords,A.pagecount FROM ' . TABLE_PREFIX . 'contentgroup_content CC,' . TABLE_PREFIX . 'article A WHERE groupid=' . $avs['id'] . ' AND CC.geoid=' . intval($avs['city']) . ' AND A.id=CC.contentid' . $channelSql . ' AND A.time<{sysTime} ORDER BY CC.taxis DESC LIMIT ' . $start . ',' . $num;
     }
 }
开发者ID:ailingsen,项目名称:pigcms,代码行数:31,代码来源:tag_groupContents.class.php


示例8: init


//.........这里部分代码省略.........
             $result = $this->db->listinfo($sql, 'searchid DESC', $page, 10);
         }
         //如果开启相关搜索功能
         if ($setting['relationenble']) {
             //如果关键词长度在8-16之间,保存关键词作为relation search
             $this->keyword_db = pc_base::load_model('search_keyword_model');
             if (strlen($q) < 17 && strlen($q) > 5 && !empty($segment_q)) {
                 $res = $this->keyword_db->get_one(array('keyword' => $q));
                 if ($res) {
                     //关键词搜索数+1
                     //$this->keyword_db->update(array('searchnums'=>'+=1'), array('keyword'=>$q));
                 } else {
                     //关键词转换为拼音
                     pc_base::load_sys_func('iconv');
                     $pinyin = gbk_to_pinyin($q);
                     if (is_array($pinyin)) {
                         $pinyin = implode('', $pinyin);
                     }
                     $this->keyword_db->insert(array('keyword' => $q, 'searchnums' => 1, 'data' => $segment_q, 'pinyin' => $pinyin));
                 }
             }
             //相关搜索
             if (!empty($segment_q)) {
                 $relation_q = str_replace(' ', '%', $segment_q);
             } else {
                 $relation_q = $q;
             }
             $relation = $this->keyword_db->select("MATCH (`data`) AGAINST ('%{$relation_q}%' IN BOOLEAN MODE)", '*', 10, 'searchnums DESC');
         }
         //如果结果不为空
         if (!empty($result) || !empty($commend['id'])) {
             //开启sphinx后文章id取法不同
             if ($setting['sphinxenable']) {
                 foreach ($result as $_v) {
                     $sids[] = $_v['attrs']['id'];
                 }
             } else {
                 foreach ($result as $_v) {
                     $sids[] = $_v['id'];
                 }
             }
             if (!empty($commend['id'])) {
                 $sids[] = $commend['id'];
             }
             $sids = array_unique($sids);
             $where = to_sqls($sids, '', 'id');
             //获取模型id
             $model_type_cache = getcache('type_model_' . $siteid, 'search');
             $model_type_cache = array_flip($model_type_cache);
             $modelid = $model_type_cache[$typeid];
             //是否读取其他模块接口
             if ($modelid) {
                 $this->content_db->set_model($modelid);
                 /**
                  * 如果表名为空,则为黄页模型
                  */
                 if (empty($this->content_db->model_tablename)) {
                     $this->content_db = pc_base::load_model('yp_content_model');
                     $this->content_db->set_model($modelid);
                 }
                 if ($setting['sphinxenable']) {
                     $data = $this->content_db->listinfo($where, 'id DESC', 1, $pagesize);
                     $pages = pages($totalnums, $page, $pagesize);
                 } else {
                     $data = $this->content_db->select($where, '*');
                     $pages = $this->db->pages;
                     $totalnums = $this->db->number;
                 }
                 //如果分词结果为空
                 if (!empty($segment_q)) {
                     $replace = explode(' ', $segment_q);
                     foreach ($replace as $replace_arr_v) {
                         $replace_arr[] = '<font color=red>' . $replace_arr_v . '</font>';
                     }
                     foreach ($data as $_k => $_v) {
                         $data[$_k]['title'] = str_replace($replace, $replace_arr, $_v['title']);
                         $data[$_k]['description'] = str_replace($replace, $replace_arr, $_v['description']);
                     }
                 } else {
                     foreach ($data as $_k => $_v) {
                         $data[$_k]['title'] = str_replace($q, '<font color=red>' . $q . '</font>', $_v['title']);
                         $data[$_k]['description'] = str_replace($q, '<font color=red>' . $q . '</font>', $_v['description']);
                     }
                 }
             } else {
                 //读取专辑搜索接口
                 $special_api = pc_base::load_app_class('search_api', 'special');
                 $data = $special_api->get_search_data($sids);
                 $totalnums = count($data);
             }
         }
         $execute_time = execute_time();
         $pages = isset($pages) ? $pages : '';
         $totalnums = isset($totalnums) ? $totalnums : 0;
         $data = isset($data) ? $data : '';
         include template('search', 'list');
     } else {
         include template('search', 'index');
     }
 }
开发者ID:baowzh,项目名称:renfang,代码行数:101,代码来源:index.php


示例9: getChannelTotalPage

 /**
  * 根据模板中的pageContents标签获取每页的数量值,仅生成静态页时有效
  *
  * @param unknown_type $channelID
  * @return unknown
  */
 public function getChannelTotalPage($channelID)
 {
     $tpl = bpBase::loadAppClass('template', 'template', 1);
     //channel
     $channelID = intval($channelID);
     $thisChannel = $this->getChannelByID($channelID);
     //分析模板
     $template = $tpl->get($thisChannel->channeltemplate);
     if (!file_exists(ABS_PATH . 'templatesCache' . DIRECTORY_SEPARATOR . $template->id . '.parsed.tpl.php')) {
         $tpl->createChannelPageR($channelid);
     }
     //只有生成静态页的情况下,下面的代码才有效
     $totalPage = 1;
     if (file_exists(ABS_PATH . '/templatesCache/' . $template->id . '.tags.tpl.php')) {
         @(require ABS_PATH . '/templatesCache/' . $template->id . '.tags.tpl.php');
         $pageSize = 20;
         //判断是否有分页标签
         $isPagination = false;
         if ($tagsArr) {
             foreach ($tagsArr as $t) {
                 if ($t['name'] == 'pageContents') {
                     //
                     $isPagination = true;
                     $pageSize = $t['avs']['pageNum'];
                 }
             }
         }
         if ($isPagination) {
             $childChannels = $this->getChannelsByParentID($channelID);
             $channelidArr = array($channelID);
             if ($childChannels) {
                 foreach ($childChannels as $c) {
                     array_push($channelidArr, $c->id);
                 }
             }
             $article_db = bpBase::loadModel('article_model');
             $where = to_sqls($channelidArr, '', 'channel_id');
             $totalCount = $article_db->get_var($where, 'COUNT(id)', '', '');
             $totalPage = $totalCount % $pageSize > 0 ? intval($totalCount / $pageSize) + 1 : $totalCount / $pageSize;
             $totalPage = $totalPage < 1 ? 1 : $totalPage;
         } else {
             $totalPage = 1;
         }
     }
     return $totalPage;
 }
开发者ID:ailingsen,项目名称:pigcms,代码行数:52,代码来源:channelObj.class.php


示例10: deleteExRelateArticle20130416

 public function deleteExRelateArticle20130416()
 {
     $taskName = 'deleteExRelateArticle20130416';
     $thisTask = $this->update_log_db->get_one(array('file' => $taskName));
     $this->_executedCheck($taskName, $thisTask);
     //
     $content_db = bpBase::loadModel('content_model');
     $article_db = bpBase::loadModel('article_model');
     $articles = $article_db->select(array('ex' => 1), 'id');
     $articleids = array();
     if ($articles) {
         foreach ($articles as $a) {
             array_push($articleids, $a['id']);
         }
     }
     $content_db->delete(to_sqls($articleids, '', 'contentid'));
     //
     $this->_finishTask($taskName, $thisTask);
 }
开发者ID:liuguogen,项目名称:weixin,代码行数:19,代码来源:updateTask.php


示例11: init

 /**
  * 关键词搜索
  */
 public function init()
 {
     //获取siteid
     $siteid = isset($_REQUEST['siteid']) && trim($_REQUEST['siteid']) ? intval($_REQUEST['siteid']) : 1;
     $SEO = seo($siteid);
     //搜索配置
     $search_setting = getcache('search');
     $setting = $search_setting[$siteid];
     $search_model = getcache('search_model_' . $siteid);
     $type_module = getcache('type_module_' . $siteid);
     if (isset($_POST['q'])) {
         if (trim($_POST['q']) == '') {
             header('Location: ' . APP_PATH . 'index.php?m=search');
             exit;
         }
         $typeid = empty($_POST['typeid']) ? 0 : intval($_POST['typeid']);
         $time = empty($_POST['time']) || !in_array($_POST['time'], array('all', 'day', 'month', 'year', 'week')) ? 'all' : trim($_POST['time']);
         $page = isset($_POST['page']) ? intval($_POST['page']) : 1;
         $pagesize = 10;
         $q = safe_replace(trim($_POST['q']));
         $q = new_html_special_chars(strip_tags($q));
         $q = str_replace('%', '', $q);
         //过滤'%',用户全文搜索
         $search_q = $q;
         //搜索原内容
         $sql_time = $sql_tid = '';
         if ($typeid) {
             $sql_tid = ' AND typeid = ' . $typeid;
         }
         //按时间搜索
         if ($time == 'day') {
             $search_time = SYS_TIME - 86400;
             $sql_time = ' AND adddate > ' . $search_time;
         } elseif ($time == 'week') {
             $search_time = SYS_TIME - 604800;
             $sql_time = ' AND adddate > ' . $search_time;
         } elseif ($time == 'month') {
             $search_time = SYS_TIME - 2592000;
             $sql_time = ' AND adddate > ' . $search_time;
         } elseif ($time == 'year') {
             $search_time = SYS_TIME - 31536000;
             $sql_time = ' AND adddate > ' . $search_time;
         } else {
             $search_time = 0;
             $sql_time = '';
         }
         if ($page == 1 && !$setting['sphinxenable']) {
             //精确搜索
             $commend = $this->db->get_one("`siteid`= '{$siteid}' {$sql_tid} {$sql_time} AND `data` like '%{$q}%'");
         } else {
             $commend = '';
         }
         //如果开启sphinx
         if ($setting['sphinxenable']) {
             $sphinx = pc_base::load_app_class('search_interface', '', 0);
             $sphinx = new search_interface();
             $offset = $pagesize * ($page - 1);
             $res = $sphinx->search($q, array($siteid), array($typeid), array($search_time, SYS_TIME), $offset, $pagesize, '@weight desc');
             $totalnums = $res['total'];
             //如果结果不为空
             if (!empty($res['matches'])) {
                 $result = $res['matches'];
             }
         } else {
             $sql = "`siteid`= '{$siteid}' {$sql_tid} {$sql_time} AND `data` like '%{$q}%'";
             $result = $this->db->listinfo($sql, 'searchid DESC', $page, 10);
             //$result = $this->db->listinfo($sql, 'adddate ASC', $page, 10);
         }
         //如果结果不为空
         if (!empty($result) || !empty($commend['id'])) {
             foreach ($result as $_v) {
                 if ($_v['typeid']) {
                     $sids[$_v['typeid']][] = $_v['id'];
                 }
             }
             if (!empty($commend['id'])) {
                 if ($commend['typeid']) {
                     $sids[$commend['typeid']][] = $commend['id'];
                 }
             }
             $model_type_cache = getcache('type_model_' . $siteid, 'search');
             $model_type_cache = array_flip($model_type_cache);
             $data = array();
             foreach ($sids as $_k => $_val) {
                 $tid = $_k;
                 $ids = array_unique($_val);
                 $where = to_sqls($ids, '', 'id');
                 //获取模型id
                 $modelid = $model_type_cache[$tid];
                 //是否读取其他模块接口
                 if ($modelid) {
                     $this->content_db->set_model($modelid);
                     /**
                      * 如果表名为空,则为黄页模型
                      */
                     if (empty($this->content_db->model_tablename)) {
                         $this->content_db = pc_base::load_model('yp_content_model');
//.........这里部分代码省略.........
开发者ID:hw18708118867,项目名称:htmlmoban,代码行数:101,代码来源:index.php


示例12: createChannelPageSelect

 function createChannelPageSelect()
 {
     $channel_db = bpBase::loadModel('channel_model');
     $channel = bpBase::loadAppClass('channelObj', 'channel', 1);
     if (isset($_POST['doSubmit'])) {
         //选定栏目
         if ($_GET['type'] == 'channel') {
             $channelIDStr = '';
             if ($_POST['channels']) {
                 $comma = '';
                 foreach ($_POST['channels'] as $c) {
                     //$channelTotalPage=$channel->getChannelTotalPage($c);
                     $channelTotalPage = 1;
                     for ($t = 1; $t < $channelTotalPage + 1; $t++) {
                         $channelIDStr .= $comma . $c . '.' . $t;
                         //,channelid.pageNum
                         $comma = ',';
                     }
                     //清除缓存
                     $content = bpBase::loadAppClass('articleObj', 'article', 1);
                     $content->clearContentsCache($c);
                     $channel->clearCrumbCache($c);
                 }
             }
             file_put_contents(ABS_PATH . 'templatesCache' . DIRECTORY_SEPARATOR . 'channels.txt', $channelIDStr);
             echo '<script>window.location.href=\'?m=template&c=createHtml&a=createChannelPage&siteid=' . $_GET['siteid'] . '&type=channel\';</script>';
         } elseif ($_GET['type'] == 'content') {
             $article_db = bpBase::loadModel('article_model');
             $contentIDStr = '';
             if ($_POST['channels']) {
                 $where = to_sqls($_POST['channels'], '', 'channel_id');
                 $contents = $article_db->get_results('id', '', $where, 'time DESC');
                 $comma = '';
                 if ($contents) {
                     foreach ($contents as $cc) {
                         $contentIDStr .= $comma . $cc->id;
                         $comma = ',';
                     }
                 }
             }
             file_put_contents(ABS_PATH . 'templatesCache' . DIRECTORY_SEPARATOR . 'contents.txt', $contentIDStr);
             echo '<script>window.location.href=\'?m=template&c=createHtml&a=createChannelPage&siteid=' . $_GET['siteid'] . '&type=content\';</script>';
         }
     } else {
         /*
         $channels=$channel_db->select('');
         $channelsByID=array();//用栏目id作为数组id来组织栏目数组
         if ($channels){
         	foreach ($channels as $c){
         		$channelsByID[$c['id']]=$c;
         	}
         }
         $rights=$this->rights($user->uid);//根据用户id获取用户的权限数组
         $accessChannels=$this->accessChannels($rights);
         //*******************向上查找哪些父栏目需要在栏目树中显示********************
         $showChannels=array();//向上查找哪些父栏目需要在栏目树中显示
         foreach ($accessChannels as $channelid){
         	$pid=$channelid;
         	do {
         		$pid=$channelsByID[$channelid]['parentid'];
         		array_push($showChannels,$pid);
         		array_push($showChannels,$channelid);
         		$channelid=$channelsByID[$pid]['id'];
         	}while ($pid!=0&&!in_array($pid,$showChannels));
         }
         */
         /////////////////////////////////////////////////
         $selectOptionStr = $channel->channelCreatePageTree($channel->tree(0, $_GET['siteid']), 0, $accessChannels, $showChannels);
         include $this->showManageTpl('createChannelPageSelect');
     }
 }
开发者ID:liuguogen,项目名称:weixin,代码行数:71,代码来源:createHtml.php


示例13: get_search_data

 /**
  * 获取专题下内容数据
  * @param string/intval $ids 多个id用“,”分开
  */
 public function get_search_data($ids)
 {
     $where = to_sqls($ids, '', 'id');
     $data = $this->db->select($where, '`id`, `title`, `thumb`, `description`, `url`, `inputtime`', '', '', '', 'id');
     return $data;
 }
开发者ID:boylzj,项目名称:omguitar,代码行数:10,代码来源:search_api.class.php


示例14: exportmobile

 public function exportmobile()
 {
     $start_time = isset($_POST['start_time']) ? $_POST['start_time'] : '';
     $end_time = isset($_POST['end_time']) ? $_POST['end_time'] : date('Y-m-d', SYS_TIME);
     $where_start_time = strtotime($start_time) ? strtotime($start_time) : 0;
     $where_end_time = strtotime($end_time) + 86400;
     $groupid = isset($_POST['groupid']) && !empty($_POST['groupid']) ? $_POST['groupid'] : '';
     $modelid = isset($_POST['modelid']) && !empty($_POST['modelid']) ? $_POST['modelid'] : 10;
     //开始时间大于结束时间,置换变量
     if ($where_start_time > $where_end_time) {
         $tmp = $where_start_time;
         $where_start_time = $where_end_time;
         $where_end_time = $tmp;
         $tmptime = $start_time;
         $start_time = $end_time;
         $end_time = $tmptime;
         unset($tmp, $tmptime);
     }
     $where = '';
     if ($groupid) {
         $where .= "`groupid` = '{$groupid}' AND ";
     }
     if ($modelid) {
         $where .= "`modelid` = '{$modelid}' AND ";
     }
     $where .= "`regdate` BETWEEN '{$where_start_time}' AND '{$where_end_time}'";
     //根据条件读取会员主表
     $total = $this->member_db->count($where);
     $str = '';
     $perpage = 10;
     for ($i = 0; $i <= floor($total / $perpage); $i++) {
         $start = $i * $perpage;
         $data = $this->member_db->select($where, 'userid', "{$start}, {$perpage}");
         $userid_arr = array();
         foreach ($data as $v) {
             $userid_arr[] = $v['userid'];
         }
         $uids = to_sqls($userid_arr, '', 'userid');
         //读取模型表中手机号码字段
         $this->member_db->set_model($modelid);
         $data = $this->member_db->select($uids);
         foreach ($data as $v) {
             if (!empty($v['mobile'])) {
                 $str .= $v['mobile'] . "\r\n";
             }
         }
         $this->member_db->set_model();
     }
     header("Content-type:application/octet-stream");
     header("Content-Disposition: attachment; filename=mobile.txt");
     echo $str;
 }
开发者ID:baowzh,项目名称:renfang,代码行数:52,代码来源:sms.php


示例15: export

 public function export()
 {
     if (isset($_POST['doSubmit'])) {
         //1 创建保存路径
         $modelPath = ABS_PATH . 'templates' . DIRECTORY_SEPARATOR . 'specialModel';
         if (!file_exists($modelPath) || !is_dir($modelPath)) {
             mkdir($modelPath, 777);
         }
         $saveFolder = $modelPath . DIRECTORY_SEPARATOR . $_POST['enname'];
         if (!file_exists($saveFolder) || !is_dir($saveFolder)) {
             mkdir($saveFolder, 777);
         }
         //2 拷贝专题文件到模型路径
         recurse_copy(ABS_PATH . 'templates' . DIRECTORY_SEPARATOR . 'special' . DIRECTORY_SEPARATOR . $_POST['enname'] . DIRECTORY_SEPARATOR, $saveFolder . DIRECTORY_SEPARATOR);
         //3 保存模型信息:名称、简介等
         $modelInfo = array();
         $modelInfo['name'] = $_POST['name'];
         $modelInfo['enname'] = $_POST['enname'];
         $modelInfo['intro'] = $_POST['intro'];
         file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'modelInfo.txt', base64_encode(serialize($modelInfo)));
         //4 创建logo
         $logoPath = str_replace(array(MAIN_URL_ROOT . '/', '/'), array(ABS_PATH, DIRECTORY_SEPARATOR), $_POST['thumb']);
         @unlink($saveFolder . DIRECTORY_SEPARATOR . 'logo.jpg');
         @rename($logoPath, $saveFolder . DIRECTORY_SEPARATOR . 'logo.jpg');
         //5 导出专题首页模板信息
         $thisSpecial = $this->special_db->get($_POST['specialid']);
         $tpl_db = bpBase::loadModel('template_model');
         $thisTemplate = $tpl_db->get_one(array('id' => intval($thisSpecial['templateid'])));
         //保存专题首页模板
         $tplFile = ABS_PATH . substr($thisTemplate['path'], 1);
         $thisTemplate['code'] = file_get_contents($tplFile);
         file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'index.template.info.txt', base64_encode(serialize($thisTemplate)));
         file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'index.template.txt', $thisTemplate['code']);
         //6 导出专题使用的栏目
         $channel_db = bpBase::loadModel('channel_model');
         $channels = $channel_db->select(array('site' => intval($_POST['specialid'])));
         file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'channels.data.txt', base64_encode(serialize($channels)));
         //保存栏目信息
         //7 处理栏目及内容用的模板
         if ($channels) {
             //查询出所有用到的栏目和内容templateid
             $templateids = array();
             foreach ($channels as $channel) {
                 array_push($templateids, $channel['channeltemplate']);
                 array_push($templateids, $channel['contenttemplate']);
             }
             $templates = $tpl_db->select(to_sqls($templateids, '', 'id'));
             $templates = arrToArrByKey($templates);
             file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'templates.data.txt', base64_encode(serialize($templates)));
             foreach ($channels as $channel) {
                 if ($channel['channeltype'] == 1) {
                     //只处理普通栏目的模板
                     //只处理非默认模板
                     $thisChannelTemplate = $templates[$channel['channeltemplate']];
                     $thisContentTemplate = $templates[$channel['contenttemplate']];
                     if (!$thisChannelTemplate['isdefault']) {
                         //栏目模板
                         $tplFile = ABS_PATH . substr($thisChannelTemplate['path'], 1);
                         $code = file_get_contents($tplFile);
                         file_put_contents($saveFolder . DIRECTORY_SEPARATOR . $channel['cindex'] . '.' . $thisChannelTemplate['id'] . '.channel.template.txt', $code);
                     }
                     if (!$thisContentTemplate['isdefault']) {
                         //内容模板
                         $tplFile = ABS_PATH . substr($thisContentTemplate['path'], 1);
                         $code = file_get_contents($tplFile);
                         file_put_contents($saveFolder . DIRECTORY_SEPARATOR . $channel['cindex'] . '.' . $thisContentTemplate['id'] . '.content.template.txt', $code);
                     }
                 }
             }
         }
         showMessage('导出完成', '?m=special&c=m_special&a=specials');
     } else {
         $adus = bpBase::loadAppClass('adus', 'manage');
         $adus->title = '导出专题为模型';
         $adus->formAction = '?m=special&c=m_special&a=export';
         $adus->tip = '导出条件:专题所用的图片、js和css均在“/templates/special/当前专题/”文件夹下';
         /********************输入项*************************/
         //获取专题模板文件夹列表
         $specialPathSub = ABS_PATH . 'templates' . DIRECTORY_SEPARATOR . 'special';
         $files = scandir($specialPathSub);
         $folderArr = array();
         if ($files) {
             foreach ($files as $f) {
                 if ($f != '.' && $f != '..' && is_dir($specialPathSub . DIRECTORY_SEPARATOR . $f)) {
                     array_push($folderArr, array('itemValue' => $f, 'itemText' => $f, 'selected' => false));
                 }
             }
         }
         //
         $inputs = array();
         array_push($inputs, array('name' => '名称', 'type' => 'text', 'validate' => "'required'", 'style' => 'width:180px;', 'field' => 'name', 'value' => ''));
         array_push($inputs, array('name' => '', 'type' => 'hidden', 'validate' => "'required'", 'field' => 'specialid', 'value' => $_GET['specialid']));
         array_push($inputs, array('type' => 'select', 'field' => 'enname', 'name' => '选择文件夹', 'data' => $folderArr, 'complement' => '本专题的css、图片等文件存放文件夹'));
         array_push($inputs, array('name' => '缩略图', 'type' => 'thumb', 'validate' => "'required'", 'style' => 'width:180px;', 'field' => 'thumb', 'value' => '', 'width' => 800, 'height' => 800));
         array_push($inputs, array('name' => '简介', 'type' => 'textarea', 'style' => 'width:80%;font-size:12px;height:60px;', 'field' => 'intro', 'value' => ''));
         $adus->inputs = $inputs;
         $adus->outputPage();
     }
 }
开发者ID:ailingsen,项目名称:pigcms,代码行数:99,代码来源:m_special.php


示例16: delete

	/**
	 * 删除用户
	 * @param string {$uid:用户id;$username:用户名;$email:email}
	 * @return array {-1:删除失败;>0:删除成功}
	 */
	public function delete() {
		$this->uid = isset($this->data['uid']) ? $this->data['uid'] : '';
		$this->email = isset($this->data['email']) ? $this->data['email'] : '';

		if($this->uid > 0 || is_array($this->uid)) {
			$where = to_sqls($this->uid, '', 'uid');
			
			//ucenter部份
			if ($this->config['ucuse']) {
				pc_base::load_config('uc_config');
				require_once PHPCMS_PATH.'api/uc_client/client.php';
				$s = $this->db->select($where, 'ucuserid');
				if ($s) {
					$uc_data = array();
					foreach ($s as $k=>$v) {
						$uc_data[$k] = $v['ucuserid'];
					}
					if (!empty($uc_data)) $r = uc_user_delete($uc_data);
					if (!$r) {
						exit('-1');
					}
				} else {
					exit('-1');
				}
				
			}
			
			/*插入消息队列*/
			$noticedata['uids'] = $this->uid;
			messagequeue::add('member_delete', $noticedata);
			
			$this->db->delete($where);
			exit('1');
		} elseif(!empty($this->username)) {
			$this->db->delete(array('username'=>$this->username));
			exit('2');
		} elseif(!empty($this->email)) {
			$this->db->delete(array('email'=>$this->email));
			exit('3');
		} else {
			exit('-1');
		}
	}
开发者ID:heqishengcai,项目名称:phpcms,代码行数:48,代码来源:index.php


示例17: move

 /**
  * move member
  */
 function move()
 {
     if (isset($_POST['dosubmit'])) {
         $uidarr = isset($_POST['userid']) ? $_POST['userid'] : showmessage(L('illegal_parameters'), HTTP_REFERER);
         $groupid = isset($_POST['groupid']) && !empty($_POST['groupid']) ? $_POST['groupid'] : showmessage(L('illegal_parameters'), HTTP_REFERER);
         $where = to_sqls($uidarr, '', 'userid');
         $this->db->update(array('groupid' => $groupid), $where);
         showmessage(L('member_move') . L('operation_success'), HTTP_REFERER, '', 'move');
     } else {
         $show_header = $show_scroll = true;
         $grouplist = getcache('grouplist');
         foreach ($grouplist as $k => $v) {
             $grouplist[$k] = $v['name'];
         }
         $ids = isset($_GET['ids']) ? explode(',', $_GET['ids']) : showmessage(L('illegal_parameters'), HTTP_REFERER);
         array_pop($ids);
         if (!empty($ids)) {
             $where = to_sqls($ids, '', 'userid');
             $userarr = $this->db->listinfo($where);
         } else {
             showmessage(L('illegal_parameters'), HTTP_REFERER, '', 'move');
         }
         include $this->admin_tpl('member_move');
     }
 }
开发者ID:zhouzhouxs,项目名称:Progect,代码行数:28,代码来源:member.php


示例18: searchContentSql

 function searchContentSql($channelID = 0, $keywords = '', $page = 0, $count = 0, $starttime = 0, $endtime = 0, $exceptChannel = 0, $uid = 0, $siteid = 1)
 {
     $channelID = intval($channelID);
     $keywords = format_bracket($keywords);
     $starttime = intval($starttime);
     $endtime = intval($endtime);
     $exceptChannel = intval($exceptChannel);
     $keywordsArr = explode(' ', $keywords);
     $normalWords = array('的', '什么');
     $keywordsSql = '';
     if ($keywordsArr) {
         foreach ($keywordsArr as $k) {
             if (strlen($k) && !in_array($k, $normalWords)) {
                 $keywordsSql .= ' OR content LIKE \'%' . $k . '%\' OR title LIKE \'%' . $k . '%\'';
             }
         }
     }
     $keywordsSql = substr($keywordsSql, 4);
     if (strlen($keywordsSql)) {
         $keywordsSql = ' AND (' . $keywordsSql . ')';
     }
     //time
     if (!$starttime && !$endtime) {
         $timeSql = '';
     } elseif ($endtime == 0) {
         $timeSql = ' AND time>' . $starttime . ' AND time<' . SYS_TIME;
     } else {
         $timeSql = ' AND time>' . $starttime . ' AND time<' . $endtime;
     }
     //
     //if (strlen($keywordsSql)){
     $start = 0;
     if ($page > 1) {
         $start = ($page - 1) * $count;
     }
     $limitSql = '';
     if ($count) {
         $limitSql .= ' LIMIT ' . $start . ',' . $count;
     }
     $channelIDSql = '';
     if ($exceptChannel) {
         $exceptChannelSql = ' AND channel_id!=' . $exceptChannel;
     }
     $uid = intval($uid);
     $uidSql = '';
     if ($uid) {
         $uidSql = ' AND uid=' . $uid;
     }
     if ($channelID) {
         $channelObj = bpBase::loadAppClass('channelObj', 'channel');
         $descentChannels = $channelObj->allDescentChannels($channelID);
         $descentsCount = count($descentChannels);
         $channelIDArr = array($channelID);
         if ($descentChannels) {
             foreach ($descentChannels as $c) {
                 array_push($channelIDArr, $c->id);
             }
         }
         $channelIDSql = ' AND ' . to_sqls($channelIDArr, '', 'channel_id');
     } else {
         $channelIDSql = '';
     }
     $article_db = M('article');
     if (!$page && !$count) {
         $sql = 'SELECT COUNT(id) FROM ' . $article_db->table_name . ' WHERE site=' . $siteid . $channelIDSql . $timeSql . $keywordsSql . $exceptChannelSql . $uidSql;
     } else {
         $sql = 'SELECT * FROM ' . $article_db->table_name . ' WHERE site=' . $siteid . $channelIDSql . $timeSql . $keywordsSql . $exceptChannelSql . $uidSql . ' ORDER BY time DESC' . $limitSql;
     }
     return $sql;
 }
开发者ID:ailingsen,项目名称:pigcms,代码行数:70,代码来源:articleObj.class.php


示例19: ignore

	/**
	 * ignore member
	 */
	function ignore() {
		if(isset($_POST['userid'])) {		
			$uidarr = isset($_POST['userid']) ? $_POST['userid'] : showmessage(L('illegal_parameters'), HTTP_REFERER);
			$where = to_sqls($uidarr, '', 'userid');
			$res = $this->db->update(array('status'=>2, 'message'=>$_POST['message']), $where);
			//发送 email通知
			if($res) {
				if($_POST['sendemail']) {
					$memberinfo = $this->db->select($where);
					pc_base::load_sys_func('mail');
					foreach ($memberinfo as $v) {
						sendmail($v['email'], L('reg_ignore'), $_POST['message']);
					}
				}
			}
			showmessage(L('ignore').L('operation_success'), HTTP_REFERER);
		} else {
			showmessage(L('operation_failure'), HTTP_REFERER);
		}
	}
开发者ID:panhongsheng,项目名称:zl_cms,代码行数:23,代码来源:member_verify.php


示例20: check_manage_info

该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP to_string函数代码示例发布时间:2022-05-23
下一篇:
PHP to_number函数代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap