diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2008-07-28 13:29:46 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2008-07-28 13:29:46 +0000 |
| commit | cf3d5c3416f6f1a319128568413e310ca153d87b (patch) | |
| tree | 17fddcfa7044a80759820333fa0495bf5f7a4bd2 /phpBB/docs | |
| parent | bba6488d3d085ebfe398c1026d58179120fe5c26 (diff) | |
| download | forums-cf3d5c3416f6f1a319128568413e310ca153d87b.tar forums-cf3d5c3416f6f1a319128568413e310ca153d87b.tar.gz forums-cf3d5c3416f6f1a319128568413e310ca153d87b.tar.bz2 forums-cf3d5c3416f6f1a319128568413e310ca153d87b.tar.xz forums-cf3d5c3416f6f1a319128568413e310ca153d87b.zip | |
force the use of sql_multi_insert() for multi inserts... also adjusted the coding guidelines accordingly.
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8693 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/docs')
| -rw-r--r-- | phpBB/docs/coding-guidelines.html | 31 |
1 files changed, 30 insertions, 1 deletions
diff --git a/phpBB/docs/coding-guidelines.html b/phpBB/docs/coding-guidelines.html index 7d777056d9..1e7faf88e5 100644 --- a/phpBB/docs/coding-guidelines.html +++ b/phpBB/docs/coding-guidelines.html @@ -690,7 +690,29 @@ $sql = 'UPDATE ' . SOME_TABLE . ' $db->sql_query($sql); </pre></div> - <p>The <code>$db->sql_build_array()</code> function supports the following modes: <code>INSERT</code> (example above), <code>INSERT_SELECT</code> (building query for <code>INSERT INTO table (...) SELECT value, column ...</code> statements), <code>MULTI_INSERT</code> (for returning extended inserts), <code>UPDATE</code> (example above) and <code>SELECT</code> (for building WHERE statement [AND logic]).</p> + <p>The <code>$db->sql_build_array()</code> function supports the following modes: <code>INSERT</code> (example above), <code>INSERT_SELECT</code> (building query for <code>INSERT INTO table (...) SELECT value, column ...</code> statements), <code>UPDATE</code> (example above) and <code>SELECT</code> (for building WHERE statement [AND logic]).</p> + + <h4>sql_multi_insert():</h4> + + <p>If you want to insert multiple statements at once, please use the separate <code>sql_multi_insert()</code> method. An example:</p> + + <div class="codebox"><pre> +$sql_ary = array(); + +$sql_ary[] = array( + 'somedata' => $my_string_1, + 'otherdata' => $an_int_1, + 'moredata' => $another_int_1, +); + +$sql_ary[] = array( + 'somedata' => $my_string_2, + 'otherdata' => $an_int_2, + 'moredata' => $another_int_2, +); + +$db->sql_multi_insert(SOME_TABLE, $sql_ary); + </pre></div> <h4>sql_in_set():</h4> @@ -2195,6 +2217,13 @@ if (utf8_case_fold_nfc($string1) == utf8_case_fold_nfc($string2)) <div class="content"> +<h3>Revision 8596+</h3> + +<ul> + <li>Removed sql_build_array('MULTI_INSERT'... statements.</li> + <li>Added sql_multi_insert() explanation.</li> +</ul> + <h3>Revision 1.31</h3> <ul> |