macfall Posted July 12, 2011 Share Posted July 12, 2011 I'm trying to make a user database for my website, and while I have found several MySQL tutorials, I haven't found any that tell me exactly what I need to do. What I need is to have a db that will store user names, passwords, and a Boolean table that will store whether they are paid or free users. Is there a tutorial that will help me out here? Obviously I'm just starting out with this stuff. And while some questions are specific to MySQL and not to PHP, but here's what I need to do with PHP: - Populate the database with data from forms on the website - Create links that are responsive to the paid/unpaid Boolean - Notify me by email whenever someone creates a user account Also, here's one other specific question that I foresee as a problem - I have to use the host's phpMyAdmin to create tables, and as far as I can tell there's no way to change the number of fields once the table is created. So if I name the tables "user1", "user2", "user3" and so forth, will I be able to use a wildcard in my PHP script so that it would interact with all the tables? I hope I'm coming across clearly here; I really don't know enough about what I'm doing to say it any better. Link to comment https://forums.phpfreaks.com/topic/241763-is-there-a-tutorial-specifically-for-usernamepassword-sql-databases/ Share on other sites More sharing options...
teynon Posted July 12, 2011 Share Posted July 12, 2011 Of course there is a tutorial out there somewhere. However. I can't seem to find one that, in my opinion is a complete / proper way of doing it. If you are still looking for a good tutorial on friday / saturday, send me a message. I'll walk you through it. Link to comment https://forums.phpfreaks.com/topic/241763-is-there-a-tutorial-specifically-for-usernamepassword-sql-databases/#findComment-1241676 Share on other sites More sharing options...
macfall Posted July 12, 2011 Author Share Posted July 12, 2011 Well, I hope I get this solved before then. My website is going to be advertised on the radio on Saturday and I really want to have this done before then. Link to comment https://forums.phpfreaks.com/topic/241763-is-there-a-tutorial-specifically-for-usernamepassword-sql-databases/#findComment-1241680 Share on other sites More sharing options...
Drummin Posted July 12, 2011 Share Posted July 12, 2011 I wouldn't create a table for each user. I would have a table called users and add each person to it thereby giving each person an id to identify each person. Link to comment https://forums.phpfreaks.com/topic/241763-is-there-a-tutorial-specifically-for-usernamepassword-sql-databases/#findComment-1241681 Share on other sites More sharing options...
teynon Posted July 12, 2011 Share Posted July 12, 2011 You don't have a login script yet and you're advertising the website on saturday? Hmm... Ok... http://www.phpeasystep.com/phptu/6.html Google.com: PHP username password tutorial Link to comment https://forums.phpfreaks.com/topic/241763-is-there-a-tutorial-specifically-for-usernamepassword-sql-databases/#findComment-1241685 Share on other sites More sharing options...
macfall Posted July 12, 2011 Author Share Posted July 12, 2011 You don't have a login script yet and you're advertising the website on saturday? Hmm... Ok... The timing was pushed up beyond what I wanted. Thanks for the suggestions. Link to comment https://forums.phpfreaks.com/topic/241763-is-there-a-tutorial-specifically-for-usernamepassword-sql-databases/#findComment-1241822 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.