Can't connect to database in namespaces classes

Question

I connect to database then use class , I can't use database there .. I use namespaces .. I'm a beginner and I don't know much about it.

I tried to search for a solution, but I couldn't find anything can help. Please guide me to any tutorial if it will help .

server.php

//Connect to database
$host = 'localhost';
$db   = 'market';
$user = 'root';
$pass = '';
$dsn = 'mysql:host=localhost;dbname=market';
try {
    $pdo = new \PDO($dsn, $user, $pass);
    // set the PDO error mode to exception
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

}
catch(\PDOException $e)
{
    echo "Connection failed: " . $e->getMessage();
}

index.php

require 'server.php';
require 'vendor/autoload.php';
use App\Product;
$product= new Product;
$product->all();

product.php

namespace App;
Class Product
{
protected $rate;
protected $name;
protected $cost;
public function all()
{
    $sql = 'SELECT product,price,rating FROM products';
    $q = $pdo->query($sql);
}

I expect it to know what is $pdo as I require server.php in index.php But it throws :"Fatal error: Uncaught Error: Call to a member function query() on null in Market\src\Product.php:14 please guide me how to connect to database in my classes ..

score 0 · Answer 1 · answered Apr 25 '19 at 23:32

0

move your require 'server.php'; in the all () function of the Product class and this should work like this:

namespace App;
Class Product
{
    protected $rate;
    protected $name;
    protected $cost;
    public function all()
    {
        require_once ('server.php');
        $sql = 'SELECT product,price,rating FROM products';
        $q = $pdo->query($sql);
    }
}

answered Apr 25 '19 at 23:32

Mamadou Aliou Bah

44
6

same problem . also i made sure server.php is called . still pdo isn't declared – osama hussien Apr 25 '19 at 23:37
in a server.php file declare $pdo = null; before try bloc – Mamadou Aliou Bah Apr 25 '19 at 23:43
If you are using Global PHP functions inside a namespace use "\" before the function. For Example $conn = new \mysqli($servername, $username, $password); – insaneray Nov 19 '22 at 11:40

score 0 · Answer 2 · answered Apr 25 '19 at 23:50

0

From a quick look since the lack of the global keyword could be your issue when using the pdo object

try global $pdo; at the top of your all() function

answered Apr 25 '19 at 23:50

Marky Ross

41
5

Can't connect to database in namespaces classes

2 Answers2