how to insert multiple row value in database

system · June 29, 2011, 9:47am

<?php $linkid = mysql_connect('localhost','root','') or die("could not connect to $dbhost database"); mysql_select_db("TMS",$linkid) or die("could not connect to test database"); echo "Time Management System"; ?>

<SCRIPT language="javascript">
    function addRow(tableID) {

        var table = document.getElementById(tableID);

        var rowCount = table.rows.length;
        var row = table.insertRow(rowCount);

        var colCount = table.rows[1].cells.length;

        for(var i=0; i<colCount; i++) 
		{

            var newcell = row.insertCell(i);

            newcell.innerHTML = table.rows[1].cells[i].innerHTML;
            //alert(newcell.childNodes);
            switch(newcell.childNodes[0].type) 
			{
			 			
								
                case "text":
						//alert("come here 12");
                        newcell.childNodes[0].value = "";
						
						if(newcell.childNodes[0].name == "date" )
						{
              				newcell.childNodes[0].name = "date_"+rowCount;
                        } 
						else if(newcell.childNodes[0].name == "from_time" )
						{
              				newcell.childNodes[0].name = "from_time_"+rowCount;
                        } 
						else if (newcell.childNodes[0].name == "to_time")
						{
              				newcell.childNodes[0].name = "to_time_"+rowCount;
                        }
						else if (newcell.childNodes[0].name == "hrs_spend")
						{
              				newcell.childNodes[0].name = "hrs_spend_"+rowCount;
                        }
						else if (newcell.childNodes[0].name == "comment")
						{
              				newcell.childNodes[0].name = "comment_"+rowCount;
                        }
						else if (newcell.childNodes[0].name == "pro_name")
						{
              				newcell.childNodes[0].name = "pro_name_"+rowCount;
                        }
						else if (newcell.childNodes[0].name == "devlp_name")
						{
              				newcell.childNodes[0].name = "devlp_name_"+rowCount;
                        }
						break;
						
						 case "checkbox":
						 
						 newcell.childNodes[0].checked = true;  
                        if (newcell.childNodes[0].name == "chk")
						 {
              				newcell.childNodes[0].name = "chk_"+rowCount;
                        }                         
                        break;
                
				 	case "select-one":
                        newcell.childNodes[0].selectedIndex = 2;
                        break;
													
               			/*case "select":
                          if (newcell.childNodes[0].name == "pro_name")
						 {
						   newcell.childNodes[0].name = "pro_name_"+rowCount; 
						   
						   newcell.childNodes[0].+"pro_name_"+rowCount = newcell.childNodes[0].selectedIndex;
						}
						
                        break;	 			 		
						*/
                        
                 }       
   
			   
			   
				
           
        }
    }

    function deleteRow(tableID) {
        try {
        var table = document.getElementById(tableID);
        var rowCount = table.rows.length;

        for(var i=0; i<rowCount; i++) {
            var row = table.rows[i];
            var chkbox = row.cells[0].childNodes[0];
            if(null != chkbox && true == chkbox.checked) {
                if(rowCount <= 1) {
                    alert("Cannot delete all the rows.");
                    break;
                }
                table.deleteRow(i);
                rowCount--;
                i--;
            }

        }
        }catch(e) {
            alert(e);
        }
    }

</SCRIPT>

<script language="JavaScript" src="calendar_db.js"></script>
<link rel="stylesheet" href="calendar.css">

<?php $project_name=$_POST['project_name']; echo ''; ?> <?php $develp_name=$_POST['dev_name']; echo ''; ?>

<td><input type="text" name="date" />
<script language="JavaScript">
new tcal ({
	'formname': 'testform',
	'controlname': 'date'
});
</script></td>
<td><input type="text" name="from_time"/></td>
<td><input type="text" name="to_time"/></td>
<td><input type="text" name="hrs_spend"/></td>
<td><input type="text" name="comment" /></td>
 <input type="hidden" name="pro_name" value="<?php $_POST['project_name']; ?>"/>
 <input type="hidden" name="devlp_name" value="<?php $_POST['dev_name']; ?>"/>

Project Name

Developer Name

Date

From time

To time

Hrs Spend

comment

<?php $sql = "select * from si_project_developer"; echo ' Select project';

$result = mysql_query($sql);
while ($db_field = mysql_fetch_assoc($result))
{
$project_name = $db_field[‘project_name’];

echo ‘’.$project_name.’’;

}
echo ‘’;?>

<?php $sql = "select * from si_project_developer"; echo ' Select developer'; $result = mysql_query($sql); while ($db_field = mysql_fetch_assoc($result)) { $dev_name = $db_field['dev_name'];

echo ’

'.$dev_name.'';

}
echo ‘’;?>

<?php echo $_POST['project_name']; ?>

<INPUT type="button" value="Delete Row" onClick="deleteRow('dataTable')" />
    <INPUT type="submit" value="submit" />