alexville Posted February 17, 2006 Share Posted February 17, 2006 Ok, I already have a way for people to register (insert data) into the database. But I wish to create a PHP login script. I'm completly lost with this part and I am hopeing you guys arnt. :-DHere is my database setup:[code]SQL resultHost: localhostDatabase: alexg_webGeneration Time: Feb 16, 2006 at 06:44 PMGenerated by: phpMyAdmin 2.6.4-pl2 / MySQL 4.1.14-standardSQL query: SELECT * FROM `Citizens` LIMIT 0, 30;Rows: 1id Firstname Lastname Username Password Email Invision1 Austin Grenier AustinRocks carcar austin@austin.com on[/code]If someone could help that would be great! Quote Link to comment Share on other sites More sharing options...
wickning1 Posted February 17, 2006 Share Posted February 17, 2006 Are you familiar with the concept of session handling? If no, that's what you need to investigate.If yes, what about logging in has you hung up? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 17, 2006 Share Posted February 17, 2006 What's wrong with "SELECT * FROM citizens WHERE username='$user' and password='$pass'" and checking to see if anything matches? Quote Link to comment Share on other sites More sharing options...
alexville Posted February 17, 2006 Author Share Posted February 17, 2006 Ok thanks for your help, but can someone make me a example script? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 17, 2006 Share Posted February 17, 2006 PHP is not my forte -- I'm sure someone else can give you some psuedo-code or recommend a good tutorial. Good luck. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.