| Moodle PHP Documentation 4.1
    Moodle 4.1.19+ (Build: 20250711) (5f47dc23ffc) | 
Database module external functions. More...
 
  
| Static Public Member Functions | |
| static | add_entry ($databaseid, $groupid, $data) | 
| Adds a new entry to a database. | |
| static | add_entry_parameters () | 
| Returns description of method parameters. | |
| static | add_entry_returns () | 
| Returns description of method result value. | |
| static | approve_entry ($entryid, $approve=true) | 
| Approves or unapproves an entry. | |
| static | approve_entry_parameters () | 
| Returns description of method parameters. | |
| static | approve_entry_returns () | 
| Returns description of method result value. | |
| static | call_external_function ($function, $args, $ajaxonly=false) | 
| Call an external function validating all params/returns correctly. | |
| static | clean_returnvalue (external_description $description, $response) | 
| Clean response If a response attribute is unknown from the description, we just ignore the attribute. | |
| static | delete_entry ($entryid) | 
| Deletes an entry. | |
| static | delete_entry_parameters () | 
| Returns description of method parameters. | |
| static | delete_entry_returns () | 
| Returns description of method result value. | |
| static | external_function_info ($function, $strictness=MUST_EXIST) | 
| Returns detailed function information. | |
| static | get_data_access_information ($databaseid, $groupid=0) | 
| Return access information for a given database. | |
| static | get_data_access_information_parameters () | 
| Returns description of method parameters. | |
| static | get_data_access_information_returns () | 
| Returns description of method result value. | |
| static | get_databases_by_courses ($courseids=array()) | 
| Returns a list of databases in a provided list of courses, if no list is provided all databases that the user can view will be returned. | |
| static | get_databases_by_courses_parameters () | 
| Describes the parameters for get_databases_by_courses. | |
| static | get_databases_by_courses_returns () | 
| Describes the get_databases_by_courses return value. | |
| static | get_entries ($databaseid, $groupid=0, $returncontents=false, $sort=null, $order=null, $page=0, $perpage=0) | 
| Return access information for a given feedback. | |
| static | get_entries_parameters () | 
| Returns description of method parameters. | |
| static | get_entries_returns () | 
| Returns description of method result value. | |
| static | get_entry ($entryid, $returncontents=false) | 
| Return one entry record from the database, including contents optionally. | |
| static | get_entry_parameters () | 
| Returns description of method parameters. | |
| static | get_entry_returns () | 
| Returns description of method result value. | |
| static | get_fields ($databaseid) | 
| Return the list of configured fields for the given database. | |
| static | get_fields_parameters () | 
| Returns description of method parameters. | |
| static | get_fields_returns () | 
| Returns description of method result value. | |
| static | search_entries ($databaseid, $groupid=0, $returncontents=false, $search='', $advsearch=[], $sort=null, $order=null, $page=0, $perpage=0) | 
| Return access information for a given feedback. | |
| static | search_entries_parameters () | 
| Returns description of method parameters. | |
| static | search_entries_returns () | 
| Returns description of method result value. | |
| static | set_context_restriction ($context) | 
| Set context restriction for all following subsequent function calls. | |
| static | set_timeout ($seconds=360) | 
| This method has to be called before every operation that takes a longer time to finish! | |
| static | update_entry ($entryid, $data) | 
| Updates an existing entry. | |
| static | update_entry_parameters () | 
| Returns description of method parameters. | |
| static | update_entry_returns () | 
| Returns description of method result value. | |
| static | validate_context ($context) | 
| Makes sure user may execute functions in this context. | |
| static | validate_parameters (external_description $description, $params) | 
| Validates submitted function parameters, if anything is incorrect invalid_parameter_exception is thrown. | |
| static | view_database ($databaseid) | 
| Simulate the data/view.php web interface page: trigger events, completion, etc... | |
| static | view_database_parameters () | 
| Returns description of method parameters. | |
| static | view_database_returns () | 
| Returns description of method result value. | |
| Static Protected Member Functions | |
| static | get_context_from_params ($param) | 
| Get context from passed parameters. | |
| static | get_context_parameters () | 
| Returns a prepared structure to use a context parameters. | |
| static | validate_database ($databaseid) | 
| Utility function for validating a database. | |
Database module external functions.
| 
 | static | 
Adds a new entry to a database.
| int | $databaseid | the data instance id | 
| int | $groupid | (optional) group id, 0 means that the function will determine the user group | 
| array | $data | the fields data to be created | 
| array | of warnings and status result | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | static | 
Approves or unapproves an entry.
| int | $entryid | the record entry id id | 
| bool | $approve | whether to approve (true) or unapprove the entry | 
| array | of warnings and the entries | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | staticinherited | 
Call an external function validating all params/returns correctly.
Note that an external function may modify the state of the current page, so this wrapper saves and restores tha PAGE and COURSE global variables before/after calling the external function.
| string | $function | A webservice function name. | 
| array | $args | Params array (named params) | 
| boolean | $ajaxonly | If true, an extra check will be peformed to see if ajax is required. | 
| array | containing keys for error (bool), exception and data. | 
| 
 | staticinherited | 
