1.

Explain the Database error handling and management process in PHP?

Answer»

Managing Database Connections: The below code snippet describes managing database connection methods and features.

<?php

$servemame = “localhost”;

$username = “username”;

$password = “password”;

$DBname = “SchoolDB”;

// Create connection

Sconn = mysqli_connect($servemame, Susername, Spassword,SDBname);

// Check connection

if (! Sconn) {

die(“Ccnnection failed: “ . mysqli_connect_error( ));

}.

echo “Connected successfully”;

?>

In the above code snippet, three variables are used to connect to the Database server. 

They are 

1. $servemame → Database Server IP address

2. $usemame → Database Server User Name

3. $password → Database Server Password 

4. $DB_Name → Database Name 

The mysqli_connect function uses these variables and connect Database server from PHP scripting. If connection gets fail, output will be printed with MySQL error code. Otherwise connection is success.


Discussion

No Comment Found

Related InterviewSolutions