175 public function query($sql, $a_handle_error =
true);
238 public function connect($a_return_false_for_error =
false);
297 public function createTable($a_name, $a_definition_array, $a_drop_table =
false, $a_ignore_erros =
false);
304 public function dropTable($a_name, $a_error_if_not_existing =
true);
374 public function addIndex($a_table, $a_fields, $a_name =
'in', $a_fulltext =
false);
492 public function queryF($a_query, $a_types, $a_values);
533 public function prepare($a_query, $a_types =
null, $a_result_types =
null);
547 public function execute($a_stmt, $a_data =
null);
561 public function insert($a_table, $a_columns);
569 public function update($a_table, $a_columns, $a_where);
577 public function replace($a_table, $a_pk_columns, $a_other_columns);
610 public function in($a_field, $a_values, $negate =
false,
$a_type =
'');
625 public function concat($a_values, $a_allow_null =
true);
633 public function substr($a_exp, $a_pos = 1, $a_len = -1);
653 public function locate($a_needle, $a_string, $a_start_pos = 1);
662 public function like($a_col,
$a_type, $a_value =
'?', $case_insensitive =
true);
671 public function equals($a_col, $a_value,
$a_type, $a_empty_or_null =
false);
754 public function autoExecute($a_tablename, $a_fields, $a_mode =
'MDB2_AUTOQUERY_INSERT', $a_where =
false);
777 public function fetchAll($query_result, $fetch_mode = 2);
810 public function PEAR($error_class =
null);
if(!isset( $_REQUEST[ 'ReturnTo'])) if(!isset($_REQUEST['AuthId'])) $options
An exception for terminatinating execution or to throw for unit testing.
Class ilDBLegacyInterface.
query($sql, $a_handle_error=true)
dropFulltextIndex($a_table, $a_name)
renameTableColumn($a_table, $a_column, $a_new_column)
checkColumn($a_col, $a_def)
checkColumnDefinition($a_def, $a_modify_mode=false)
pushErrorHandling($mode, $options=null)
addPrimaryKey($a_table, $a_fields)
insert($a_table, $a_columns)
quote($a_query, $a_type=null)
dropIndexByFields($a_table, $a_fields)
setDBSlavePassword($a_password)
alterTable($a_name, $a_changes)
equalsNot($a_col, $a_value, $a_type, $a_empty_or_null=false)
createTable($a_name, $a_definition_array, $a_drop_table=false, $a_ignore_erros=false)
quoteIdentifier($a_identifier, $check_option=false)
getSequenceName($table_name)
handleError($a_res, $a_info='', $a_level='')
modifyTableColumn($a_table, $a_column, $a_attributes)
tableColumnExists($a_table, $a_column_name)
isError($data, $code=null)
renameTable($a_name, $a_new_name)
addIndex($a_table, $a_fields, $a_name='in', $a_fulltext=false)
throwError($message=null, $code=null, $userinfo=null)
executeMultiple($a_stmt, $a_data)
dropUniqueConstraint($a_table, $a_name='con')
raisePearError($a_message, $a_level='')
addUniqueConstraint($a_table, $a_fields, $a_name='con')
indexExistsByFields($a_table, $a_fields)
in($a_field, $a_values, $negate=false, $a_type='')
execute($a_stmt, $a_data=null)
supportsEngineMigration()
prepareManip($a_query, $a_types=null)
replace($a_table, $a_pk_columns, $a_other_columns)
prepare($a_query, $a_types=null, $a_result_types=null)
createSequence($a_table_name, $a_start=1)
migrateAllTablesToEngine($engine='InnoDB')
setStorageEngine($a_storage_engine)
like($a_col, $a_type, $a_value='?', $case_insensitive=true)
dropSequence($a_table_name)
fetchAll($query_result, $fetch_mode=2)
dropTable($a_name, $a_error_if_not_existing=true)
substr($a_exp, $a_pos=1, $a_len=-1)
connect($a_return_false_for_error=false)
getPrimaryKeyIdentifier()
dropIndex($a_table, $a_name='in')
enableResultBuffering($a_status)
queryF($a_query, $a_types, $a_values)
uniqueConstraintExists($a_table, $a_fields)
locate($a_needle, $a_string, $a_start_pos=1)
setDBPassword($a_password)
isFulltextIndex($a_table, $a_name)
checkTableColumns($a_cols)
addFulltextIndex($a_table, $a_fields, $a_name='in')
addTableColumn($a_table, $a_column, $a_attributes)
createDatabase($a_name, $a_charset='utf8', $a_collation='')
dropTableColumn($a_table, $a_column)
equals($a_col, $a_value, $a_type, $a_empty_or_null=false)
update($a_table, $a_columns, $a_where)
getStaticProperty($class, $var)
setErrorHandling($mode=null, $options=null)
fromUnixtime($a_expr, $a_to_text=true)
dropUniqueConstraintByFields($a_table, $a_fields)
registerShutdownFunc($func, $args=array())
constraintName($a_table, $a_constraint)
initFromIniFile($tmpClientIniFile=null)
addTypesToArray($a_arr, $a_type, $a_cnt)
manipulateF($a_query, $a_types, $a_values)
autoExecute($a_tablename, $a_fields, $a_mode='MDB2_AUTOQUERY_INSERT', $a_where=false)
staticPushErrorHandling($mode, $options=null)
raiseError($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
_checkDelExpect($error_code)
concat($a_values, $a_allow_null=true)
sequenceExists($a_sequence)
setLimit($a_limit, $a_offset=0)
catch(Exception $e) $message
if($modEnd===false) $module