how can i retrieve the record from the database

milo_pantig

i got problem getting the record for example the value of the field $m_category = Kids and Teens.
When i retrive the Category and pass in the url i got only the Value of "Kids" instead of "Kids and Teens".
I use the function htmlspecialchars but it doesnt work;

heres the error part of the codes --> m_cat=<? echo $m_category?> <-- the retrieving of records $m_category is not complete
m_cat = "Kids and Teens" not m_cat = "Kids";

heres the complete code!!!!!

$q=mysql_query("Select * from main_category order by m_id");
while($row=mysql_fetch_array($q)) {
extract($row);
?>
<tr>
<td ><? echo $m_id."   ".$m_category;?></td>
<td><div align="right"><a href=add_main_cat.php?m_edit=<? echo $m_id?>>Add Sub Category </a> - <a href=add_main_cat.php?m_edit=<? echo $m_id?>&&m_cat=<? echo $m_category?>>Edit</a> - <a href=add_main_cat.php?m_delete=<? echo $m_id?>>Delete</a></div></td>
</tr>
<?
}
?>

thanks,

Milo

bpat1434

That's because you're not encoding the " " as %20 (the html entity). For that, you should use: [man]htmlentities/man. Then you can pass that value properly.

Don't forget to use html_entites_decode() on the opposite side too.

~Brett

Weedpacket

You're also supposed to be quoting the values of your attributes: i.e., <a href="...">

You won't need to use html_decode_entities on the other side; properly-encoded strings are decoded automatically.

milo_pantig

heres my code

echo "<td><a href=view.php?m_id=".$m_id."&&m_cat=".htmlentities($m_category).">". $m_category ."</a>";

thanks

milo_pantig

and also this 🙂

					echo "<td><a href=view.php?m_id=".$m_id."&&m_cat=".htmlentities($m_category,ENT_QUOTES).">". $m_category ."</a>";

the value of m_cat = still not exact some string is missing it shoud be "Kids and Teens" not "kids"

thanks

milo_pantig

echo "<td><a href='view.php?m_id=".$m_id."&&m_cat=".htmlentities($m_category,ENT_QUOTES)."'>". $m_category ."</a>";

milo_pantig

Originally posted by Weedpacket
You're also supposed to be quoting the values of your attributes: i.e., <a href="...">

You won't need to use html_decode_entities on the other side; properly-encoded strings are decoded automatically.

milo_pantig

Originally posted by bpat1434
That's because you're not encoding the " " as %20 (the html entity). For that, you should use: [man]htmlentities/man. Then you can pass that value properly.

Don't forget to use html_entites_decode() on the opposite side too.

~Brett