Hey guys and gals,
This one is a little messed up but hopefully somebody can help. Right now the way the page works is the user specifies a search criteria on searchForm.php. Then whatever they're searching for is displayed on search.php. Each record will be displayed with an "edit" link next to it. When you click on this link you will be brought to update.php where the details of that record will be displayed. You can then update the record or delete it. Here's where the problem is. I want the page to go back to search.php with the same search criteria as before when you click on update or delete. Any help on this is greatly appreciated and thanks in advance. Here's the code:
SEARCH.PHP
<?
include("header.inc");
include("menu.inc");
include("details.inc");
$locate=$_POST['location'];
$searching=$_POST['searching'];
?>
<TR ALIGN="CENTER">
<TD><H2><CENTER>Display results: <?printf($locate);?></CENTER></H2><P>
</TD>
</TR>
<TR ALIGN="CENTER">
<TD>
<form name="frmCheck" action="<?php echo $PHP_SELF; ?>" method="post">
<?
if (isset($_POST['btnSearch'])) {
//Check if the user checked a search criteria
if($searching == "") {
printf("Please select a search criteria");
}
//Check if the user did select a search criteria
elseif ($searching != "") {
include("title.inc");
//Check if the selected search criteria is by serial number
if ($searching == "serNum") {
$search=$_POST['serial'];
$query="SELECT * FROM assets WHERE serialNum='" . $search . "'";
$result=mysql_query($query);
}
//Check if the selected search criteria is by asset number
elseif ($searching == "assNum") {
$search=$_POST['asset'];
$query="SELECT * FROM assets WHERE assetNum='" . $search . "'";
$result=mysql_query($query);
}
//Check if the selected search criteria is by location
elseif ($searching == "locate") {
$query="SELECT * FROM assets WHERE location='" . $search . "'";
$result=mysql_query($query);
//Check if the user choose to display all
if ($locate == "Display All") {
$query="SELECT * FROM assets ORDER BY location ASC";
$result=mysql_query($query);
}
}
//Fetch the info from the database into an array and display the records with an edit link beside them
While ($rs = mysql_fetch_array($result)) {
print ("<TR ALIGN=CENTER><TD><A HREF=update.php?id=".$rs['id']."&searching=".$searching."&search=".$search.">Edit</A></TD><TD>" . $rs['itemName'] . "</TD><TD>" . $rs['serialNum'] . "</TD><TD>" . $rs['assetNum'] . "</TD><TD>" . $rs['location'] . "</TD><TD>" . $rs['description'] . "</TD><TD>" . $rs['entryDate'] . "</TD><TD>" . $rs['warranty'] . "</TD></TR>");}
}
}
?>
</TABLE>
</TD>
</TR>
<?
include("footer.inc");
?>
UPDATE.PHP
<?
include("details.inc");
//post values into the variables from the search.php form
$asset = stripslashes(addslashes($_POST['asset']));
$name = stripslashes(addslashes($_POST['name']));
$location = stripslashes(addslashes($_POST['location']));
$description = stripslashes(addslashes($_POST['description']));
$warranty = stripslashes(addslashes($_POST['warranty']));
$serial = stripslashes(addslashes($_POST['serial']));
//get id num into the $id variable, else post
if(isset($_GET['id'])){
$id=$_GET['id'];
}else{
$id = $_POST['id'];
}
$query="SELECT * FROM assets WHERE id=".$id;
$result=mysql_query($query);
$rs= mysql_fetch_array($result);
//if the delete button is clicked, delete the current record and display to the user that it was deleted
if(isset($_POST['btnDelete'])) {
$query="DELETE FROM assets WHERE id=".$id;
mysql_query($query) or die (mysql_error());
header("Location: search.php?searching=".$searching."&search=".$search);
}
//if the update button is clicked, update the current record and display to the user that it was updated
if(isset($_POST['btnUpdate'])) {
$query = "UPDATE assets SET serialNum = '".$serial."', assetNum = '".$asset."', itemName = '".$name."',location = '".$location."', description = '".$description."',warranty = '".$warranty."' WHERE id = ".$id;
mysql_query($query) or die (mysql_error());
header("Location: search.php?searching=".$searching."&search=".$search);
}
include("header.inc");
include("menu.inc");
$searching=$_GET['searching'];
$search=$_GET['search'];
?>
<TR ALIGN="CENTER">
<TD><CENTER><H2>Update Database</H2></CENTER><P></TD>
</TR>
<form method="post" action="<?php echo $PHP_SELF;?>">
<TR ALIGN="CENTER">
<TD>
<TABLE BORDER=1 WIDTH=40% ALIGN="CENTER">
<TR ALIGN=CENTER>
<TD><B>Item Name</B></TD>
<TD><Input type="text" name="name" size="20" value="<? echo $rs['itemName'] ?>"></TD>
</TR>
<TR ALIGN=CENTER>
<TD><B>Serial Number</B></TD>
<TD><Input type="text" name="serial" size="20" value="<? echo $rs['serialNum'] ?>"></TD>
</TR>
<TR ALIGN=CENTER>
<TD><B>Asset Number</B></TD>
<TD><Input type="text" name="asset" size="20" value="<? echo $rs['assetNum'] ?>"></TD>
</TR>
<TR ALIGN=CENTER>
<TD><B>Location</B></TD><TD>
<?
//selection array to place the locations into the select box and determine which one is selected
$location_array = array("Baie Verte", "Botwood", "Bishop Falls", "Buchans", "Carmanville", "Centreville", "Change Islands", "Fogo Island", "Gambo", "Gander", "Gaultois", "Glenwood", "Glovertown", "Grand Falls", "Greenspond", "HarbourBreton", "Hare Bay", "Harry's Harbour", "Hermitage", "King's Point", "LaScie", "Lewisporte", "Lumsden", "Musgrave Harbour", "Norris Arm", "Point Leamington", "Robert's Arm", "Seal Cove", "Springdale", "St. Alban's", "Summerford", "Twillingate", "Wesleyville");
echo "<SELECT NAME=location>";
foreach($location_array as $value){
echo "<OPTION VALUE=".urlencode($value);
if($rs['location'] == $value)
echo " SELECTED";
echo ">".$value."</OPTION>";
}
echo "</SELECT>";
?>
</TD>
</TR>
<TR ALIGN=CENTER>
<TD><B>Description</B></TD>
<TD><Input type="text" name="description" size="20" value="<? echo $rs['description'] ?>"></TD>
</TR>
<TR ALIGN=CENTER>
<TD><B>Warranty</B></TD>
<TD><Input type="text" name="warranty" size="20" value="<? echo $rs['warranty'] ?>"></TD>
</TR>
</TABLE>
<BR><CENTER>
<input type="Submit" name="btnUpdate" Value="Update Record">
<input type="Submit" name="btnDelete" Value="Delete Record">
</FORM></CENTER>
</TD>
</TR>
<?
include("footer.inc");
?>
