Calling for data to be displayed using the URL

kyleldi · July 31, 2007

Hi, I'm having a problem getting my code to pull the appropriate information when I call for it via URL. (example: http://..../.php?id=2). For some reason I can't get it to pull the information for ID #2 (or any ID over 1) and input that information into my dynamic page. No matter what ID i type, or even if I neglect to type in an ID to begin with, it displays the same information. What am I doing wrong? The entire code for my page is pasted below. If anyone could help I would be grateful. I know there's something simple i'm over looking, but I can't figure out what. It connects and downloads the information for ID #1 if I remove $_GET and replace it w/ $row_StaffDirectory, but this is where it only pulls information for ID #1 and no other, no matter which ID I call it from in the URL. Any ideas?

Thanks,

The Code:

<?php require_once('Connections/StaffDirectory.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

mysql_select_db($database_StaffDirectory, $StaffDirectory);

$query_StaffDirectory = "SELECT * FROM staffdirectory";

$StaffDirectory = mysql_query($query_StaffDirectory, $StaffDirectory) or die(mysql_error());

$row_StaffDirectory = mysql_fetch_assoc($StaffDirectory);

$totalRows_StaffDirectory = mysql_num_rows($StaffDirectory);

$result = mysql_fetch_assoc($StaffDirectory);

$ID = $_GET['id'] ;

$ID = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($ID) : mysql_escape_string($ID);

if (isset($ID)) //this is looking at a specific ID

{

$query_StaffDirectory="SELECT * from staffdirectory where id='$ID'";

//$ID is the number after the ID= in your browser

$query_StaffDirectory=mysql_query($StaffDirectory);

print "$row_StaffDirectory[$Result]";

//prints the text or entries of the field with the set ID

}

?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Staff Directory </title>

<!--

.staffleft {

height: 233px;

width: 350px;

border: 2px groove #FFFFFF;

float: left;

margin-top: 20px;

margin-right: 2px;

margin-bottom: 15px;

margin-left: 25px;

text-align: center;

white-space: normal;

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: x-small;

font-style: normal;

line-height: normal;

font-weight: normal;

font-variant: normal;

text-transform: capitalize;

text-decoration: none;

color: #FFFFFF;

padding: 3px;

}

.newblock {

margin-top: 45px;

margin-right: 15px;

margin-bottom: 15px;

margin-left: 15px;

padding-top: 0px;

padding-right: 0px;

padding-bottom: 5px;

padding-left: 0px;

text-align: center;

vertical-align: bottom;

}

.stafftable {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: x-small;

color: #FFFFFF;

margin: 0px;

padding: 2px;

}

.staffright {

padding: 3px;

float: right;

height: 233px;

width: 370px;

margin-top: 20px;

margin-right: 5px;

margin-bottom: 15px;

margin-left: 0px;

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: x-small;

color: #FFFFFF;

}

.staffcenter {

padding: 3px;

width: 600px;

margin-top: 15px;

margin-right: auto;

margin-bottom: 15px;

margin-left: auto;

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: large;

font-style: normal;

line-height: normal;

font-weight: bold;

font-variant: normal;

color: #FFFFFF;

text-align: center;

white-space: normal;

text-transform: capitalize;

}

.stafftableheading {

color: #FFFFFF;

font-weight: bold;

}

-->

</style>

</head>

<body>

<tr>

<tr>

width="766" height="227" type="application/x-shockwave-flash">

FAIL (the browser should render some flash content, not this).

</object>

</object>

<ul>

<li><a href="laser-custom-tube-cutting.html">Tube Laser Cutting</a></li>

<li><a href="flat-metal-laser-cutting.html">Flat Laser Cutting</a></li>

<li><a href="cnc-turning.html">CNC Turning</a></li>

<li><a href="metalfabrication.html">Metal Fabrication</a></li>

<li><a href="multimedia.html">Video Library</a></li>

<li><a href="about-us.html">About Us</a></li>

<li><a href="our-clients.html">Clients</a></li>

<li><a href="careers.html">Careers</a></li>

<li><a href="contact-us.html">Contact Us</a></li>

<li><a href="quote.html">Request A Quote</a></li>

</ul>

</div> </td>

</tr>

<tr>

<div class="staffleft"><img src="<?php echo $_GET['Photo']; ?>" alt="Laser Dynamics Staff Directory" width="350" height="233"></div>

<tr>

</tr>

<tr>

<td><span class="stafftableheading">Department/Title:</span></td>

</tr>

<tr>

<td><span class="stafftableheading">E-mail Address:</span></td>

</tr>

<tr>

<td><span class="stafftableheading">Phone Number/Extension:</span></td>

</tr>

</table>

</div>

</div> </td>

</tr>

<tr>

<td valign="top" width="1180" height="34" style="background-image:url(images/bottom.gif) " class="footer"><div style="margin:9 0 0 51px "><b><a href="terms.html">Terms of Use</a> |<a href="privacy.html"> Privacy Statement</a><a href="privacy.html"></a></b><img alt="" src="images/spacer.gif" width="314px" height="1px"> © Test</div></td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

<?php

echo $html_output;

mysql_free_result($StaffDirectory);

?>

kyleldi · July 31, 2007

bump

Hybride · July 31, 2007

Try this, put it near the top of the page:

if (isset($_GET['id'])) { //Page first accessed
	$id =  $_GET['id']; 
} else {  
	if (isset($_POST['id'])) {  //form has been submit
	$id =  $_POST['id'];
}
}

And this part at the bottom, where you get the name, department title, etc., aren't you grabbing that from the database? switch it from <? echo $_GET['name']; ?> to <? echo $row['name']; ?>

kyleldi · July 31, 2007

I tried everything that you said, for some reason it continues to pull information from the table that is not signifcant to the ID in the url. It pulls the data for #1 when I try any other ID.. The hardest part is, I don't get any errors, so I have nothing to paste as a failed result. Any other ideas? I've tried everything I know. Thanks for your help!

Kyle

kyleldi · August 1, 2007

it doesn't seem to matter whether I move the _GET code to the top of the page or leave it where it is at. Anyone have any idea what my code is doing wrong? I'm not getting any errors. :-\

Sign In

Calling for data to be displayed using the URL

Recommended Posts

kyleldi

Link to comment

Share on other sites

kyleldi

Link to comment

Share on other sites

Hybride

Link to comment

Share on other sites

kyleldi

Link to comment

Share on other sites

kyleldi

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information