Expand|Select|Wrap|Line Numbers
- <html>
- <head>
- <title>Fill Form</title>
- <link rel="stylesheet" type="text/css" href="page.css">
- <script>
- // Helper function
- function upTo(el, tagName) {
- el = el && el.parentNode;
- tagName = tagName.toLowerCase();
- for ( ;el; el = el.parentNode) {
- if (el.tagName && el.tagName.toLowerCase() == tagName) {
- return el;
- }
- }
- return null;
- }
- // Row cloning function
- function cloneRow(el) {
- var newRow;
- var row = el && upTo(el, 'tr');
- if (row) {
- newRow = row.cloneNode(true);
- row.parentNode.appendChild(newRow);
- }
- }
- </script>
- </head>
- <body>
- <div class="header">
- <img src="817.jpg" alt="logo"/>
- <h2 align="left"><font face="Trebuchet MS">SOFTWARE
- DEVELOPMENT CHANGE REQUEST FORM</font></h2>
- </div><br><br>
- <form name="myForm" method="post"
- action="to_db.php" onSubmit="alert('YOUR REQUEST HAS BEEN RECEIVED.');" >
- <TABLE BORDER=0>
- <TR>
- <TD><font face="Trebuchet MS">Department</font> </TD>
- <TD><select name="department"><option>
- -select- <option>Finance<option>
- Systems<option>HR&ADMIN
- <option> Access <option> Backbone <option> Engineering & ops
- <option> Pricing <option> Project management <option>
- Service Delivery <option> Others</select></TD>
- <TD><font face="Trebuchet MS">Date Submitted</font></TD><TD>
- <input type="date" name="bday" >
- </TD>
- </TR>
- <TR>
- <TD><font face="Trebuchet MS">Requested by</font></TD>
- <TD><INPUT type=text name="reqby"></TD>
- <TD><font face="Trebuchet MS">priority</font></TD>
- <TD><select name="priority"><option value="1">1
- <option value="2">2<option value="3">3
- <option value="4">4<option value="5">5</select></TD>
- </TR>
- <TR>
- <TD><font face="Trebuchet MS">Description Of Change:</font></TD>
- <TD> <textarea name="doc" id="doc" cols="25" rows="3"></textarea></TD></TR>
- <TR>
- <TD><font face="Trebuchet MS">Bussiness Impact Of Change:</font></TD>
- <TD> <textarea name="boc" id="doc" cols="25" rows="3"></textarea></TD>
- </TR>
- </TABLE><br><br>
- <table class="dynatable1">
- <thead>
- <tr>
- <th><font face="arial">Bussiness Process Impacted</font></th>
- <th><font face="arial">Tools Used / System Impacted</font></th>
- <th><font face="arial">Bussiness Driver description</font></th>
- <th><font face="arial">Impact category</font></th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td><textarea name="v1" cols="30" row="1" id="demo3" value=""></textarea></td>
- <td><textarea name="v2" cols="50" rows="2" id="demo1" value="" /></textarea></td>
- <td><textarea name="v3" cols="50" rows="2" id="demo2" value="" /></textarea></td>
- <td> <select name="v4"><option>-select-<option>
- Customer Satisfaction<option>Strategic
- <option>Fte<option>Time</select></td>
- </td>
- <td><button type="button" onclick="cloneRow(this)">Add a row</button>
- </tr>
- </tbody>
- </table><br><br>
- <input name ="printbtn" type="image" src="submit.jpg" class="submit"
- value="SUBMIT" >
- </form>
- <div class="screen">
- <div class="innerdiv">
- For any changes or queries ,
- click on mail<a
- href="mailto:bnoronha@virtela.net?
- Subject=CR FORM QUERY%20" target="_top"> mail </a>
- </div>
- </div>
- </body>
- My PHP CODE
- <?php
- $username="root";
- $password="";
- $hostname="localhost";
- //connection to the database
- $dbhandle= mysql_connect($hostname,$username,$password)
- or die("Unable to connect to database");
- //select your database
- $selected = mysql_select_db("form",$dbhandle)
- or die("could not select the database");
- //get the data an put data in database
- $val1 = $_POST['crno'];
- $val2 = $_POST['department'];
- $val3 = $_POST['bday'];
- $val4 = $_POST['reqby'];
- $val5 = $_POST['priority'];
- if(isset($_POST['doc']))
- {
- $dec_of_change = $_POST['doc'];
- }
- if(isset($_POST['boc']))
- {
- $bus_of_change = $_POST['boc'];
- }
- if(isset($_POST['v1']))
- {
- $variable_string1 = $_POST['v1'];
- }
- if(isset($_POST['v2']))
- {
- $variable_string2 = $_POST['v2'];
- }
- if(isset($_POST['v3']))
- {
- $variable_string3 = $_POST['v3'];
- }
- if(isset($_POST['v4']))
- {
- $variable_string4 = $_POST['v4'];
- }
- if ($val2 == "" || $val3 == "" || $val4 == "" || $val5 == "" || $dec_of_change == "" || $bus_of_change == "" || $variable_string1 == "" ||$variable_string2 == "" || $variable_string3 == "") {
- echo "Fill the entire form ";
- header("Location: fill.html"); }
- else {
- $sql="INSERT INTO fill1(department,date, reqby, priority,doc,boc,bpi,tu,bd,ic)VALUES('$val2', '$val3', '$val4' , '$val5' ,'$dec_of_change' , '$bus_of_change','$variable_string1','$variable_string2','$variable_string3','$variable_string4')";
- $result=mysql_query($sql);
- header("Location: startpage.html");
- //ends here
- //close the connection
- mysql_close($dbhandle);
- }
- ?>