Development:DML functions - Revision history

Stronk7: fixing get_recordset use

2011-05-05T22:37:55Z

fixing get_recordset use

← Older revision		Revision as of 22:37, 5 May 2011
Line 270:		Line 270:

	<code php>		<code php>
	~~if (~~$rs = $DB->get_recordset(....) {		$rs = $DB->get_recordset(....) {
	foreach ($rs as $record) {		foreach ($rs as $record) {
	// Do whatever you want with this record		// Do whatever you want with this record
	}
	~~$rs->close(); // Don't forget to close the recordset!~~
	}		}
			$rs->close(); // Don't forget to close the recordset!
	</code>		</code>

2011-05-05T18:03:21Z

moodle_database::get_records_select_menu()

← Older revision		Revision as of 18:03, 5 May 2011
Line 160:		Line 160:
	///The 'select' parameter is (if not empty) is dropped directly into the WHERE clause without alteration.		///The 'select' parameter is (if not empty) is dropped directly into the WHERE clause without alteration.
	$table = 'foo';		$table = 'foo';
	$select = 'jon = 'doe' AND bob != "tom" '; //is put into the where clause		$select = 'jon = "doe" AND bob != "tom" '; //is put into the where clause
	$result = $DB->get_records_select_menu($table,$select);		$result = $DB->get_records_select_menu($table,$select);

2011-05-05T16:29:48Z

moodle_database::get_records_select_menu()

← Older revision		Revision as of 16:29, 5 May 2011
Line 164:		Line 164:

	$table = 'foo';		$table = 'foo';
	$select = 'jon = 'doe' AND bob != "tom" '; //is put into the where clause		$select = 'jon = "doe" AND bob != "tom" '; //is put into the where clause
	$fields = 'id, tacos';//return these fields		$fields = 'id, tacos';//return these fields
	$result = $DB->get_records_select_menu($table,$select,null,$fields);		$result = $DB->get_records_select_menu($table,$select,null,$fields);

2011-05-05T16:26:25Z

moodle_database::get_records_menu()

← Older revision		Revision as of 16:26, 5 May 2011
Line 150:		Line 150:
	The result of this last example will look something like:		The result of this last example will look something like:
	<code php>		<code php>
	///the value of the 'tacos' column is 6		/// The value of the id field is 909 and the value of the 'tacos' column is 6
	array(1) { [~~'id'~~]=6 }		array(1) { [909]=6 }
	</code>		</code>

2011-05-05T16:26:13Z

moodle_database::get_records_select_menu()

← Older revision		Revision as of 16:26, 5 May 2011
Line 171:		Line 171:
	The result of this last example will look something like:		The result of this last example will look something like:
	<code php>		<code php>
	///the value of the 'tacos' column is 6		/// The value of the id field is 909 and the value of the 'tacos' column is 6
	array(1) { [~~'id'~~]=6 }		array(1) { [909]=6 }
	</code>		</code>

2011-05-05T16:25:34Z

moodle_database::get_records_sql_menu()

← Older revision		Revision as of 16:25, 5 May 2011
Line 195:		Line 195:
	The result of this last example will look something like:		The result of this last example will look something like:
	<code php>		<code php>
	/// The value of the id is 909 and the value of the 'tacos' column is 6		/// The value of the id field is 909 and the value of the 'tacos' column is 6
	array(1) { [909]=6 }		array(1) { [909]=6 }
	</code>		</code>

2011-05-05T16:24:25Z

moodle_database::get_records_sql_menu(): added example

@@ Line 176: / Line 176: @@
 =====moodle_database::get_records_sql_menu()=====
 <code php>
 </code>

2011-05-05T16:06:33Z

moodle_database::get_records_select_menu()

← Older revision		Revision as of 16:06, 5 May 2011
Line 169:		Line 169:
	</code>		</code>

	The result of this ~~method~~ will look something like:		The result of this last example will look something like:
	<code php>		<code php>
	array(1) { ['~~foo~~']=~~'bar'~~ }		///the value of the 'tacos' column is 6
			array(1) { ['id']=6 }
	</code>		</code>

2011-05-05T16:05:43Z

moodle_database::get_records_menu(): clarified return values

← Older revision		Revision as of 16:05, 5 May 2011
Line 146:		Line 146:

	$result = $DB->get_records_menu($table,$conditions));		$result = $DB->get_records_menu($table,$conditions));


	</code>		</code>
	The result of this ~~method~~ will look something like:		The result of this last example will look something like:
	<code php>		<code php>
	array(1) { ['~~foo~~']=~~'bar'~~ }		///the value of the 'tacos' column is 6
			array(1) { ['id']=6 }
	</code>		</code>

2011-05-05T16:04:00Z

moodle_database::get_records_select_menu(): added examples

@@ Line 155: / Line 155: @@
 =====moodle_database::get_records_select_menu()=====
 <code php>
 </code>