PHP clsDB::getOptionsFromTable Examples

Example #1

File: admin.php Project: shifter/ospap2

if ($strSubAction == '') {
} else {
    if ($strSubAction == 'import') {
        $objBreadcrumbs->add('Import', 'index.php?action=admin&subaction=import');
        $objAdmin->set('path', "../ospap");
        print "Importing from OSPAP...<br>";
        print "<form method='get' action='index.php'>";
        print "<input type='hidden' name='action' value='admin'>";
        print "<input type='hidden' name='subaction' value='import2'>";
        print "Path to OSPAP " . $objAdmin->getTextField('path') . "<br>";
        print $objAdmin->getSubmit('Go');
        print "</form>";
    } else {
        if ($strSubAction == 'import2') {
            $objBreadcrumbs->add('Import', 'index.php?action=admin&subaction=import');
            $arrUserOptions = clsDB::getOptionsFromTable('user', 'username', 'id', "Don't import");
            $objAdmin->getFromRequest();
            require_once $objAdmin->get('path') . "/configuration.php";
            print "<form method='get' action='index.php'>";
            print "<input type='hidden' name='action' value='admin'>";
            print "<input type='hidden' name='subaction' value='import3'>";
            print "Path to OSPAP " . $objAdmin->getTextField('path') . "<br>";
            $conDB = mysql_connect($db_host, $db_read_user, $db_read_pass);
            if (!mysql_select_db($db_name, $conDB)) {
                print "Error: couldn't connect to the ospap database: " . mysql_error($conDB);
            } else {
                $result = mysql_query("SELECT * FROM users JOIN categories ON users.user_id = categories.user_id ORDER BY users.username, categories.name");
                if (!$result) {
                    print "Query error: " . mysql_error($conDB);
                } else {
                    print "<table>";