Accessing Query Strings?

matthurne

I know this is a simple problem but I don't really know jack about PHP yet. Really though, this should work...I request the page with this url:

mysqltest4.php?id=0

Then in the php script I have tried to access 'id' by both of these methods:

1) $id
2) $_GET['id']

Neither is working! I know $id doesn't work because of a setting in php.ini, but I'm advised to leave it that way for security reasons. the $_GET[] method is the only alternative I have found. Why isn't it working?

rIkLuNd

maybe you have an old version of php, and then you'll have to use
$HTTP_GET_VARS['id']...

matthurne

Actually, I'm using 4.3. Isn't that the latest release?

riffy

can u post ure code?

matthurne

<?php
$db = mysql_connect("localhost", "root", "mysqlonnow");
mysql_select_db("test",$db);
// display individual record
if ($_GET['id'])
{
$result = mysql_query("SELECT FROM employees WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("First name: %s\n ", $myrow["first"]);
printf("Last name: %s\n ", $myrow["last"]);
printf("Address: %s\n ", $myrow["address"]);
printf("Position: %s\n ", $myrow["position"]);
}
else
{
// show employee list
$result = mysql_query("SELECT FROM employees",$db);
if ($myrow = mysql_fetch_array($result))
{
// display list if there are records to display
do
{
printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]);
} while ($myrow = mysql_fetch_array($result));
}
else
{
// no records to display
echo "Sorry, no records were found!";
}
}
?>

rIkLuNd

usually there aren't any objects in a table with the id 0...

matthurne

I assure you, in my table there is.

rIkLuNd

Not sure that it will work, but try this code:

<?php 
$db = mysql_connect("localhost", "root", "mysqlonnow"); 
mysql_select_db("test",$db); 
// display individual record 
if ($_GET['id']) 
{ 
 $result = mysql_query("SELECT * FROM employees WHERE id='".$_GET['id']."'",$db); 
 $myrow = mysql_fetch_array($result,1); 
 printf("First name: %s\n<br>", $myrow['first']); 
 printf("Last name: %s\n<br>", $myrow['last']); 
 printf("Address: %s\n<br>", $myrow['address']); 
 printf("Position: %s\n<br>", $myrow['position']); 
} 
else 
{ 
 // show employee list 
 $result = mysql_query("SELECT * FROM employees",$db); 
 if (mysql_num_rows($result) > 0)
 {
  // display list if there are records to display  

  while($myrow = mysql_fetch_array($result,1))
  {
    printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]); 
  }
 } 
 else 
 { 
  // no records to display 
  echo "Sorry, no records were found!"; 
 } 
} 
?>

matthurne

No cigar. I'm baffled and frustrated.

matthurne

I made some headway just now. I changed the id=0 to id=1 in the URL. I also changed the id of my first row in my table to 1 rather than 0. It displayed everything properly. My guess is that when the script reads $_GET['id'] and id=0 it returns FALSE because 0 is the equivalent to FALSE. Am I right?