ProAnswers.org

How do I prevent SQL injection in PHP?

Use PDO and prepared queries.

($conn is a PDO object)

$stmt = $conn->prepare(“INSERT INTO tbl VALUES(:id, :name)”);
$stmt->bindValue(’:id’, $id);
$stmt->bindValue(’:name’, $name);
$stmt->execute();