Re: Unified DB Query function
| From: | Casey Allen Shobe | Date: | Mon, 01 Jul 2002 17:05:49 +0000 |
| Subject: | Re: Unified DB Query function | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20240@lists.php.net to get a copy of this message | ||
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
cshobe@secureworks.net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.