If I want to get values from my php webservice which is connected to a mysql database with a multiple value string... how should I write it in the url for example.
What I want:
login?next=initial_page?email=(1,2,3)
if the webservice looks something like this:
select * from login where email in (('".$_GET["email"]."'))
is it possible or is there a better way, lets say I would send an array instead, how would I write the php webservice then?
分享 1) If the values are integer then pass it like this way
login?next=initial_page&email=1,2,3
^ // here it should be & not ?
And the query will be
$sql = "select * from login where email in (".$_GET["email"].")";
Note : Escape the string before embedding it in query to prevent SQL injection.
2) Another way is you can post the data in JSON format and at PHP end use json_decode to decode that data and use it in your query.
分享
