function db_connect(&$db_result, $object, $db_name = "")
{
//dev/live
global $flag;
global $g_db_info;
$dbConfig = new dbConfig();
$db_host = $dbConfig::DB_HOST;
if ($db_name == "") {
$db_name = $dbConfig::DB_DATABASE_01;
}
$db_con_array = $dbConfig->getDBconnection();
if (array_key_exists($db_name, $db_con_array)) {
$db_user = $db_con_array[$db_name]['username'];
$db_password = $db_con_array[$db_name]['password'];
}
$db_result = mysqli_connect($db_host, $db_user, $db_password, $db_name);
if (!$db_result) {
die('Could not connect: ' . mysqli_connect_error());
//mail to admin@pbmarketing.ca
$to = "*****@*****.**";
$subject = "The form in " . $_SERVER['SERVER_NAME'] . " Is Broken";
$message = "\n\t\t\t<html>\n\t\t\t<head>\n\t\t\t<title>" . $subject . "</title>\n\t\t\t</head>\n\t\t\t<body>\n\t\t\t<p>The registration form has lost the database connection. Please check and resolve the issue.</p>\n\t\t\t<p>Regards,<br>PB marketing Support</p>\n\t\t\t</body>\n\t\t\t</html>\n\t\t\t";
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <*****@*****.**>' . "\r\n";
$headers .= 'Cc: admin@pbmarketing.ca' . "\r\n";
mail($to, $subject, $message, $headers);
}
if (is_array($object)) {
// array of object
$count = 0;
$table_name = array();
$table = array();
foreach ($object as $obj_key => $obj_val) {
if (is_array($g_db_info) && !array_key_exists($obj_key, $g_db_info) || !$g_db_info) {
$table_name[$count] = $obj_key;
if ($flag == "live") {
$table[$count] = $obj_key;
} elseif ($flag == "dev") {
$table[$count] = $obj_key . "_debug";
}
$count++;
}
}
//end of foreach
$n = count($table);
for ($i = 0; $i < $n; $i++) {
$sql = "SHOW COLUMNS FROM " . $db_name . "." . $table[$i];
$result = mysqli_query($db_result, $sql);
$num = mysqli_num_rows($result);
$field_name = array();
$t = 0;
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$field_name[$t] = $row['Field'];
$t++;
}
$g_db_info[$table_name[$i]] = array('no' => $num, 'name' => $field_name, 'table' => $table[$i]);
}
//end of for loop
} else {
// object - not array
$table_name = $object;
if ($flag == "live") {
$table = $object;
} elseif ($flag == "dev") {
$table = $object . "_debug";
}
$sql = "SHOW COLUMNS FROM " . $db_name . "." . $table;
$result = mysqli_query($db_result, $sql);
$num = mysqli_num_rows($result);
$field_name = array();
$t = 0;
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$field_name[$t] = $row['Field'];
$t++;
}
$g_db_info[$table_name] = array('no' => $num, 'name' => $field_name, 'table' => $table);
}
return true;
}
