how to update record using ajax and php

[mukeshrasm]

Hi

I am displaying record using php. I am giving the record structure in html format.

Admin will allow user to view the no. of record user will view.

 
<table>
<tr><td>name</td><td>age</td><td>show status</td>
<tr><td>xyz</td><td>12</td><td>yes</td>
<tr><td>abc</td><td>22</td><td>yes</td>
<tr><td>mno</td><td>32</td><td>yes</td>
<tr><td>pqr</td><td>19</td><td>yes</td>
</table>

Say for first record when User will click yes it will update its corresponding record to the database to no i.e not visible to user and it will then be not visible to user at front end.

How this will done using Ajax and php.

[acoder]

Say for first record when User will click yes it will update its corresponding record to the database to no i.e not visible to user and it will then be not visible to user at front end.

Is this for the admin or for the user (the clicking)?

[mukeshrasm]

Is this for the admin or for the user (the clicking)?

This is for admin. Admin will decide which item he wanted to show to user.

[acoder]

For the show status field, either use a button, checkbox or radio button. Use onclick to trigger the Ajax function. Depending on the selection (yes/no), set the field in the database using PHP.

[mukeshrasm]

For the show status field, either use a button, checkbox or radio button. Use onclick to trigger the Ajax function. Depending on the selection (yes/no), set the field in the database using PHP.

Actually in project I wanted to show the status using image(Icons) so when that image will be clicked its corresponding status image will display means if it is active is then active image will come and if deactive then deactive image will come.

[acoder]

Actually in project I wanted to show the status using image(Icons) so when that image will be clicked its corresponding status image will display means if it is active is then active image will come and if deactive then deactive image will come.

Then just change the src property of the image to "active.gif" or whatever.