How to Connect PHP File to MySQL Database using phpMyAdmin | CRUD Operations

foreign [Music] htdocs this is a web page called user registration now we'll start Apache and MySQL from the zamp control panel in the web browser go to the Local Host [Music] here click on the user registration the page is now visible filling in all details like username email and password and when we click on sign up we get this fatal error that says unknown database now go to phpmyadmin then click on the user accounts here you will see the root user has no password set in the user Administration folder click on the PHP crud folder here open the config PHP file here if you have access to these credentials then you can attach any database again go to the Local Host and then phpmyadmin these are all the databases create a new database with the name PHP crud click on the import button at the top click on the choose file go to the user registration folder open the SQL folder and select the user registration SQL from here scroll down and click on the import button at the bottom once done click on the table member then click on the choose file and then select the employee SQL scroll down and click on the import button at the bottom employee SQL is now imported here you can see all the employees details go to the page that shows the error message and refresh the page go to the table members to access the username and password [Music] use it to log in here you can see all the details using the add new employee button you can add a new employee by providing their name address and salary [Music] let's check in the phpmyadmin you can see a new employee is also added here now there are a total of four employees you can view the details of employees by clicking on the I icon you can edit it by clicking on the pencil icon and you can also delete it by clicking on the trash bin icon the record is also deleted from the database thanks for watching please like share and subscribe

Channel: Outright Systems

Views: 25,212

Keywords: php, mysql, phpmyadmin, database, CRUD, localhost, Xampp, SQL, php tutorial, phpmyadmin tutorial

Id: Fa1a8cTiY4M

Length: 2min 51sec (171 seconds)

Published: Wed Jun 07 2023