Write a note PHP MySQL database connection?

1.	Write a note PHP MySQL database connection?
Answer» Database Connections: Before accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect() Function. Syntax: mysqli_connect(“Server Name” , “User Name” , “Password” , “DB Name”); This function requires four parameters to connect to database server. Database Server name, Database username, password and Database Name. Managing Database Connections: The below code snippet describes managing database connection methods and features. <?php $servername = “localhost”; $username = “username”; $password = “password”; $DBname = “SchoolDB”; // Create connection $conn = mysqli_connect($servemame, Susername, Spassword,$DB_name).

Answer»

Database Connections:

Before accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect() Function.

Syntax:

mysqli_connect(“Server Name” , “User Name” , “Password” , “DB Name”);

This function requires four parameters to connect to database server. Database Server name, Database username, password and Database Name.

Managing Database Connections:

The below code snippet describes managing database connection methods and features.

<?php

$servername = “localhost”;

$username = “username”;

$password = “password”;

$DBname = “SchoolDB”;

// Create connection

$conn = mysqli_connect($servemame, Susername, Spassword,$DB_name).

Discussion