PHP pulldown示例

示例#1

文件： usage-summary.php 项目： Norky/PBS-tools

            echo "</TR>\n";
            ob_flush();
            flush();
        }
        echo "</TABLE>\n";
        if (isset($_POST['xls'])) {
            $xlsresult = db_query($db, $sql);
            $columns = array("package", "jobcount", "cpuhours", "users", "groups");
            result_as_xls($xlsresult, $columns, $_POST['system'] . "-software_usage-" . $_POST['start_date'] . "-" . $_POST['end_date']);
        }
        if (isset($_POST['ods'])) {
            $odsresult = db_query($db, $sql);
            $columns = array("package", "jobcount", "cpuhours", "users", "groups");
            result_as_ods($odsresult, $columns, $_POST['system'] . "-software_usage-" . $_POST['start_date'] . "-" . $_POST['end_date']);
        }
    }
    db_disconnect($db);
    bookmarkable_url();
} else {
    begin_form("usage-summary.php");
    system_chooser();
    date_fields();
    $orders = array("jobcount", "cpuhours", "users", "groups");
    checkboxes_from_array("Supplemental reports", array("institution", "software"));
    $defaultorder = "cpuhours";
    pulldown("order", "Order results by", $orders, $defaultorder);
    checkbox("Generate Excel files for supplemental reports", "xls");
    checkbox("Generate ODF files for supplemental reports", "ods");
    end_form();
}
page_footer();

示例#2

文件： active-users.php 项目： Norky/PBS-tools

$keys = array_keys($_POST);
if (isset($_POST['system'])) {
    $db = db_connect();
    $sql = "SELECT username, groupname, COUNT(jobid) AS jobcount, SUM(nproc*TIME_TO_SEC(walltime))/3600 AS cpuhrs FROM Jobs WHERE system LIKE '" . $_POST['system'] . "' AND ( " . dateselect("submit", $_POST['start_date'], $_POST['end_date']) . " ) GROUP BY username ORDER BY " . $_POST['order'] . " DESC LIMIT " . $_POST['limit'];
    #    echo "<PRE>".$sql."</PRE>\n";
    $result = db_query($db, $sql);
    echo "<TABLE border=\"1\">\n";
    echo "<TR><TH>user</TH><TH>group</TH><TH>job count</TH><TH>CPU-hours</TH></TR>\n";
    while ($result->fetchInto($row)) {
        echo "<TR>";
        $rkeys = array_keys($row);
        foreach ($rkeys as $key) {
            $data[$key] = array_shift($row);
            echo "<TD align=\"right\"><PRE>" . htmlspecialchars($data[$key]) . "</PRE></TD>";
        }
        echo "</TR>\n";
    }
    echo "</TABLE>\n";
    db_disconnect($db);
    bookmarkable_url();
} else {
    begin_form("active-users.php");
    system_chooser();
    date_fields();
    $choices = array("cpuhrs", "jobcount");
    $defaultchoice = "cpuhrs";
    pulldown("order", "Order by", $choices, $defaultchoice);
    textfield("limit", "Max shown", "10", 4);
    end_form();
}
page_footer();

示例#3

文件： metaform.php 项目： JoshuaGrams/wfpl

function preview()
{
    tem_load('code/wfpl/metaform/preview.html');
    tem_set('form_name', $GLOBALS['form_name']);
    tem_set('fields', $_REQUEST['fields']);
    $preview_tem = new tem();
    $preview_tem->load_str(make_html(false));
    if ($GLOBALS['opt_db'] == 'Yes') {
        $preview_tem->show('new_msg');
    }
    $fields = get_fields();
    foreach ($fields as $field) {
        list($name, $type, $input, $format, $sql) = $field;
        if ($type == 'pulldown') {
            pulldown($name, array('option 1', 'option 2', 'option 3'));
        }
    }
    $preview = $preview_tem->run();
    unset($preview_tem);
    $preview = ereg_replace('type="submit"', 'type="submit" disabled="disabled"', $preview);
    tem_set('preview', $preview);
    tem_show('hiddens');
    set_form_action();
    tem_output();
}

示例#4

文件： encode.php 项目： JoshuaGrams/wfpl

function enc_provinces($province)
{
    return enc_options(pulldown($province, $GLOBALS['wfpl_provinces_assoc']));
}

示例#5

文件： DBOS.class.php 项目： jonah/ActiveCoreDBOS

 function formSelect($p, $opts = false)
 {
     $fname = $this->getFname($p[field]);
     $this->debug = false;
     if (is_array($opts)) {
         extract($opts);
     } else {
         unset($opts);
     }
     if ($this->debug) {
         da($opts);
     }
     if (!$opts[required]) {
         if (!$choose) {
             $choose = "Choose...";
         }
     } elseif (!$choose) {
         $choose = false;
     }
     $this->fieldHeader($p, $opts);
     pulldown($p[rel]['foreign_table'], array("id_field" => $p[rel][foreign_field], "choose" => $choose, "fname" => $fname, "default" => $this->{$p}[field], "db" => $p[rel]['foreign_db'], "where" => $opts['where'], "frozen" => $opts['frozen']), $opts);
     $this->fieldFooter($p, $opts);
 }

示例#6

文件： software-usage-by-institution.php 项目： Norky/PBS-tools

                $sql .= $pkgmatch[$key];
            } else {
                $sql .= "script LIKE '%" . $key . "%' OR software LIKE '%" . $key . "%'";
            }
            $sql .= " ) AND ( " . dateselect("start", $_POST['start_date'], $_POST['end_date']) . " )";
            $result = db_query($db, $sql);
            while ($result->fetchInto($row)) {
                $rkeys = array_keys($row);
                echo "<TR>";
                foreach ($rkeys as $rkey) {
                    $data[$rkey] = array_shift($row);
                    echo "<TD align=\"right\"><PRE>" . $data[$rkey] . "</PRE></TD>";
                }
                echo "</TR>\n";
            }
            echo "</TABLE>\n";
        }
    }
    db_disconnect($db);
    bookmarkable_url();
} else {
    begin_form("software-usage-by-institution.php");
    system_chooser();
    date_fields();
    $orders = array("jobcount", "cpuhours", "users", "groups");
    $defaultorder = "cpuhours";
    pulldown("order", "Order by", $orders, $defaultorder);
    checkboxes_from_array("Packages", $packages);
    end_form();
}
page_footer();