DbConnect.class.php (1108B)
1 <?php 2 3 ############################### 4 # include files from root dir # 5 ############################### 6 $root_1 = realpath($_SERVER["DOCUMENT_ROOT"]); 7 $currentdir = getcwd(); 8 $root_2 = str_replace($root_1, '', $currentdir); 9 $root_3 = explode("/", $root_2); 10 if ($root_3[1] == 'core') { 11 echo $root_3[1]; 12 $root = realpath($_SERVER["DOCUMENT_ROOT"]); 13 }else{ 14 $root = $root_1 . '/' . $root_3[1]; 15 } 16 /** 17 * Handling database connection 18 * 19 * @author Ravi Tamada 20 */ 21 class DbConnect { 22 23 private $conn; 24 25 function __construct() { 26 } 27 28 /** 29 * Establishing database connection 30 * @return database connection handler 31 */ 32 function connect() { 33 global $root; 34 include_once $root . '/core/config/api.php'; 35 36 // Connecting to mysql database 37 $this->conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME); 38 39 // Check for database connection error 40 if (mysqli_connect_errno()) { 41 echo "Failed to connect to MySQL: " . mysqli_connect_error(); 42 } 43 44 // returing connection resource 45 return $this->conn; 46 } 47 48 } 49 50 ?>