Insert data from a php table to my mysql database

Question

I would like to ask for support to be able to insert the data I bring into a table and insert it into a table in my mysql database.

enter image description here

I have a button that I want to click on to save the data in a mysql table.

How do I pass the data that is in the table and send it to the database?

Can I do it using AJAX?

Share the code of what you have tried.

Abdellah Ramadan
– Abdellah Ramadan

2020-06-14 05:39:49 +00:00
Commented Jun 14, 2020 at 5:39 — Abdellah Ramadan
– Abdellah Ramadan, Commented Jun 14, 2020 at 5:39

R Var · Accepted Answer · 2020-06-14 05:48:07Z

1

Yes - you can save using AJAX. One possible approach:

When a user clicks save, run a loop in javascript to gather the fields of each row into an object, and add it to an array; a structure like:

var table_data = [
    {field1:value1, field2:value2, field3: value3...}, // one of these for every row in the table
]

fieldX would be the names of your column headers, and valueX would be the values of those fields.

Using ajax, post the data to a server-side script. An example using jQuery:

$ajax.({
    type : 'POST',
    url  : 'script.php',
    data : { 'submit_data' : table_data } 
});

On the server in a file called script.php, receive the POST'ed data, and then run a loop over the data to save each row to the table. Here's a sparse example, using PHP and mysqli:

$mysqli = database_connection();
$data = $_POST['submit_data']; //sanitize this!

foreach($data as $row){
    $mysqli->query( "INSERT INTO data_table (field1, field2, field3) VALUES($row['field1'], $row['field2'], $row['field3'])" );
}

Bear in mind the above is very unsafe for a production environment; at a minimum, you should use prepared statements and parameter binding to insert the data: https://www.php.net/manual/en/mysqli.quickstart.prepared-statements.php

I hope this gets you going. GL!

edited Jun 14, 2020 at 5:48

answered Jun 14, 2020 at 5:43

R Var

114 bronze badges

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

2 Comments

Pedro Islas Reséndiz Over a year ago

Thanks for your comment. How can I extract the data from the table? I use datatable plugin. I would like to extract the data from the datatable and send it through an array using ajax. Could you help me please.

R Var Over a year ago

I'm not familiar enough with datatable to know whether it has functionality to convert the table data into an array, but, using jquery, you can do something like: ``` var table_rows = array(); $('table tbody tr').each(function(){ var row = array(); $(this).find('td').each(function(){ row.push( $(this).text() ); }); table_rows.push(row); }) ``` Bear in mind the above is an array of arrays, and not an array of objects that contain the field names

Collectives™ on Stack Overflow

Insert data from a php table to my mysql database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related