PHP MYSQL Save search query into database

Question

I have search on my site where user can search in titles, description and select categories.

I wont to save the search into database but only if user wonts to save it.

This is my link which save into database. domain.com/save/?action=save&reference=SEARCH_QUERY.

but because i have title&description&cat.

It stop at & save the first part of the query.

How can i save this in to database including the & as i need to get this back so user can go back to save search query later on.

I have used htmlentities and htmlspecial but still it turns into & but first char is &.

try urlencode and then urldecode when you got to use the saved query. — prodigitalson
– prodigitalson, Commented Dec 21, 2010 at 22:32

Jonathan · Accepted Answer · 2010-12-21 22:31:38Z

1

Sounds like you need urlencode:

echo urlencode('title=t&description=d&cat=c');

results in

title%3Dt%26description%3Dd%26cat%3Dc

answered Dec 21, 2010 at 22:31

Jonathan

6,0031 gold badge30 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HoLyVieR · Accepted Answer · 2010-12-21 22:30:36Z

1

You need to use urlencode to encode parameter that are passed in the URL.

htmlentities and htmlspecialchars are function that are used to espace string that will end up in HTML code, not in URL.

answered Dec 21, 2010 at 22:30

HoLyVieR

11.1k5 gold badges44 silver badges67 bronze badges

Brad Christie · Accepted Answer · 2010-12-21 22:30:43Z

0

Maybe you're looking for urlencode?

answered Dec 21, 2010 at 22:30

Brad Christie

102k16 gold badges160 silver badges200 bronze badges