How can a PHP developer store multiple values from a form select field into a database?

When storing multiple values from a form select field into a database, you can serialize the array of selected values before saving it. This way, you can store all the selected values as a single string in a database column. When retrieving the data, you can unserialize the string back into an array to access the individual values. 

// Serialize the array of selected values before saving it to the database
$selectedValues = $_POST['select_field'];
$serializedValues = serialize($selectedValues);

// Save the serialized values to the database
$query = "INSERT INTO table_name (selected_values) VALUES ('$serializedValues')";
// Execute the query

// Retrieve the serialized values from the database
$query = "SELECT selected_values FROM table_name WHERE id = $id";
// Execute the query
$row = mysqli_fetch_assoc($result);

// Unserialize the values to access the individual selected values
$selectedValues = unserialize($row['selected_values']);

Keywords

PHP form select field database values

Related Questions