DB_SourceLines::f PHP代码示例

示例#1

0

显示文件

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

    ?>
:</td><td><input type="text" name="realname" size=20 maxlength=64 value="<?php 
    $db->p("realname");
    ?>
"></td></tr>
<tr>
<td align=right><?php 
    echo $t->translate("E-Mail");
    ?>
:</td><td><input type="text" name="email_usr" size=20 maxlength=128 value="<?php 
    $db->p("email_usr");
    ?>
"></td></tr>
<tr>
<?php 
    $time = mktimestamp($db->f("modification_usr"));
    ?>
<td align=right><?php 
    echo $t->translate("Last modified");
    ?>
:</td><td><?php 
    echo timestr($time);
    ?>
</td></tr>
<tr>
<?php 
    $time = mktimestamp($db->f("creation_usr"));
    ?>
<td align=right><?php 
    echo $t->translate("Created");
    ?>

示例#2

0

显示文件

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

require "./include/config.inc";
require "./include/lib.inc";
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n";
echo "           \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n";
echo "<rss version=\"0.91\">\n";
echo "  <channel>\n";
echo "    <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo "    <link>http:" . $sys_url . "</link>\n";
echo "    <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n";
echo "    <language>en-us</language>\n";
echo "  <image>\n";
echo "    <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo "    <url>" . $sys_url . $sys_logo_image . "</url>\n";
echo "    <link>http:" . $sys_url . "</link>\n";
echo "    <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n";
echo "    <width>66</width>\n";
echo "    <height>73</height>\n";
echo "  </image>\n";
$db = new DB_SourceLines();
$db->query("SELECT * FROM tblsolutions,auth_user WHERE tblsolutions.username = auth_user.username AND tblsolutions.solutions_name != 'no_name' ORDER BY tblsolutions.solutions_modify_date DESC limit 10");
$i = 0;
while ($db->next_record()) {
    echo "  <item>\n";
    echo "    <title>" . htmlspecialchars($db->f("solutions_name")) . "</title>\n";
    echo "    <link>http:" . $sys_url . "solutions.php?solu_id=" . $db->f("solutions_id") . "</link>\n";
    echo "  </item>\n";
    $i++;
}
echo "  </channel>\n";
echo "</rss>\n";

示例#3

0

显示文件

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

    }
    $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";
            }
            if (!empty($solutions_contact_url)) {

示例#4

0

显示文件

文件： selkeyword.php 项目： BackupTheBerlios/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
 $tbw->table_row_next();
 $tbw->table_body_column("&nbsp;");
 $tbw->table_body_column_begin();
 echo "<input type='hidden' name='action' value='db_delete'>";
 echo "<input type='hidden' name='id' value='{$id}'>";
 echo "<input type='hidden' name='solu_id' value='{$solu_id}'>";
 echo "<input type='submit' value='" . $t->translate("Delete") . "'>";
 $tbw->table_body_column_end();
 echo "</form>";
 /*==========*/
 echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
 $tbw->table_body_column_begin();
 echo "<input type='hidden' name='action' value=''>";

示例#5

0

显示文件

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

 $query = "SELECT * FROM tbldocument WHERE document_id = '{$id}' AND solutions_id = '{$solu_id}'";
 $db_del->query($query);
 $db_del->next_record();
 /*-----------------------------------------------------------------------*/
 $bx->box_begin();
 $bx->box_title($t->translate("Delete document"));
 $bx->box_body_begin();
 /*-----------------------------------------------------------------------*/
 echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
 $tbw->table_begin();
 // title
 $tbw->table_row_begin();
 $tbw->table_body_column_begin();
 echo "<b>" . $t->translate("Title") . ":</b>";
 $tbw->table_body_column_next(2);
 echo $db_del->f("document_title");
 $tbw->table_body_column_end();
 // buttons
 $tbw->table_row_next();
 $tbw->table_body_column("&nbsp;");
 $tbw->table_body_column_begin();
 echo "<input type='hidden' name='action' value='db_delete'>";
 echo "<input type='hidden' name='id' value='{$id}'>";
 echo "<input type='hidden' name='solu_id' value='{$solu_id}'>";
 echo "<input type='hidden' name='filename' value='" . $db_del->f("document_filename") . "'>";
 echo "<input type='submit' value='" . $t->translate("Delete") . "'>";
 $tbw->table_body_column_end();
 echo "</form>";
 /*==========*/
 echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
 $tbw->table_body_column_begin();

示例#6

0

显示文件

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

</head>
<body bgcolor="<?php 
echo $th_body_bgcolor;
?>
" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" marginheight="0" marginwidth="0">

<!-- content -->

<p>&nbsp;
<?php 
$bx->box_begin();
$bx->box_body_begin();
echo "<a href=\"{$sys_url_title}\" target=\"_content\"><img src=\"{$sys_logo_small_image}\" border=\"0\" height=\"{$sys_logo_small_heigth}\" width=\"{$sys_logo_small_width}\" ALT=\"{$sys_logo_small_alt}\"></a>";
$bx->box_body_end();
$bx->box_end();
$bx->box_begin();
$bx->box_title("<font size=\"1\">" . $t->translate("Recent Solutions") . "</font>");
$db->query("SELECT * FROM tblsolutions WHERE tblsolutions.solutions_name != 'no_name' ORDER BY solutions_modify_date DESC limit 20");
$bx->box_body_begin();
while ($db->next_record()) {
    echo "<div class=newsind>&#149;&nbsp;";
    echo "<a href=\"" . $sys_url . "solutions.php?solu_id=" . $db->f("solutions_id") . "\" target=\"_content\">" . $db->f("solutions_name") . "</a></div>\n";
}
echo "<p><b><font size=\"1\"><a href=\"" . $sys_url . "\" target=\"_content\">more...</a></font></b>\n";
$bx->box_body_end();
$bx->box_end();
?>
</body>
</html>
<?php 
@page_close();

示例#7

0

显示文件

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

 $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
 $tbw->table_row_next();

示例#8

0

显示文件

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

 $bx->box_title($t->translate("Add a language"));
 $bx->box_body_begin();
 /*-----------------------------------------------------------------------*/
 echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
 $tbw->table_begin();
 // language
 $tbw->table_row_begin();
 $tbw->table_body_column_begin();
 echo "<b>" . $t->translate("Language") . ":</b>";
 $tbw->table_body_column_next(2);
 $db_sel = new DB_SourceLines();
 $query = "SELECT * FROM tbllanguage ORDER BY language_name";
 $db_sel->query($query);
 echo "<select name='language_id' size='1'>\n";
 while ($db_sel->next_record()) {
     echo "<option value=" . $db_sel->f("language_id") . ">" . $t->translate($db_sel->f("language_name")) . "</option>\n";
 }
 echo "</select>";
 $tbw->table_body_column_end();
 // buttons
 $tbw->table_row_next();
 $tbw->table_body_column("&nbsp;");
 $tbw->table_body_column_begin();
 echo "<input type='hidden' name='action' value='db_add'>";
 echo "<input type='hidden' name='solu_id' value='{$solu_id}'>";
 echo "<input type='submit' value='" . $t->translate("Add") . "'>";
 $tbw->table_body_column_end();
 echo "</form>";
 /*------------*/
 echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
 $tbw->table_body_column_begin();

PHP DB_SourceLines::f示例