PHP solshow примеры использования

Пример #1

Файл: advsearch.php Проект: BackupTheBerlios/sourcelines

        break;
    case "Date":
        $order = "solutions_modify_date DESC, solutions_id DESC";
        break;
    default:
        $order = "solutions_modify_date DESC, solutions_id DESC";
        break;
}
$limit = $cnt . "," . $config_show_solsperpage;
$sort = $t->translate("sorted by") . ": " . "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Date")) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Name")) . "\">" . $t->translate("Name") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Contact")) . "\">" . $t->translate("Contact") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Branch")) . "\">" . $t->translate("Branch") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Category")) . "\">" . $t->translate("Category") . "</a>\n";
$bs->box_strip($sort);
$nav = "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("cnt" => $prev_cnt, "by" => $by)) . "\">&lt;&nbsp;" . $t->translate("previous") . " {$config_show_solsperpage} " . $t->translate("Solutions") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Date")) . "\">" . $t->translate("Top") . "</a>";
if ($cnt > 0) {
    $nav .= " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("cnt" => $next_cnt, "by" => $by)) . "\">" . $t->translate("next") . " {$config_show_solsperpage}&nbsp;" . $t->translate("Solutions") . "&nbsp;&gt;</a>";
} else {
    $nav .= " | " . $t->translate("next") . " {$config_show_solsperpage}&nbsp;" . $t->translate("Solutions") . "&nbsp;&gt;";
}
$bs->box_strip($nav);
$query = "SELECT {$columns} FROM {$tables} WHERE {$where} ORDER BY {$order} LIMIT {$limit}";
$db->query($query);
while ($db->next_record()) {
    solshow($db);
}
$bs->box_strip($nav);
$bs->box_strip($sort);
?>
<!-- end content -->

<?php 
require "footer.inc";
page_close();

Пример #2

Файл: solutions.php Проект: BackupTheBerlios/sourcebiz

<?php 
if (!isset($cnt)) {
    $cnt = 0;
}
$next_cnt = $cnt + $config_showfull_solperpage;
if ($cnt >= $config_showfull_solperpage) {
    $prev_cnt = $cnt - $config_showfull_solperpage;
} else {
    $prev_cnt = 0;
}
$query = solquery(0);
$db->query($query);
solsort($db, 0);
if ($db->num_rows() > 0) {
    while ($db->next_record()) {
        solshow($db, admin($db));
    }
    solnav($db, 0);
} else {
    $be->box_full($t->translate("Attention!"), $t->translate("No more Solution exist") . ".");
}
?>
</td><td width=20%>
<?php 
// Recent Solutions at the right column
solidx($config_showshort_solperpage);
?>
</td></tr>
</table>
<!-- end content -->