What are some best practices for creating a simple customer database in PHP and MySQL?

To create a simple customer database in PHP and MySQL, it is important to follow best practices such as properly sanitizing user input to prevent SQL injections, using prepared statements to prevent SQL injection attacks, and encrypting sensitive data such as passwords before storing them in the database. 

<?php
// Establish a connection to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "customer_database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create a table to store customer information
$sql = "CREATE TABLE customers (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";

if ($conn->query($sql) === TRUE) {
    echo "Table customers created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

$conn->close();
?>

Keywords

PHP MySQL database design SQL injection data validation

Related Questions