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 [email protected] on[/code]If someone could help that would be great! Link to comment https://forums.phpfreaks.com/topic/3453-solved-making-a-php-login-page-with-a-mysql-database/ 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? Link to comment https://forums.phpfreaks.com/topic/3453-solved-making-a-php-login-page-with-a-mysql-database/#findComment-11846 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? Link to comment https://forums.phpfreaks.com/topic/3453-solved-making-a-php-login-page-with-a-mysql-database/#findComment-11851 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? Link to comment https://forums.phpfreaks.com/topic/3453-solved-making-a-php-login-page-with-a-mysql-database/#findComment-11858 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. Link to comment https://forums.phpfreaks.com/topic/3453-solved-making-a-php-login-page-with-a-mysql-database/#findComment-11876 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.