blob: 7635d2992d9d3c471c79cced9ef0e3c0f33fe858 [file] [log] [blame]
wdenkfe8c2802002-11-03 00:38:21 +00001<?php // php pages made with phpMyBuilder <http://kyber.dk/phpMyBuilder> ?>
2<?php
3 // (C) Copyright 2001
Wolfgang Denkb3b0fd52005-08-12 23:20:59 +02004 // Murray Jensen <Murray.Jensen@csiro.au>
wdenkfe8c2802002-11-03 00:38:21 +00005 // CSIRO Manufacturing Science and Technology, Preston Lab
6
7 // doedit page (hymod_bddb / boards)
8
9 require("defs.php");
10
11 pg_head("$bddb_label - Add Log Entry Results");
12
Wolfgang Denkd992daf2005-08-12 23:27:18 +020013 if (!isset($_REQUEST['serno']) || $_REQUEST['serno'] == '')
wdenkfe8c2802002-11-03 00:38:21 +000014 die("serial number not specified!");
Wolfgang Denkd992daf2005-08-12 23:27:18 +020015 $serno=intval($_REQUEST['serno']);
wdenkfe8c2802002-11-03 00:38:21 +000016
Wolfgang Denkd992daf2005-08-12 23:27:18 +020017 if (isset($_REQUEST['logno'])) {
18 $logno=$_REQUEST['logno'];
wdenkfe8c2802002-11-03 00:38:21 +000019 die("log number must not be set ($logno) when Creating!");
Wolfgang Denkd992daf2005-08-12 23:27:18 +020020 }
wdenkfe8c2802002-11-03 00:38:21 +000021
22 $query="update log set serno=$serno";
23
24 list($y, $m, $d) = split("-", $date);
25 if (!checkdate($m, $d, $y) || $y < 1999)
26 die("date is invalid (input '$date', yyyy-mm-dd '$y-$m-$d')");
27 $query.=", date='$date'";
28
Wolfgang Denkd992daf2005-08-12 23:27:18 +020029 if (isset($_REQUEST['who'])) {
30 $who=$_REQUEST['who'];
wdenk6dd652f2003-06-19 23:40:20 +000031 $query.=", who='" . $who . "'";
Wolfgang Denkd992daf2005-08-12 23:27:18 +020032 }
wdenk6dd652f2003-06-19 23:40:20 +000033
Wolfgang Denkd992daf2005-08-12 23:27:18 +020034 if (isset($_REQUEST['details'])) {
35 $details=$_REQUEST['details'];
wdenkfe8c2802002-11-03 00:38:21 +000036 $query.=", details='" . rawurlencode($details) . "'";
Wolfgang Denkd992daf2005-08-12 23:27:18 +020037 }
wdenkfe8c2802002-11-03 00:38:21 +000038
39 // echo "final query = '$query'<br>\n";
40
41 $sqlerr = '';
42
43 mysql_query("insert into log (logno) values (null)");
44 if (mysql_errno())
45 $sqlerr = mysql_error();
46 else {
47 $logno = mysql_insert_id();
48 if (!$logno)
49 $sqlerr = "couldn't allocate new serial number";
50 else {
51 mysql_query($query . " where logno=$logno");
52 if (mysql_errno())
53 $sqlerr = mysql_error();
54 }
55 }
56
57 if ($sqlerr == '') {
58 echo "<font size=+2>\n";
59 echo "\t<p>\n";
60 echo "\t\tA log entry with log number '$logno' was " .
61 "added to the board with serial number '$serno'\n";
62 echo "\t</p>\n";
63 echo "</font>\n";
64 }
65 else {
66 echo "\t<font size=+4>\n";
67 echo "\t\t<p>\n";
68 echo "\t\t\tThe following SQL error was encountered:\n";
69 echo "\t\t</p>\n";
70 echo "\t\t<center>\n";
71 printf("\t\t\t<b>%s</b>\n", $sqlerr);
72 echo "\t\t</center>\n";
73 echo "\t</font>\n";
74 }
75
76?>
77<p></p>
78<table width="100%">
79<tr>
80 <td align=center><a href="brlog.php?serno=<?php echo "$serno"; ?>">Go to Browse</a></td>
81 <td align=center><a href="index.php">Back to Start</a></td>
82</tr>
83</table>
84<?php
85 pg_foot();
86?>