How can I create a login

I hope you got a basic idea on how to store, fetch data from a mysql table using PHP. Store the login details like username and password to the table. On login page check the value the user have entered and check if those values are there in the table (Both username and password.) The mysql query could be "SELECT count(*) FROM users WHERE username= $_POST[Username] AND password= $_POST[password]". This will return the number of records which satisfies the where condition. If the count is equal to 1 then the login details are correct and thus set a session variable, let us say $_SESSION['login']== true else set the session variable to false. Check this session variable (whether it is true or false. If true allow the user to view the page. If false or the varaible is not set then redirect to the login page) on all the other pages which require the user to be logged in to view the page. The above setup is a basic login page setup. In a real project you need to consider many security related things like sql injection, password encryption etc. Just to learn the logging process the above said details would be fine. For more details about session, mysql related function refer http://www.php.net. Hope that helps you.

I found this quite helpful: http://www.sitepoint.com/article/php-mysql-tutorial - How to build your own database driven website, helpful for learning about mysql and php. http://www.sitepoint.com/article/users-php-sessions-mysql - Managing Users with PHP Sessions and MySQL, has the actual code for it aswell Hope it helps

u can download a simple script from here http://php.html.it/script/vedi/1804/phpmylogin-v-15/ very easy to install. It create table in MySql where register all passwor.