Insert values in database from array table using ajax and php

Question

help me to insert data from array inputs from my table using ajax and php. I have the separate php file, but it is blank at the moment.

this is my current html + php code:

<form class='form-horizontal form-validate' id="form">
<?php
echo "<table id='example' class='table table-bordered'>
<thead>
<tr>
<th>Category</th>
<th>Last Qtr Average time</th>
<th>Target time</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Category</th>
<th>last Qtr Average time</th>
<th>Target time</th>
</tr>
</tfoot>
<tbody>";
$get_category_query = "select * from daily_checklist_category order by category asc";
$get_category_result = mysql_query($get_category_query) or die(mysql_error());
while($count_rows = mysql_fetch_row($get_category_result)){
echo'<tr>';
echo'<td>'.$count_rows[1].'</td>';
echo'<td id="fucktime[]">'.$count_rows[2].'</td>';
echo'<td><input type="text" value="'.$count_rows[3].'" id="cat_rows[]"/></td>';
echo'</tr>';                                    
}
echo "</tbody>

</table>";
?>
<div class="form-actions">
<input type="submit" id="finish" class="btn btn-primary" value="Submit">
</div>

and this is my ajax :

$(document).ready(function(){

  $('#form').ajaxForm(function(){
    //$("#loading").fadeIn();

    var catRows = $('#cat_rows[]').val();
    $.ajax({
        type: "GET",
        data: $('#form').serialize(),
        url: 'pages/scripts/insert_daily_checklist_category.php',
        cache: false,
        success:function(data){
            alert('Daily Checklist Categories are now updated.');
        }
    });
  });

});

need help.

devpro · Accepted Answer · 2016-01-23 08:46:17Z

1

Issue in your code is that, you are not using name field in input field:

<input type="text" value="'.$count_rows[3].'" id="cat_rows[]"/>

This Should be:

<input type="text" name="cat_rows[]" value="'.$count_rows[3].'" id="cat_rows"/>

In jQuery:

You need to get this value as:

var catRows = $('#cat_rows').val();

Side note:

I am assuming you are using closing tag in your original file.

Also use mysqli_ or PDO becuase mysql_ extension is deprecated and not available in PHP 7.

edited Jan 23, 2016 at 8:46

answered Jan 23, 2016 at 4:35

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Pao Over a year ago

thanks for that. i tested that in ajax and json, tried to output it, but it alerts, "undefined" instead of its value.

devpro Over a year ago

Undefine in ajax success @pao

Pao Over a year ago

yes. how can i get atleast 1 row to be outputed in my ajax success? using json?

devpro Over a year ago

@pao if u r sendind response in ajax than use datatype in ajax param dataType:"json",

Pao Over a year ago

this is my ajax code: $(document).ready(function(){ $('#form').ajaxForm(function(){ //$("#loading").fadeIn(); var catRows = $('#cat_rows').val(); $.ajax({ type: "GET", data: {'cat_rows':catRows}, url: 'pages/scripts/insert_daily_checklist_category.php', cache: false, dataType: 'json', success:function(data){ alert(data.catrows); //alert('Daily Checklist Categories are now updated.'); } }); }); });

|

Vikash Kumar · Accepted Answer · 2016-01-23 06:46:37Z

0

First add the name attribute into your input form element like this.

echo '<td><input type="text" name="cat_rows[]" value="'.$count_rows[3].'" id="cat_rows_'.$count_rows[3].'"/></td>';

And your are already using ajaxForm jquery so there is no need of any another write ajax statement into callback. Your ajaxForm jquery would be like this.

jQuery Example-

// bind form using 'ajaxForm' 
$('#form').ajaxForm({
  url: 'pages/scripts/insert_daily_checklist_category.php',
  beforeSubmit: function(formData, jqForm, options) {
    // write code here like loader if needed
  },
  success: function(responseText, statusText, xhr, $form) {
    // write code for response handling
  }
});

answered Jan 23, 2016 at 6:46

Vikash Kumar

1,1119 silver badges17 bronze badges

3 Comments

Pao Over a year ago

how i do retrieve array input rows using php? var catRows = $('#cat_rows').val(); this is my variable in ajax call to get values from my array input boxes, but it seems that its getting nothing.

Vikash Kumar Over a year ago

@Pao, Why are you doing this, I can't understand? There is no need of this, you can retrieve form input value at php server just using $_REQUEST['cat_rows'] and this will return an array.

Pao Over a year ago

its ok now, thanks for the advices sir. i used $('#form').serialize() instead of var catRows = $('#cat_rows').val(). and i used while loop and if else statement inside it to update my database rows from my array inputs.

Collectives™ on Stack Overflow

Insert values in database from array table using ajax and php

2 Answers 2

9 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related