Hey guys and gals,
I'm just trying to approach an old problem a new way. Right now everything works fine but it seems that $searching isn't getting assigned the right text. Everything loads up to the point of the titles.inc. Then it just gives out.
Here's the run down of how this should work. The user searches for records. Then clicks on the edit link next to the desired record. This brings you to update.php where you can update or delete. When one of these buttons is pressed it should automatically link back to search.php and display the records again.
P.S. I'm also trying to pass hidden variables in my other appempt so please refer to that post if you have an idea about passing.
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10248539
Here's my code:
SEARCH.PHP
<?
include("header.inc");
include("menu.inc");
include("details.inc");
if(isset($_GET['searching'])){
$searching=$_GET['searching'];
}else{
$searching = $_POST['searching'];
}
if ($searching == "serNum") {
$search=$_POST['serial'];
}
elseif ($searching == "assNum") {
$search=$_POST['asset'];
}
elseif ($searching == "locate") {
$search=$_POST['location'];
}
?>
<TR ALIGN="CENTER">
<TD><H2><CENTER>Display results: <? echo $search ?></CENTER></H2><P>
</TD>
</TR>
<TR ALIGN="CENTER">
<TD>
<form name="frmCheck" action="update.php" method="post">
<?
//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 ($search=="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['po'] . "</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']));
$po = stripslashes(addslashes($_POST['po']));
$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);
mysql_query($query) or die (mysql_error());
$searching=$_GET['searching'];
$search=$_GET['search'];
//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."', po= '".$po."',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");
?>
<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>P.O. #</B></TD>
<TD><Input type="text" name="po" size="20" value="<? echo $rs['po'] ?>"></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");
?>
