Skip to content
PHP Logo

How can PHP developers ensure data consistency when storing boolean values in a MySQL database?

When storing boolean values in a MySQL database, PHP developers can ensure data consistency by using the TINYINT data type in MySQL to represent boolean values as 0 (false) or 1 (true). This ensures that only valid boolean values are stored in the database and prevents any unexpected data from being saved.

php
// Example code snippet to ensure data consistency when storing boolean values in MySQL

// Connect to MySQL database
$connection = new mysqli('localhost', 'username', 'password', 'database');

// Define boolean value
$booleanValue = true;

// Convert boolean value to integer (0 or 1)
$intValue = $booleanValue ? 1 : 0;

// Prepare SQL query to insert boolean value into database
$query = "INSERT INTO table_name (boolean_column) VALUES ($intValue)";

// Execute SQL query
$connection->query($query);

// Close database connection
$connection->close();