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; }