Update help

fehrenbacher33 · December 12, 2009

I cant get this to update the records into the database

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<head>

<title>Instrctional Support Service</title>

<!--

.style2 {

font-size: large

}

.style3 {

font-size: x-large;

color: #AA0000;

}

-->

</style>

</head>

<body>

<ul>

<li><a href="https://mycourses.siu.edu/webct/entryPageIns.dowebct" title="" target="_blank">WebCT</a></li>

<li><a href="http://www.lib.siu.edu/index.html" title="" target="_blank">Library</a></li>

<li><a href="#" title="">Contact</a></li>

<li>

</li>

</ul>

</div>

</div>

<h2 align="center">Recipt Printout Form<br />

</h2>

</div>

<br/>

<tr>

<td>Order Number: </td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</div>

<br/>

<!--

//

// From Metamorphosis Design team:

//

We request you retain the full copyright notice below including the link to www.metamorphozis.com.

This not only gives respect to the large amount of time given freely by the developers

but also helps build interest, traffic and use of our free and paid designs. If you cannot (for good

reason) retain the full copyright we request you at least leave in place the

Website Templates line, with Website Templates linked to www.metamorphozis.com. If you refuse

to include even this then support may be affected.

You are allowed to use this design only if you agree to the following conditions:

- You cannot remove copyright notice from this design without our permission.

- You cannot use images from this design anywhere else without permission.

- If you modify this design it still should contain copyright because it is based on our work.

For support visit http://www.metamorphozis.com/contact/index_contact2.php

The Metamorphosis Design : 2007

// -->

</div>

</body>

</html>

<?php

$OID =$_POST['OID'];

$SID = $_POST['SID'];

$server = "localhost"; // server name

$user = "root"; // user name

$pwd = ""; // password

$connect = mysql_connect($server, $user, $pwd)

or die ("Error connection failed!");

$sel = mysql_select_db("SIU");

if(!$sel)

exit("Error: Could not select database!");

$sql = " SELECT * FROM Equipment_Receipt, Equipment WHERE $OID = Equipment_Receipt.Order_ID AND $SID = Equipment_Receipt.Dwag_Tag";

$query = mysql_query($sql);

if (mysql_num_rows($query) == 0)

{

echo "<h3>No records found</h3>";

}

else

{

$row = mysql_fetch_array($query);

$Category = $row['Equipment_Category'];

$Pickup = $row['Pickup'];

$Buliding = $row['Buliding'];

$SIU_STATUS = $row['SIU_STATUS'];

$Dept = $row['Dept'];

$Phone = $row['Phone'];

$Comments = $row['Comments'];

$OID = $row['Order_ID'];

$SID = $row['Dwag_Tag'];

$Name = $row['Name'];

$EID = $row['Equip_Number'];

} echo "

<h1>Update Equipment Order</h1>

<hr>

<tr>

</tr>

<tr>

<td>Order ID:</td>

</tr>

<tr>

</tr>

<tr>

<td>Equipment ID:</td>

</tr>

<tr>

<td>Buliding:</td>

</tr>

<tr>

<td>SIU STATUS:</td>

<td><input type='radio' name='STATUS' value='Student' "; echo($SIU_STATUS =='Student') ? 'checked' : ''; echo ">Student

<input type='radio' name='STATUS' value='Staff' "; echo($SIU_STATUS=='Staff') ? 'checked' : ''; echo ">Staff

<input type='radio' name='STATUS' value='Professor' "; echo($SIU_STATUS=='Professor') ? 'checked' : ''; echo ">Professor

</td>

</tr>

<tr>

<td>Department:</td>

</tr>

<tr>

<td>Phone:</td>

</tr>

<br />

<br/>

<tr>

<td>Message:</td>

'$Comments'

</textarea>

</td>

</tr>

<tr>

<td> Orderd Equipment :</td>

<td>";

$sql = "select Equipment.Equip_Number, Equipment.Equipment_Name ,Equipment.Equipment_Category, Equipment_receipt.Order_ID from Equipment right join Equipment_receipt ON Equipment.Equip_Number = Equipment_receipt.Equip_Number WHERE $OID = equipment_receipt.order_id order by Equipment_Category";

$query = mysql_query($sql);

if(!mysql_num_rows($query))

{

echo '<h3>No records found</h3>';

}

else

{

echo "<select name='ECategory[]' size='5' multiple style='width:300px;'>";

while($row = mysql_fetch_array($query))

{

$Equip_Number = $row['Equip_Number'];

$Category = $row['Equipment_Category'] . ' - ' . $row['Equipment_Name'];

echo "<option value=Equip_Number ";

echo ($row['Order_ID'] != null) ? "selected" : "";

echo ">$Category</option>";

}

echo '</select>';

}

echo "

</td>

</tr>

<tr>

<td> Pickup Date:</td>

</tr>

<tr>

</td>

</tr>

</table>

</form>

";

mysql_close($connect);

?>

<?php

$OID = $_POST['OID'];

$SID = $_POST['SID'];

$Buliding = $_POST['Buliding'];

$Dept = $_POST['Dept'];

$Pickup = date('Y-m-d',strtotime($_POST ['Pickup']));

$Comments = $_POST['Comments'];

$Phone = $_POST['Phone'];

$EID = $_POST['EID'];

if(!isset($_POST['STATUS']))

$STATUS = 'off';

else

$STATUS = $_POST['STATUS'];

$server="localhost"; // Server name

$uid ="root"; // User name

$pass=""; // Password

$connect = mysql_connect("$server","$uid","$pass")

or die("ERROR: Selecting SERVER failed");

$sel = mysql_select_db("SIU");

if(!$ser)

exit("Error: Could not select database");

$sql = "UPDATE Equipment_Receipt SET Pickup = '$Pickup', Buliding = '$Buliding', Dept= '$Dept', Comments = '$Comments', Phone = '$Phone', STATUS = '$STATUS' WHERE $OID = $OID AND $EID = $EID ";

echo $sql;

$query = mysql_query($sql);

$numRows = mysql_affected_rows();

if($numRows == 1)

{

echo "<h3>Order has been Updated";

}

mysql_close($connect);

?>

vinpkl · December 12, 2009

use

tags for posting information and code

Sign In

Update help

Recommended Posts

fehrenbacher33

Link to comment

Share on other sites

vinpkl

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information