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() {
$argc = func_num_args(); $args = func_get_args();
$parts = explode('?',$args[0]);
for($i=1,$sql=$parts[0];$i<count($parts);$i++) {
$str = (gettype($args[$i])=='string') ? ("'".addslashes($args[$i])."'") :
$args[$i];
$sql.=$str.$parts[$i];
}
return $sql;
}
$sql = "update user_list set first_name = ? where id = ?";
echo execute($sql,'andrew',1);
Try running that little 60-second hack job. Seems to do most of what you
just described. Put another 10 minutes of work into it and you are there.
-Rasmus
> 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 (PERL, Java... )and i thought people might get a lot of use out
> of it in php...
> it abstracts the details of escaping strings, enclosing them in single
> quotes, and type checking from the developer to make things easier. it
> also speeds up execution in some circumstances.
>
>
> At 06:59 PM 10/26/01 -0700, you wrote:
> > > 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 working on it. thanks!
> >
> >Prepared statements isn't something you implement in a scripting language.
> >It is something that needs to be implemented in the SQL server itself.
> >What exactly would you be "preparing" in PHP space?
> >
> >-Rasmus
>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
