本文整理匯總了PHP中error::createInvalidOrderbyError方法的典型用法代碼示例。如果您正苦於以下問題：PHP error::createInvalidOrderbyError方法的具體用法？PHP error::createInvalidOrderbyError怎麽用？PHP error::createInvalidOrderbyError使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類error的用法示例。
在下文中一共展示了error::createInvalidOrderbyError方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: connectionOrderString
/**
* Create the SQL ORDER and LIMIT BY clause for connections
*
* @param integer $start start row
* @param integer $max max number of rows to return
* @param string $o order by column
* @param string $s sort order (ASC or DESC)
* @return string
*/
function connectionOrderString($o, $s)
{
global $CFG, $HUB_FLM, $HUB_SQL;
//check order by param is valid
switch ($o) {
case "date":
$orderby = "t.CreationDate";
break;
case "moddate":
$orderby = "t.ModificationDate";
break;
case "vote":
$orderby = "vote";
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidOrderbyError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
//check sort param is valid
switch ($s) {
case "ASC":
$sort = $HUB_SQL->ASC;
break;
case "DESC":
$sort = $HUB_SQL->DESC;
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidSortError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
if ($o == 'vote') {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort . ", weight " . $HUB_SQL->DESC . ", CreationDate " . $HUB_SQL->DESC;
} else {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort;
}
return $str;
}示例2: connectionOrderString
/**
* Create the SQL ORDER and LIMIT BY clause for connections
*
* @param integer $start start row
* @param integer $max max number of rows to return
* @param string $o order by column
* @param string $s sort order (ASC or DESC)
* @return string
*/
function connectionOrderString($o, $s)
{
global $CFG, $HUB_FLM, $HUB_SQL;
//check order by param is valid
switch ($o) {
case "date":
$orderby = "t.CreationDate";
break;
case "moddate":
$orderby = "t.ModificationDate";
break;
case "vote":
$orderby = "vote";
break;
case "ideavote":
$orderby = "vote";
break;
case "fromname":
$orderby = "t.FromLabel";
break;
case "toname":
$orderby = "t.ToLabel";
break;
case "random":
//MB: This does not scale and should be replaced eventually.
$day = date('j', time());
$hour = date('G', time());
$orderby = "RAND(" . $day . $hour . ")";
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidOrderbyError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
//check sort param is valid
switch ($s) {
case "ASC":
$sort = $HUB_SQL->ASC;
break;
case "DESC":
$sort = $HUB_SQL->DESC;
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidSortError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
if ($o == 'ideavote') {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort . ", weight " . $HUB_SQL->DESC . ", kids " . $HUB_SQL->DESC . ", kidsweight " . $HUB_SQL->DESC;
} else {
if ($o == 'vote') {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort . ", weight " . $HUB_SQL->DESC . ", CreationDate " . $HUB_SQL->DESC;
} else {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort;
}
}
return $str;
}