проблему с динамическим добавлением строки решить удалось
<script src="js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="js/dataTables.bootstrap.min.js" type="text/javascript"></script>
<link rel="stylesheet" href="css/jquery.dataTables.min.css">
<link rel="stylesheet" href="css/dataTables.bootstrap.min.css">
<br>
<br>
<br>
<script type="text/javascript">
$(document).ready(function() {
var dataSet = [
[ "Tiger Nixon", "System Architect", "Edinburgh", "5421", "2011/04/25"],
[ "Garrett Winters", "Accountant", "Tokyo", "8422", "2011/07/25"],
[ "Ashton Cox", "Junior Technical Author", "San Francisco", "1562", "2009/01/12"],
[ "Cedric Kelly", "Senior Javascript Developer", "Edinburgh", "6224", "2012/03/29"]
];
var t = $('#example').DataTable(
{
data: dataSet,
columns: [
{ title: "col1" },
{ title: "col2" },
{ title: "col3" },
{ title: "col4" },
{ title: "col5" }
]
}
);
var counter = 1;
$('#addRow').on( 'click', function () {
t.row.add( [
counter +'.1',
counter +'.2',
counter +'.3',
counter +'.4',
counter +'.5'
] ).draw( false );
counter++;
} );
// Automatically add a first row of data
$('#addRow').click();
} );
</script>
<div class="container">
<button id="addRow" class="btn btn-success"><i class="glyphicon glyphicon-ok-sign" ></i> Добавить строку</button>
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>Имя</th>
<th>Column 2</th>
<th>Column 3</th>
<th>Column 4</th>
<th>Column 5</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Имя</th>
<th>Column 2</th>
<th>Column 3</th>
<th>Column 4</th>
<th>Column 5</th>
</tr>
</tfoot>
</table>
</div>
</body>
</html>
но теперь открылся вопрос как информацию из новой строки превратить в insert в БД