Using $_GET

[KingPuyol]

Originally Posted by harmor19

PHP Code:

if($_GET['act'] == "mods")
{
   echo "List mods";

   if($_GET['do'] == "download")
   {
       echo "download mod ID: ".$_GET['modid'];
   }
} 


Thanks, I really appreciate it, and the "List mods" will be shown everywhere isn't it?

Originally Posted by AN-net

if($_REQUEST['modid'] == 46)
{
do something;
}
if($_REQUEST['page'] == "home)
{
do something else;
}

please though run your data through the vbulletin GPC if your using vbulletin or sanatize incoming data.

What's the difference between $_GET and $_REQUEST?

[harmor19]

$_REQUEST can be used as both $_POST and $_GET

[KingPuyol]

Thanks for the reply

[Paul M]

Perhaps you should start by reading about php, these are pretty basic questions covered by any php online manual or book.

[KingPuyol]

Originally Posted by Paul M

Perhaps you should start by reading about php, these are pretty basic questions covered by any php online manual or book.

I actually know these stuff but they didn't work at the first place for some typo mistakes, that's why I asked.

I just have one more question:

If I had a MySQL table called players:

ID   -   Player
1    -    John
2    -    Paul
3    -    Puyol

By using $_GET, how can I set the value of "$playername" to the player name in the database according to the ID.

For example, if someone opened index.php like:
index.php?id=1, then I want the $playername to be set to John, and if ?id=2 then to be set to Paul, then if ?id=3 then to be set as Puyol. According to what's on the database.

[ragtek]

Originally Posted by Paul M

Perhaps you should start by reading about php, these are pretty basic questions covered by any php online manual or book.

as paul says
start reading about php and mysql
or look into the tutorials

https://vborg.vbsupport.ru/forumdisplay.php?f=184

[KingPuyol]

Originally Posted by ragtek

as paul says
start reading about php and mysql
or look into the tutorials

https://vborg.vbsupport.ru/forumdisplay.php?f=184

I know what he said and I couldn't find it because what I want to do is lots of combination of codes and I've read lots and lots of php tutorial and I can't waste some time in finding this answer, so if anyone can be kind enough in giving me the answer please.

[RedTyger]

You would use something like

SELECT *
FROM yourdb
WHERE id='" . $_REQUEST['id'] . ''

In this case I'd also use strlen and is_numeric to check that it's only a number and it's very short character sequence being requested, or some other failsafing of your choice. Note the use of REQUEST and not GET, when using vBulletin you should always use REQUEST and not GET.

Originally Posted by harmor19

$_REQUEST can be used as both $_POST and $_GET

That's not strictly speaking true, $_REQUEST is a combination of both. It's not a case of "can be used" as you don't have a choice.

[thincom2000]

I'm pretty sure you would want to clean the variables before doing something like that.

Originally Posted by thincom2000

I'm pretty sure you would want to clean the variables before doing something like that.

Yes, always clean global variables $_POST, $_GET, and $_REQUEST with vBulletin's built in cleanser:

https://vborg.vbsupport.ru/showthread.php?t=119372