PHP sql_gettable Examples

Example #1

File: common.php Project: NonameTV/nonametv

function db_readdatachange($myc, $tn)
{
    global $debug;
    $aidb = sql_gettable($myc, "datachanges", "tablename='" . $tn . "'");
    if ($debug) {
        dbg("db_readdatachange", $aidb);
    }
    if (sizeof($aidb) == 1) {
        return $aidb[0];
    } else {
        return false;
    }
}

Example #2

File: admins.php Project: NonameTV/nonametv

function sql_nadjiAdmin($myc, $kaj, $vrijednost)
{
    global $dconf, $debug;
    switch ($kaj) {
        //case 'fwrules': // walk through multiline text fields
        //case 'unwinsservers':
        //$cond = $kaj . " LIKE '%" . $vrijednost . "%'";
        //return false; // ??????????
        default:
            $cond = $kaj . "='" . $vrijednost . "'";
            break;
    }
    $sn = sql_gettable($myc, 'admins', $cond);
    if ($debug) {
        dbg("sql_nadjiAdmin", $sn);
    }
    if (sizeof($sn) == 1) {
        // slaganje multiline text polja
        //$sn[0]['fwrules'] = split ("\n", $sn[0]['fwrules']);
        return $sn[0];
    } else {
        return false;
    }
}