In PHP, how can developers efficiently count the occurrences of specific complications, like "Tumor," within a comma-separated field in a database?

To efficiently count the occurrences of specific complications like "Tumor" within a comma-separated field in a database, developers can use PHP to retrieve the field value, explode it into an array using the comma as a delimiter, and then loop through the array to count the occurrences of the specified complication. 

// Assume $complicationsField contains the comma-separated complications field value from the database
$complications = explode(',', $complicationsField);
$complicationToCount = 'Tumor';
$count = 0;

foreach ($complications as $complication) {
    if (trim($complication) == $complicationToCount) {
        $count++;
    }
}

echo "Occurrences of '$complicationToCount': $count";

Keywords

PHP database count occurrences comma-separated field

Related Questions