Пример #1
0
 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);
     }
 }