在查询中插入动态文本框值

Question

Here is my javascript and php code and also one form. How can i insert value for multiple dynamic text box in table.please let me know how to put an array in query to insert a value Query of my code.

<?
if(isset($_POST['submit']) && $_POST['submit']=="Submit")
{

  $filter_attr=$_POST['filter_attr'];

    $query=mysql_query("insert into filter (filter_attr,addedon)values ('".$filter_attr."','".date("Y-m-d H:i:s")."')");

  }
?>


<script language="javascript">
var i = 1;
function changeIt()
{

my_div.innerHTML = my_div.innerHTML +"<br><input type='text' size='70' id='filter_attr' name='filter_attr'+ i>"
i++;
}
</script>

<tr height="20"></tr>
<tr height="25">
<td width="30%">Filter Attribute</td>
<td width="50%"><input type="text" name="filter_attr" size="70" id="filter_attr" filter="50"><div id="my_div"></div></td>
<td width="20%"> <input type="button"  value="ADD" onClick="changeIt()"></td>
</tr>
</table>
</form>

Answer 1

just giving a demo of how you can achieve it

  $postedData=$_POST;
  $keys = implode(',', array_keys($postedData));
  $values = implode(',', $postedData);

    $query=mysql_query("insert into filter ('".$keys."',addedon)values ('".$values."','".date("Y-m-d H:i:s")."')");

  }
?>

code is not tested so please tacke care of that