php mysql function

list.php 

<?php

require_once("func.php");
require_once("setting.php");
$titles=Array("ID","Name","Path","Desc");

$record=array("list_field_id","_name","phone","call_status");

$query="select * from list";

$db_con=conect_db($setting[host],$setting[username],$setting[password],$setting[db]);

table($titles);

display_records($db_con,$query,$record);



?>

setting.php

<?php
/* db conection settings */
$setting=array("username"=>"root","password"=>"12340","host"=>"127.0.0.1","db"=>"dialer");



?>

func.php

<?php

/*db conection function */


function  conect_db($host,$username,$password,$db) {

$link = mysqli_connect("$host", "$username", "$password", "$db");


/* check connection */

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

else {

echo " Sucessfully conected to the database $db  ";

}
return $link;

}






/*table header function */


function table($titles){

echo"<br>
<center>
<table width=\"500\" border=\"0\" align=\"center\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"#999999\" onMouseOver=this.bgColor=\"gold\" onMouseOut=this.bgColor=\"#CCCCCC\">
 <tr align=\"center\" bgcolor=\"#CCCCCC\">";

 foreach($titles as $value){
 echo "<td width=\"150\" nowrap=\"nowrap\"><strong>$value</strong></td>";
}

}



/*db display db elemtn function */


function display_records($link,$query,$record) {

if ($result = mysqli_query($link,$query)) {
$row_cnt = mysqli_num_rows($result);

    printf("Result set has %d rows.\n", $row_cnt);

    while ($row = mysqli_fetch_assoc($result)) {
  echo '<tr bgcolor="#FFFFFF" onMouseOver=this.bgColor="gold" onMouseOut=this.bgColor="white">';

foreach($record as $value) {

echo   "<td width=\"150\" nowrap=\"nowrap\">" .$row[$value] . "</td>";

}

}


}
else {

    printf(" Query failed: %s\n", mysqli_error($link));
exit();
}

}



?>