The problem is that the required file is not part of the class. You have set $user,$pass,$db as global variables which are out of scope of the class variables.
What I would do is create a new class with a constructor that connects to the DB. Then include that class and make a new variable instance of that class. --- In flexcoders@yahoogroups.com, "timgerr" <tgallag...@...> wrote: > > Hello all, I have started using stored procedures for my MySql queries > so to call the stored procedures I use mysqli. The problem is that I > have a class and one of my public methods calls private methods to do > the work. Here is what I mean. > Class Tree{ > var $mysqli; > var $finalArry; > var $collectArry; > var $dUName; > var $dPWord; > var $dHost; > var $dDB; > public function Tree() > { > $this->finalArry = array(); > $this->collectArry = array(); > } > public function MasterCall(SB $obj) > { > switch($obj->call){ > case "BuildTreeStructure": > $called = $this->BuildTreeStructure($obj); > break; > case "AddNewNode": > $called = $this->AddNewNode($obj); > break; > } > return $called; > } > > private function AddNewNode($obj) > { > /* Calling the SQL stored procedure AddNodeSP > */ > $mysqli = new mysqli('localhost', 'root', '', 'MeDatabase'); > if (mysqli_connect_errno( )) { > printf("Connect failed: %s\n", mysqli_connect_error( > )); > exit ( ); > } else { > // printf("Connect succeeded\n"); > } > $sql = "CALL > AddNodeSP('$obj->parentCBSid','$obj->rootCBSid','$obj->newNode')"; > $mysqli->query($sql); > > if ($mysqli->errno) { > die("Execution failed: ".$mysqli->errno.": ".$mysqli->error); > } > $getTree = $this->BuildTreeStructure($obj); > return $getTree; > } > > } > Class SB { > var $parentCBSid; > var $rootCBSid; > var $newNode; > var $call; > var $user; > var $pass; > var $host; > var $db; > } > > so in my AddNewNode method I have a mysqli connection : > $mysqli = new mysqli('localhost', 'root', '', 'MeDatabase'); > > I dont want to have to add this line everytime I do this because if I > have to change my password. SO I created a password file and did an > include: > In the AddNewNode method I do this > require_once('PasswordFile.php'); > $mysqli = new mysqli('localhost',$user,$pass,$db); > > > When I run this script from a webpage (remember I am using this as a > service from Webord) It works fine. When I run my flex app, I get an > error in charles : > <b>Warning</b>: mysqli::mysqli() [<a > href='function.mysqli-mysqli'>function.mysqli-mysqli</a>]: > (28000/1045): Access denied for user 'ODBC'@'localhost' (using > password: NO) in > <b>C:\xampp\htdocs\weborb\Services\com\ArrayTree\Tree.php</b> on line > <b>100</b><br /> > Connect failed: Access denied for user 'ODBC'@'localhost' (using > password: NO) > > Anyone know how I can use a password file with Weborb, mysqli, and Flex? > > Thanks for the read, > timgerr >