Clean response If a response attribute is unknown from the description, we just ignore the attribute.
If a response attribute is incorrect, invalid_response_exception is thrown. Note: this function is similar to validate parameters, however it is distinct because parameters validation must be distinct from cleaning return values.
| external_description | $description | description of the return values | 
| mixed | $response | the actual response | 
| mixed | response with added defaults for optional items, invalid_response_exception thrown if any problem found | 
| 
 | static | 
Deletes an entry.
| int | $entryid | the record entry id | 
| array | of warnings success status | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | staticinherited | 
Returns detailed function information.
| string | object | $function | name of external function or record from external_function | 
| int | $strictness | IGNORE_MISSING means compatible mode, false returned if record not found, debug message if more found; MUST_EXIST means throw exception if no record or multiple records found | 
| stdClass | description or false if not found or exception thrown | 
| coding_exception | for any property and/or method that is missing or invalid | 
| 
 | staticprotectedinherited | 
Get context from passed parameters.
The passed array must either contain a contextid or a combination of context level and instance id to fetch the context. For example, the context level can be "course" and instanceid can be courseid.
See context_helper::get_all_levels() for a list of valid context levels.
| array | $param | 
| invalid_parameter_exception | 
| context | 
| 
 | staticprotectedinherited | 
Returns a prepared structure to use a context parameters.
| external_single_structure | 
Reimplemented in core_competency\external, and tool_lp\external.
| 
 | static | 
Return access information for a given database.
| int | $databaseid | the database instance id | 
| int | $groupid | (optional) group id, 0 means that the function will determine the user group | 
| array | of warnings and access information | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | static | 
Returns a list of databases in a provided list of courses, if no list is provided all databases that the user can view will be returned.
| array | $courseids | the course ids | 
| array | the database details | 
| 
 | static | 
Describes the parameters for get_databases_by_courses.
| external_function_parameters | 
| 
 | static | 
Describes the get_databases_by_courses return value.
| external_single_structure | 
| 
 | static | 
Return access information for a given feedback.
| int | $databaseid | the data instance id | 
| int | $groupid | (optional) group id, 0 means that the function will determine the user group | 
| bool | $returncontents | Whether to return the entries contents or not | 
| str | $sort | sort by this field | 
| int | $order | the direction of the sorting | 
| int | $page | page of records to return | 
| int | $perpage | number of records to return per page | 
| array | of warnings and the entries | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | static | 
Return one entry record from the database, including contents optionally.
| int | $entryid | the record entry id id | 
| bool | $returncontents | whether to return the entries contents or not | 
| array | of warnings and the entries | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | static | 
Return the list of configured fields for the given database.
| int | $databaseid | the database id | 
| array | of warnings and the fields | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | static | 
Return access information for a given feedback.
| int | $databaseid | the data instance id | 
| int | $groupid | (optional) group id, 0 means that the function will determine the user group | 
| bool | $returncontents | whether to return contents or not | 
| str | $search | search text | 
| array | $advsearch | advanced search data | 
| str | $sort | sort by this field | 
| int | $order | the direction of the sorting | 
| int | $page | page of records to return | 
| int | $perpage | number of records to return per page | 
| array | of warnings and the entries | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | staticinherited | 
Set context restriction for all following subsequent function calls.
| stdClass | $context | the context restriction | 
| 
 | staticinherited | 
This method has to be called before every operation that takes a longer time to finish!
| int | $seconds | max expected time the next operation needs | 
| 
 | static | 
Updates an existing entry.
| int | $entryid | the data instance id | 
| array | $data | the fields data to be created | 
| array | of warnings and status result | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static | 
| 
 | staticinherited | 
| 
 | staticprotected | 
Utility function for validating a database.
| int | $databaseid | database instance id | 
| array | array containing the database object, course, context and course module objects | 
| 
 | staticinherited | 
Validates submitted function parameters, if anything is incorrect invalid_parameter_exception is thrown.
This is a simple recursive method which is intended to be called from each implementation method of external API.
| external_description | $description | description of parameters | 
| mixed | $params | the actual parameters | 
| mixed | params with added defaults for optional items, invalid_parameters_exception thrown if any problem found | 
| 
 | static | 
Simulate the data/view.php web interface page: trigger events, completion, etc...
| int | $databaseid | the data instance id | 
| array | of warnings and status result | 
| moodle_exception | 
| 
 | static | 
Returns description of method parameters.
| external_function_parameters | 
| 
 | static |