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