Posted by Stephen V on 04/02/06 17:51

I am afraid I don't understand.

"J.O. Aho" <user@example.net> a �crit dans le message de news:
49a06hFnm3dpU1@individual.net...
> Stephen V wrote:
>
> ---next line MUST be the first one, no spaces/tabs allowed before
> <?PHP ---
>> <?php
>>
>> // variable name of submit button of request form
>>
>> $addrequest = $_POST['addrequest'];
> // OUTPUT prevents header(): print "$addrequest <BR>";
>>
>>
>> //test if something is submited in the form if this is the case then
>> insert data in DB
>>
>> if ($addrequest!='') {
>>
>> $req_name = $_POST['request_name'];
>>
>> $req_date = $_POST['request_date'];
>>
>> $req_client_id = $_POST['request_client_name'];
>>
>> $req_req_type_id = $_POST['request_type'];
>>
>> $req_brand_id = $_POST['request_brand_name'];
>> if ($req_brand_id=='Brand Name') $req_brand_id='NULL';
>>
>> $req_exp_date = $_POST['request_expected_date'];
>>
>> $req_comment = $_POST['request_comment'];
>>
>> $c1=oci_connect("stephane","Stef1975",$bdtest05);
>>
>> $query="insert into requests (
>> request_name, request_date, request_client_id, request_request_type_id,
>> request_brand_id, request_wished_delivery_date, request_comment)
>> values
>>
>> ('$req_name',to_date('$req_date','DD.MM.YYYY'),$req_client_id,$req_req_type_id,
>> $req_brand_id,to_date('$req_exp_date','DD.MM.YYYY'),'$req_comment')";
>>
>> $stmt=oci_parse($c1,$query);
>>
>>
>>
> // OUTPUT prevents header(): Print "$stmt <BR>";
> // OUTPUT prevents header(): Print "$query <BR>";
>>
>> if (oci_execute($stmt)){
>>
>> oci_free_statement($stmt);
> // OUTPUT prevents header(): print
> "add_task.php?request_name=$req_name";
> header("Location:
> http://127.0.0.1/add_task.php?request_name=$req_name");
> exit
> }
>> // gestion du ELse: erreur dans l'insertion en BdD
>>
>> }
>>
>> ?>
>> <center><h1>Add request</h1></p></center>
>> <hr>
>>
>> <p align="center">
>> &nbsp;
>>
>> <form method="POST" name="requestform" action="add_request.php">
>> <table border="1" width="50%">
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Request Name</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2">
>> <p align="left"><input type="text" size="40"
>> name="request_name">&nbsp<b>*</b>&nbsp</p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Request Date</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2">
>> <p align="left"><input type="text" size="20"
>> name="request_date">&nbsp<b>*</b>&nbsp;&nbsp;
>> <a
>> href="javascript:show_calendar('requestform.request_date',null,null,'DD.MM.YYYY');"
>> onMouseOver="window.status='Date Picker'; overlib('Click here to choose a
>> date from a one month pop-up calendar.'); return true;"
>> onMouseOut="window.status=''; nd(); return true;"><img
>> src="show-calendar.gif" width=24 height=22 border=0></a></p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Client Name</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2">
>> <p align="left">
>> <select name="request_client_name" size="1">
>> <option>Client Name</option>
>> <?php
>>
>> //connection to database
>>
>> $c1=oci_connect("stephane","Stef1975",$bdtest05);
>>
>> $query="select client_id, client_firstname||' '||client_lastname as
>> client_fullname from clients";
>>
>> $stmt=oci_parse($c1,$query);
>>
>> oci_execute($stmt);
>>
>> while ($row = oci_fetch_array($stmt,OCI_NUM))
>> {
>> echo"<option value=$row[0]>$row[1]</option>";
>> }
>>
>> oci_free_statement($stmt);
>> ?>
>>
>> </select>&nbsp<b>*</b></p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Request Type</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2">
>> <p align="left">
>> <select name="request_type" size="1">
>> <option>Request Type</option>
>>
>> <?php
>>
>> $query="select request_type_id, request_type_name from request_types";
>>
>> $stmt=oci_parse($c1,$query);
>>
>> oci_execute($stmt);
>>
>> while ($row = oci_fetch_array($stmt,OCI_NUM))
>> {
>> echo"<option value=$row[0]>$row[1]</option>";
>> }
>>
>> oci_free_statement($stmt);
>>
>> ?>
>>
>> </select>&nbsp<b>*</b>
>> </p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Brand Name</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2">
>> <p align="left">
>> <select name="request_brand_name" size="1">
>> <option>Brand Name</option>
>>
>> <?php
>>
>> $query="select brand_id, brand_name from brands";
>>
>> $stmt=oci_parse($c1,$query);
>>
>> oci_execute($stmt);
>>
>> while ($row = oci_fetch_array($stmt,OCI_NUM))
>> {
>> echo"<option value=$row[0]>$row[1]</option>";
>> }
>>
>> oci_free_statement($stmt);
>>
>> //close connection to database
>>
>> oci_close($c1);
>> ?>
>>
>> </select>
>> </p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Expected Delivery Date</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2">
>> <p align="left"><input type="text" size="20"
>> name="request_expected_date">&nbsp<b>*</b>&nbsp;&nbsp;
>> <a
>> href="javascript:show_calendar('requestform.request_expected_date',null,null,'DD.MM.YYYY');"
>> onMouseOver="window.status='Date Picker'; overlib('Click here to choose a
>> date from a full year pop-up calendar.'); return true;"
>> onMouseOut="window.status=''; nd(); return true;"><img
>> src="show-calendar.gif" width=24 height=22 border=0></a></p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left">Comment on Request</p>
>> </td>
>> <td align="left" width="50%" height="25" colspan="2"><textarea
>> name="request_comment" cols="30" rows="4"></textarea><p>
>> </td>
>> </tr>
>> <tr>
>> <td align="left" width="50%" height="25">
>> <p align="left"></td>
>> <td align="left" width="25%" height="25">
>> <p align="left"><input type="submit" name="addrequest" value="add
>> request">
>> </p>
>> </td>
>> <td align="left" width="25%" height="25">
>> <input type="reset" name="resetButton" value="Reset">
>> </td>
>> </tr>
>> </table>
>> </form>
>> <p align="left"></p>
>> <hr>
>>
>> <div id="overDiv" style="position:absolute; visibility:hidden;
>> z-index:1000;"></div>
>>
>>
>> <p align="center"><a href="index.php">[Home]</a></p>
>>
>>
>> </form>
>> </body>
>>
>> </html>
>
>
> //Aho

• Next in forum: Re: Mmmm...New Blog Version
• Prev in forum: Mmmm...New Blog Version
• Thread view: Re: redirection to another php page

[Reply to this message]