query inside class

[[deleted]]

Hi All,
i have a base class in which i want constructor (function base) to have one query.

then i want to use the query result inside the other functions without having to query again.

i somehow dont get it to work.

 class base
{
	var $id;

function base($id)
{
$getuserdata  = mysql_query("SELECT * FROM users WHERE user_id = '".$id."'");
$user = mysql_fetch_array($getuserdata);

}
function userinfo()
{
/*
here i want to use $user to display part of the result
for example $user[name'] and $user[cashtotal]
*/
}

function whatever()
{
// perform some calculations with $user[whatever]
}
}

any help apreciated, thnx in advance

Arjan

[barand]

class base 
{ 
    var $id; 
    var $name;
    var $cashtotal;

function base($id) 
{
 $this->id = $id;

$getuserdata  = mysql_query("SELECT * FROM users WHERE user_id = '".$id."'"); 
$user = mysql_fetch_array($getuserdata); 
$this->name = $user['name'];
$this->cashtotal = $user['cashtotal']
} 
function userinfo() 
{ 
/* 
here i want to use $user to display part of the result 
for example $user[name'] and $user[cashtotal] 
*/ 
} 

function whatever() 
{ 
// perform some calculations with $user[whatever] 
} 
}

In your other functions, refer to $this->variableName to pick up the values.

hth

[[deleted]]

hmm thanx,

so i cant say something like this?

class base  

{  

    var $id;  

    var $name; 
    var $cashtotal; 

function base($id)  
{ 
 $this->id = $id; 

$getuserdata  = mysql_query("SELECT * FROM users WHERE user_id = '".$id."'");  
$user = mysql_fetch_array($getuserdata);  
}   

function userinfo()  

    {  

 $this->name = $user['name']; 
    $this->cashtotal = $user['cashtotal'] 
    }  

}

so lets say i have 20 columnnames and using them all in the other methods then i have to specify all 20 as vars AND the result in the constructor right?

Arjan

[Weedpacket]

function base($id)  

    { 
     $this->id = $id; 

$getuserdata  = mysql_query("SELECT * FROM users WHERE user_id = '".$id."'");  
$user = mysql_fetch_array($getuserdata);  
}    

[/b]

The problem is that the only object property this function sets is $this->id. $getuserdata and $user don't get stored anywhere, and in fact $user is never even used.

If you had $user as a property, you could store the fetched array in it by referring to the property as $this->user.