How can SQL injection be prevented in PHP when handling user input?
SQL injection can be prevented in PHP when handling user input by using prepared statements with parameterized queries. This method separates SQL code from user input, preventing malicious SQL code from being executed. By binding parameters to placeholders in the SQL query, the database engine can distinguish between code and data, effectively preventing SQL injection attacks.
// Establish a connection to the database
$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 user input to the parameter
$stmt->bindParam(':username', $_POST['username']);
// Execute the query
$stmt->execute();
// Fetch the results
$results = $stmt->fetchAll();
Related questions
-
PHP file handling fopen
-
AJAX PHP scripts dynamic variables
-
PHP JavaScript data processing