How can PHP developers prevent SQL injections when interacting with databases?

To prevent SQL injections when interacting with databases in PHP, developers should use prepared statements with parameterized queries. This method ensures that user input is treated as data rather than executable code, making it impossible for malicious SQL code to be injected into the query. 

// Establish a database connection
$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

// Prepare a SQL statement with a parameterized query
$stmt = $pdo->prepare('SELECT * FROM users WHERE username = :username');

// Bind the parameter value to the query
$stmt->bindParam(':username', $_POST['username']);

// Execute the query
$stmt->execute();

// Fetch the results
$results = $stmt->fetchAll();

Keywords

SQL injection prepared statements parameterized queries PDO mysqli_prepare

Related Questions