Re: [PHP-DEV] mysql prepared statements

2001-10-26 Thread l0t3k
im working on this. contact me via email if you'd like to help... Andrew Watson <[EMAIL PROTECTED]> wrote in message 5.1.0.14.0.20011026220832.00a20c40@pop-server">news:5.1.0.14.0.20011026220832.00a20c40@pop-server... > > for example in PERL DBD::mysql you can prepare statements like so: > > $sql

Re: [PHP-DEV] mysql prepared statements

2001-10-26 Thread Rasmus Lerdorf
Ok, well prepared statements to me mean that the SQL engine has pre-compiled the SQL which is something MySQL doesn't support. If all you want is an easier way to manage your queries using placeholders it seems like a pretty trivial little thing to do in user space. eg. function execute

Re: [PHP-DEV] mysql prepared statements

2001-10-26 Thread Andrew Watson
for example in PERL DBD::mysql you can prepare statements like so: $sql = "update user_list set first_name = ? where id = ?" $han = $dbh->prepare($sql); $han->execute('andrew',1); $han->execute('bill',2); this is a very useful thing that's implemented in a lot of different languages (PER

Re: [PHP-DEV] mysql prepared statements

2001-10-26 Thread Rasmus Lerdorf
> i'd like to get people's feedback on the possibility/ feasibility of > implementing prepared statements in php for atleast MySQL and perhaps > more. i'm new to the list, so maybe you've already discussed this. i'd > like to start developing something like this soon unless someone else is >

[PHP-DEV] mysql prepared statements

2001-10-26 Thread andrew watson
i'd like to get people's feedback on the possibility/ feasibility of implementing prepared statements in php for atleast MySQL and perhaps more. i'm new to the list, so maybe you've already discussed this. i'd like to start developing something like this soon unless someone else is already w