/**
* Fetch Field Names
*
* Generates an array of column names
*
* @access public
* @return array
*/
function list_fields()
{
$field_names = array();
while ($field = sasql_fetch_field($this->result_id)) {
$field_names[] = $field->name;
}
return $field_names;
}
/**
* Return All values of Results in one choose format
* @param constant $type Format of return
* @return array
*/
public function fetchAll($type = SQLAnywhereClient::FETCH_ASSOC)
{
$data = array();
if ($this->result) {
switch ($type) {
case 'array':
while ($row = sasql_fetch_array($this->result)) {
array_push($data, $row);
}
break;
case 'assoc':
while ($row = sasql_fetch_assoc($this->result)) {
array_push($data, $row);
}
break;
case 'row':
while ($row = sasql_fetch_row($this->result)) {
array_push($data, $row);
}
break;
case 'field':
while ($row = sasql_fetch_field($this->result)) {
array_push($data, $row);
}
break;
case 'object':
while ($row = sasql_fetch_object($this->result)) {
array_push($data, $row);
}
break;
default:
while ($row = sasql_fetch_array($this->result)) {
array_push($data, $row);
}
break;
}
}
return $data;
}
/**
* Fetch results from a row.
*/
function db_result($qid = false, $row = '', $field = '')
{
if ($qid === false) {
return false;
}
if (!sasql_data_seek($qid, $res, $row)) {
return false;
}
return sasql_fetch_field($res, $field);
}
/**
* SQL Anywhere Export
*
* @access private
* @param array Preferences
* @return mixed
*/
function _backup($params = array())
{
if (count($params) == 0) {
return FALSE;
}
// Extract the prefs for simplicity
extract($params);
// Build the output
$output = '';
foreach ((array) $tables as $table) {
// Is the table in the "ignore" list?
if (in_array($table, (array) $ignore, TRUE)) {
continue;
}
// Get the table schema
$query = $this->db->query("SHOW CREATE TABLE `" . $this->db->database . '`.`' . $table . '`');
// No result means the table name was invalid
if ($query === FALSE) {
continue;
}
// Write out the table schema
$output .= '#' . $newline . '# TABLE STRUCTURE FOR: ' . $table . $newline . '#' . $newline . $newline;
if ($add_drop == TRUE) {
$output .= 'DROP TABLE IF EXISTS ' . $table . ';' . $newline . $newline;
}
$i = 0;
$result = $query->result_array();
foreach ($result[0] as $val) {
if ($i++ % 2) {
$output .= $val . ';' . $newline . $newline;
}
}
// If inserts are not needed we're done...
if ($add_insert == FALSE) {
continue;
}
// Grab all the data from the current table
$query = $this->db->query("SELECT * FROM {$table}");
if ($query->num_rows() == 0) {
continue;
}
// Fetch the field names and determine if the field is an
// integer type. We use this info to decide whether to
// surround the data with quotes or not
$i = 0;
$field_str = '';
$is_int = array();
while ($field = sasql_fetch_field($query->result_id)) {
// Most versions of SQL Anywhere store timestamp as a string
$is_int[$i] = in_array(strtolower(sasql_field_type($query->result_id, $i)), array('tinyint', 'smallint', 'mediumint', 'int', 'bigint'), TRUE) ? TRUE : FALSE;
// Create a string of field names
$field_str .= '`' . $field->name . '`, ';
$i++;
}
// Trim off the end comma
$field_str = preg_replace("/, \$/", "", $field_str);
// Build the insert string
foreach ($query->result_array() as $row) {
$val_str = '';
$i = 0;
foreach ($row as $v) {
// Is the value NULL?
if ($v === NULL) {
$val_str .= 'NULL';
} else {
// Escape the data if it's not an integer
if ($is_int[$i] == FALSE) {
$val_str .= $this->db->escape($v);
} else {
$val_str .= $v;
}
}
// Append a comma
$val_str .= ', ';
$i++;
}
// Remove the comma at the end of the string
$val_str = preg_replace("/, \$/", "", $val_str);
// Build the INSERT string
$output .= 'INSERT INTO ' . $table . ' (' . $field_str . ') VALUES (' . $val_str . ');' . $newline;
}
$output .= $newline . $newline;
}
return $output;
}
