seperating longtext values

rhiza

[mysql/php] seperating field values

I have a table named customizations, with two fields in this table. One is a varchar(20) user that stores the user name, the other is a longtext options that stores options that the user chooses, seperated by a comma. The reason that this is longtext is so the user can choose any amount of options, and in any order. What I'm wondering is, if I get the value of options in a variable in PHP, how do I seperate/split the values up by the commas?

pete_bisby

$arrayOptions = explode(",", $Options);

The explode() function will place the $Options longtext variable into an array. Simply navigate through the array to view the selected options.

rhiza

awesome, thanks. I was thinking it was something to do with explode.

rhiza

ok - one more question:

I have names of different pages stored in a database, under field options, seperated by a comma. I want to be able to include each stored page. If I change the includes to echos, it outputs the correct page. If I change $array[1]. '.php' to the actual file name, it includes the correct page. But, the only include array element that works is $array[0]. I don't get it.

$array = explode (",", $row['options']);

include $array[0]. '.php';
include $array[1]. '.php';
include $array[2]. '.php';

pete_bisby

Mmm, strange!

I did this as test code and it works fine:

	$options = "test1,test2,test3";
	$arrayOption = explode(",", $options);

include $arrayOption[0] . ".php";
include $arrayOption[1] . ".php";
include $arrayOption[2] . ".php";

The pages test1.php, test2.php, test3.php just echo a string, which appears successfully.

Do the PHP pages that are referenced in the "include" statements exist? Are there any errors within the PHP pages that are "included"?

Test the size of the array, to make sure that the array is being populated:

for ($i=0; $i < sizeof($array); $i++) {
  echo $array[$i];
}

xblue

seperated by a comma

a comma and nothing else, not even a space? a space after each comma might result in the behaviour you described.

just a guess, but if this is the reason, a simple call to trim() should help.

rhiza

Originally posted by xblue
a comma and nothing else, not even a space? a space after each comma might result in the behaviour you described.

just a guess, but if this is the reason, a simple call to trim() should help.

🙂 oops! yeah, i had them seperated by a comma and a space.... thanks a lot