how to retrived records in grid from mysql db to php form

@Codex_NGSep 04.2015 — #PHP only executes off the server, what you need is combination of html, css, ajax, javascript, php & sql commands.

If your using check boxes you need to use ajax which send a request to a php script on the server this php script will send a query to the database, returning the results to the ajax request while using javascript to create the tables in html & css, although with out a working database this request is rather vague.

@ginerjmSep 04.2015 — #As Codex says - your question presents some rather advanced programming techniques. From what I gather you want to display two tables on the screen and using a checkbox, move a set of data from what table to the other table. Correct?

To do that in real-time without a refresh of the page you do need to do some new technologies. OTOH - if you can live with the refresh and a call to the server to achieve your end result, simply make each row of your table #1 a form by itself and use a button rather than a checkbox. A click on a button will trigger a call to your server script where you can take the data from that form and put it into the set of data in your table #2, removing it from the table #1 data. Then your script simply re-builds the page and sends it back. Of course this means using a session var to keep track of the data in table #2 and another to eliminate those records from table #1.

I am imagining that you would have a set of record keys that comprise the total set of data. To start all the records belong to one html table. As you go thru the selection process to move things you would have to split that set of keys into the #1 keys and the #2 keys. I would use two session vars to hold these during the process. Then you could use those two sets (arrays?) of keys to query your db twice - once to re-build the table #1 output and once for the #2 output.

I am also changing your design from having the ability to do multiple selections at a time. If you want to do that, then you would have to use checkboxes all in one form where each box held the value of that record's key. Then you could still build the two session vars I mentioned, adding the key to the #2 var and removing it from the #1 var. Then do the re-build.

Sounds complicated but at this point in your development this will be a bit easier.

how to retrived records in grid from mysql db to php form

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

how to retrived records in grid from mysql db to php form

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