PHP db_get_data Exemples

Exemple #1

Fichier : antiddos.mod.php Projet : lishengjia/anti_ddos_attack

function antiddos_search()
{
    $appname = @mysql_escape_string($_REQUEST['appname']);
    if (!$appname) {
        die_(1, "'appname' is required");
    }
    $data = db_get_data("select accesskey,service_status,domain_status from anti_ddos where appname='{$appname}'");
    if ($data === False) {
        die_(1, db_last_error());
    }
    die_(0, $data);
}

Exemple #2

Fichier : todo_dlg_item.inc.php Projet : BackupTheBerlios/winbinder-svn

function update_item_controls($window)
{
    global $id_edit, $curr_cat;
    $table = "item";
    $data = db_get_data($table, $id_edit, null, "", FETCH_ASSOC);
    $data = $data[0];
    wb_set_text(wb_get_control($window, ID_NAME), $data["name"]);
    wb_set_text(wb_get_control($window, ID_DESCRIPTION), $data["description"]);
    // Select the appropriate values from the combo boxes
    wb_set_selected(wb_get_control($window, ID_CATLIST), (int) array_search($curr_cat === null ? $data["cat"] : $curr_cat, db_get_data("cat", null, "id")));
    wb_set_selected(wb_get_control($window, ID_PRIORLIST), (int) array_search($data["priority"], db_get_data("priority", null, "id")));
    wb_set_selected(wb_get_control($window, ID_SEVERLIST), (int) array_search($data["severity"], db_get_data("severity", null, "id")));
}

Exemple #3

Fichier : db_common.inc.php Projet : BackupTheBerlios/winbinder-svn

/**
* db_get_index()
*
* Returns the index of the record identified by $id
*
* @param  $tablename
* @param  $id
* @param string $idfield
* @return index or FALSE
*/
function db_get_index($tablename, $id, $idfield = "id")
{
    $data = db_get_data($tablename, null, $idfield);
    return array_search($id, $data);
}

Exemple #4

Fichier : todo_dlg_prior.inc.php Projet : BackupTheBerlios/winbinder-svn

function update_prior_controls($window)
{
    global $mainwin, $prior_table;
    $itemlist = wb_get_control($window, ID_PRIORITYLIST);
    $id = db_get_id($prior_table, wb_get_selected($itemlist));
    wb_set_text(wb_get_control($window, ID_NAME), db_get_data($prior_table, $id, "name"));
    $sel = wb_get_selected($itemlist);
    wb_set_enabled(wb_get_control($window, ID_SETITEM), $sel != -1);
    wb_set_enabled(wb_get_control($window, ID_DELETEITEM), $sel != -1);
}

Exemple #5

Fichier : todo_dlg_cat.inc.php Projet : BackupTheBerlios/winbinder-svn

function get_selected_tree_item_index($window)
{
    global $cat_table, $it_list;
    // Below: get id of selected treeview element. See comment in update_items()
    $it_list = wb_get_control($window, ID_TREE);
    $sel_text = wb_get_text($it_list);
    $cat_data = db_get_data("cat", null, "name");
    $sel_index = (int) array_search($sel_text, $cat_data);
    return $sel_index;
}

Exemple #6

Fichier : db.php Projet : lishengjia/anti_ddos_attack

function db_get_row($sql, $name = "default")
{
    $data = db_get_data($sql, $name);
    return @reset($data);
}

Exemple #7

Fichier : todo_import_export.inc.php Projet : BackupTheBerlios/winbinder-svn

function todo_export_text($data)
{
    $spaces = str_repeat("-", 80);
    $txt = COMPLETENAME . "\r\n" . "Generated automatically by " . APPNAME . " in " . date("m/d/Y") . "\r\n(" . count($data) . " items)\r\n\r\n{$spaces}\r\n";
    foreach ($data as $entry) {
        $id = $entry[0];
        $name = trim($entry[1]);
        $desc = trim($entry[2]);
        if (!$desc) {
            $desc = "(No description)";
        }
        $cat = db_get_data("cat", null, "name", "id == {$entry[3]}");
        $prior = db_get_data("priority", null, "name", "id == {$entry[4]}");
        $sever = db_get_data("severity", null, "name", "id == {$entry[5]}");
        $txt .= "\r\nItem/bug #{$id}: {$name}\r\n{$sever}, {$prior} priority\r\n\r\n{$desc}\r\n\r\n{$spaces}\r\n";
    }
    return $txt;
}