PHP and MySQL Connection in Visual Studio Code | How to Connect MySQL Database to PHP | #1

How to Connect MySQL Database with PHP
MySQL is a highly popular database management system that can power projects of all sizes. Its ability to handle huge volumes of data without breaking a sweat is one of its biggest selling points. Connect MySQL with PHP code, you can make use of one of three methodologies.

There are three types of methods in PHP to connect MySQL database through backend:

MySQL
MySQLi
PDO
mysql() is now obsolete because of security issues like SQL injection etc, but the other two are being actively used.

MySQLi
MySQLi is an API used as a connector function to link the backend of the PHP app to the MySQL database. It works just like the previous version, but it is safer and faster, and provides a better set of functions and extensions. MySQLi was introduced with PHP 5.0.0 and the drivers were installed in 5.3.0. The API was designed to support MySQL from version 4.1.13 to newer ones.

PDO
PHP Data Objects (PDO) extension is a Database Abstraction Layer. It is like an interface for the backend to interact with the MySQL database and make changes without making any change in the PHP code. It also gives you the freedom to work with multiple databases. The major advantage of using PDO is that your code stays simple and portable.

In this article, I’ll discuss how to connect MySQL Database on different servers and I’ll also give you an overview of connecting Database using PDO.

Connect MySQL using Localhost Server
Connect MySQL using Cloudways Server
Connect MySQL using PDO
Connect MySQL using Remote MySQL
Connect MySQL Database with PHP
Create MySQL Database at the Localhost
Create Database
Create a Folder in htdocs
Create Database Connection File In PHP
Create new php file to check your database connection
Run it
Create MySQL Database at Cloudways Server
Create Database Connection
MySQLi Procedural Query
Connect MySQL Database with PHP Using PDO
Check Connection
Remote MySQL
Top MySQL Management tools
MySQL Workbench
Navicat For MySQL
MySQL Yog
Cloudways MySQL Database Manager
Conclusion
Download MYSQL Cheat Sheet Now
We’ll send a download link to your inbox.

Email Address
I agree to the Cloudways Terms of Service & Privacy Policy
Create MySQL Database at the Localhost
Before you start building PHP connection to MySQL database you need to know what PHPMyAdmin is. It’s a control panel from where you can manage the database that you’ve created. Open your browser and go to localhost/PHPMyAdmin or click “Admin” in XAMPP UI.

When you first installed XAMPP, it only created the username for it to be accessed, you now have to add a password to it by yourself. For this, you have to go to User account where the user is the same as the one shown in this picture:

change password database
Now click Edit privileges and go to Change Admin password, type your password there and save it. Remember this password as it will be used to connect to your Database.

change password database
Note: It is not necessary to change the password to access databases on the localhost. It is a good practice and that is why we have used a password.

Create Database
Now return to the homepage of PHPMyAdmin. Click the New button to create a new database.

phpmyadmin
In the new window, name your database as per your need, I am naming it “ practice ”. Now select Collation as utf8_general_ci, as we are using it for learning purposes and it will handle all of our queries and data that will be covered in this tutorial series. Now click on Create and your database will be created.

create database
The newly created database will be empty now, as there are no tables in it. I will be covering that in the upcoming series where we will learn how to create tables and insert data in it. In this tutorial, we are going to connect this database to localhost using PHP

Follow my Facebook Page : https://www.facebook.com/105940115222549
Follow me on Instagram : https://www.instagram.com/p/CViUlw2sOMi
Follow me on tumblr : http://programming-guru.tumblr.com
Follow me on reddit : https://www.reddit.com/u/Programming_guru1?utm_medium=android_app&utm_source=share