[SOLVED] Passing variable via url

[dodgei]

I'm saving the variables that I retrieve from the database into a link so that it can be passed to the next page.

 

My problem is that the 'Merchant' field sometimes contains multiple words. When I try to set the contents of the

'Merchant' field into the url, it is only setting the first word.

 

while($r = @odbc_fetch_array($results)) 
{
     echo "<tr><td>".$r['EntryID']."</td>";
 $alldate=substr($r['DueDate'],0,2).'.'.substr($r['DueDate'],2,2).'.'.substr($r['DueDate'],4,4);
 echo "<td>".$alldate."</td>";
 echo "<td>".$r['Merchant']."</td>";
 echo "<td>".$r['Amount']."</td>";
 echo "<td>".$r['Status']."</td>";
 echo "<td><a href=http://www.merediencapital.com/ada/makepay.php?action=pay
&row_id=" . $r['EntryID']."&merchant=". $r['Merchant']."&duedate=".$r['DueDate']."
&amount=".$r['Amount'].">Payment</a></td>";
     echo "<td><a href=" . $_SERVER['PHP_SELF'] . "?action=delete&row_id=" . $r['EntryID'].">delete</a></td></tr>";	  
}

 

How can I fix this?

[ted_chou12]

yeah, as long as there are no line breaks, like:

test

test

this is a line break, this wont work, but spaces dont matter.

Ted

[dodgei]

This is the link that it creates when there are 2 words in the 'Merchant' field,

 

http://www.merediencapital.com/ada/makepay.php?action=pay&row_id=22&merchant=Western

 

The value of the field is 'Western Printing'. And this is displayed when I use odbc to just echo the

contents of that field.

 

Why does it stop when it hits the space?

[ted_chou12]

as far as i tried, the word space doesnt matter, but if that is the case for you, you can try replacing the space with some special string like "EGIEG" using str_replace() and use the same fuction to replace the special string back with space after passing through the url, in that way, you wont have this problem then.

[dodgei]

The problem was that the url cannot contains spaces so this is the function that will enable variables with spaces

to be passed by the url.

 

urlencode()