insert data from dynamic rows

akaki

Hi,
Any one please help me to insert values to a table from a text box, which field I am increasing with a Add button.

I've a text box in a row & I can add more rows(with text boxes). I am increasing rows with javascript codes.
But how I can Insert all the values to table?

There's also a text box which is not increasing. its fixed.

please see the attchment.

jeremyphphaven

I'm not downloading your attachment... (sorry)...

but no matter how many fields you add (via javascript or what not on the page), name them all the same name followed by brackets

example - <input type="text" name="haircolors[]" />

This way you can then can pick them up in your php like so:

foreach($_REQUEST['haircolors'] as $color)
{
// DO SOMETHING WITH EACH ONE HERE
}

Cheers

jai

<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("db_name",$con);
if($POST["Submit"]=='Submit')
{$comments=$POST["comm"];
$row=$_POST["file"];
$result=implode(",",$row);

$sql=mysql_query("insert into tablename(fieldname)VALUES('$result','$comments')");
}
?>

<html>
<script language="JavaScript">
var glob;
glob = 1;
function insert_row(tablename)
{

var the_table = document.getElementById(tablename);
var new_row_index = the_table.rows.length;
glob = glob + 1;
the_table.insertRow(new_row_index);
the_table.rows[new_row_index].insertCell(0);
the_table.rows[new_row_index].cells[0].innerHTML =(the_table.rows[0].innerHTML);
}

function removeRowFromTable(tblSample)
{
var tbl = document.getElementById(tblSample);
var lastRow = tbl.rows.length;
if (lastRow > 1) tbl.deleteRow(lastRow - 1);
}

	  <td >Text Field: <span style="color:red">*</span><br />

<p> Comments:
<input type="text" name="comm">
</p>
<p>
<input type="submit" value="Submit" name="Submit" />
</p>

</form>
</body>
</html>