MySQLi extension

Question 1

What is the MySQLi extension?

Answer 1

MySQLi (MySQL Improved) is a PHP extension that provides an interface for accessing MySQL databases. It offers enhanced features over the older MySQL extension, including support for prepared statements, transactions, and improved security.

Question 2

How many methods are available to connect to a database using MySQLi?

Answer 2

There are three methods to connect to a database using MySQLi:
Method 1 - MySQLi Object-Oriented
Method 2 - MySQLi Procedural
Method 3 - MySQLi with DSN

Question 3

Method 1 - MySQLi Object-Oriented

Answer 3

$mysqli = new mysqli(“localhost”, “username”, “password”, “database”);

This method creates a new instance of the mysqli class, establishing a connection to the MySQL database using the provided credentials.

Question 4

Method 2 - MySQLi Procedural

Answer 4

$connection = mysqli_connect(“localhost”, “username”, “password”, “database”);

This method uses the mysqli_connect() function to establish a connection to the MySQL database, returning a connection resource.

Question 5

Method 3 - MySQLi with DSN

Answer 5

$dsn = “mysql:host=localhost;dbname=database”;
$username = “username”;
$password = “password”;
$mysqli = new mysqli($dsn, $username, $password);

This method uses a Data Source Name (DSN) to specify the database connection parameters, allowing for a more structured connection string.