Anyone?
----- Original Message -----
From: "Dan Bowkley" <dan@xxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Sunday, May 02, 2004 1:21 AM
Subject: lamer noob with repeat question
> Hello everyone,
>
> I've been working on (read:tearing my hair out over) my mom's website for
> some time now. Specifically, I'm trying to get her work order database up
> and running.
>
> The basic idea is this: you start out adding a new record by going to
> add.php. It sees that you've not done anything yet and thus presents you
> with a form to fill out. That form gets submitted to add.php, which sees
> that you're adding something. It checks for a duplicate work order number
> (and eventually other errors) and then either adds the stuff you submitted
> into the DB, or pops an error and presents the form again.
>
> Alas, it does nothing.
>
> When you initially load the page, it works okay, sensing that you've not
yet
> done anything and displaying the form. But when you submit data, it spits
> out naught more than a blank page, and doesn't add anything to the
database.
>
> Damned lazy script.
>
>
> What I've got so far is this:
>
> <html>
> <head><title>The Board Lady - Work Order Database 0.1a</title></head>
> <body>
> <?php
> define ('DB_USER', 'user');
> define ('DB_PASSWORD', '********');
> define ('DB_HOST', 'localhost');
> define ('DB_NAME', 'boardlady');
> $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not
> connect to database: ' . mysql_error());
> @mysql_select_db (DB_NAME) OR die ('Could not connect to database: ' .
> mysql_error());
> $page_req=$HTTP_GET_VARS['action'];
> if ($page_req == "") {$page_req="0";}
> if ($page_req == "0") {
> echo "SWORD data entry<br>\n";
> echo "<form action=\"add.php\" method=\"get\">";
> echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n";
> echo "Customer Name: <input type=\"text\" name=\"name\"> Phone: <input
> type=\"text\" name=\"phone\"><br>\n";
> echo "Email Addy: <input type=\"text\" name=\"email\"> Date In: <input
> type=\"text\" name=\"date\"><br>\n";
> echo "Board Type and SN: <input type=\"text\" name=\"board_type\"> Last 3
of
> SN: <input type=\"text\" name=\"last_three\"><br>\n";
> echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight Out:
<input
> type=\"text\" name=\"weight_out\"><br>\n";
> echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n";
> echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT
> type=\"reset\"><br>\n";
> }
> if ($page_req == "1") {
> $wo_num=$HTTP_GET_VARS['wo_num'];
> $name=$HTTP_GET_VARS['name'];
> $phone=$HTTP_GET_VARS['phone'];
> $email=$HTTP_GET_VARS['email'];
> $date=$HTTP_GET_VARS['date'];
> $board_type=$HTTP_GET_VARS['board_type'];
> $last_three=$HTTP_GET_VARS['last_three'];
> $weight_in=$HTTP_GET_VARS['weight_in'];
> $weight_out=$HTTP_GET_VARS['weight_out'];
> $query_testingforadupe = "SELECT job_no FROM boards WHERE job_no ==
$job_no
> ORDER BY job_no ASC";
> $result_testingforadupe = @mysql_query ($query_testingforadupe);
> if ($result_testingforadupe) {
> echo "That's a duplicate work order number, you ditz. Try again, this time
> without screwing it all up.<br><br>\n";
> echo "<form action=\"add.php\" method=\"get\">";
> echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n";
> echo "Customer Name: <input type=\"text\" name=\"name\"> Phone: <input
> type=\"text\" name=\"phone\"><br>\n";
> echo "Email Addy: <input type=\"text\" name=\"email\"> Date In: <input
> type=\"text\" name=\"date\"><br>\n";
> echo "Board Type and SN: <input type=\"text\" name=\"board_type\"> Last 3
of
> SN: <input type=\"text\" name=\"last_three\"><br>\n";
> echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight Out:
<input
> type=\"text\" name=\"weight_out\"><br>\n";
> echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n";
> echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT
> type=\"reset\"><br>\n";
> }
> else {
> $query_insert = "INSERT INTO boards (wo_num, name, phone, email, date,
> board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\',
> \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\',
> \'$last_three\', \'$weight_in\', \'$weight_out\')";
> $result_insert = @mysql_query ($query_insert);
> if ($result_insert == "") {
> echo "<input type=\"hidden\" name=\"action\" value=\"0\"\n";
> echo "<INPUT type=\"submit\" value=\"Continue\">\n";
> }
> else {echo "OOPS! Your programmer is an idiot!\n";}
> }}
> mysql_close();
> ?>
> </body>
> </html>
>
>
>
>
>
> The database looks like this, in case you're curious:
> CREATE TABLE boards (
> name varchar(40) default NULL,
> phone varchar(12) default NULL,
> email varchar(40) default NULL,
> purveyor varchar(40) default NULL,
> job_no int(5) unsigned NOT NULL default '0',
> date varchar(10) NOT NULL default '',
> board_type varchar(100) NOT NULL default '',
> weight_in decimal(4,2) default NULL,
> weight_out decimal(4,2) default NULL,
> last_three int(3) unsigned default NULL,
> PRIMARY KEY (job_no),
> KEY last-three (last_three)
> ) TYPE=MyISAM;
>
>
> Can anyone help me to get this thing working?
>
> TIA
> Dan
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
