PHP DB_SourceLines::next_record示例

示例#1

文件： chguser.php 项目： BackupTheBerlios/sourcelines

                    mailuser("admin", "User parameters has changed", $message);
                }
            } else {
                $be->box_full($t->translate("Error"), $t->translate("Access denied"));
            }
            break;
        default:
            break;
    }
}
$bx->box_begin();
$bx->box_title($t->translate("Change User Parameters"));
$bx->box_body_begin();
echo "<table border=0 align=\"center\" cellspacing=0 cellpadding=3>\n";
$db->query("select * from auth_user where username='******'");
while ($db->next_record()) {
    ?>
<form method="post" action="<?php 
    $sess->pself_url();
    ?>
">
<tr valign=middle align=left>
<td align=right><?php 
    echo $t->translate("Username");
    ?>
:</td><td><?php 
    $db->p("username");
    ?>
</td></tr>
<tr>
<td align=right><?php 

示例#2

文件： selkeyword.php 项目： BackupTheBerlios/sourcelines

    $tbw->table_row_end();
    echo "</form>";
    /*----------*/
    $tbw->table_end();
    /*-----------------------------------------------------------------------*/
    $bx->box_body_end();
    $bx->box_end();
} else {
    if ($action == "delete") {
        // DELETE
        $id = rawurldecode($id);
        $solu_id = rawurldecode($solu_id);
        $db_del = new DB_SourceLines();
        $query = "SELECT * FROM tblkeyword WHERE keyword_id = '{$id}' AND solutions_id = '{$solu_id}'";
        $db_del->query($query);
        $db_del->next_record();
        /*-----------------------------------------------------------------------*/
        $bx->box_begin();
        $bx->box_title($t->translate("Delete keyword"));
        $bx->box_body_begin();
        /*-----------------------------------------------------------------------*/
        echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
        $tbw->table_begin();
        // keyword
        $tbw->table_row_begin();
        $tbw->table_body_column_begin();
        echo "<b>" . $t->translate("Keyword") . ":</b>";
        $tbw->table_body_column_next(2);
        echo $db_del->f("keyword_text");
        $tbw->table_body_column_end();
        // buttons

示例#3

文件： solbycontact.php 项目： BackupTheBerlios/sourcelines

        $conby = "Unknown";
    }
    $bx->box_title($t->translate("Contact") . ": " . $conby);
    $bx->box_body_begin();
    ?>
<table border=0 align=center cellspacing=1 cellpadding=1 width=100%>
<?php 
    echo "<tr><td><b>" . $t->translate("No") . ".</b></td><td><b>#&nbsp;" . $t->translate("Sols") . "</b></td><td><b>" . $t->translate("Name") . "</b></td><td><b>" . $t->translate("E-Mail") . "</b></td><td><b>" . $t->translate("Homepage") . "</b></td></tr>\n";
    $i = 1;
    while ($db->next_record()) {
        $solutions_contact_name = addslashes($db->f("solutions_contact_name"));
        $solutions_contact_email = $db->f("solutions_contact_email");
        $solutions_contact_url = $db->f("solutions_contact_url");
        $db2 = new DB_SourceLines();
        $db2->query("SELECT COUNT(*) FROM tblsolutions WHERE solutions_contact_name='{$solutions_contact_name}' AND solutions_contact_email='{$solutions_contact_email}' AND solutions_contact_url='{$solutions_contact_url}'");
        $db2->next_record();
        if ($db2->f("COUNT(*)")) {
            $num = "[" . sprintf("%03d", $db2->f("COUNT(*)")) . "]";
            echo "<tr><td>" . sprintf("%d", $i) . "</td>\n";
            if (empty($solutions_contact_name)) {
                echo "<td><a href=\"" . $sess->url("bycontact.php") . $sess->add_query(array("solutions_contact_name" => "", "solutions_contact_email" => "{$solutions_contact_email}", "solutions_contact_url" => "{$solutions_contact_url}")) . "\">{$num}</a></td>\n";
                echo "<td>" . $t->translate("Unknown") . "</td>\n";
            } else {
                echo "<td><a href=\"" . $sess->url("bycontact.php") . $sess->add_query(array("solutions_contact_name" => $db->f("solutions_contact_name"), "solutions_contact_email" => "{$solutions_contact_email}", "solutions_contact_url" => "{$solutions_contact_url}")) . "\">{$num}</a></td>\n";
                echo "<td>" . $db->f("solutions_contact_name") . "</td>\n";
            }
            if (!empty($solutions_contact_email)) {
                echo "<td>&lt;<a href=\"mailto:" . mailtoencode($solutions_contact_email) . "\">" . ereg_replace("\\.", " dot ", ereg_replace("@", " at ", htmlentities($solutions_contact_email))) . "</a>&gt;</td>\n";
            } else {
                echo "<td>&nbsp;</td>\n";
            }

示例#4

文件： selcomponent.php 项目： BackupTheBerlios/sourcelines

 $bx->box_begin();
 $bx->box_title($t->translate("Add a component"));
 $bx->box_body_begin();
 /*-----------------------------------------------------------------------*/
 echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
 $tbw->table_begin();
 // componenttype
 $tbw->table_row_begin();
 $tbw->table_body_column_begin();
 echo "<b>" . $t->translate("Type") . ":</b>";
 $tbw->table_body_column_next(2);
 $db_sel = new DB_SourceLines();
 $query = "SELECT * FROM tblcomponenttype ORDER BY componenttype_name";
 $db_sel->query($query);
 echo "<select name='componenttype_id' size='1'>";
 while ($db_sel->next_record()) {
     echo "<option value=" . $db_sel->f("componenttype_id") . ">" . $t->translate($db_sel->f("componenttype_name")) . "</option>";
 }
 if ($db_sel->num_rows() > 0) {
     $db_sel->seek(0);
 }
 echo "</select>";
 $tbw->table_body_column_end();
 // component_name
 $tbw->table_row_next();
 $tbw->table_body_column_begin();
 echo "<b>" . $t->translate("Name") . ":</b>";
 $tbw->table_body_column_next(2);
 echo "<input type='text' size='40' maxlength='255' name='component_name' value=''>";
 $tbw->table_body_column_end();
 // component_version