http://wiki.mipt.ru/index.php?action=history&feed=atom&title=Development%3ADML_functions_-_pre_2.0 2026-05-07T00:58:25Z История изменений этой страницы в вики MediaWiki 1.42.1 http://wiki.mipt.ru/index.php?title=Development:DML_functions_-_pre_2.0&diff=11006&oldid=prev 2024-10-21T08:51:09Z

<p>1 версия импортирована</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="ru"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Предыдущая версия</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Версия от 08:51, 21 октября 2024</td> </tr><tr><td colspan="2" class="diff-notice" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

Олег Давидович http://wiki.mipt.ru/index.php?title=Development:DML_functions_-_pre_2.0&diff=11005&oldid=prev 2008-10-20T14:57:50Z

<p><span dir="auto"><span class="autocomment">The functions: </span> updated to make this a little more readabable and have a contents for quick access</span></p> <p><b>Новая страница</b></p><div>&lt;p class=&quot;note&quot;&gt;&#039;&#039;&#039;Important note:&#039;&#039;&#039; This article contains information valid for versions before Moodle 2.0, so should be considered &#039;&#039;&#039;deprecated&#039;&#039;&#039;. If you want to see up to date information, please go to [[Development:DML functions|DML functions]] instead.&lt;/p&gt;<br /> <br /> In this page you&#039;ll access to the available functions under Moodle to be able to access to DB data. You should use &#039;&#039;&#039;exclusively&#039;&#039;&#039; these functions in order to retrieve or modify DB contents because these functions provide an high level of abstraction and guarantee that your DB manipulation will work against different RDBMS.<br /> <br /> Where possible, tricks and examples will be documented here in order to make developers&#039;s life a bit easier. Of course, feel free to clarify, complete and add more info to all this documentation. It will be welcome, absolutely!<br /> <br /> == Main info ==<br /> <br /> == The functions ==<br /> <br /> === Seeing if any records exist match a given criteria ===<br /> <br /> o record_exists($table, $field1=&#039;&#039;, $value1=&#039;&#039;, $field2=&#039;&#039;, $value2=&#039;&#039;, $field3=&#039;&#039;, $value3=&#039;&#039;) <br /> Test whether a record exists in a table where all the given fields match the given values.<br /> o record_exists_select($table, $select=&#039;&#039;) <br /> Test whether any records exists in a table which match a particular WHERE clause.<br /> o record_exists_sql($sql) <br /> Test whether a SQL SELECT statement returns any records.<br /> <br /> === Seeing how many records match a given criteria ===<br /> <br /> o count_records($table, $field1=&#039;&#039;, $value1=&#039;&#039;, $field2=&#039;&#039;, $value2=&#039;&#039;, $field3=&#039;&#039;, $value3=&#039;&#039;) <br /> Count the records in a table where all the given fields match the given values.<br /> o count_records_select($table, $select=&#039;&#039;, $countitem=&#039;COUNT(*)&#039;) <br /> Count the records in a table which match a particular WHERE clause.<br /> o count_records_sql($sql) <br /> Get the result of a SQL SELECT COUNT(...) query.<br /> <br /> === Retrieving a single record ===<br /> <br /> o get_record($table, $field1, $value1, $field2=&#039;&#039;, $value2=&#039;&#039;, $field3=&#039;&#039;, $value3=&#039;&#039;, $fields=&#039;*&#039;) <br /> Get a single record as an object<br /> o get_record_select($table, $select=&#039;&#039;, $fields=&#039;*&#039;) <br /> Gets one record from a table, as an object<br /> o get_record_sql($sql, $expectmultiple=false, $nolimit=false) <br /> Get a single record as an object using an SQL statement<br /> <br /> <br /> === Getting an array of records ===<br /> <br /> o get_records($table, $field=&#039;&#039;, $value=&#039;&#039;, $sort=&#039;&#039;, $fields=&#039;*&#039;, $limitfrom=&#039;&#039;, $limitnum=&#039;&#039;) <br /> Get a number of records as an array of objects.<br /> o get_records_select($table, $select=&#039;&#039;, $sort=&#039;&#039;, $fields=&#039;*&#039;, $limitfrom=&#039;&#039;, $limitnum=&#039;&#039;) <br /> Get a number of records as an array of objects.<br /> o get_records_list($table, $field=&#039;&#039;, $values=&#039;&#039;, $sort=&#039;&#039;, $fields=&#039;*&#039;, $limitfrom=&#039;&#039;, $limitnum=&#039;&#039;) <br /> Get a number of records as an array of objects.<br /> o get_records_sql($sql, $limitfrom=&#039;&#039;, $limitnum=&#039;&#039;) <br /> Get a number of records as an array of objects.<br /> o get_records_menu($table, $field=&#039;&#039;, $value=&#039;&#039;, $sort=&#039;&#039;, $fields=&#039;*&#039;) <br /> Get the first two columns from a number of records as an associative array.<br /> o get_records_select_menu($table, $select=&#039;&#039;, $sort=&#039;&#039;, $fields=&#039;*&#039;) <br /> Get the first two columns from a number of records as an associative array.<br /> o get_records_sql_menu($sql) <br /> Get the first two columns from a number of records as an associative array.<br /> <br /> <br /> === Getting a particular field from the database ===<br /> <br /> o get_field($table, $return, $field1, $value1, $field2=&#039;&#039;, $value2=&#039;&#039;, $field3=&#039;&#039;, $value3=&#039;&#039;) <br /> Get a single value from a table row where all the given fields match the given values.<br /> o get_field_select($table, $return, $select) <br /> Get a single value from a table row where a particular select clause is true.<br /> o get_field_sql($sql) <br /> Get a single value from a table.<br /> <br /> <br /> === Setting a particular field in the database ===<br /> <br /> o set_field($table, $newfield, $newvalue, $field1, $value1, $field2=&#039;&#039;, $value2=&#039;&#039;, $field3=&#039;&#039;, $value3=&#039;&#039;) <br /> Set a single field in every table row where all the given fields match the given values.<br /> <br /> <br /> ===Deleting Records===<br /> <br /> o delete_records($table, $field1=&#039;&#039;, $value1=&#039;&#039;, $field2=&#039;&#039;, $value2=&#039;&#039;, $field3=&#039;&#039;, $value3=&#039;&#039;) <br /> Delete the records from a table where all the given fields match the given values.<br /> o delete_records_select($table, $select=&#039;&#039;) <br /> Delete one or more records from a table<br /> <br /> <br /> ===Inserting Records===<br /> <br /> o insert_record($table, $dataobject, $returnid=true, $primarykey=&#039;id&#039;) <br /> Insert a record into a table and return the &quot;id&quot; field if required<br /> <br /> <br /> ===Updating Records===<br /> <br /> o update_record($table, $dataobject) <br /> Update a record in a table<br /> <br /> ==See also==<br /> <br /> * [[Development:DDL functions]]: Up to date information about DDL functions.<br /> * [[Development:DML functions]]: Up to date information about DML functions.<br /> * [[Development:DDL functions - pre 2.0]]: &#039;&#039;&#039;(deprecated!)&#039;&#039;&#039; Where all the functions used to handle DB objects ([[wikipedia:Data_Definition_Language|DDL]]) are defined .<br /> * [[Development:DB layer 2.0 migration docs|DB layer 2.0 migration docs]]: Information about how to modify your code to work with the new Moodle 2.0 DB layer.<br /> <br /> [[Category:DB]]<br /> [[Category:XMLDB]]</div>

1>Gmccullagh@gmail.com