[RESOLVED] need help splitting string and database conversion

deregular

hey guys, been looking at this way too long,
for some reason its not working.

I have an entry in a mysql database field that looks like this:

1x2,3,4 (\r\n)
2x4,5,6 (\r\n)
3x7,8,9 (\r\n)

(each of those ^ are seperated with \r\n )

Having trouble returning each number converted against numbers in my database, I know my database query is correct however the splitting of the returned textarea field has me baffled..
Im only getting back the first line (1x2)

$explodest= explode("\r\n",$stencils);
	foreach($explodest AS $lines){
		list($samnt,$snumbers) = explode("x", $lines);
			echo"".$samnt." x ";

		$explode2= explode(",",$snumbers);

		foreach($explode2 AS $sn){

			/////////////////////////////////
			/////query to database goes here
			/////should return $row1['catnum']
			/////foreach of the numbers
			////////////////////////////////

    		echo"".$row1['catnum'].",";

		}
	echo"<br>";
}

pete_bisby

Does the array $explodest contain the correct data, e.g.:

$explodest[0] = "1x2,3,4";
$explodest[1] = "2x4,5,6";
$explodest[2] = "3x7,8,9";

I've just typed in your code, with $stencils as the following ...

$stencils = "1x2,3,4\r\n2x4,5,6\r\n3x7,8,9\r\n";

... substituted $row1['catnum'] with $sn, and it returns the following ...

Are you sure "\r\n" are present at the end of each line?

deregular

Thats strange, I just did the same as you.. leaving everything there,
but subsituting the variable '$stencils' with a new one

$stencils="".$stencamnt1."x".$stencils1."\r\n".$stencamnt2."x".$stencils2."\r\n".$stencamnt3."x".$stencils3."";

This is the variable that is passed to the page
which creates a mysql input of

1x2,3,4,
2x4,5,6,
3x7,8,9,

That is how it looks in phpmyadmin, I can do a str_replace on the \r\n with <br> and it echos out the same.

But going back and reading it from the original $stencils variable it outputs
something along the lines of 1x2,3, and thats it?

Ill have to have a look at rewriting the variable.

deregular

ok now im getting somewhere.. seems that escaping the string was killing the \r\n

heres what i have now, although it seems to still not be working quite right

$explodest= explode("\n",$stencils);

//split amount from stencil numbers
foreach($explodest AS $lines){
		list($samnt,$snumbers) = explode('x', $lines);
	//echo"".$explodest[0]."<br>"; //outputs 1x1,2,3
	echo"".$samnt." x ";

		//explode stencil list
		$explode2= explode(',',$snumbers);

		//loop through all stencils
		foreach($explode2 AS $sn){

			$stencilsdb1=mysql_query("SELECT catnum FROM $venuedb WHERE vennum='$sn'");
    		$row1=mysql_fetch_array($stencilsdb1);

    		echo"".$row1['catnum'].",";

		}
	echo"<br>";

}

This results in....

1 x 1 ,2 ,,
2 x 4 ,5 ,,
3 x 7 ,8 ,9 ,

This isnt making a lot of sense to me..
If i blank out the mysql query and echo out $sn like you did I am getting correct results also!

(note: i changed the \r\n to just \n ...)

pete_bisby

Now whether phpmyadmin is manipulating the results within your table slightly so it can be viewed via a web browser .... this maybe confusing the issue.

Also, when you run the query "... WHERE vennum='$sn'" ... when $sn equals 3 or 6, do these records exist? It is very strange that it executes correctly for 7 of the inputs, but not those two.

deregular

Fixed it guys...
Seems putting a , comma at the end of each line in the $stencils field worked.
Perhaps the explode function wasnt working correctly and only identifying
x2 of the numbers (re... 1x1,2 instead of 1x1,2,3)

Thanks for your patience.