How can PHP functions like explode be used to separate and manipulate data stored in a single column in a database?

When data is stored in a single column in a database, it may be necessary to separate and manipulate that data for various purposes. PHP functions like explode can be used to split the data based on a delimiter (such as a comma or space) and then manipulate the resulting array elements as needed. This can be useful for tasks like extracting specific values, rearranging data, or performing calculations on individual pieces of information.

// Assume $data contains the string stored in the database column
$data = "John,Doe,30";

// Explode the data using a comma as the delimiter
$dataArray = explode(",", $data);

// Access individual elements of the array
$firstName = $dataArray[0]; // John
$lastName = $dataArray[1]; // Doe
$age = $dataArray[2]; // 30

// Manipulate the data as needed
$newAge = $age + 5; // Adds 5 to the age

// Update the database with the manipulated data
$newData = $firstName . "," . $lastName . "," . $newAge;
// Update database column with $newData