PHP Define a new PDO object inside class (outside function)

debugcn Published at Dev

Dan Lindqvist

I am making a class with a couple function that requires some SQL stuff, and I do not want define a new PDO object for every function, but have a one that works on all functions.

This is what I got so far:

<?php
class UserSystem
{
    public $mysqlDetails = 
    [
        "host"        => "127.0.0.1",
        "user"        => "",
        "pass"        => "",
        "database"    => "",
        "table"       => ""
    ];

    public $con = new PDO
    (
        "mysql:host=" . $this->mysqlDetails['host'] .
        ";dbname=" .    $this->mysqlDetails['database'] . ";",
                        $this->mysqlDetails['user'],
                        $this->mysqlDetails['pass']
    );

How could I get this to work? Currently I get this error: Parse error: syntax error, unexpected 'new' (T_NEW). Is there a better way to do this, so I can use the $con variable in functions without having to create a new one. I do not want to inject it into functions as I've seen suggested. IE this:

<?php
function someFunc ($pdo)
{
    $pdo->query("SELECT * FROM `someTable`");
}

deceze

You cannot initialize class properties with anything but compile time resolvable constant values. You'll have to create the PDO object in the constructor:

public function __construct() {
    $this->con = new PDO(...);
}

Better yet, you should make your class accept a PDO object and dependency inject it, since I'd be guessing you need a database connection in more than just this one class, and you don't want to connect to the same database again and again in different classes:

public function __construct(PDO $con) {
    $this->con = $con;
}

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-22

Comments

0 comments

From Dev

Related Related

Article

PHP Define a new PDO object inside class (outside function)

PHP Define a new PDO object inside class (outside function)

Function define a new object class

PHP Call outside class function inside anonymous function

Why are PHP tags not allowed inside a class but outside a function?

PHP PDO injection inside a class

How to define a member function outside class in python?

Define a Function inside an Object with a variable as part of the function

PHP function - works outside function, but not inside

How to use an external variable inside a class/function/object in php

Define member variables of class inside function

function declaration inside object/class

C++ - Define member function outside template-class but in header

Can I define a private template function outside of a class?

PHP pdo class getadresses warning and Call to a member function prepare() on a non-object

Friend function inside class and outside class, what difference does it make?

Define new function, array, struct etc inside of parameter of function call

Define new function, array, struct etc inside of parameter of function call

php public function is not working outside of the class

Declare object outside function, pass it as reference and then create it inside function

Why is a collection initializer without `new` allowed inside an object initializer but not outside?

How to correctly define (function || function) inside a Javascript object?

problems with retrieving the value of a class pointer object member allocated with operator new inside a function

Class object inside or outside a parallel_for / parallel_for_each?

How php requires a class inside a class function?

C++ Static Function: Put Inside or Outside Scope of Class?

PHP PDO: Search array value inside of MySQL's JSON object

New issues in PDO Class

PHP: Create new object of this class in class, is correct?

Can I define a type inside a class in Object Pascal?

Function which produces new variable for use outside of function - PHP