110 public function now();
175 public function query($sql, $a_handle_error =
true);
238 public function connect($a_return_false_for_error =
false);
259 public function useSlave($a_val =
true);
267 public function handleError($a_res, $a_info =
'', $a_level =
'');
288 public function createDatabase($a_name, $a_charset =
'utf8', $a_collation =
'');
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);
311 public function alterTable($a_name, $a_changes);
319 public function addTableColumn($a_table, $a_column, $a_attributes);
374 public function addIndex($a_table, $a_fields, $a_name =
'in', $a_fulltext =
false);
395 public function dropIndex($a_table, $a_name =
'in');
492 public function queryF($a_query, $a_types, $a_values);
500 public function manipulateF($a_query, $a_types, $a_values);
513 public function setLimit($a_limit, $a_offset = 0);
519 public function nextId($a_table_name);
533 public function prepare($a_query, $a_types = null, $a_result_types = null);
540 public function prepareManip($a_query, $a_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);
589 public function free($a_st);
601 public function numRows($a_set);
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);
639 public function upper($a_exp);
645 public function lower($a_exp);
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);
680 public function equalsNot($a_col, $a_value,
$a_type, $a_empty_or_null =
false);
687 public function fromUnixtime($a_expr, $a_to_text =
true);
754 public function autoExecute($a_tablename, $a_fields, $a_mode =
'MDB2_AUTOQUERY_INSERT', $a_where =
false);
763 public function getOne($sql);
770 public function getRow($sql, $mode = 3);
777 public function fetchAll($query_result, $fetch_mode = 2);
810 public function PEAR($error_class = null);
813 public function _PEAR();
like($a_col, $a_type, $a_value='?', $case_insensitive=true)
raiseError($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
dropTable($a_name, $a_error_if_not_existing=true)
getPrimaryKeyIdentifier()
fromUnixtime($a_expr, $a_to_text=true)
modifyTableColumn($a_table, $a_column, $a_attributes)
dropUniqueConstraintByFields($a_table, $a_fields)
setStorageEngine($a_storage_engine)
sequenceExists($a_sequence)
getSequenceName($table_name)
isFulltextIndex($a_table, $a_name)
addTypesToArray($a_arr, $a_type, $a_cnt)
setDBSlavePassword($a_password)
renameTableColumn($a_table, $a_column, $a_new_column)
quoteIdentifier($a_identifier, $check_option=false)
addUniqueConstraint($a_table, $a_fields, $a_name='con')
alterTable($a_name, $a_changes)
addTableColumn($a_table, $a_column, $a_attributes)
staticPushErrorHandling($mode, $options=null)
enableResultBuffering($a_status)
indexExistsByFields($a_table, $a_fields)
isError($data, $code=null)
migrateAllTablesToEngine($engine='InnoDB')
dropIndexByFields($a_table, $a_fields)
replace($a_table, $a_pk_columns, $a_other_columns)
initFromIniFile($tmpClientIniFile=null)
createSequence($a_table_name, $a_start=1)
quote($a_query, $a_type=null)
createTable($a_name, $a_definition_array, $a_drop_table=false, $a_ignore_erros=false)
dropIndex($a_table, $a_name='in')
supportsEngineMigration()
setErrorHandling($mode=null, $options=null)
if($modEnd===false) $module
dropFulltextIndex($a_table, $a_name)
Class ilDBLegacyInterface.
in($a_field, $a_values, $negate=false, $a_type='')
executeMultiple($a_stmt, $a_data)
catch(Exception $e) $message
uniqueConstraintExists($a_table, $a_fields)
raisePearError($a_message, $a_level='')
query($sql, $a_handle_error=true)
connect($a_return_false_for_error=false)
pushErrorHandling($mode, $options=null)
autoExecute($a_tablename, $a_fields, $a_mode='MDB2_AUTOQUERY_INSERT', $a_where=false)
registerShutdownFunc($func, $args=array())
addPrimaryKey($a_table, $a_fields)
concat($a_values, $a_allow_null=true)
throwError($message=null, $code=null, $userinfo=null)
dropUniqueConstraint($a_table, $a_name='con')
dropSequence($a_table_name)
equals($a_col, $a_value, $a_type, $a_empty_or_null=false)
update($a_table, $a_columns, $a_where)
createDatabase($a_name, $a_charset='utf8', $a_collation='')
equalsNot($a_col, $a_value, $a_type, $a_empty_or_null=false)
substr($a_exp, $a_pos=1, $a_len=-1)
Create styles array
The data for the language used.
queryF($a_query, $a_types, $a_values)
setLimit($a_limit, $a_offset=0)
addFulltextIndex($a_table, $a_fields, $a_name='in')
addIndex($a_table, $a_fields, $a_name='in', $a_fulltext=false)
locate($a_needle, $a_string, $a_start_pos=1)
checkColumn($a_col, $a_def)
handleError($a_res, $a_info='', $a_level='')
fetchAll($query_result, $fetch_mode=2)
dropTableColumn($a_table, $a_column)
tableColumnExists($a_table, $a_column_name)
getStaticProperty($class, $var)
manipulateF($a_query, $a_types, $a_values)
prepare($a_query, $a_types=null, $a_result_types=null)
_checkDelExpect($error_code)
setDBPassword($a_password)
checkColumnDefinition($a_def, $a_modify_mode=false)
renameTable($a_name, $a_new_name)
constraintName($a_table, $a_constraint)
checkTableColumns($a_cols)
prepareManip($a_query, $a_types=null)
insert($a_table, $a_columns)
if(!isset($_REQUEST['ReturnTo'])) if(!isset($_REQUEST['AuthId'])) $options
execute($a_stmt, $a_data=null)