php - Trouble connecting to mysql database when using a config file -

i can't connect database when use these files. here php code.

the db_config.php file:

<?php     define('db_user', "root");     define('db_password', "mypassword");     define('db_database', "mydbname");     define('db_server', "localhost"); ?> 

the db_connect.php file:

<?php      class db_connect     {         //constructor         function __construct()         {             $this->connect();         }          //destructor         function __destruct()         {             $this.close();         }          function connect()         {             // import database connection variables             require_once __dir__ . '/db_config.php';              $con = mysql_connect(db_server, db_user, db_password) or die(mysql_error());             $db = mysql_select_db(db_database) or die(mysql_error());              // returing connection cursor             return $con;         }          function close()         {             //closing db connection             mysql_close();         }     }  ?> 

the add_team.php file:

<?php  $response = array();  if(isset($_post['team_full_name']) && isset($_post['team_short_name']) && isset($_post['league'])) {     $team_fn = $_post['team_full_name'];     $team_sn = $_post['team_short_name'];     $league = $_post['league'];      require_once __dir__ . '/db_connect.php';     $db = new db_connect();      $result = mysql_query("insert teamdata (team_full_name, team_short_name, league) values ('$team_fn', '$team_sn', '$league')");      if($result)     {         $response["success"] = 1;         $response["message"] = "team data added.";          echo json_encode($response);     }     else     {         $response["success"] = 0;         $response["message"] = "error occurred!";          echo json_encode($response);     }     //for testing     //mysql_close($dbhandle); } else {     $response["success"] = 0;     $response["message"] = "required field(s) missing.";     echo json_encode($response); }  ?> 

when use these files run add_team.php file, program crashes (using in java). when change add_team.php file not use db_connect class this:

<?php  $response = array();  if(isset($_post['team_full_name']) && isset($_post['team_short_name']) && isset($_post['league'])) {     $team_fn = $_post['team_full_name'];     $team_sn = $_post['team_short_name'];     $league = $_post['league'];      $dbhandle = mysql_connect("localhost", "root", "mypassword") or die ("unable connect mysql");     $db = mysql_select_db("mydbname", $dbhandle);      $result = mysql_query("insert teamdata (team_full_name, team_short_name, league) values ('$team_fn', '$team_sn', '$league')");      if($result)     {         $response["success"] = 1;         $response["message"] = "team data added.";          echo json_encode($response);     }     else     {         $response["success"] = 0;         $response["message"] = "error occurred!";          echo json_encode($response);     }      mysql_close($dbhandle); } else {     $response["success"] = 0;     $response["message"] = "required field(s) missing.";     echo json_encode($response); }  ?> 

it works perfectly. following tutorial , version doesn't work how guy said set up. doing wrong? i'm new php excuse me if see statements deprecated, change them later. i'm using them because tutorial following pretty old , don't know how use non-deprecated alternatives yet.

also, config file setup db_connect class, because don't have hard code database password in php files performing database transactions. seems bit safer version works. if can better version working, setup? if want make multiple inserts, updates, deletes, etc @ 1 moment, going have reconnect , disconnect every single time call 1 of php files performs database transaction?

please try following in db_connect.php

<?php  class db_connect {     function connect()     {         // import database connection variables         require_once __dir__ . '/db_config.php';          $con = mysql_connect(db_server, db_user, db_password) or die(mysql_error());         $db = mysql_select_db(db_database) or die(mysql_error());          // returing connection cursor         return $con;     }      function close()     {         //closing db connection         mysql_close();     } }  ?> 

and in add_team.php update

$db = new db_connect(); $dbcon = $db->connect(); $query = "insert teamdata (team_full_name, team_short_name, league) values ('{$team_fn}', '{$team_sn}', '{$league}')"; $result = mysql_query($query,$dbcon);