Anyone?
----- Original Message ----- 
From: "Dan Bowkley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 02, 2004 1:21 AM
Subject: [PHP-DB] 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

Reply via email to