What is Query string collection in asp?

[hirewebdesigner]

What is Query string collection in asp?

 

[zebraweb]

Query string collection is retrieving the variable values in HTTP query strings, it is specified by the values following question mark (?)

 

[NathanRidley]

This forum is the ultimate in cream-of-the-crop programming and design-related discussion.

</sarcasm>

Seriously though, this question is the "how is babby made" of the programming world

 

[mattseh]

This forum is the ultimate in cream-of-the-crop programming and design-related discussion.

</sarcasm>

Seriously though, this question is the "how is babby made" of the programming world

we need a mod to ban retards.

 

[jryan21]

I like in these threads how the same certain words are capitalized in the question and the answer.

 

[mofey]

You might try stackoverflow.com next time.

 

[AmazingArticles]

You can pass values to your page in this way.

http://localhost/script/directory/NAMES.ASP?Q=Fred&Q=Sally

And get the values by calling Request.QueryString["Q"] in C#.

 

[shindig]

Works the same as php. My server doesn't support asp so I don't have an example. I do work with C# a lot and would probably love asp because I hate php syntax but it's easier to set up in more environments and is effective.

In my software I grab the mac address off the user's network card, and send it to the server in a URL like this:

http://myDomain.com/adverts/userStats.php?name=001EC946C2F4&adNum=3&playClick=1

where name=mac address, adNum = 3, playClick = 1

I use that url ^^ to update a mysql database, if there is a matching mac address it will update the record with the information in the URL, if there is no matching mac address it will make a new row and populate it with that data.

userStats.php:

<?php 
  $db = mysql_connect('localhost', 'username', 'password') or die('Could not connect: ' . mysql_error()); 
$db_selected= mysql_select_db("databaseName", $db);
if (!$db_selected)
  {
  die ("Can\'t use test_db : " . mysql_error());
  }  
        $name = mysql_real_escape_string($_GET['name']); 
        $date = date("d/m/Y");
        $adClick =($_GET['adNum']);
        $playN = ($_GET['playClick']);

$query = "INSERT INTO playerData (mac,date,adClick,playNum) VALUES ('$name', '$date','$adClick','$playN') ON DUPLICATE KEY UPDATE playNum = playNum+$playN, adClick = adClick + $adClick;";
$results = mysql_query($query, $db);

echo "$query";
mysql_close($db);
?>