Skip to content
PHP Logo

How can PHP developers ensure data integrity and prevent manipulation when storing and retrieving data from a database?

To ensure data integrity and prevent manipulation when storing and retrieving data from a database, PHP developers can use prepared statements with parameterized queries. This helps protect against SQL injection attacks by separating SQL logic from user input. Additionally, developers should validate and sanitize user input before inserting it into the database to prevent any malicious code execution.

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

// Prepare a SQL statement with parameters
$stmt = $pdo->prepare("INSERT INTO users (username, password) VALUES (:username, :password)");

// Bind parameters to the statement
$stmt->bindParam(':username', $username);
$stmt->bindParam(':password', $password);

// Sanitize and validate user input
$username = filter_var($_POST['username'], FILTER_SANITIZE_STRING);
$password = password_hash($_POST['password'], PASSWORD_DEFAULT);

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