does it good & safe enough? to estabish additional connection for particular page

Question

I have aleady use mysqli for the main connection, but use this mysql for additioal connection on particular page.

class DBController {
private $host = "localhost";
private $user = "root";
private $password = "";
private $database = "blog_samples";

function __construct() {
    $conn = $this->connectDB();
    if(!empty($conn)) {
        $this->selectDB($conn);
    }
}

function connectDB() {
    $conn = mysql_connect($this->host,$this->user,$this->password);
    return $conn;
}

Is it good & safe enough? Are there better way for doing this? please explain me the advantage. Thanks in advance

It is already bad because `mysql` api is deprecated in latest php5 and removed in php7. And you __must__ forget about it and use `mysqli` or `PDO`. — u_mulder, Apr 21 '17 at 06:50
As already said, stop using mysql and use mysqli or PDO instead. Also, you should check if the connection was successfull or not, and return some errors. Use try / catch. — Twinfriends, Apr 21 '17 at 06:57

score 0 · Answer 1 · answered Apr 21 '17 at 07:04

0

You can use pdo method for connection and check.

try {
  $conn = new PDO('mysql:host=localhost;dbname=database_name', $username, $password);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
  echo 'ERROR: ' . $e->getMessage();
}

Other method also are mysql or mysqli as per your php version.

// Try and connect to the database
$connection = mysqli_connect('localhost',$username,$password,$dbname);

// If connection was not successful, handle the error
if($connection === false) {
    // Handle error - notify administrator, log to a file, show an error screen, etc.
}

answered Apr 21 '17 at 07:04

Bhupat Bheda

1,968
1
8
13

Thanks that looks good, but I have already used mysqli for my main connection. And the mysql I use for seconds connection on particular page only. Am I wrong? – Larasati Habibi Apr 21 '17 at 07:10
yes you can use private connection for particular page and query but you should check your php version and query which connection you passed in your query. you have all types of flexibility. – Bhupat Bheda Apr 21 '17 at 07:15
Never echo PHP errors right away – Your Common Sense Apr 21 '17 at 07:18
It still working good on PHP 5.6. – Larasati Habibi Apr 21 '17 at 07:28

does it good & safe enough? to estabish additional connection for particular page

1 Answers1