doedlog.php 1.91 KB
Newer Older
Alexander Yurtsev's avatar
Alexander Yurtsev committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
<?php // php pages made with phpMyBuilder <http://kyber.dk/phpMyBuilder> ?>
<?php
	// (C) Copyright 2001
	// Murray Jensen <Murray.Jensen@csiro.au>
	// CSIRO Manufacturing Science and Technology, Preston Lab

	// doedit page (hymod_bddb / boards)

	require("defs.php");

	pg_head("$bddb_label - Edit Log Entry Results");

	if (!isset($_REQUEST['serno']) || $_REQUEST['serno'] == '')
		die("the board serial number was not specified");
	$serno=intval($_REQUEST['serno']);

	if (!isset($_REQUEST['logno']) || $_REQUEST['logno'] == '')
		die("log number not specified!");
	$logno=intval($_REQUEST['logno']);

	$query="update log set";

	if (isset($_REQUEST['date'])) {
		$date=$_REQUEST['date'];
		list($y, $m, $d) = split("-", $date);
		if (!checkdate($m, $d, $y) || $y < 1999)
			die("date is invalid (input '$date', " .
				"yyyy-mm-dd '$y-$m-$d')");
		$query.=" date='$date'";
	}

	if (isset($_REQUEST['who'])) {
		$who=$_REQUEST['who'];
		$query.=", who='" . $who . "'";
	}

	if (isset($_REQUEST['details'])) {
		$details=$_REQUEST['details'];
		$query.=", details='" . rawurlencode($details) . "'";
	}

	$query.=" where serno=$serno and logno=$logno";

	mysql_query($query);
	if(mysql_errno()) {
		$errstr = mysql_error();
		echo "\t<font size=+4>\n";
		echo "\t\t<p>\n";
		echo "\t\t\tThe following error was encountered:\n";
		echo "\t\t</p>\n";
		echo "\t\t<center>\n";
		printf("\t\t\t<b>%s</b>\n", $errstr);
		echo "\t\t</center>\n";
		echo "\t</font>\n";
	}
	else {
		echo "\t<font size=+2>\n";
		echo "\t\t<p>\n";
		echo "\t\t\tThe log entry with log number <b>$logno</b> and\n";
		echo "\t\t\tserial number <b>$serno</b> ";
		echo "was successfully updated\n";
		echo "\t\t</p>\n";
		echo "\t</font>\n";
	}

?>
<p>
<table align=center width="100%">
<tr>
  <td align=center><a href="brlog.php?serno=<?php echo "$serno"; ?>">Back to Log</a></td>
  <td align=center><a href="index.php">Back to Start</a></td>
</tr>
</table>
<?php
	pg_foot();
?>