Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
CRITICAL SECURITY VERSION UPDATE:
https://github.com/daylightstudio/FUEL-CMS/releases/tag/1.4.13
https://github.com/daylightstudio/FUEL-CMS/releases/tag/1.4.13
Capturing Line Breaks for a Site Variable
Hi,
Come across a need to store line breaks in a Site Variable stored in Fuel. Would like to know the approach I should take. The use case is for storing a set of dropdown values in a Site Variable field where each value is separated by a newline or line break. I would like to pull the Site Variable down in code and then explode it in php to create an array using the newline as the separator. This array can then be used to populate the dropdown with the values in the Site Variable.
The code looks like this:
Only problem is that it appears the MySQL text fields don't support storing newlines. Is there a way I can force newlines to be saved with a mod to Fuel, or do I have to choose a different mysql field data type? Would like to not have to go that route, since you guys have good reason for using the text field for Site Variables.
Thanks!
Erik
Come across a need to store line breaks in a Site Variable stored in Fuel. Would like to know the approach I should take. The use case is for storing a set of dropdown values in a Site Variable field where each value is separated by a newline or line break. I would like to pull the Site Variable down in code and then explode it in php to create an array using the newline as the separator. This array can then be used to populate the dropdown with the values in the Site Variable.
The code looks like this:
$this->load->module_model(FUEL_FOLDER, 'sitevariables_model');
$referralCodes = $this->sitevariables_model->find_one(array('name' => 'Referral Codes'));
if(isset($referralCodes->value))
{
$referralCodes = explode('/n', $referralCodes->value);
foreach($referralCodes as $referralCode)
{
$referralCodes[$referralCode] = $referralCode;
}
return $referralCodes;
}Only problem is that it appears the MySQL text fields don't support storing newlines. Is there a way I can force newlines to be saved with a mod to Fuel, or do I have to choose a different mysql field data type? Would like to not have to go that route, since you guys have good reason for using the text field for Site Variables.
Thanks!
Erik
Comments
$referralCodes = explode("\n", $referralCodes->value);