944,120 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 2513
  • MySQL RSS
Jun 29th, 2005
0

Interface page for my new database...

Expand Post »
Ok, so i created a db, with the help of the MYSQL manual and think i'm on the right track (well, i'm on a track at least).


this db is for our members area (car club web site).

I put 3 tables in there
users
auto_info
auto_mods


all 3 have a row named ID that is auto-incrementing and primary.

I would like to be able to add a member via an 'admin' webpage, that will store basic info into each table, and create a pw for the user (would like to use user_lastname, ID, and pw as login info) to initally log in, and change their stuff, and pw.

does anyone have somethign similar they could share w/ a noob like me?
Thanks,
Jason
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ZR2_S10 is offline Offline
4 posts
since Jun 2005
Jun 29th, 2005
0

Re: Interface page for my new database...

First of all, it sounds like you don't have any graphical interface for MySql currently. Do you have phpMyAdmin? If not, GET IT!
http://www.phpmyadmin.net/home_page/

phpMyAdmin is a PHP browser-based MySQL Administration tool. You can create databases, table, columns, edit current data, get lists of data, import, export, etc. It's really nice, and it's free. Installing it is *easy*, but depending on your exact server setup, you may run into small issues. Just follow the documentation, and keep banging until you get it working. You can use it as your admin tool to add users into your table -- that is if only you need to have this privilege. You don't want to give anyone else access to directly modify your database and tables.

If you want a tool to help you build web forms to your MySQL data, look at Databik. This is the second post in which I'm "recommending" this tool, but I've never used it...so I hope somebody provides some feedback regarding it. It looks like a solid, simple, tool.
http://www.dadabik.org/index.php

I have personally authored a PHP class to handle Session Management & Password Protection. I wrote an article about it.
http://www.tgreer.com/class_session_php.html

The class includes a sample login.php page that works with the session mgmt class. You'll need to insert your own database logic to test authentication.

For working with your database in PHP, I've authored another class that I think makes working with MySQL very easy (PHP already makes it really easy!) My class provides a common interface to multiple databases, so if you ever end up changing databases, it's not difficult to migrate your code. My class_db also allows you to cache data if your database resources are limited. The caching mechanism is transparent to your code. Probably more than you need, but the article & code can teach you about working with MySQL in PHP.
http://www.tgreer.com/class_db_php.html
Reputation Points: 36
Solved Threads: 6
Posting Whiz
Troy is offline Offline
354 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: simply generate user front end for mysql ?
Next Thread in MySQL Forum Timeline: Find table size





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC