本文整理汇总了PHP中global_common::endsWith方法的典型用法代码示例。如果您正苦于以下问题:PHP global_common::endsWith方法的具体用法?PHP global_common::endsWith怎么用?PHP global_common::endsWith使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类global_common
的用法示例。
在下文中一共展示了global_common::endsWith方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getSQLSelectByTableName
/**
* get sql select articles from multi tables
*
* @param mixed $arrSummary This is a description
* @param mixed $intPage This is a description
* @param mixed $topRow top of article, 0: get all
* @param mixed $selectField This is a description
* @param mixed $whereClause This is a description
* @param mixed $orderBy This is a description
* @return mixed This is the return value description
*
*/
private function getSQLSelectByTableName($arrSummary, $intPage, $topRow, $selectField, $whereClause, $orderBy)
{
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy;
}
$listArticleID = '';
foreach ($arrSummary as $item) {
$listArticleID = $item[global_mapping::SubContents] . $listArticleID;
}
$arrDocInTable = global_common::getListTableName($listArticleID, $intPage, Model_Article::NUM_PER_PAGE, global_common::SEPARATE_BY_MONTH);
$strSQL = '';
$condition = '';
foreach ($arrDocInTable as $key => $iDoc) {
//print_r($iDoc);
//check endWith ',' and then remove it
if (global_common::endsWith($iDoc, ',')) {
$strDocInTable = global_common::cutLast($iDoc, 1);
}
$strTableName = Model_Article::TBL_SL_ARTICLE . '_' . $key;
if ($whereClause) {
$condition = 'WHERE (' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') and `' . global_mapping::ArticleID . '` IN (' . $strDocInTable . ') and ' . $whereClause;
} else {
$condition = 'WHERE (' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') and `' . global_mapping::ArticleID . '` IN (' . $strDocInTable . ')';
}
if ($topRow > 0) {
$strSQL .= "(" . global_common::prepareQuery(global_common::SQL_SELECT_FREE_LIMIT, array($selectField, $strTableName, $condition . $orderBy, 0, $topRow)) . " ) UNION ALL ";
} else {
$strSQL .= "(" . global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, $strTableName, $condition . $orderBy)) . " ) UNION ALL ";
}
}
//xóa bỏ đoạn text UNION ALL cuối chuỗi $strSQL
$strSQL = global_common::cutLast($strSQL, strlen('UNION ALL '));
//echo $strSQL;
return $strSQL;
}
示例2: getCommentByArticle
public function getCommentByArticle(&$intPage, &$total, $articleID, $selectField = '*', $whereClause = '', $orderBy = '')
{
$arrSummary = global_common::getContentIDs($this->_objConnection, $intPage, $articleID, global_common::COMMENT_TYPE);
if ($arrSummary) {
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy;
}
$listCommentID = '';
foreach ($arrSummary as $item) {
$listCommentID = $item[global_mapping::SubContents] . $listCommentID;
}
$IDList = global_common::splitString($listCommentID);
$total = count($IDList);
$arrDocInTable = global_common::getListTableName($listCommentID, $intPage, Model_Comment::NUM_PER_PAGE, global_common::SEPARATE_BY_MONTH);
$strSQL = '';
$condition = '';
foreach ($arrDocInTable as $key => $iDoc) {
//check endWith ',' and then remove it
if (global_common::endsWith($iDoc, ',')) {
$strDocInTable = global_common::cutLast($iDoc, 1);
}
$strTableName = Model_Comment::TBL_SL_COMMENT . '_' . $key;
if ($whereClause) {
$condition = 'WHERE (' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') and `' . global_mapping::CommentID . '` IN (' . $strDocInTable . ') and ' . $whereClause;
} else {
$condition = 'WHERE (' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') and `' . global_mapping::CommentID . '` IN (' . $strDocInTable . ')';
}
$strSQL .= "(" . global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, $strTableName, $condition . $orderBy)) . " ) UNION ALL ";
}
//xóa bỏ đoạn text UNION ALL cuối chuỗi $strSQL
$strSQL = global_common::cutLast($strSQL, strlen('UNION ALL '));
$arrResult = $this->_objConnection->selectCommand($strSQL);
$arrResult = global_common::mergeUserInfo($arrResult);
//print_r($arrResult);
return $arrResult;
}
return null;
}