Connecting to database showing error many time?

[williamnoah]

Pls anyone tell me to connect database

[Barand]

This the content of my include file ("db_inc.php")

<?php
define("HOST",'localhost');
define("USERNAME",'????');
define("PASSWORD",'????');
define("DATABASE", 'test');                         // default database name

function pdoConnect($dbname=DATABASE) 
{
    $db = new PDO("mysql:host=".HOST.";dbname=$dbname;charset=utf8",USERNAME,PASSWORD);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
    return $db;
}

function myConnect($dbname=DATABASE)
{
    mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); 
    $db = mysqli_connect(HOST,USERNAME,PASSWORD,$dbname);
    $db->set_charset('utf8');
    return $db;
}

To use

include 'db_inc.php';

$conn = pdoConnect();                           // pdo connection to default database

or, for example, to connect a different database using mysqli

$conn = myConnect('sakila');

I recommend using PDO.