How get value from URL

Question

I want to get the value from the URL to choose data from the database by ID  I want the value for the id  For example  if I were to open  www example com index php id 12   I want to get a value whose id   12 in the database  If I open  www example com index php id 7   I want to get the value whose id   7 in the database and so on  I have some code   results   mysql query  quot SELECT   FROM next WHERE id  id quot        while   row   mysql fetch array  results                      url    row  url        echo  url

User · Answer

You can get that value by using the   GET array  So the id value would be stored in   GET  id     So in your case you could store that value in the  id variable as follows    id     GET  id

User · Answer

Website URL   http   www example com  id 2   Code    id   intval   GET  id      results   mysql query  SELECT   FROM next WHERE id  id        while   row   mysql fetch array  results                      url    row  url        echo  url    Outputs  2

User · Answer

You can access those values with the global   GET variable    www example com index php id 7 print   GET  id       prints  7    You should check all  incoming  user data - so here  that  id  is an INT  Don t use it directly in your SQL  vulnerable to SQL injections

User · Answer

You can also get a query string value as    uri      SERVER  REQUEST URI      it will print full url  uriArray   explode       uri     convert string into array with explode  id    uriArray 1     Print first array value

User · Answer

There are two ways to get variable from URL in PHP  When your URL is  http   www example com index php id 7 you can get this id via   GET  id   or   REQUEST  id   command and store in  id variable  Lest s take a look     url is www example com id 7    get id from url via   GET  id   command   id     GET  id    same will be    get id from url via   REQUEST  id   command   id     REQUEST  id    the difference is that variables can be passed to file via URL or via POST method  if variable is passed through url  then you can get it with   GET  variable name   or   REQUEST  variable name   but if variable is posted  then you need to you   POST  variable name   or   REQUEST  variable name   So as you see   REQUEST  variable name   can be used in both ways  P S  Also remember - never do like this   results   mysql query  quot SELECT   FROM next WHERE id  id quot    it may cause MySQL Injection and your database can be hacked  Try to use   results   mysql query  quot SELECT   FROM next WHERE id   quot  mysql real escape string  id   quot   quot

[php] How get value from URL

Examples related to php

Examples related to mysql

Examples related to database

Examples related to url