Esempi in PHP per check_single_tuple

Esempio n. 1

File: deck_util.php Progetto: jjjj222/hsinfo

function get_deck_all_attr($id)
{
    global $DECK_TABLE_ATTR, $DECK_TABLE_NAME;
    $attr_list_str = implode(', ', $DECK_TABLE_ATTR);
    $query = "SELECT {$attr_list_str} FROM {$DECK_TABLE_NAME} WHERE id=\"{$id}\"";
    $result = mysql_query($query);
    $count = @mysql_numrows($result);
    check_single_tuple($count, $id);
    $all_attr = array();
    foreach ($DECK_TABLE_ATTR as $attr) {
        $value = mysql_result($result, 0, $attr);
        $all_attr[$attr] = $value;
    }
    return $all_attr;
}

Esempio n. 2

File: mysql_query.php Progetto: jjjj222/hsinfo

function get_card_name_by_id($id)
{
    global $CARD_TABLE_NAME;
    $query = "SELECT name FROM {$CARD_TABLE_NAME} WHERE id=\"{$id}\";";
    #print_msg($query);
    $result = mysql_query($query);
    $num = @mysql_numrows($result);
    check_single_tuple($num, $id);
    return mysql_result($result, 0, "name");
}