Asbestos asked:
I’m making a website and need to allow users to log-in and store information. I only have access to one database, but I can make as many tables and fields as I need.
I’m making a website and need to allow users to log-in and store information. I only have access to one database, but I can make as many tables and fields as I need.
What sort of structure should I use to store the information? Do I have to use some “index” thing?
I know almost nothing about MYSQL, but I’m good at coding things I don’t know. The PHP and the HTML forms is a cinch, I just need to know how to structure the files.
Thanks!
I have PHPmyAdmin. You are not understanding the question. How should I organize the data? Should I have a seperate table for each user? Should I have a table just for usernames and a table for passwords and a table for other things?
Do I need an index? Stuff like that! Examples would be good.
3 Comments to 'What is the most efficient way to make a user database in PHP/MySQL?'
March 17, 2009
I know of a tool that i hope you’ll make use of:
Easy PHP
March 20, 2009
Try using PHPMyAdmin (http://phpmyadmin.net). It is a web-based editing script for MySQL databases, written in PHP. It’ll allow you to visually setup your database.
March 23, 2009
Before you do anything you need to read a book on PHP sessions or cookies. After you do this you will know how to structure a database for multiple user accounts.
The idea is that you know who your visitor is by its unique session id and you make sure to inculde this in you WHERE clauses whenever you make a query to the database.
Good luck.
Leave a comment