How can array values be properly stored in a database field in PHP?

When storing array values in a database field in PHP, the array needs to be serialized before insertion and unserialized after retrieval. This ensures that the array is stored as a string in the database and can be converted back to an array when needed. 

// Serialize array before insertion
$array = [1, 2, 3];
$serializedArray = serialize($array);

// Insert serialized array into database
$query = "INSERT INTO table_name (array_field) VALUES ('$serializedArray')";

// Retrieve serialized array from database
$query = "SELECT array_field FROM table_name";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$unserializedArray = unserialize($row['array_field']);

Keywords

PHP array values database field storing serialization

Related Questions