PHP Tutorial
Home
PHP Install Xampp
PHP Syntax & Comments
PHP Variables
PHP Constants
PHP Data Types
PHP Echo & Print
PHP Strings
PHP If...Else...Elseif
PHP Ternary Operator
PHP Loops
PHP Functions
PHP Arrays
PHP GET & POST
PHP Advanced
PHP Date and Time
PHP Include and Require
PHP File Upload
PHP Sessions
PHP Cookies
PHP Send Email
PHP JSON Parsing
PHP MySQL Database
PHP MySQL Introduction
PHP Connect to MySQL
PHP MySQL Create DB
PHP MySQL Create Table
PHP MySQL Insert Data
PHP MySQL Select Data
PHP MySQL Delete Data
PHP MySQL Update Data
PHP MySQL Where
In PHP you can easily do this using the mysqli_connect() function. All communication between PHP and MySQL database server takes place through this connection.
Syntax : MySQLi Procedural
$link = mysqli_connect("hostname", "username", "password", "database");
Example : MySQLi Procedural
<?php // Create connection $link = mysqli_connect("localhost", "root", "password"); // Check connection if (!$link) { die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully"; ?>
Syntax : MySQLi PDO
$pdo = new PDO("mysql:host=hostname;dbname=database", "username", "password");
Example : MySQLi PDO
<?php try { $link = new PDO("mysql:host=hostname;dbname=database", "root", "password"); // set the PDO error mode to exception $link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?>
Syntax : MySQLi Object Oriented
$link = new mysqli("hostname", "username", "password", "database");
Example : MySQLi Object Oriented
<?php // Create connection $link = new mysqli("localhost", "root", "password", "database"); // Check connection if ($link->connect_error) { die("Connection failed: " . $link->connect_error); } echo "Connected successfully"; ?>