<?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 - Add Log Entry Results"); if (!isset($_REQUEST['serno']) || $_REQUEST['serno'] == '') die("serial number not specified!"); $serno=intval($_REQUEST['serno']); if (isset($_REQUEST['logno'])) { $logno=$_REQUEST['logno']; die("log number must not be set ($logno) when Creating!"); } $query="update log set serno=$serno"; 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) . "'"; } // echo "final query = '$query'<br>\n"; $sqlerr = ''; mysql_query("insert into log (logno) values (null)"); if (mysql_errno()) $sqlerr = mysql_error(); else { $logno = mysql_insert_id(); if (!$logno) $sqlerr = "couldn't allocate new serial number"; else { mysql_query($query . " where logno=$logno"); if (mysql_errno()) $sqlerr = mysql_error(); } } if ($sqlerr == '') { echo "<font size=+2>\n"; echo "\t<p>\n"; echo "\t\tA log entry with log number '$logno' was " . "added to the board with serial number '$serno'\n"; echo "\t</p>\n"; echo "</font>\n"; } else { echo "\t<font size=+4>\n"; echo "\t\t<p>\n"; echo "\t\t\tThe following SQL error was encountered:\n"; echo "\t\t</p>\n"; echo "\t\t<center>\n"; printf("\t\t\t<b>%s</b>\n", $sqlerr); echo "\t\t</center>\n"; echo "\t</font>\n"; } ?> <p></p> <table width="100%"> <tr> <td align=center><a href="brlog.php?serno=<?php echo "$serno"; ?>">Go to Browse</a></td> <td align=center><a href="index.php">Back to Start</a></td> </tr> </table> <?php pg_foot(); ?>