mysqli Getting started with mysqli
Remarks
MySQLi is a PHP Extension which enables PHP to communicate with MySQL Databases. MySQLi comes built in with PHP. MySQLi was introduced with PHP 5.0.
MySQLi is available in procedural & Object Oriented style. MySQLi supports CRUD queries, prepared statements,Multiple statements,Transaction and SQL operations.
Before MySQLi, MySQL (Note: Its not MySQLi ) is the Default extension of PHP for connecting MySQL database. Due to several vulnerabilities in MySQL extention,MySQLi was introduced.
Installation or Setup
MySQLi is a PHP Extension which enables PHP to communicate with MySQL Databases. MySQLi comes built in with PHP. MySQLi was introduced with PHP 5.0.
For More details about Installations Refer official PHP MySQLi Documentation
MySQLi Basic Example in Procedural Style
<?php
//Creating Connection to MySQL database using MySQLi
$mysqli = mysqli_connect("IP ADDRESS OR DOAMIN", "username", "password", "database_name");
//Executing Query in the Database using MySQLi
$result = mysqli_query($mysqli, "SELECT * FROM TABLE");
//Getting Results from MySQL
$row = mysqli_fetch_assoc($result);
echo $row[columnName];
//Closing connection to the Database
$mysqli_close($mysqli);
?>
