- PHP Tutorial
- PHP Syntax
- PHP Variables
- PHP Data Types
- PHP Constants
- PHP Operators
- PHP if elseif else statements
- PHP Switch Statement
- Arrays in PHP
- Loops in PHP
- Strings in PHP
- GET and POST in PHP
- Functions in PHP
- Cookies in PHP
- Sessions in PHP
- Include and Require in PHP
- File Opening and Reading in PHP
- File Creation and Writing in PHP
- Form Validation in PHP
- Date and Time Functions in PHP
- Validation and Sanitizing Data Via PHP Filters
- Introduction to Object Oriented Programming in PHP
- Parameterized Constructors in PHP
- Inheritance in Object Oriented PHP
- Abstract Class in PHP
- Math Functions in PHP
- Error and Exception Handling in PHP
- Reading XML data in PHP
- Reading XML Nodes/Attributes Values in PHP
- XML DOM Parser
- Sorting Arrays in PHP
- Commonly Used Array Functions in PHP
- Commonly Used String Functions in PHP
- Access Modifiers in PHP
- Variable Examination Functions in PHP
- File Upload in PHP
- PHP and AJAX
- PHP Frameworks
- Connecting PHP to MySQL
- Create Database in MySQL via PHP Script
- Drop Database in MySQL via PHP Script
- Selecting Mysql Database via PHP Script
- Create Table in MySQL via PHP Script
- Drop Table in MySQL
- Inserting Data in MySQL Table via PHP Script
- Selecting MySQL Table Data via PHP Script
- Where Clause in MySQL
- Update MySQL Table data via PHP Script
- Deleting Data From MySQL Table via PHP Script
- Sorting MySQL table data via PHP Script
- LIKE Query in MySQL
- Select Unique Data via Distinct In MySQL
- IN Operator in MySQL
- Using BETWEEN operator in MySQL
- AND/OR Operators In MySQL
- Selecting Limited records via LIMIT in MySQL
- Max and Min Functions in MySQL
- SUM and AVG Functions in MySQL
- Using COUNT Function in MySQL
- UCASE and LCASE Functions in MySQL
- GROUP BY and HAVING Clauses in MySQL
- INSERT INTO SELECT in MySQL
- DEFAULT Statement in MySQL
- Implementing Check on Table Columns
- INNER JOIN in MySQL
- LEFT JOIN in MySQL
- RIGHT JOIN In MySQL
- Implementing FULL Join in MySQL
Connecting PHP to MySQL
MySQL works great with multiple platforms such as Java, C, C++, Python, PHP etc. However, in this series of articles, our focus will be on executing MySQL queries via PHP queries.
Though there are multiple ways of connecting PHP scripts to MySQL, this article focuses on using MySQLi technology. MySQLi provides both object oriented as well as procedural way of connecting to MySQL databases. In this article, we shall see both approaches.
Object Oriented MySQLi
Object oriented MySQLi uses built-in mysqli class to connect to MySQL databases. This object takes three parameters i.e. database name, user name and password. When used in if block the connect_error function of the mysqli object returns true if connection establishment is failed, else it returns false. Let’s have a look at a working example.
Using MySQLi for connecting PHP to MySQL connect_error) { die("Connection not established: " . $connection->connect_error); } echo "Connection established successfully."; ?>
To run this code on your machine you will have to change the values for server, username and password and replace it with your own.
Procedural MySQLi
Apart from creating mysqli object, you can also connect PHP scripts with MySQL database via procedural MySQLi approach. This is demonstrated in the following example.
Using MySQLi for connecting PHP to MySQL connect_error) { die("Connection not established: " . $connection->connect_error); } echo "Connection established successfully."; ?>
In procedural MySQLi you simply use mysqli_connect function rather than creating object of mysqli to connnect PHP script to MySQL.