Įcho "alert('User Name Or Password Invalid!')" Following code has the login form and to get posted value after the form submitted using $_POST. Mysql_Database : mysql database name STEP 3: Create the Login pageĬreate login.php file and copy past the below code to the file.Hostname : It specifies system host name or system ip address.
STEP2: Connect the MySQL database using PHPĬreate config.php file and paste the following code to the file. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 Ĭlick the insert link for login table and give sample user name and password and click go buttonĪfter the sample user data inserted, table will show the data like below image. `user_id` int(11) NOT NULL auto_increment, Please find the image below CREATE TABLE IF NOT EXISTS `login` ( Find the image belowĪfter the database created, click the SQL link from the top menu and paste the following sql query into the text area and click go button below the textarea. For this tutorial we using database name as “user”. Once the browser opens the phpmyadmin page, Enter the database name inside “create new database” field and click create button.
Php login script mysql download how to#
STEP1: Create Database and Table using MySQLįind the below image which show how to Open the phpmyadmin (Php my admin is for creating the MySQL database) In tutorial I’m using the WAMP Server 2.0 which has the MySQL and apache services which will run the php files.
By using the input box, we can get the username and password using php post method which is secure after submitting the form.įirst we have to create a database and enter some dummy user information’s. For authentication process we have to create login page with username and password input field. By using this login script, we can show the secure pages after the login page successfully logged in. This tutorial will explain how to login and logout the web page using php session and database using MySql.
0 kommentar(er)
