diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2008-07-28 13:37:16 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2008-07-28 13:37:16 +0000 |
| commit | 1b67e804224a4477031da03ff5108c621cf6d13b (patch) | |
| tree | 4d6fc01dc442b7d0caaa0e38ac7a96cc5a597101 /phpBB/docs/coding-guidelines.html | |
| parent | d8f2c4a1c4468440cf6c8657891e179bf7d222f5 (diff) | |
| download | forums-1b67e804224a4477031da03ff5108c621cf6d13b.tar forums-1b67e804224a4477031da03ff5108c621cf6d13b.tar.gz forums-1b67e804224a4477031da03ff5108c621cf6d13b.tar.bz2 forums-1b67e804224a4477031da03ff5108c621cf6d13b.tar.xz forums-1b67e804224a4477031da03ff5108c621cf6d13b.zip | |
marge
git-svn-id: file:///svn/phpbb/trunk@8696 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/docs/coding-guidelines.html')
| -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 961088a381..f88dbd480c 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> @@ -2201,6 +2223,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> |