Re: [PHP] check unread messages in a forum
the method explained by Stas is the most common method used on all boards.
But if you need a more precise method, that will also require more
ressources from you server, what you can do is have a specific DB table
called "msg_read" taking 2 parameters : msg_id, user_id.
- Each time a user reads a message, you insert the pair "msg_id"/"user_id".
- Each time the user reloads a page,you do something like this :
$sql = "select msg_id from msg_read where user_id = ".addslashes($user_id);
// process $sql query
$msg_list = array();
while ( $row = getNextRow($mysqlResult)){
array_push($msg_list, $row[0]);
}
- when displaying the list of all message you just check if the message is
in the array $msg_list
if ( in_array($currentMsg, $msg_list)){
echo "READ";
}else{
echo "UNREAD";
}
regards
Eric
> Just store the user's last log-in date/time either in the database or in
> cookie. On the next log-in "select * messages where creationDate >
> $userLastLoginDate" and highlight those selected. It won't work for every
> particular unread message, but I doubt if one needs to be that much
> specific.
>
> HTH, Stas
>
> - Original Message -
> From: "Charlotte" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, August 26, 2002 1:04 PM
> Subject: [PHP] check unread messages in a forum
>
>
> > I have made a forum in PHP, and the users are logged in using cookies. I
> > want all new threads (and if there are new replies in an old thread) to
be
> > highlight or something like that.
> >
> > How do I check if a user has read a message or not?
> >
> >
> >
> > /Charlotte
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] check unread messages in a forum
the method explained by Stas is the most common method used on all boards.
But if you need a more precise method, that will also require more
ressources from you server, what you can do is have a specific DB table
called "msg_read" taking 2 parameters : msg_id, user_id.
- Each time a user reads a message, you insert the pair "msg_id"/"user_id".
- Each time the user reloads a page,you do something like this :
$sql = "select msg_id from msg_read where user_id = ".addslashes($user_id);
// process $sql query
$msg_list = array();
while ( $row = getNextRow($mysqlResult)){
array_push($msg_list, $row[0]);
}
- when displaying the list of all message you just check if the message is
in the array $msg_list
if ( in_array($currentMsg, $msg_list)){
echo "READ";
}else{
echo "UNREAD";
}
regards
Eric
> Just store the user's last log-in date/time either in the database or in
> cookie. On the next log-in "select * messages where creationDate >
> $userLastLoginDate" and highlight those selected. It won't work for every
> particular unread message, but I doubt if one needs to be that much
> specific.
>
> HTH, Stas
>
> - Original Message -
> From: "Charlotte" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, August 26, 2002 1:04 PM
> Subject: [PHP] check unread messages in a forum
>
>
> > I have made a forum in PHP, and the users are logged in using cookies. I
> > want all new threads (and if there are new replies in an old thread) to
be
> > highlight or something like that.
> >
> > How do I check if a user has read a message or not?
> >
> >
> >
> > /Charlotte
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] check unread messages in a forum
Hi, Just store the user's last log-in date/time either in the database or in cookie. On the next log-in "select * messages where creationDate > $userLastLoginDate" and highlight those selected. It won't work for every particular unread message, but I doubt if one needs to be that much specific. HTH, Stas - Original Message - From: "Charlotte" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 1:04 PM Subject: [PHP] check unread messages in a forum > I have made a forum in PHP, and the users are logged in using cookies. I > want all new threads (and if there are new replies in an old thread) to be > highlight or something like that. > > How do I check if a user has read a message or not? > > > > /Charlotte > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] check unread messages in a forum
> From: Charlotte [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 26, 2002 8:04 AM > To: [EMAIL PROTECTED] > Subject: [PHP] check unread messages in a forum > > > I have made a forum in PHP, and the users are logged in using > cookies. I > want all new threads (and if there are new replies in an old > thread) to be > highlight or something like that. > > How do I check if a user has read a message or not? I'd say you'd need to keep a list of messages read by users somewhere. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
