Database Connections with settings & define keyword

 

settings.php

<?php

return[

'database'=>[

'name'=>'vritant_db',

'user'=>'root',

'pass'=> '',

'host'=> '127.0.0.1:3308',

],

];

?>

dbconnect.php

<?php

$settings= include_once('settings.php');

define('DB_HOST',$settings['database']['host']);

define('DB_USER',$settings['database']['user']);

define('DB_PASS',$settings['database']['pass']);

define('DB_NAME',$settings['database']['name']);

try{

$conn =mysqli_connect(DB_HOST,DB_USER,DB_PASS,DB_NAME);

if(!$conn){

throw new Exception("Connection Exeption",1);

}

}catch(Exeption $e){

echo "Connection Error ".mysqli_error($conn);

echo $e->getMessage();

exit;

}

?>