Terminology Index

Glossary

1801 terms

Open concept maps

Showing 1121-1152 of 1801 terms

O
8
P
24

Parameterized Queries

A coding technique that separates SQL code from user-supplied data by using placeholders bound to values, so input cannot be interpreted as commands, the primary defense against SQL injection.

Parameterized queries (prepared statements) send the SQL structure and the data separately, with placeholders the database binds to user input as pure values, never as executable code. This makes SQL injection essentially impossible because attacker input can't change the query's meaning. It is the recommended, robust defense for database access, far stronger than trying to sanitize or escape input by hand, and a foundational secure-coding practice for any application that queries a database.

Introduced in: Defensive Web Fundamentals

Examples

  • Binding a user's input to a query placeholder rather than concatenating it.
  • Using prepared statements so input can't alter a query's structure.
  • Defending against SQL injection with parameterized queries.

No related terms linked yet.