Hi, am a new user here and also a beginner. I've been working on a project and got stuck. I have a table which I dynamically(using ajax) add rows that comprises of input text, select box and text area using the following code
$("#add_row").on("click", function()
{
var pam = $("tr:last-child td:first-child").html();
if(pam=="s/n") pas=1;
else
{
var past = parseInt(pam);
var pas = (past) + 1;
}
$.ajax(
{
url:"../Admin_Manager/financeHandler.php?opt=income_tbl&adrw="+pas,
type:"POST", dataType:"json",
error: function()
{ alert("error now");
},
success: function(data)
{
$("#table_inc").append(data.table);
$('#numrows').html(data.numrows);
}
});
});
<?php
require_once "./database/Model.php";
$db=new Model();
if(isset($_GET['opt']))
{
$opt = trim($_GET['opt']);
switch ($opt)
{
case 'income_tbl':
$pam = $_GET['adrw'];
$table='<tr id="row'.$pam.'"><td>'.$pam.'</td><td><select id="item_name'.$pam.'" name="i_name'.$pam.'">
<option value="tithe">Tithes</option>
<option value="offer">Offering</option>
<option value="donations">Donations</option>
<option value="others">Others</option>
</select></td><td>
<textarea type="text" rows="3" cols="30" name="inc_desc'.$pam.'" id="inc_desc'.$pam.'"></textarea>
</td><td><form class="form-inline"><div class="form-group">
<label class="sr-only" for="in_Amount">Amount (in Naira)</label>
<div class="input-group"><div class="input-group-addon">₦</div>
<input type="text" class="form-control" name="inc_amt.'.$pam.'" id="inc_amount'.$pam.'" placeholder="Amount">
<div class="input-group-addon">.00</div></div></div></form></td><td>
<input type="date" name="inc_date'.$pam.'" id="date_in'.$pam.'"></td></tr>';
echo json_encode(array("table" => $table, "numrows" => $pam ));
break;
?>
Am confused about how to submit multiple rows of the table to my database. Thanks in advance.