Re: Calling methods from others classes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ben Stones wrote:
Hi,

I have this piece of code that I have created:

class userQueries {
    public function numberUsers() {
        $get_users=mysql_query("SELECT * FROM `users` WHERE `online` <
NOW()") or exit("../includes/error.php");
    }
}

class usersOnline extends userQueries {
    public function usersOnline() {
        echo mysql_num_rows($this->numberUsers);
    }
}

How do I request specific methods in other classes? The error that comes up
is:

mysql_num_rows(): supplied argument is not a valid MySQL result resource

which is somewhat expected as $this only refers to the variables and there
are no variables called numberUsers.

You forgot to "return $get_users;" from your numberUsers() function....

Also in your code you will never free the result nicely which is bad.

In order to count the users, you should possibly also use SELECT COUNT(*) FROM... and then use the single value that is returned as this will be more efficient (does not require all the data to be fetched and sent).

Col

--

Colin Guthrie
gmane(at)colin.guthr.ie
http://colin.guthr.ie/

Day Job:
  Tribalogic Limited [http://www.tribalogic.net/]
Open Source:
  Mandriva Linux Contributor [http://www.mandriva.com/]
  PulseAudio Hacker [http://www.pulseaudio.org/]
  Trac Hacker [http://trac.edgewall.org/]


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux