Variable from required document not found

Question

MySQLiconfig.php:

<?php
$MySQLi   = new mysqli('localhost','root','123','Database') or die('ERROR');

Other document:

<?php
require 'MySQLiconfig.php';

function DoAQuery($Query){
   $MySQLi->query($Query);
}

The error is:

 Undefined variable: MySQLi

That's because `$MySQLI` is out of [scope](http://php.net/manual/en/language.variables.scope.php) in your `DoAQuery()` function. — vascowhite, Jul 27 '14 at 07:31
@Mr.Alien,@vascowhite Would it be a good solution if I would write 'global $MySQLi;' inside the function? — Entimon, Jul 27 '14 at 07:43
Change your funtion signature to `DoAQuery(mysqli $MySQLi, $Query)`. — Álvaro González, Jul 27 '14 at 08:19
@ÁlvaroG.Vicario Is there a way to set the Connection parameter of a function to a default one like DoAQuery($MySQLi = new MySQli ....)? — Entimon, Jul 27 '14 at 15:12
You'd have to use `DoAQuery($Query, mysqli $MySQLi=null)` and create it from within the method if `null`, but that's horrible from the design point of view. — Álvaro González, Jul 27 '14 at 15:14

Tapos · Answer 1 · 2014-07-27T18:27:25.730

-1

You are wrong with variable scope. In the function you need to use like global $MySQLi or you can pass as function parameter.

edited Jul 27 '14 at 18:27

answered Jul 27 '14 at 07:31

Tapos

1 Answers1