本文整理汇总了PHP中paging::execSQL方法的典型用法代码示例。如果您正苦于以下问题：PHP paging::execSQL方法的具体用法？PHP paging::execSQL怎么用？PHP paging::execSQL使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类paging的用法示例。
在下文中一共展示了paging::execSQL方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: lower
}
if (isset($_POST['search']) && !empty($_POST['search'])) {
$query .= " AND lower(p.problema) like lower(('%" . noHtml($_POST['search']) . "%')) ";
}
}
}
//------------------------------------------------------------- FIM ALTERACAO --------------------------------------------------------------
$query .= " ORDER BY s.sistema, p.problema";
$resultado = mysql_query($query) or die(TRANS('ERR_QUERY') . "<br>" . $query);
$registros = mysql_num_rows($resultado);
if (isset($_GET['LIMIT'])) {
$PAGE->setLimit($_GET['LIMIT']);
}
$PAGE->setSQL($query, isset($_GET['FULL']) ? $_GET['FULL'] : 0);
if (!isset($_GET['action']) && empty($_POST['submit'])) {
$PAGE->execSQL();
//print "<TR><TD bgcolor='".BODY_COLOR."'><a href='".$_SERVER['PHP_SELF']."?action=incluir&cellStyle=true'>Incluir novo tipo de Problema</a></TD></TR>";
print "<TR><TD><input type='button' class='button' id='idBtIncluir' value='" . TRANS('BT_NEW_RECORD', '', 0) . "' onClick=\"redirect('" . $_SERVER['PHP_SELF'] . "?action=incluir&cellStyle=true');\"></TD></TR>";
print "<tr>" . "<td colspan='4'>" . "<input type='text' class='text' name='search' id='idSearch' value='" . $search . "'> ";
//------------------------------------------------------------- INICIO ALTERACAO --------------------------------------------------------------
if ($OPERADOR_AREA) {
$qryarea = "SELECT sis_id, sistema FROM sistemas WHERE sis_id = " . $_SESSION['s_area'] . " ORDER BY sistema";
} else {
$qryarea = "SELECT sis_id, sistema FROM sistemas ORDER BY sistema";
}
$execarea = mysql_query($qryarea);
print "<SELECT class='select' name='id_sistema' size='1'>";
print "<option value='-1'>" . TRANS('OCO_SEL_AREA') . "</option>";
while ($rowArea = mysql_fetch_array($execarea)) {
$isSelecionado = "";
if ($rowArea['sis_id'] == $_SESSION['id_sistema_filtro']) {