How can multiple values (checkbox or select list with multiple values) be stored in a single field in a database using PHP?

When storing multiple values (checkbox or select list with multiple values) in a single field in a database using PHP, you can serialize the array of values before storing it and unserialize it when retrieving it. This allows you to store and retrieve multiple values as a single string in the database. 

// Serialize array of values before storing in the database
$selectedValues = ['value1', 'value2', 'value3'];
$serializedValues = serialize($selectedValues);

// Store $serializedValues in the database

// Retrieve $serializedValues from the database
$selectedValues = unserialize($serializedValues);

// $selectedValues will now be an array containing the selected values

Keywords

PHP MySQL database multiple values serialization

Related Questions