本文整理汇总了PHP中getorders函数的典型用法代码示例。如果您正苦于以下问题:PHP getorders函数的具体用法?PHP getorders怎么用?PHP getorders使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getorders函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getwheres
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 'v.');
foreach ($likekeys as $k) {
$_GET[$k] = dhtmlspecialchars($_GET[$k]);
}
$mpurl .= '&' . implode('&', $results['urls']);
$wherearr = $results['wherearr'];
if ($_GET['dateline1']) {
$wherearr[] = "v.dateline >= '" . strtotime($_GET['dateline1']) . "'";
$mpurl .= '&dateline1=' . $_GET['dateline1'];
}
if ($_GET['dateline2']) {
$wherearr[] = "v.dateline <= '" . strtotime($_GET['dateline2']) . "'";
$mpurl .= '&dateline2=' . $_GET['dateline2'];
}
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$orders = getorders(array('dateline', 'uid'), 'dateline', 'v.');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$orders = in_array($_G['orderby'], array('dateline', 'uid')) ? $_G['orderby'] : 'dateline';
$ordersc = in_array(strtolower($_GET['ordersc']), array('asc', 'desc')) ? $_GET['ordersc'] : 'desc';
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(10, 20, 50, 100))) {
$perpage = 10;
}
$perpages = array($perpage => ' selected');
$mpurl .= '&perpage=' . $perpage;
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
示例2: array
} else {
//处理搜索
if ($_GET['expiration']) {
$val = $_GET['expiration'] == 1 ? 1 : 2;
$_GET['expiration' . $val] = $_SGLOBAL['timestamp'];
}
$intkeys = array('uid', 'noreply', 'pid', 'sex');
$strkeys = array('username');
$randkeys = array(array('sstrtotime', 'dateline'), array('intval', 'voternum'), array('intval', 'replynum'), array('intval', 'percredit'), array('intval', 'expiration'), array('intval', 'hot'));
$likekeys = array('subject');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, '');
$wherearr = $results['wherearr'];
$mpurl .= '&' . implode('&', $results['urls']);
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
//排序
$orders = getorders(array('dateline', 'viewnum', 'replynum', 'percredit', 'hot'), 'pid', '');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100, 1000))) {
$perpage = 20;
}
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
示例3: cpmessage
} else {
cpmessage('choose_to_delete_events', $_POST['mpurl']);
}
}
$mpurl = 'admincp.php?ac=doing';
//处理搜索
$intkeys = array('uid');
$strkeys = array('ip', 'username');
$randkeys = array(array('sstrtotime', 'dateline'));
$likekeys = array('message');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$mpurl .= '&' . implode('&', $results['urls']);
//排序
$orders = getorders(array('dateline', 'lastpost'), 'doid');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100, 1000))) {
$perpage = 20;
}
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
示例4: cpmessage
} else {
cpmessage('please_delete_the_correct_choice_to_share', $_POST['mpurl']);
}
}
$mpurl = 'admincp.php?ac=share';
//处理搜索
$intkeys = array('uid', 'sid');
$strkeys = array('username', 'type');
$randkeys = array(array('sstrtotime', 'dateline'), array('intval', 'hot'));
$likekeys = array();
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$mpurl .= '&' . implode('&', $results['urls']);
//排序
$orders = getorders(array('dateline', 'hot'), 'sid');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100, 1000))) {
$perpage = 20;
}
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
示例5: array
}
}
}
if (empty($_GET['op'])) {
$mpurl = 'admincp.php?ac=mtag';
//处理搜索
$intkeys = array('close', 'fieldid', 'joinperm', 'viewperm', 'tagid');
$strkeys = array();
$randkeys = array(array('intval', 'membernum'));
$likekeys = array('tagname');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$mpurl .= '&' . implode('&', $results['urls']);
//排序
$orders = getorders(array('membernum'), 'tagid DESC');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$joinperms = array($_GET['joinperm'] => ' selected');
$viewperms = array($_GET['viewperm'] => ' selected');
//显示分页
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100))) {
$perpage = 20;
}
$mpurl .= '&perpage=' . $perpage;
$perpages = array($perpage => ' selected');
示例6: empty
$member['flagstr'] = empty($member['flag']) ? '<a href="' . CPURL . '?action=member&op=delete&uid=' . $member['uid'] . '" onclick="return confirm(\'' . $alang['confirm_the_deletion_user_date'] . '\');">' . $alang['delete_user_date'] . '</a>' : $alang['users_protection_was_not_deleted'];
}
$member['flagcheck'] = empty($member['flag']) ? array(' checked', '') : array('', ' checked');
} else {
$mpurl = CPURL . '?action=' . $action;
//处理搜索
$intkeys = array('uid', 'groupid');
$strkeys = array('username');
$randkeys = array(array('sstrtotime', 'dateline'), array('sstrtotime', 'updatetime'));
$likekeys = array();
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 's.');
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$mpurl .= '&' . implode('&', $results['urls']);
//排序
$orders = getorders(array('dateline', 'updatetime'), '', 's.');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
//显示分页
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100))) {
$perpage = 20;
}
$mpurl .= '&perpage=' . $perpage;
$perpages = array($perpage => ' selected');
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
示例7: array
$intkeys = array('topicid', 'uid', 'closed');
$strkeys = array();
$randkeys = array();
$likekeys = array('title', 'username');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
foreach ($likekeys as $k) {
$_GET[$k] = htmlspecialchars(stripslashes($_GET[$k]));
}
$wherearr = $results['wherearr'];
$mpurl = ADMINSCRIPT . '?action=topic';
$mpurl .= '&' . implode('&', $results['urls']);
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
if (strlen($_GET['closed'])) {
$statusarr[$_GET['closed']] = ' selected';
}
$orders = getorders(array('dateline'), 'topicid');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(10, 20, 50, 100))) {
$perpage = 10;
}
$searchlang = array();
$keys = array('search', 'likesupport', 'resultsort', 'defaultsort', 'orderdesc', 'orderasc', 'perpage_10', 'perpage_20', 'perpage_50', 'perpage_100', 'topic_dateline', 'topic_id', 'topic_title', 'topic_uid', 'topic_username', 'topic_closed', 'nolimit', 'no', 'yes');
foreach ($keys as $key) {
$searchlang[$key] = cplang($key);
}
示例8: getwheres
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, $pre);
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$mpurl .= '&' . implode('&', $results['urls']);
if (isset($_GET['namestatus']) && $_GET['namestatus'] == '0') {
$wheresql .= " AND s.name!=''";
}
//激活
$actives = array($_GET['tab'] => ' class="active"');
if (!isset($_GET['tab'])) {
$actives = array('all' => ' class="active"');
} else {
$mpurl .= '&tab=' . $_GET['tab'];
}
//排序
$orders = getorders(array('dateline', 'updatetime', 'friendnum', 'credit', 'viewnum', 'experience'), 'uid', $pre);
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
//用户组
$usergroups = array();
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('usergroup'));
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
$usergroups[$value['gid']] = $value;
}
//显示分页
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100))) {
示例9: array
//激活
if (strlen($_GET['grade']) && $_GET['grade'] == 0) {
$actives = array('grade0' => ' class="active"');
} elseif ($_GET['grade'] == -1) {
$actives = array('grade_1' => ' class="active"');
} elseif ($_GET['grade'] == 1) {
$actives = array('grade1' => ' class="active"');
} elseif ($_GET['grade'] == -2) {
$actives = array('grade_2' => ' class="active"');
} elseif ($_GET['grade'] == 2) {
$actives = array('grade2' => ' class="active"');
} else {
$actives = array('all' => ' class="active"');
}
//排序
$orders = getorders(array('dateline', 'starttime', 'membernum', 'hot'), 'eventid');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
//显示分页
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100, 1000))) {
$perpage = 20;
}
$mpurl .= '&perpage=' . $perpage;
$perpages = array($perpage => ' selected');
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
示例10: array
$likekeys = array('subject');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 'b.');
$wherearr = $results['wherearr'];
$mpurl .= '&' . implode('&', $results['urls']);
//限制条件2
$intkeys = array();
$strkeys = array('postip');
$randkeys = array();
$likekeys = array('message');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 'bf.');
$wherearr2 = $results['wherearr'];
$mpurl .= '&' . implode('&', $results['urls']);
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$wheresql2 = empty($wherearr2) ? '' : implode(' AND ', $wherearr2);
//排序
$orders = getorders(array('dateline', 'viewnum', 'replynum'), 'blogid DESC', 'b.');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100, 1000))) {
$perpage = 20;
}
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
示例11: array
if(empty($_GET['op'])) {
$mpurl = 'admincp.php?ac=mtag';
//处理搜索
$intkeys = array('close', 'recommend', 'fieldid', 'joinperm', 'viewperm', 'threadperm', 'postperm', 'tagid');
$strkeys = array();
$randkeys = array(array('intval','membernum'), array('intval','threadnum'), array('intval','postnum'));
$likekeys = array('tagname');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr)?'1':implode(' AND ', $wherearr);
$mpurl .= '&'.implode('&', $results['urls']);
//排序
$orders = getorders(array('membernum','threadnum','postnum'), 'tagid');
$ordersql = $orders['sql'];
if($orders['urls']) $mpurl .= '&'.implode('&', $orders['urls']);
$orderby = array($_GET['orderby']=>' selected');
$ordersc = array($_GET['ordersc']=>' selected');
$joinperms = array($_GET['joinperm']=>' selected');
$viewperms = array($_GET['viewperm']=>' selected');
$threadperms = array($_GET['threadperm']=>' selected');
$postperms = array($_GET['postperm']=>' selected');
//显示分页
$perpage = empty($_GET['perpage'])?0:intval($_GET['perpage']);
if(!in_array($perpage, array(20,50,100))) $perpage = 20;
$mpurl .= '&perpage='.$perpage;
$perpages = array($perpage => ' selected');
示例12: array
}
$mpurl = 'admincp.php?ac=' . $ac;
//处理搜索
$intkeys = array('uid', 'groupid', 'namestatus', 'avatar');
$strkeys = array('username');
$randkeys = array(array('sstrtotime', 'dateline'), array('sstrtotime', 'updatetime'), array('intval', 'credit'));
$likekeys = array('name');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 's.');
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$mpurl .= '&' . implode('&', $results['urls']);
if (isset($_GET['namestatus']) && $_GET['namestatus'] == '0') {
$wheresql .= " AND s.name!=''";
}
//排序
$orders = getorders(array('dateline', 'updatetime', 'friendnum', 'credit', 'viewnum'), '', 's.');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
//显示分页
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100))) {
$perpage = 20;
}
$mpurl .= '&perpage=' . $perpage;
$perpages = array($perpage => ' selected');
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
示例13: cplang
$_GET = $_GET + $_POST;
$searchctrl = '<span style="float: right; padding-right: 40px;">' . '<a href="javascript:;" onclick="$(\'tb_search\').style.display=\'\';$(\'a_search_show\').style.display=\'none\';$(\'a_search_hide\').style.display=\'\';" id="a_search_show">' . cplang('show_search') . '</a>' . '<a href="javascript:;" onclick="$(\'tb_search\').style.display=\'none\';$(\'a_search_show\').style.display=\'\';$(\'a_search_hide\').style.display=\'none\';" id="a_search_hide" style="display:none">' . cplang('hide_search') . '</a>' . '</span>';
showsubmenu('blockstyle', array(array('list', 'blockstyle', 1), array('add', 'blockstyle&operation=add', 0)), $searchctrl);
$mpurl = ADMINSCRIPT . '?action=blockstyle';
$intkeys = array('styleid');
$strkeys = array('blockclass');
$randkeys = array();
$likekeys = array('name', 'template');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
foreach ($likekeys as $k) {
$_GET[$k] = htmlspecialchars(stripslashes($_GET[$k]));
}
$wherearr = $results['wherearr'];
$mpurl .= '&' . implode('&', $results['urls']);
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$orders = getorders(array('blockclass'), 'styleid');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(10, 20, 50, 100))) {
$perpage = 20;
}
$perpages = array($perpage => ' selected');
$mpurl .= '&perpage=' . $perpage;
$searchlang = array();
$keys = array('search', 'likesupport', 'resultsort', 'defaultsort', 'orderdesc', 'orderasc', 'perpage_10', 'perpage_20', 'perpage_50', 'perpage_100', 'blockstyle_id', 'blockstyle_name', 'blockstyle_blockclass', 'blockstyle_template');
foreach ($keys as $key) {
示例14: getwheres
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 'b.');
$wherearr = $results['wherearr'];
$selectfid = array($_GET['fid'] => 'selected="selected"');
$mpurl .= '&' . implode('&', $results['urls']);
//限制条件2
$intkeys = array();
$strkeys = array('useip');
$randkeys = array();
$likekeys = array('message');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys, 'bf.');
$wherearr2 = $results['wherearr'];
$mpurl .= '&' . implode('&', $results['urls']);
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$wheresql2 = empty($wherearr2) ? '' : implode(' AND ', $wherearr2);
//排序
$orders = getorders(array('dateline', 'views', 'replies'), 'tid DESC', 'b.');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => 'selected="selected"');
$ordersc = array($_GET['ordersc'] => 'selected="selected"');
$perpage = empty($_GET['perpage']) ? 20 : intval($_GET['perpage']);
if (!in_array($perpage, array(20, 50, 100, 1000))) {
$perpage = 20;
}
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
示例15: intval
if (!empty($_GET['catid'])) {
$catid = intval($_GET['catid']);
$mpurl .= '&catid=' . $catid;
$catids = category_get_childids('portal', $_GET['catid']);
$catids[] = $_GET['catid'];
$wherearr[] = 'catid IN (' . dimplode($catids) . ')';
}
if (!empty($_GET['tag'])) {
$tag = article_make_tag($_GET['tag']);
$wherearr[] = "(tag & '{$tag}' = '{$tag}')";
foreach ($_GET['tag'] as $k => $v) {
$mpurl .= "&tag[{$k}]={$v}";
}
}
$wheresql = empty($wherearr) ? '1' : implode(' AND ', $wherearr);
$orders = getorders(array('dateline'), 'aid');
$ordersql = $orders['sql'];
if ($orders['urls']) {
$mpurl .= '&' . implode('&', $orders['urls']);
}
$orderby = array($_GET['orderby'] => ' selected');
$ordersc = array($_GET['ordersc'] => ' selected');
$perpage = empty($_GET['perpage']) ? 0 : intval($_GET['perpage']);
if (!in_array($perpage, array(10, 20, 50, 100))) {
$perpage = 10;
}
$categoryselect = category_showselect('portal', 'catid', true, $_GET['catid']);
$searchlang = array();
$keys = array('search', 'likesupport', 'resultsort', 'defaultsort', 'orderdesc', 'orderasc', 'perpage_10', 'perpage_20', 'perpage_50', 'perpage_100', 'article_dateline', 'article_id', 'article_title', 'article_uid', 'article_username', 'article_category', 'article_tag');
foreach ($keys as $key) {
$searchlang[$key] = cplang($key);