TalkPHP - View Single Post

Tanax · 12-31-2008, 02:03 AM

PHP Code:


			
// -- I can't exactly understand Tanax's Class :/ -- //
            $this->configinfo = $this->dbobj
                           ->exeQuery($this->queryformat)
                            ->loadFetch(true,$this->queryformat);

You don't need to use $this->queryformat in your loadFetch if you've already executed the query with the exeQuery function.

Also, I think(since you're assigning the fetched results to a variable) you need to use the getFetch().

You could do like this:

PHP Code:


			
            $this->configinfo = $this->dbobj
                           ->exeQuery($this->queryformat)
                            ->loadFetch(true)->getFetch();

or like this:

PHP Code:


			
            $this->configinfo = $this->dbobj
                            ->loadFetch(true,$this->queryformat)->getFetch();

or even like this:

PHP Code:


			
            $this->configinfo = $this->dbobj
                            ->getFetch(true, true, $this->queryformat);
// 1st true is because you didn't use the loadFetch.
// 2nd true is because you want assoc
// 3rd parameter is the sql

Hope you understand more now. Read my SQL thread if not! Or PM me.

12-31-2008, 02:03 AM	#13 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	PHP Code: `// -- I can't exactly understand Tanax's Class :/ -- // $this->configinfo = $this->dbobj ->exeQuery($this->queryformat) ->loadFetch(true,$this->queryformat);` You don't need to use $this->queryformat in your loadFetch if you've already executed the query with the exeQuery function. Also, I think(since you're assigning the fetched results to a variable) you need to use the getFetch(). You could do like this: PHP Code: `$this->configinfo = $this->dbobj ->exeQuery($this->queryformat) ->loadFetch(true)->getFetch();` or like this: PHP Code: `$this->configinfo = $this->dbobj ->loadFetch(true,$this->queryformat)->getFetch();` or even like this: PHP Code: `$this->configinfo = $this->dbobj ->getFetch(true, true, $this->queryformat); // 1st true is because you didn't use the loadFetch. // 2nd true is because you want assoc // 3rd parameter is the sql` Hope you understand more now. Read my SQL thread if not! Or PM me. __________________