function query($SQLCmd)
{
if (!$this->isConnect) {
return null;
}
$stmt = ociparse($this->connection, $SQLCmd);
ociexecute($stmt, OCI_DEFAULT);
$results = array();
oci_fetch_all($stmt, $results, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN);
$rs = new ResultSet();
$rs->setHolder($results);
oci_free_statement($stmt);
return $rs;
}
function query($SQLCmd)
{
if (!$this->isConnect) {
echo "not connected";
return new ResultSet();
}
$cursor = mysql_query($SQLCmd, $this->connection);
if (!$cursor) {
return new ResultSet();
}
$results = array();
$resultName = array();
for ($i = 0; $i < mysql_num_fields($cursor); $i++) {
$resultName[$i] = mysql_field_name($cursor, $i);
}
$cnt = 0;
while ($row = mysql_fetch_assoc($cursor)) {
for ($i = 0; $i < count($resultName); $i++) {
$results[$resultName[$i]][$cnt] = $row[$resultName[$i]];
}
$cnt++;
}
$rs = new ResultSet();
$rs->setHolder($results);
return $rs;
}
function query($SQLCmd)
{
if (!$this->isConnect) {
return null;
}
$cursor = ora_open($this->connection);
ora_parse($cursor, $SQLCmd);
ora_exec($cursor);
$results = array();
$resultName = array();
for ($i = 0; $i < ora_numcols($cursor); $i++) {
$resultName[$i] = ora_columnname($cursor, $i);
}
$cnt = 0;
while (ora_fetch($cursor)) {
for ($i = 0; $i < ora_numcols($cursor); $i++) {
$results[$resultName[$i]][$cnt] = ora_getcolumn($cursor, $i);
}
$cnt++;
}
$rs = new ResultSet();
$rs->setHolder($results);
ora_close($cursor);
return $rs;
}
function query($SQLCmd)
{
if (!$this->isConnect) {
return null;
}
$cursor = pg_query($this->connection, $SQLCmd);
$results = array();
$resultName = array();
for ($i = 0; $i < pg_num_fields($cursor); $i++) {
$resultName[$i] = pg_field_name($cursor, $i);
}
$cnt = 0;
while ($row = pg_fetch_assoc($cursor)) {
for ($i = 0; $i < count($resultName); $i++) {
$results[$resultName[$i]][$cnt] = $row[$resultName[$i]];
}
$cnt++;
}
$rs = new ResultSet();
$rs->setHolder($results);
return $rs;
}
