vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Code works, but move it to a class and it stops (https://vborg.vbsupport.ru/showthread.php?t=164306)

Big9erFan 12-04-2007 04:46 PM
Code works, but move it to a class and it stops
 
Ok, I've been tearing my hair out over this trying to figure out what is going on. I'm at a loss, and probably just missing something REALLY simple, but I'm at a total loss.

I'm writing a little custom vba module for my guild.

I have 3 templates that I pull in

So I do something like this

PHP Code:
global $vbulletin;
eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_progression_header') . '";');
$instances = $vbulletin->db->query_read( "SQL STUFF HERE" );
while ($instance = $vbulletin->db->fetch_array($instances))
{
    $img_name = $instance['image'];
    $name = $instance['name'];
    eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_progression_data') . '";');
} 
That works fine.

Now, trying to put it into a class

PHP Code:
class cls_progression
{
    var $theDB;
    function cls_progression( $DB )
    {
        $this->theDB = $DB;
    }
    
    function LoadInstances()
    {
        $instances = $this->theDB->db->fetch_array( $this->theDB->db->query_read("SQL STUFF HERE" ) );
        $iCount = $this->theDB->db->num_rows($instances);
        echo "iCount = $iCount";
        while ($instance = $this->theDB->db->fetch_array($instances))
        {
            $img_name = $instance['image'];
            $name = $instance['name'];
            eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_progression_data') . '";');
        }
    }

//call the class:
$progress = new cls_progression( $vbulletin );

$progress->LoadInstances(); 
the class doesn't work at all. I know it is called, but the echo returns just
"iCount = "

I'm horribly confused :(

Opserty 12-04-2007 05:44 PM
Code:
$instances = $this->theDB->db->fetch_array( $this->theDB->db->query_read("SQL STUFF HERE" ) );

Big9erFan 12-04-2007 09:05 PM
Perhaps I'm just very dense today, but I don't see the difference or the problem >.<

Guest190829 12-04-2007 09:18 PM
it should be like this:

PHP Code:
class example
{
   function exampe(&$registry, $otherags = 0 )
   {
          $this->registry =& $registry;
   }

   function fetch_example($id)
  {
         $this->registry->db->query_read("... some mysql ...");
        /*
                more code....
        */
  }
}

$example1 = new example($vbulletin);
$example1->fetch_example(2); 

Things to notice are the &'s and the naming convention of registry to hold the vBulletin object (not required, but conforms to vB's approach)

Big9erFan 12-04-2007 09:45 PM
Ah!

Thank you very much. Still kind of new to php programming, but been writing in C++ for years.

Thanks again :)

Guest190829 12-04-2007 10:07 PM
Yeah, the ampersand is a little annoyance with PHP 4, but it becomes habit to add it eventually.

Opserty 12-05-2007 10:41 AM
Quote:
Originally Posted by Big9erFan (Post 1395059)
Perhaps I'm just very dense today, but I don't see the difference or the problem >.<
You fetch the array and assigned it to a variable and then you tried to count the rows of that variable...you should be using the query handle to do it. i.e. remove the bit in red...

(Look at your code, you've used fetch_array() twice. )


All times are GMT. The time now is 02:14 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01076 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete