To retrieve and manipulate the data from MySQL database server.

This function requires four parameters to connect to database server.

1. The mysqli_fetch_assoc() function fetches a result row as an associative array .
2. Syntax
mysqIi_fetch_assoc(result);

Connection function	Close function
1) Before accessing MYSQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect() Function.	Mysqli_close() Function is used to close an existing opened database connection between PHP scripting and MySQL Database Server.
2) This function requires 4 parameters	This function requires only one parameter.

(i) The MySQLi functions allows you to access MYSQL database servers.
(ii) For the MYSQL functions to be available, you must compile PHP with support for the MYSQLi extension.

The SQL query statements are helping with PHP MySQL extension to achieve the objective of MySQL and PHP connection.

The main goal of MySQL and PHP connectivity is to retrieve and manipulate the data from MySQL database server.

(i) MySQL is the most popular Open Source Relational SQL Database Management System.
(ii) MySQL is one of the best RDBMS being used for developing various web-based software applications.

Syntax:
mysqli_connect("Server Name","User Name","password","DB Name");
Example:

In PHP Scripting language many functions are available for MySQL Database connectivity and executing SQL queries. MySQLi is extension in PHP Scripting language which gives access to the MySQL database. MySQLi extension was introduced version 5.0.0.

The MySQLi extension contains the following important functions which are related to MySQL database connectivity and management.
i) Mysqli_connect() Function
ii) Mysqli_close() Function
iii) Mysqli_query() Function

(i) Four Parameters are used to connect to the Database server.
(ii) They are
1.＄ servername -> Database Server server IP address
2.＄ susername -> Database Server User Name
3.＄ password -> Database Server Password
4.＄ DB_Name -> Database Name

Performing Queries: The main goal of MySQL and PHP connectivity is to retrieve and manipulate the data from MySQL database server. The SQL query statements are help in PHP MySQL extension to achieve the objective of MySQL and PHP connection. “mysqli_query” is a function, that helps to execute the SQL query statements in PHP scripting language.
Syntax:
mysqli_query(“Connection Object”,“SQL Query”)
Example:
$con=mysqli_connect(“localhost”,“my_user”,“my_password”,“Student_DB”);
$sql=“SELECT student_name,student_age FROM student”;mysqli_query($con,$sql);