mysqli_prepare

Can you use the mysqli_prepare function to UPDATE MySQL or is it
just limited to an INSERT statement?

For example.
$stmt = mysqli_prepare($db, 'UPDATE proj_overview SET proj_id = ?,
proj_name = ?, ...

and so on...
mysqli_stmt_bind_para...
mysqli_stmt_execute...

Thanks,
CH
____________________________________
Craig Hoffman
IM / iChat: m0untaind0g
____________________________________

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysqli_prepare

------=_Part_8823_27111831.1176157483042
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

yes, just be sure to follow the syntax on using INSERT

...... UPDATE db_table SET column = 'item' . . . . where ID = 'what you are
updating' . .

i still work in 4.2, so can some vertify this works for 5.0 as well?

On 4/9/07, Craig Hoffman wrote:
>
> Can you use the mysqli_prepare function to UPDATE MySQL or is it
> just limited to an INSERT statement?
>
> For example.
> $stmt = mysqli_prepare($db, 'UPDATE proj_overview SET proj_id = ?,
> proj_name = ?, ...
>
> and so on...
> mysqli_stmt_bind_para...
> mysqli_stmt_execute...
>
> Thanks,
> CH
> ____________________________________
> Craig Hoffman
> IM / iChat: m0untaind0g
> ____________________________________
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

------=_Part_8823_27111831.1176157483042--

Re: mysqli_prepare

Craig Hoffman wrote:
> Can you use the mysqli_prepare function to UPDATE MySQL or is it just
> limited to an INSERT statement?
>

mysqli_prepare works for mostly all statements, except
calling stored procedures, create commands and several show commands.

Full support is planned (and partially integrated already)

/Georg

--
Georg Richter, Development Manager - Connectors & Client Connectivity
MySQL GmbH, Radlkoferstr. 2, D-81373 München, www.mysql.com
Geschäftsführer: Hans von Bell, Kaj Arnö - HRB München 162140

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysqli_prepare

------=_Part_13703_29228208.1176330538758
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

yes, georg is correct, i made a type saying INSERT when I really meant
UPDATE. my apologies.

On 4/11/07, Georg Richter wrote:
>
> Craig Hoffman wrote:
> > Can you use the mysqli_prepare function to UPDATE MySQL or is it just
> > limited to an INSERT statement?
> >
>
> mysqli_prepare works for mostly all statements, except
> calling stored procedures, create commands and several show commands.
>
> Full support is planned (and partially integrated already)
>
> /Georg
>
> --
> Georg Richter, Development Manager - Connectors & Client Connectivity
> MySQL GmbH, Radlkoferstr. 2, D-81373 München, www.mysql.com
> Geschäftsführer: Hans von Bell, Kaj Arnö - HRB München 162140
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

------=_Part_13703_29228208.1176330538758--