how i can access connection variable in function

Question

i want to access $conn in class mention in bellow.

conn_file.php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$conn = new mysqli($servername,  $username,  $password);
if($conn->connect_error)
{
    die("Connection Failed :".$conn->connect_error);
}
?>

class.function.php

<?php
include_once 'conn_file.php';
class all_function
{
    public function something()
    {
        $data = $conn->real_escape_string("data");
        return $data;
    }
}
?>

The above gives me the following error: Notice: Undefined variable: conn in class.function.php on line 7

Fatal error: Call to a member function real_escape_string() on a non-object in class.function.php on line 7

@u_mulder No, that's not a good idea. – Rizier123 Jul 26 '15 at 11:50 — Rizier123, Jul 26 '15 at 11:50
I know, but it's used here quite often( – u_mulder Jul 26 '15 at 11:50 — u_mulder, Jul 26 '15 at 11:50

score 1 · Accepted Answer · answered Jul 26 '15 at 12:02

I suggest you to use class for connection. Example:

In conn_file.php

class DbConfig{
    public static $servername = "localhost";
    public static $username = "root";
    public static $password = "";

    public static function getCon(){
        $conn = new mysqli(self::$servername,  self::$username,  self::$password);

        if($conn->connect_error){
            die("Connection Failed :".$conn->connect_error);
        }

        return $conn;
    }
}

In class.function.php

include_once 'conn_file.php';
class all_function
{
    public function something()
    {
        $conn = DbConfig::getCon();
        $data = $conn->real_escape_string("data");
        return $data;
    }
}

how i can access connection variable in function

1 Answers1