Simple security scheme for MySQL info portal 1

[GKChesterton]

I'm enabling a knowledge base for spare parts. I need a simple logon/off scheme. No commerce, no high-level security needs. I will have a few users, a stable bunch. MySQL holds the data (converting from MS Access).

I'm new to PHP; getting pretty good at running HTML forms through and using them to query records, but session variables are beyond me so far. My ISP seems to provide mysql not mysqli.

I have a table user_list with three fields: an auto-incr primary, name_user and pass-user. That seems like a decent way to store my users. I should be able to use cookies.

Can anyone recommend a scheme and point me to some scripts? And can I learn about session handling along the way?

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[jpadie]

no worries at all. glad it's all sorted.

if you're looking for another provider you might consider 1&1. I've found their setup very robust and you can change just about anything you need through localised php.ini's. they support both php 4 and 5 too.