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 >