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.
// 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();
Related questions
-
PHP date() gmdate()
-
session fixation session hijacking session_regenerate_id
-
PHP functions pp_db_insert