Re: [PHP-DB] Unified DB Query function

[Casey Allen Shobe]

I figured it out.  Here's my completed code for reference:

$db2_conn = @odbc_connect (DB2_ALIAS, DB2_USERNAME, DB2_PASSWORD) or
        $db_error .= '<font size="+2"><b>Unable to connect to DB2 
Database!!</b></font><br>'."\n".'<b><font color="#cc0000">Error Message: 
</font></b>'.$php_errormsg.'<br>';

$piv_conn = @sybase_connect (PIV_ALIAS, PIV_USERNAME, PIV_PASSWORD) or
        $db_error .= '<font size="+2"><b>Unable to connect to Pivotal 
Database!!</b></font><br>'."\n".'<b><font color="#cc0000">Error Message: 
</font></b>'.$php_errormsg.'<br>';
if (!isset($db_error)) {
        sybase_select_db ('Enterprise_Data', $piv_conn);
}

function db_query ($db_type, $db_query) {
        if ($db_type == 'db2') {
                global $db2_conn;
                $result = odbc_exec ($db2_conn, $db_query);
                while (odbc_fetch_into ($result, &$row)) {
                        $data[0][] = $row;
                }
                $data[1] = odbc_num_rows ($result);
                odbc_free_result ($result);
        } else if ($db_type == 'piv') {
                global $piv_conn;
                $result = sybase_query ('set textsize 32768'."\n".$db_query, 
$piv_conn);
                // What do I put here?
                while ($row = sybase_fetch_array ($result)) {
                        $data[0][] = $row;
                }
                $data[1] = sybase_num_rows ($result);
        }
        return $data;
}

-- 
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
[EMAIL PROTECTED] / http://www.secureworks.net
Content is my own and does not necessarily represent my company.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php