4th quarter 17 php & my sql registration page
DESCRIPTION
PHP & MySQLTRANSCRIPT
PHP & MySQL(Registration Page)
by: Engr. Esmeraldo T. Guimbarda Jr.
Activity:
Open Xampp Control Panel:
Check running services of XAMPP.
Open your web browser and type in localhost/phpmyadmin
1. Click Database2. write section as name of your database3. then click Create
As you can see, the database named section is created. Now click the database section
1. By clicking section name we automatically making a new table2. Input name as login3. Input number of columns as 34. Then click Go
1. Input the following data:
2. Click Save
Note: That Auto-increment allows a unique number to be generated when a new record is inserted into a table.
Name Type Length/Values Index AI
id INT PRIMARY (Check)
username VARCHAR 35
password VARCHAR 35
now create a HTML & a PHP file to connect with the database which was created in MySQL
Open Notepad++
Create a HTML file save as register.html
Note: Save to folder xampp\htdocs\section
Create another PHP file save as register.php
Note: Save to folder xampp\htdocs\section
Test files:● Open the browser and type the URL
localhost/section/register.html
Check MySQL about the data that has been registered.