using event to get row id from mysql
using event to get row id from mysql
Hi Allan, hi fellow DataTables users...
Currently i am experimenting with the event "onSubmitSuccess".
My plan is to forward the user to a different page based on the
id of the row... directly after submit.
unfortunately the id does not exist yet when the event fires.
I mean, it certainly does exist in the freshly created row in the mysql table.
I guess I have to do another db query to get the id.
How could i pass it to the onSubmitSucces event?
(possibly via the success callback?)
Currently the user has to reclick the row to get to that page..
for the sake of usability and to make it more convenient I'd
like to to economize on every extra click.
If it is too complicated to achieve this, please let me know.
Any Ideas are greatly appreciated.
Thanks in advance
Martin
Currently i am experimenting with the event "onSubmitSuccess".
My plan is to forward the user to a different page based on the
id of the row... directly after submit.
unfortunately the id does not exist yet when the event fires.
I mean, it certainly does exist in the freshly created row in the mysql table.
I guess I have to do another db query to get the id.
How could i pass it to the onSubmitSucces event?
(possibly via the success callback?)
Currently the user has to reclick the row to get to that page..
for the sake of usability and to make it more convenient I'd
like to to economize on every extra click.
If it is too complicated to achieve this, please let me know.
Any Ideas are greatly appreciated.
Thanks in advance
Martin
This discussion has been closed.
Replies
couldn't see the wood for the trees
(we have a bunch of trees in Berlin)
solved my problem by refeshing the page with an url param via the event.
and a "SELECT MAX(id)" on the page
cheers
martin