Implement read/unread like in email

[sarahaziz]

Hello Guys i am trying to implemenet something like the read/unread in the email.How can i do so by using jquery , php and mysql. What i want to do in steps:

1- When i click on a row in html table i change the status of the this message in database. 2- And then change the background of this row but also if i logout and relogin the row remains changed. 3- knowing that i am already using css classes for the table rows.

What i have done till now is that i changed the status of this specific messages in database with an update.

Regards.

[Atli]

Hey.

You would have to have the onclick event of the rows trigger a function that:

1. Sends an AJAX request to a server-side script that updates the database. This is fairly simple using jQuery. (See the AJAX section of the documentation.)
   The server-side (PHP) part is also pretty basic.
2. Swaps out the CSS class/styles for said row. Again, jQuery makes this very easy to do. Just use the addClass, removeClass or css functions of the jQuery object.

And, to make it stay "read" once logged out and in, you would have to check the database to see if it has already been read when you first load the list of emails.