PHP Query1 Examples

Example #1

File: nextpage.php Project: laiello/ebpls

        include 'includes/asslinks.php';
    } elseif ($itemID_ == 2212) {
        include 'includes/paylinks.php';
    } elseif ($itemID_ == 3212) {
        include 'includes/rellinks.php';
    } elseif ($itemID_ == 5212) {
        include 'includes/applinks.php';
    } else {
        if ($selMode == ebpls_nbusiness) {
            include 'includes/eNature-inc.php';
        }
    }
}
//end while
// Figure out the total number of results in DB:
$total_results = Result($dbtype, Query1($dbtype, $dbLink, $cntsql), 0);
// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);
// Build Page Number Hyperlinks
?>
<!--<table border=0 width=100%>
	<tr><td>-->
		<?php 
echo "<div align=left>&nbsp;<br />";
// Build Previous Link
if ($selMode == 'ebpls_nbusiness') {
    if ($page > 1) {
        $prev = $page - 1;
        echo "<a href={$PHP_SELF}?part=4&class_type=Preference&pref_type=Business&selMode=ebpls_nbusiness&action_={$action_}&page={$prev}&ascdesc1={$ascdesc1}&reftype={$reftype}&searcheenat={$searcheenat}><< Prev</a>&nbsp;";
    }
    for ($i = 1; $i <= $total_pages; $i++) {

Example #2

File: ebpls1219.php Project: laiello/ebpls

    $nextr = $pager + 1;
    echo "<a href={$PHP_SELF}?part=4&class_type=Preference&permit=others&selMode={$selMode}&action_=8&itemEvent=1&data_item=0&page={$nextr}&ascdesc1={$ascdesc1}>Next</a>&nbsp;";
    echo "<a href={$PHP_SELF}?part=4&class_type=Preference&permit=others&selMode={$selMode}&action_=8&itemEvent=1&data_item=0&page={$total_pagesr}&ascdesc1={$ascdesc1}>&gt;&gt;</a>";
}
echo "</td></tr>";
print "<table border=0 cellspacing=0 cellpadding=1 align=center width=100%>\n";
//print "<td class=bold bgcolor='#E6FFE6'>Fee ID</td>\n";
print "<td class=hdr>&nbsp;No.</td>\n";
print "<td class=hdr><a href='index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0&watfld=fee_desc&feet={$permit_type}&orderbyasde={$orderbyasde}&ordervalue=desc'>Fee Description</a></td>\n";
print "<td class=hdr><a href='index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0&watfld=fee_amount&feet={$permit_type}&orderbyasde={$orderbyasde}&ordervalue=amou'>Fee Amount</a></td>\n";
print "<td class=hdr><a href='index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0&watfld=permit_type&feet={$permit_type}&orderbyasde={$orderbyasde}&ordervalue=type'>Transaction Type</a></td>\n";
print "<td class=hdr>Action</td>\n";
$cmd = "Edit";
$cmd1 = "Delete";
//populate table
$resultr = Query1($dbtype, $dbLink, $searchsqlr);
require 'setup/setting.php';
$max_resultsr = $thIntPageLimit;
$pagemulti = $page;
if ($pagemulti == '') {
    $pagemulti = 1;
}
$norow = $pagemulti * $max_resultsr - $max_resultsr;
while ($get_info = FetchArray($dbtype, $resultr)) {
    $norow++;
    if ($get_info[active] == 1) {
        $actag = 'Delete';
        $com1 = 'deact';
    } else {
        $actag = 'Delete';
        $com1 = 'act';