public function getAllFields($tablename) { $cur = sqlrcur_alloc($this->_conn); $success = sqlrcur_sendQuery($cur, SQLHelper::createSafeSQL("select * from :table", array(":table" => $tablename))); sqlrcon_endSession($cur); if (!$success) { throw new DatasetException(sqlrcur_errorMessage($cur)); } $fields = []; $colCount = sqlrcur_colCount($cur); for ($col = 0; $col < $colCount; $col++) { $fields[] = strtolower(sqlrcur_getColumnName($cur, $col)); } sqlrcur_free($cur); return $fields; }
function da_sql_list_fields($table, $link, $config) { if (sqlrcur_sendQuery($link[cur], "SELECT * FROM {$table} WHERE 1 = 0;")) { sqlrcon_endSession($link[con]); return $link[cur]; } else { return false; } }
/** * Terminates the session * Warning, not all databases support those functionalities. * * @access protected * @return void */ function endSession() { if ($this->isOracle()) { @sqlrcon_endSession($this->conn_id); } }