Oracle Database 10g Express Edition PHP Web Programming

Querying and Transacting Using SQL Statements

The use of static SQL statements has practical limitations. It is impossible to know what your end users will select, insert, update, and delete in your web applications. You need the ability to collect inputs and dynamically search and insert data into your application. You need some type of substitution variable method to have this flexibility.

Oracle bind variables act like substitution variables. They are Oracle structures that let you pass scalar variables into and out of SQL statements and PL/SQL statements in your PHP programs. Bind variables also let you move data across memory spaces. In PHP programs bind variables let you seamlessly pass a PHP variable to Oracle and vice versa.

This section ...