JS encodeURI（）和PHP urldecode（）之间的不同结果

Question

This is the original string

Apple iPad 2 16GB Wifi + 3G (AT&T)

after js encodeURI()

Apple%20iPad%202%2016GB%20Wifi%20+%203G%20(AT&T)

after PHP urldecode(), via $_GET from AJAX call

Apple iPad 2 16GB Wifi   3G (AT&T)

after inserting into MySQL DB wrapped with single quotes

Apple iPad 2 16GB Wifi   3G (AT

How do I get the original string exactly into database?

Answer 1

You should use encodeURIComponent instead of encodeURI.

Then the string will be Apple%20iPad%202%2016GB%20Wifi%20%2B%203G%20(AT%26T) after encodeURIComponent in JavaScript, which will be converted back to Apple iPad 2 16GB Wifi + 3G (AT&T) with urldecode in PHP.