Editing record by way of hidden variable

ender · December 27, 2005

I have an inventory DB that I have built. You can go to it at [a href=\"http://71.197.44.48/frame.php\" target=\"_blank\"]http://71.197.44.48/frame.php[/a]

the user name is ryan the password is temp123 so you can look at it and see whats going on. You can get to where i want to edit by doing a query by school.

Here is the code where it defines the hidden variable:

<?PHP
//$db = mysql_connect('localhost','root','') or die("Couldn't connect to the database.");
mysql_select_db('inventorydb') or die("Couldn't select the database");
if ($campus != "") {
$result = mysql_query("SELECT * FROM inventory WHERE campus = '$campus' ORDER BY bisdnumber asc");

}
else {
$result = mysql_query("select * from inventory where bisdnumber = '$numberdata' or xpressnumber = '$numberdata' or servicetag = '$numberdata'");

}

while ($row = mysql_fetch_array($result)) {
echo "
<center>
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0 width=95%><tr align=center bgcolor=lightsteelblue>
<th><font face=tahoma size=2>BISD#:</font></font></th>
<th><font face=tahoma size=2>Product Type:</font></th>
<th><font face=tahoma size=2>Product Model:</font></th>
<th><font face=tahoma size=2>Product Brand:</font></th>
<th><font face=tahoma size=2>Service Tag#:</font></th>
<th><font face=tahoma size=2>Express#:</font></th>
<th><font face=tahoma size=2>Campus:</font></th>
<th><font face=tahoma size=2>Room#:</font></th>
<th><font face=tahoma size=2>Modified By:</font></th>
<th><font face=tahoma size=2>Last Modified:</font></th>
<th><font face=tahoma size=2>Action</font></th>
</tr>
<br>
<tr align=center bgcolor=gainsboro>
<td><font face=tahoma size=2>$row[bisdnumber]</font></td>
<td><font face=tahoma size=2>$row[producttype]</font></td>
<td><font face=tahoma size=2>$row[productmodel]</font></td>
<td><font face=tahoma size=2>$row[productbrand]</font></td>
<td><font face=tahoma size=2>$row[servicetag]</font></td>
<td><font face=tahoma size=2>$row[xpressnumber]</font></td>
<td><font face=tahoma size=2>$row[campus]</font></td>
<td><font face=tahoma size=2>$row[room]</font></td>
<td><font face=tahoma size=2>$row[modifiedby]</font></td>
<td><font face=tahoma size=2>$row[lastmodified]</font></td>
<td><font face=tahoma size=2><form action='editrecord.php'><input type='hidden' name='inventory_id' value='$inventory_id'><input type='submit' value='Edit'>

</tr>
</table>
</center> ";

}

mysql_free_result($result);

?>

and, here is the code of the edit function, which doesnt work for some reason. I want it to pull the record up in a table prefilled out with the info currently entered, but that can be changed to what it needs to be changed to:

<?PHP
$db = mysql_connect('localhost','root','') or die("Couldn't connect to the database.");
mysql_select_db('inventorydb') or die("Couldn't select the database");
$result = mysql_query("SELECT * FROM inventory '$inventory_id'");
while ($row = mysql_fetch_array($result)) {
echo "

<html>
<body>
<form action="addrecord.php">
<TABLE BORDER CELLPADDING=3 CELLSPACING=0>
<tr align=center>
<td>BISD Number:</td>
<td><input type="text" name="bisdnumber" value=echo $bisdnumber size="10"></td>

</tr>
<tr align=center>
<td>Serial Number:</td>
<td><input type="text" name="serialnumber" size="15"></td>
</tr>
<tr align=center>
<td>Product Type:</td>

<td><select name="producttype">
<option value="desktop">Desktop
<option value="laptop">Laptop
<option value="printer">Printer
<option value="palm">Palm
<option value="other">Other
</tr>
<tr align=center>
<td>Product Model:
<td><select name="productmodel">
<option value="optiplexgx260">Optiplex GX260
<option value="optiplexgx240">Optiplex GX240
<option value="inspiron8200">Insprion 8200
<option value="gatewaytower">Gateway Tower
<option value="other">Other
</select>

</tr>
<tr align=center>
<td>Product Brand:</td>
<td><select name="productbrand">
<option value="dell">Dell
<option value="gateway">Gateway
<option value="hp">HP
<option value="compaq">Compaq
<option value="lexmark">Lexmark
</select>
</td></tr>
<tr align=center>
<td>ServiceTag#:</td>
<td><input type="text" name="servicetag"size="10"></td>
</tr>

<tr align=center>
<td>ExpressServiceTag#:</td>
<td><input type="text" name="xpressnumber"size=15></td>
</tr>
<tr align=center>
<td>PO#:</td>
<td><input type'text' name="ponumber"size=20></td>
</tr>
<tr align=center>
<td>PO Date:</td>
<td><input type'text' name="podate"size=10></td>
</tr>
<tr align=center>
<td>Warranty:</td>

<td><input type'text' name="warranty"size=20></td>
</tr>
<tr align=center>
<td>Campus:</td>
<td><select name="campus">
<option value="Burleson High School">Burleson High School
<option value="Crossroads High School">Crossroads High School
<option value="Kerr Middle School">Kerr Middle School
<option value="Hughes Middle School">Hughes Middle School
<option value="Academy Elementary School">Academy Elementary School
<option value="Bransom Elementary School">Bransom Elementary School
<option value="Frazier Elementary School">Frazier Elementary School
<option value="Mound Elementary School ">Mound Elementary School
<option value="Norwood Elementary School">Norwood Elementary School
<option value="Stribling Elementary School">Stribling Elementary School
<option value="Taylor Elementary School">Taylor Elementary School

</select>
</td></tr>
<tr align=center>
<td>Room:</td>
<td><input type="text" name="roomnumber"size="3"></td>
<br>

</table><td><input type="submit" value="Submit"></td>
</form>
</body>
}
mysql_free_result($result);

?>

im still real new to this, if you couldnt tell, so any help would be appriciated. thanks.

fenway · December 28, 2005

See cross-post on [a href=\"http://www.mysqlfreaks.com/forums/index.php?showtopic=8884\" target=\"_blank\"]MySQL Freaks[/a] for responses.

Sign In

Editing record by way of hidden variable

Recommended Posts

ender

Link to comment

Share on other sites

fenway

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information