Mysql - Parse error (syntax error) in my code

Question

When I use:

$mysqli = new mysqli('localhost', 'root', '', 'cms');

in my class, As a result display Error:

Parse error: syntax error, unexpected '$mysqli' (T_VARIABLE), expecting function (T_FUNCTION) in D:\xamppp\htdocs\cms\includes\td-class-db.php on line 12

And when use $mysqli = new mysqli('localhost', 'root', '', 'cms'); outsilde the class no display any error!

My class:

class Connect_db{
  $mysqli = new mysqli('localhost', 'root', '', 'cms');
}

why?

Put that in `__construct()`. Probably `$this->mysqli = etc...` — AbraCadaver, Sep 09 '14 at 15:12

score 4 · Accepted Answer · answered Sep 09 '14 at 15:13

4

You can't instantiate classes when creating member variables in a class. You have to do this in the constructor or a method:

class Connect_db{
    private $mysqli;

    public function __constructor() {
        $this->mysqli = new mysqli('localhost', 'root', '', 'cms');
    }
}

answered Sep 09 '14 at 15:13

John Conde

217,595
99
455
496

thanx John Conde how to use static function for this function? – Sep 09 '14 at 15:32
Why does this need to be static? – John Conde Sep 09 '14 at 15:33
all my functions is static and easy to use.wrong? – Sep 09 '14 at 15:38
Methods only need to be static under certain circumstances. It isn't very common. This isn't one of those circumstances. – John Conde Sep 09 '14 at 15:39

score 0 · Answer 2 · answered Sep 09 '14 at 15:15

0

Put your code in a class method like constructor.

class Connect_db
{

  function __construct()
  {
    $mysqli = new mysqli('localhost', 'root', '', 'cms');
  }
}

answered Sep 09 '14 at 15:15

Mohsen Alizadeh

1,595
12
25

Mysql - Parse error (syntax error) in my code

2 Answers2

Linked

Related