for those coding experts.....

justeen

Hi- I really need major help on a simple assignment i'm doing for a computer course. I think I have screwed it up somehow. Please HELP!!

The purpose of the project is to combine the use of oracle server, apache server, PHP, and HTML all-together.

Below is the code of the "order" form in HTML for the user to enter. Once the user
click the SUBMIT button, the text field boxes will be send to the oracle DB. Obviously,the apache server has to be running first before it can do anything. the text boxes have to be written in php code - to "store" the information so it can sent to the DB server.

I'll try my best to demonstrate the layout better. the database is called oil_company, there are two tables called customers and orders. customers table will have Fullname, companyname, phone, and email, **need to add sequence # for customer number and order number. Orders table will have toolname1,
and toolname2, and the quantity for each.. I need a "auto-numbering" for the customer number; and it has to be "locked" so that the users can't modify it. This can be done by a sequence -but i dont know the code. It got something with like, "create sequence sequencename"

once the user clicked submit, the layout should display company name,email address, and the quantity of toolname1,and toolname2. This is written in PHP, and it will read from MySql database.

I have attached all of my codes (of waht i have done so far) here... so if there is any smart people out there who know those kind of stuff, i'll appericate your help greatly!!

justeen

HTML CODE FOR THE ORDER FORM

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>OIL EQUIPMENT CORPORATION</title>
</head>

<p><font style="font-size: 40pt" face="Halo"><b>OIL EQUIPMENT<br>
              CORPORATION</b></font></p>
<P>

<font face="Arial"><br>
<br>
Please provide the following contact information:<br>
               
<font color="#FF0000">Note: PLEASE FILL OUT ALL FIELDS REQUIRED.</font></font></P>
<BLOCKQUOTE>
<TABLE id="table1">
<TR>
<TD ALIGN="right">
<em><font face="Arial">Full Name</font></em></TD>
<TD>
<font face="Arial">
<INPUT NAME="fullname" SIZE=35>
</font>

</TD>
</TR>
<TR>
<TD ALIGN="right">
<font face="Arial"><em>Company Name</em></font></TD>
<TD>
<font face="Arial">
<INPUT NAME="companyname" SIZE=35>
</font>
</TD>
</TR>
<TR>
<TD ALIGN="right">
<font face="Arial"><em> Phone (Work) </em></font></TD>
<TD>

</BLOCKQUOTE>
<form method="POST" action="--WEBBOT-SELF--">

<p><b><font face="Arial">          
Quantity   Equipment Name<br>
</font></b>          
<input type="text" name="Q1" size="3">       
<select size="1" name="toolname1">
<option selected>None</option>

<option>428-Recon, LeGrand</option>
<option>440 Recond, Renn</option>
<option>3.5mm Btu - Single Axle, GenTex</option>
<option>224-Envirovault-Heavy Oil, LeFarge</option>
<option>Tee Body, Norris</option>
<option>Brass Washer, Mallard</option>

<option>Skid Mounted 25M, Texheater</option>
<option>1.2 MM BTU 1, TexSteamer</option>
</select><br>

          
<input type="text" name="T3" size="3">       
<select size="1" name="toolname2">
<option selected>None</option>
<option>428-Recon, LeGrand</option>

<option>440 Recond, Renn</option>
<option>3.5mm Btu - Single Axle, GenTex</option>
<option>224-Envirovault-Heavy Oil, LeFarge</option>
<option>Tee Body, Norris</option>
<option>Brass Washer, Mallard</option>
<option>Skid Mounted 25M, Texheater</option>

<option>1.2 MM BTU 1, TexSteamer</option>
</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>

          
     
          
    
</p>
</form>

<form method="POST" action="--WEBBOT-SELF--">

<p align="left">                                <input type="submit" value="Submit Form" name="B1"> 
</p>
</form>
<p align="center"><font face="Arial" size="2">Oil Equipment Corporation.<br>Copyright © 2000
- 2006<br>
Revised:
03/25/06</font></p>

</body>

</html>

justeen

PHP CODE: add the info submitted by the user to the DB

<html>
<head>
<body>
<?php

$dbcnx = @mysql_connect("localhost","root","cmps357");

if(!$dbcnx) {
echo("<P>Unable to connect to the " .
"database server at this time.</p>" );
exit();
}
echo ("Connection OK");

if (! @mysql_select_db("oil_company", $dbcnx) ) {
echo( "<p>Unable to locate the oil_company " .
"database at this time. </p>" );
exit();
}
$companyname=$POST['companyname'];
$phonenum=$POST['phonenum'];
$toolname1=$POST['toolname1'];
$toolname2=$POST['toolname2'];
$Q1=$POST['Q1'];
$Q2=$POST['Q2'];

$sql = "INSERT INTO customers SET companyname='$companyname', phonenum='$phonenum'";

$sqla = "INSERT INTO orders SET toolname1='$toolname1', toolname2='$toolname2'"

mysql_query($sql, $sqla,$dbcnx);
echo 'you are done. Go check you database...';
?>
<p>finished php...</p>
</body>
</head>
</html>

justeen

PHP CODE: connect to DB, read from the order table, retrieve data &
display on broswer

<html>
<head>
<body>
<?php
<table>
$dbcnx = mysql_connect("localhost","root","cmps357");

if(!$dbcnx) {
echo("<P>Unable to connect to the " .
"database server at this time.</p>" );
exit();
}
echo ("Connection OK");

if (! @mysql_select_db("oil_company", $dbcnx) ) {
echo( "<p>Unable to locate the oil company " .
"database at this time. </p>" );
exit();
}

$display="SELECT * FROM orders;";
$result=mysql_query($display,$dbcnx);

while ($line=mysql_fetch_array($result,MYSQL_ASSOC))
{
$companyname=$line["companyname"];
echo"<TR><TD>$companyname</TD>";
$toolname1=$line["toolname1"];
echo"<TD>$toolname</TD></TR>";
$toolname2=$line["toolname2"];
echo"<TD>$toolname2</TD></TR>";
}
?>
</TABLE>

<p>finished php...</p>
</body>
</head>
</html>

Sxooter

OK, this is far too huge for a single post. Try breaking your problem down into pieces, and posting one or two at a time here. Is it posting data to the apache server that's giving you issues? Is it getting it into the database? The smaller and more concise your question here, the quicker and more prolific the answers will be.

justeen

Ok, good advice. I'll start a new thread or post- this time with one problem at a time. just give me a couple of more days to re-organize everything i said above.

Houdini

That might be a record 5 posts for one problem, it would be nice if the code tools had been used you know the Code or HTML or the PHP provided, and I had to scroll around till I got dizzy looking at the code as it is