Home / Html / Html Table / Jquery / Mysql / Php

Sending Html Table Data Into Mysql Table

May 29, 2023 Post a Comment

I have a dynamic (via jquery) html table like this:

,'Selection1','Selection2', ..... ] url = './index.php'; $('table').find('tr:gt(0)').each(function( i, row ) { var oRow = {}; $( row ).find( 'td' ).each( function( j, cell ) { oRow[ keys[ j ] ] = $( cell ).text(); }); myData.push( oRow ); }); //myData = [ {"ID":"3u3y","Selection1",....},{"ID":"jdjdj",...}.... ] //now you can use one key to send all the data to your server $.post( url, { mydata: JSON.stringify( myData ) }, function(d) { alert( 'Server said, ' + d ); }); //In your PHP script you would look for the data in mydata --> $_POST['mydata']

EDIT

Click the link below to go to a demo.

In THIS DEMO click submit and then look at the console on the right. Click the plus on the left of the failed ajax call and then click the Post tab to examine the data the call attempted to send.

Does that help?

Post a Comment for "Sending Html Table Data Into Mysql Table"

Element?

I have a table and I need the cells to have an element posi…

CSS - Auto Fill Height

Here's a js fiddle of what I currently have, I am tryin…

Store A Generated Random Number In A Variable, Then Call That Variable As A Filename To Bring Up An Image. Javascript

So I have a few pictures that I want to randomly generate o…

CSS Hover Jitter Issue

This is my first question. I usually try to research these …

Right Floated Element Disappears When Using Columns In Firefox

I am using an ol element with column-count and column-gap p…

Setting Link Href From Child Image Src Using JQuery

I am using .wrap() to create a link around each image withi…

How To Limit The Html Table Records In Each Page

I am populating a table in my jsp which has more than 20 re…

Separate Countdown For Divs

I want to show countdown in each of my divs. Right now I ge…

Retain Dynamically Created DropDown List's Selected Value On Event Window.history.back()- JavaScript

Can use the below question as a reference to explain the co…