What's the advantage and use of prepared statements in PHP

Question

Possible Duplicate:
PHP PDO prepared statements
prepared statements - are they necessary*

Recently, heard about php prepared statements. Nearly all hi-rep php developers use php prepared statements. Can anyone explain me what's the main advantage and use of php prepared statements?

probably you are talking about **prepared statements** which are not *php statements* — Maxim Krizhanovsky, Sep 27 '11 at 12:01

score 3 · Accepted Answer · edited May 23 '17 at 10:26

3

Prepared statements allow you to make multiple similar queries more efficiently. You can prepare (for example) an insert statement, then loop over it with multiple bits of data and get a performance boost as the database has less work to do as it doesn't have to set it up each time.

As a side effect, people using prepared statements tend to use bound parameters too, and these provide protection from SQL injection.

edited May 23 '17 at 10:26

Community

1
1

answered Sep 27 '11 at 12:08

Quentin

914,110
126
1,211
1,335

1

A good programmer should avoid running multiple similar queries, shouldn't they? – Your Common Sense Sep 27 '11 at 12:50

What's the advantage and use of prepared statements in PHP

1 Answers1