decoration decoration
Stories

GROKLAW
When you want to know more...
decoration
For layout only
Home
Archives
Site Map
Search
About Groklaw
Awards
Legal Research
Timelines
ApplevSamsung
ApplevSamsung p.2
ArchiveExplorer
Autozone
Bilski
Cases
Cast: Lawyers
Comes v. MS
Contracts/Documents
Courts
DRM
Gordon v MS
GPL
Grokdoc
HTML How To
IPI v RH
IV v. Google
Legal Docs
Lodsys
MS Litigations
MSvB&N
News Picks
Novell v. MS
Novell-MS Deal
ODF/OOXML
OOXML Appeals
OraclevGoogle
Patents
ProjectMonterey
Psystar
Quote Database
Red Hat v SCO
Salus Book
SCEA v Hotz
SCO Appeals
SCO Bankruptcy
SCO Financials
SCO Overview
SCO v IBM
SCO v Novell
SCO:Soup2Nuts
SCOsource
Sean Daly
Software Patents
Switch to Linux
Transcripts
Unix Books

Gear

Groklaw Gear

Click here to send an email to the editor of this weblog.


You won't find me on Facebook


Donate

Donate Paypal


No Legal Advice

The information on Groklaw is not intended to constitute legal advice. While Mark is a lawyer and he has asked other lawyers and law students to contribute articles, all of these articles are offered to help educate, not to provide specific legal advice. They are not your lawyers.

Here's Groklaw's comments policy.


What's New

STORIES
No new stories

COMMENTS last 48 hrs
No new comments


Sponsors

Hosting:
hosted by ibiblio

On servers donated to ibiblio by AMD.

Webmaster
Prepared statements don't | 248 comments | Create New Account
Comments belong to whoever posts them. Please notify us of inappropriate comments.
Prepared statements ...
Authored by: Anonymous on Wednesday, August 22 2012 @ 02:26 PM EDT
Only problem is that 'My first book of PHP and MySQL'* does not necessarily
cover prepared statements nor salting of passwords before hashing.

* supposed to be fictitious. If there is one and the statement does not fit
then I apologize in advance.

[ Reply to This | Parent | # ]

Prepared statements don't
Authored by: jesse on Thursday, August 23 2012 @ 07:08 AM EDT
handle pattern matches.

They don't handle dynamic query phrases either (and I mean the "where"
clause).

They don't handle optimizations....

They DO handle static queries (constant where clause) quite well.

The usual problem is that prepared statements are always discussed with
"advanced features" and "optimized retrieval" where the
entire select line is relatively static, substituting only for variable values.

Yes, they can be used in other circumstances, and personally, I don't think any
other way SHOULD BE AVAILABLE.

One of the problems with that is that (from the vendors) this is an
"optimized query".

[ Reply to This | Parent | # ]

Groklaw © Copyright 2003-2013 Pamela Jones.
All trademarks and copyrights on this page are owned by their respective owners.
Comments are owned by the individual posters.

PJ's articles are licensed under a Creative Commons License. ( Details )