Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
Moodle/Programming/DB
[
Front page
]
[ ]
Start:
** DataBase API
- lib/dml/moodle_database.php
- $strictness: MUST_EXIST, IGNORE_MISSING
#br
*** API
#br
**** $DB->count_records
$count = $DB->count_records('autoattend_sessions', array...
#br
**** $DB->insert_record
- record_id insert_record($table, $dataobject, $returnid=...
$apply_id = $DB->insert_record('apply', $apply);
**** $DB->update_record
- bool update_record($table, $dataobject, $bulk=false);
update_record('apply', $apply);
**** $DB->delete_records
- bool delete_records($table, array $conditions=null)
$ret = $DB->delete_records('event', array('modulename'=>...
**** $DB->get_record
- object get_record($table, array $conditions, $fields='*...
$item = $DB->get_record('apply_item', array('id'=>$apply...
$name = $item->name;
**** $DB->get_records
- array(object) get_records($table, array $conditions=nul...
$params = array('apply_id'=>$item->apply_id);
$items = $DB->get_records('apply_item', $params, 'positi...
foreach ($items as $item) {
$name = $item->name;
......
**** $DB->get_records_select
- array(object) get_records_select($table, $select, array...
- $select の ''?'' に 配列 $params の要素が対応(並び順)
- $select 中の '':変数名'' に $params の各要素が対応
- name が結果の配列のキーになる(重複があるとワーニング)
$templates = $DB->get_records_select('apply_template', '...
**** $DB->get_records_sql
- array(object) get_records_sql($sql, array $params=null,...
- $sql の ''?'' に 配列 $params の要素が対応(並び順)
- $sql 中の '':変数名'' に $params の各要素が対応
$where = 'WHERE as.id=av.submit_id AND av.version=0 AND ...
$sql = 'SELECT MAX(ai.position) FROM {apply_submit} as...
$params = array();
$params['apply_id'] = $apply_id;
$lastpos = $DB->get_field_sql($sql, $params);
#br
**** $DB->execute
- array(object) execute($sql, array $params=null)
- $sql の ''?'' に 配列 $params の要素が対応(並び順)
- $sql 中の '':変数名'' に $params の各要素が対応
#br
End:
** DataBase API
- lib/dml/moodle_database.php
- $strictness: MUST_EXIST, IGNORE_MISSING
#br
*** API
#br
**** $DB->count_records
$count = $DB->count_records('autoattend_sessions', array...
#br
**** $DB->insert_record
- record_id insert_record($table, $dataobject, $returnid=...
$apply_id = $DB->insert_record('apply', $apply);
**** $DB->update_record
- bool update_record($table, $dataobject, $bulk=false);
update_record('apply', $apply);
**** $DB->delete_records
- bool delete_records($table, array $conditions=null)
$ret = $DB->delete_records('event', array('modulename'=>...
**** $DB->get_record
- object get_record($table, array $conditions, $fields='*...
$item = $DB->get_record('apply_item', array('id'=>$apply...
$name = $item->name;
**** $DB->get_records
- array(object) get_records($table, array $conditions=nul...
$params = array('apply_id'=>$item->apply_id);
$items = $DB->get_records('apply_item', $params, 'positi...
foreach ($items as $item) {
$name = $item->name;
......
**** $DB->get_records_select
- array(object) get_records_select($table, $select, array...
- $select の ''?'' に 配列 $params の要素が対応(並び順)
- $select 中の '':変数名'' に $params の各要素が対応
- name が結果の配列のキーになる(重複があるとワーニング)
$templates = $DB->get_records_select('apply_template', '...
**** $DB->get_records_sql
- array(object) get_records_sql($sql, array $params=null,...
- $sql の ''?'' に 配列 $params の要素が対応(並び順)
- $sql 中の '':変数名'' に $params の各要素が対応
$where = 'WHERE as.id=av.submit_id AND av.version=0 AND ...
$sql = 'SELECT MAX(ai.position) FROM {apply_submit} as...
$params = array();
$params['apply_id'] = $apply_id;
$lastpos = $DB->get_field_sql($sql, $params);
#br
**** $DB->execute
- array(object) execute($sql, array $params=null)
- $sql の ''?'' に 配列 $params の要素が対応(並び順)
- $sql 中の '':変数名'' に $params の各要素が対応
#br
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Today
Who's Online
95 user(s) are online (6 user(s) are browsing xpwiki)
Members: 0
Guests: 95
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com