What are the advantages of using a database over a CSV file for storing voucher codes and guest information in PHP?

Using a database over a CSV file for storing voucher codes and guest information in PHP offers several advantages, including better data organization, faster data retrieval, improved data security, and the ability to easily query and manipulate the data using SQL. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// Query to insert voucher code and guest information into the database
$voucher_code = "ABC123";
$guest_name = "John Doe";
$email = "johndoe@example.com";

$sql = "INSERT INTO guest_information (voucher_code, guest_name, email) VALUES ('$voucher_code', '$guest_name', '$email')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

Keywords

database CSV file voucher codes guest information PHP

Related Questions