| Re: PS Re: GUI designer in html [message #182466 is a reply to message #182463] |
Mon, 05 August 2013 22:55   |
Norman Peelman
Messages: 126
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 08/05/2013 10:57 AM, Twayne wrote:
> On 2013-08-05 12:41 AM, J.O. Aho wrote:
>> On 05/08/13 02:59, Norman Peelman wrote:
>>> On 08/04/2013 01:09 PM, J.O. Aho wrote:
>>
>
> ....
>
>>>
>>> That's only if you go out of your way to enable multiple statements
>>> by using 'mysqli_multi_query()', which doesn't support prepared
>>> statements. By default mysqli_query() and mysqli_real_query() do not
>>> allow multiple queries separated by semi-colons.
>>>
>>> http://us2.php.net/manual/en/mysqli.quickstart.multiple-statement.php
>>
>> Unless something changed, mysqli_query supports multiple statements, but
>> the return value do not support to give you the result from all the
>> queries, I think it returned the last one.
>>
>
> Quite correct and as the manual states;
No.
> "
> MySQL optionally allows having multiple statements in one statement
> string. Sending multiple statements at once reduces client-server round
> trips but requires special handling.
>
> Multiple statements or multi queries must be executed with
> mysqli_multi_query(). The individual statements of the statement string
> are separated by semicolon. Then, all result sets returned by the
> executed statements must be fetched.
>
> The MySQL server allows having statements that do return result sets and
> statements that do not return result sets in one multiple statement.
> "
>
You need to scroll down to the middle of the page and read
*Security considerations* and *Example #2*.
--
Norman
Registered Linux user #461062
-Have you been to www.php.net yet?-
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]