Creating a Database with php My Admin in

Creating a Database with php. My. Admin in XAMPP Training Division - LK Domain Registry

What is php. My. Admin? • php. My. Admin is My. SQL administration tool • Support wide range of operations such as creating and managing databases, tables, relations within tables, user permissions, etc… • You can perform these operations through an intuitive web interface without executing any SQL statement! 2

php. My. Admin and XAMPP • XAMPP comes bundled with php. My. Admin • As the initial step install XAMPP 3

Creating a database with php. My. Admin • Make sure you have start Apache & My. SQL services in XAMPP control panel 4

Creating a database with php. My. Admin • Open your web browser and type “http: //localhost/Php. My. Admin” 5

Creating a database with php. My. Admin • Click on the DATABASES tab, write “student” as Database Name and click CREATE button 6

Creating a table with php. My. Admin • Under STRUCTURE tab insert table name as “personal” and number of columns as 2 • Click “Go” button 7

Creating a table with php. My. Admin • Type “indexno” as field name, VARCHAR as field type, and 4 as the length of the field 8

Creating a table with php. My. Admin • Type “name” as field name, VARCHAR as field type, and 10 as the length of the field 9

Creating a table with php. My. Admin • Click “Save” button to create table personal 10

Inserting data to a table • Click INSERT tab 11

Inserting data to a table • Insert data in “value” column considering the data type & length 12

Inserting data to a table • Inserting data by executing SQL insert statement is also possible • Go to SQL tab and provide insert query, click “Go” button 13

View data in a table • Click on BROWSE tab to view data in the table 14

Thank You! training@nic. lk 15