when OnClick on a cell (td) of a table should call a php script with post

Job ID: 32905895

Budget: €30 – €50 EUR

i have an html table in a php page. i want a procedure when i click on a cell of this table to call a php post request script and run a mysql query to change a value. after this script, should refresh the table data without refreshing the page (ajax).
Also when clicking on another cell (td) should open a dialog form to insert one value and after confirm this form should call a php to insert values in mysql table with this value and some data from this row.
Related categories: PHP JavaScript AJAX MySQL HTML