Re[2]: [Phplib-users] Access denied, 2 databases, extrange error

[3s <3s...@se...>]

Hi,

after checking the proposals from woodbri and Donncha, still not working
and I'm thinking that the problem must be solve in other way. Because
its a conceptual matter possibly.

The main problem, I think, it is the way I use PHPLIB into my
applications. I'm not an OOP master obviouslly, will try to explain you,
if you can sugest a better approach I'll appreciate very much your
advice.

Applications are build in many layers:

1-index page, load general modules, make security tasks and if all goes
well, load the requested page, if not redirect to the home page
2-Page that calls, has their own code for make specific tasks calling to
other modules:
	3-db classes, one db class for every table or group of
	tables, including their own common methods for insert, update,
	etc in every class
	4-template
	5-layout
		5a-layout calls other pages or modules needed for it own



What is the problem? I make a new instance of the main db class in every
method of every class that manage tables.

Example:

class categories extends pageNavigation {

  function categories(){
   //calls to libs, language error files, etc
  }

  function add($array){

    // HERE IT IS THE PROBLEM------------------------------------
    // extension of the db_sql class with their own connection
    // parameters

    $q= new tbl;

    //-----------------------------------------------------------

    $query="insert into categories set bla, bla";
    if(!$q->query($query)){
      $this->error=$this->msg['NOCONNECTION'];
      return;
    }
    return TRUE;
  }

}

What is the advantage? every class for table manage, has their code very
well enclosed and can be changed little by little. Every table class has
also a constructor for call common libs, language files, etc.

I have two different possibilities, change all my code to implement a
new solution around PHPLIB db class or migrate to other database library
and make a lot of work also.

Regards,
-- 
3s <3s...@se...>