PHP Heads. User database
- Started
- Last post
- 5 Responses
- murmur
I need to either write, or use an existing script that will allow a client to login to a client database, change passwords related to each client and track client activity. If any of those features ring a bell please point me in the way. Pre-made software or tutorials. Thanks!
- unfittoprint0
//something like this
$link = @mysql_connect($dbHost, $dbUser, $dbPass);
$query = "UPDATE users_table SET password='$password";
$result = @mysql_query($query);
if($result){
echo "password change";
} else {echo "password change";
}
- murmur0
Thanks Unfit.
I'm also looking for feature rich options. I found PHP Gaurd Dog which seems suitable. Mostly because it already has the backend written.
Any Experience with other similar solutions?
- mud0
just use phpmyadmin:
- zeuben0
what you need is actually pretty simple to build yourself and can save you the hassle of all the extra mung you ususally have to cut through when you work with a pre-fab codebase.
you need 3 tables: a users table, a clients table, and a projects table.
each of those tables should contain the fields you need to keep track of those informations - ie -- > users = userID, username, password, email, secret code, etc.. clients -- > clientID, clientName, etc.. projects -- > projectID, projectName, clientID, projectDate, description.. etc..then follow the basic DB routine posted by unfittoprint to get the data in there from the form.
Once you get the info going into the DB -- the rest is cake. think of it as one DBcolumn per form field -- or something.
--- INSERT INTO's and UPDATE WHERE's -->
oh yeah and make sure you store a session for each user.this might help.
masticate.
- murmur0
Hey thanks for the help.
PHP MyAdmin isn't a suitable soloution for the client however i have come across a prefab soloution that is GPL and has a very lite code base. I am newish to PHP so my logic is find something that works and tweak it. With the assumption that i will spend less time debugging if i were to start from scratch.