Re: mysql prepared statements

From: Date: Sat, 27 Oct 2001 03:11:55 +0000
Subject: Re: mysql prepared statements
References: 1 2  Groups: php.dev 
Request: Send a blank email to php-dev+get-69108@lists.php.net to get a copy of this message 
im working on this. contact me via email if you'd like to help...

Andrew Watson <gleep@cfl.rr.com> wrote in message
news:5.1.0.14.0.20011026220832.00a20c40@pop-server...
>
> 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.
>

Thread (5 messages)

« previous php.dev (#69108) next »