What common error message might occur when trying to insert data into a MySQL database using PHP?

One common error message that might occur when trying to insert data into a MySQL database using PHP is the "SQLSTATE[HY000]: General error: 1364 Field 'column_name' doesn't have a default value" error. This error typically occurs when trying to insert data into a column that does not allow NULL values and does not have a default value specified. To solve this issue, you can either provide a value for the column in your INSERT query or alter the table structure to allow NULL values or provide a default value for the column.

<?php
// Establish a connection to the MySQL database
$pdo = new PDO('mysql:host=localhost;dbname=database_name', 'username', 'password');

// Prepare the INSERT query with values for all columns
$stmt = $pdo->prepare("INSERT INTO table_name (column1, column2) VALUES (:value1, :value2)");

// Bind the values to the parameters
$stmt->bindParam(':value1', $value1);
$stmt->bindParam(':value2', $value2);

// Assign values to the variables
$value1 = 'value1';
$value2 = 'value2';

// Execute the query
$stmt->execute();
?>