Unable To Update DB Using JEditable

Exvitermini

I don't understand how to use JEditable. I've been trying all day. I have the table so when I click on a field, it turns into a text box. When i change the content and press enter, it doesn't update the DB.

The structure of my database table is:
member_id int(11)
firstname varchar(100)
lastname varchar(100)
login varchar(100)
passwd varchar(32)
userlevel int(1)

DataTable shows all those fields except for the passwd. The code inside editable_ajax.php doesn't do anything. I tried to put some MySQL code in there to try and update the database but I can't figure out how to do that. I checked out JEditable's website as well and when you edit a field, it will return cell id and the new value. How do I turn that information into MySQL/PHP to update my database?

Thanks for taking your time. I really need to get this done today. Please help me.

Exvitermini

Anyone have any idea?

fbas

try the editable plugin. you can check out their sample code (install it and see how it works, edit it to your liking)


http://code.google.com/p/jquery-datatables-editable/downloads/detail?name=JQuery-DataTables-Editable.example.1.0.0.zip

Exvitermini

Thanks I'll try this

btvbill

I'm using the above now but there really isn't anything in it to help you update the records on a database. I was able to create a page to add new records but so far, no luck with update or delete.