How can PHP beginners ensure they are properly passing values of 0 or 1 for active or inactive states in a MySQL database?

When working with active or inactive states in a MySQL database, PHP beginners can ensure they are properly passing values of 0 or 1 by using prepared statements with placeholders. This helps prevent SQL injection and ensures the correct data type is passed to the database. By binding the parameter values to the placeholders, the values of 0 or 1 can be safely passed to the database. 

// Establish a database connection
$connection = new mysqli("localhost", "username", "password", "database");

// Prepare a SQL statement with a placeholder for the active state
$stmt = $connection->prepare("INSERT INTO table_name (active) VALUES (?)");

// Bind the parameter value (0 or 1) to the placeholder
$stmt->bind_param("i", $active);

// Set the value of $active (0 or 1)
$active = 1;

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

// Close the statement and connection
$stmt->close();
$connection->close();

Keywords

PHP MySQL database values boolean

Related Questions