passing value to different page

rose

hie..

i'm facing some problems in my php coding. the case is like this :

i have a page home.php which has a dropdown menu for the user to select an institution and a Go button. once the user selects an option, a new page named institution.php will be opened which will display information about the institution which was selected previously. i do not want to have different pages for each institution, so that's why i have one page to display the information according to the option selected in home.php. the problem is, when the user selects an option and click Go, the institution.php doesn't show any data from the db about the institution selected, not even the images that i have. can anyone tell me what's wrong?

home.php :

<?php

$inst = $_POST['inst'];

//////// populates dropdown
///////////////////////////////////////////////////////////////////////////
  $query = sprintf("SELECT * FROM institution");
  $result = @mysql_query($query);
  $row = mysql_fetch_array($result);
///////////////////////////////////////////////////////////////////////////

if($inst){
//////// gets record id to pass to next page
///////////////////////////////////////////////////////////////////////////
  $query = sprintf("SELECT * FROM institution where Inst_Id= '$inst'");
  $result = @mysql_query($query);
  $row = mysql_fetch_array($result);

  if($inst){

 //////// do the redirection here
 header("location:institution.php?id=$inst"); 
 exit;

  }

///////////////////////////////////////////////////////////////////////////
}


?>

<html>
<head>
<title>:: Welcome ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>
<body>

<form name="form1" method="post" action='home.php'>
  <select name="inst">
    <option value="" selected>Select Institution</option>
     <?php do { ?>
<option value="<?php echo $row['Inst_Id']; ?>"><?php echo $row['InstName']; ?></option>
     <?php } while ($row = mysql_fetch_array($result)); ?>
  </select>
  <input name="Go" type="submit" id="Go" value="Go">
</form>

</body>
</html>

institution.php :

<?php

if(isset($GET['id']))
 {
     $id = $GET['id'];

  $query = sprintf("SELECT * FROM institution where Inst_Id = '$id'");
  $result = @mysql_query($query);
  $row = @mysql_fetch_array($result);
 }
?>

<html>
<head>
<title>:: Institution ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>

<table width="60%" height="386" border="2" cellpadding="2" cellspacing="2">
  <tr>
    <td><?php echo '<img src="images/'.$row['pic_name'].'">';  ?></td>
  </tr>
  <tr>
    <td><?php echo $row['Inst_FullName']; ?></td>
  </tr>
  <tr>
    <td><?php echo $row['Street'].$row['City'].$row['Postcode'].$row['State']; ?></td>
  </tr>
  <tr>
    <td><?php echo $row['Description']; ?></td>
  </tr>
</table>

<p>To make reservation :

<?php if(isset($_SESSION['userid'])) { ?>
<a href="reservation.php?id=<?php echo $row['Inst_Id']; ?>">Click here</a>
<?php } else { ?>
<a href="login.php">Click here</a>
<?php } ?>

</body>
</html>

jignesh1

u r suppose to have $_GET instead of $GET

Will_Poulson

When troubleshooting try echoing out your $sql before you send it to the database, that way you can test for typos, and missing data, like that $_GET problem.

Our you can check for results by:

echo "<pre>";

print_r($row);

echo "</pre>";

rose

hie jignesh,

thanks for the correction you have made, after changing to $_GET, i can see my results already. thanks alot.

hie will,

thanks for your reply. if you don't mind, could you please explain to me briefly what are the meaning of these :

[QUOTE]Our you can check for results by:

echo "<pre>";

print_r($row);

echo "</pre>";[/QUOTE]

Will_Poulson

Sure,

the html tag <pre> is a formatting command that tells the browser that the text that is about to appear is already formatted, ie to pay attention to the 'whitespace' and 'eol' (end of lines) in between the words.

The php function: print_r($your_array);

echos out a formatted display of the contents of your array.

Put them together and you get a pretty display of all the information in your results array.

Great for checking on missing data, typos, all that jazz.

oh, almost forgot, if you are going to do a foreach loop through the array after a print_r, your have to reset the array back to the beginning, so:

print_r($some other array);

reset($some_other_array);

This doesn't matter for what you are doing today, but if you keep using print_r it will come back to bite you.

-- Will

rose

hey will,

thank you so so much for your help. i have gained my knowledge on this now. really appreciate it. thanks alot once again 🙂

bradgrafelman

Don't forget to mark this thread resolved (if it is).

mzanimephp

I think phpbuilder should allow moderators to mark threads as resolved. Because people sure as hell don't do it.

bradgrafelman

mzanimephp wrote:
I think phpbuilder should allow moderators to mark threads as resolved.

We do. But why would I want to go around marking threads resolved when it would be better to educate the uneducated about the "Mark Thread Resolved" feature?