Enter data from dynamic table into database

**brayann36** · Oct 30 '13, 05:59 AM

MY HTML CODE

Code:

<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);
	}
?>