implode/explode.....

crawfd

I'm attempting to store integers in a db field (mylist) separated by a '|'. In the scenerio below I'm trying to fetch an integer from my query string (in this case from $_GET[accept], and tack it onto the end. Must I explode the contents of my 'mylist' field first to get existing integers? and if so how would I do so? Thanks

E.g. of mylist field data - '3|5|3|6|6|'
(that's the format I'd like, but currently I only get so far as to post and integer followed by '|'. example, 6|

<?

if(!empty($a1[mylist]))
	{
		$numbers = implode("|", $_GET[accept]);
	} else {

	$numbers = $_GET[accept]."|";		
}

$q1 = "update class_members set mylist = '$numbers' where MemberID = '$_SESSION[MemberID]'";
mysql_query($q1) or die(mysql_error());


?>

zabmilenko

Like this?

$a1['mylist'][] = $_GET['accept'];
$numbers = implode('|', $a1['mylist']);

crawfd

hmm ehh hmm. I get an error that says '[] operator not supported for strings '

Weedpacket

That's because $a1['mylist'] is a string 🙂. Consider using $a1['mylist'] .= $_GET...... but that is a bad way to store a list of integers in a database.

crawfd

I tried .= and seem to be getting an array error. I'm not sure I completely understand the whole logic behind of your reply zabmilenko.

I'm attempting to retrive the array value of $a1['mylist'] and then tack on the GET value FROM the query string and copy it into the $a1['mylist'] field again . I wanna take the value of the get and include it in the array value in $a1['mylist'] in the format of x|x|x|,etc.

...so I'm not sure why $a1['mylist'][] = $_GET['accept'];

Any takers...

zabmilenko

Well, please paste the contents of $a1['mylist'] for us to peruse...

crawfd

the content of the $a1['mylist'] is

So I need to probably explode it, grab the integers in the field and tack on another interger from the GET field if there is one. So let's say there is an interger of 10 in my get query string. Then I'd have

5|10|

Justin

zabmilenko

Ahh. Try this:

$a1array = explode('|', $a1['mylist']);
$a1array[] = $_GET['accept'];
$numbers = implode('|', $a1array);

$q1 = "update class_members set mylist = '$numbers' where MemberID = '$_SESSION[MemberID]'";
    mysql_query($q1) or die(mysql_error());