I would continue with the queries. That's what a database is made for.
Optimize them and make
shure the fields you search often ( the ones in the WHERE clause ) are
index. Keep the sesion vars
as small as possible. Cookies are quite a pain to program and if the user
has disable them, nothing works.
Maybe an object (OOP) of all user info, serialized in an session var, would
be a solution...
just my advice...
----- Original Message -----
From: Conor McTernan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 7:31 AM
Subject: [PHP] (another, not entirely)sessions question
> Hey there,
> I'm currently writing a web app using php. I was just looking for some
> advice on one aspect. On this site, users will be able to log in and post
> messages, or articles, or replies etc, you get the idea.
> Anyway, I am storing some info about the users, the usual stuff, name,
> email, password, all in mysql. I am also storing other info, such as when
> they last posted, and how many times they have posted.
> When a user posts a new message, the message is sent to mysql and stored
> in a table, at the same time, i also have to increment their total number
> of posts. The way this is done is by selecting the posts field on their
> userid, which i have to find using their username, which is set as a
> session var, when the user logs in. This all results in a good few
> queries to mysql.
> I was wondering would it be better to load all the user info, e.g. number
> of posts, last post date, into session vars, or should i set a cookie on
> the client side, or should i just continue with the queries.
> Any help is appreciated.
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]