[SOLVED] class method

[corillo181]

hey I want to know how I can use a fetch_array to do something like this

 

<?php

class artistpro{
var $id;
var $db;

function artistpro($id){
	$this->id = $id;
	$this->db = new DB();
}

function body(){
	$query = "SELECT * FROM tra_artist WHERE artist_id='{$this->id}'";
	$result = $this->db->query($query);
	$aray = $this->db->fetch_array($result);
		}

function name(){
return  $aray['name'];
}

function age(){	
        return $aray['age'];
}

function genre(){
 return $aray['genre'];
}
}
?>

 

the only problem is that this doesn't work with the array, does anyone knows how i could do it?

[JJohnsenDK]

why shouldnt this work? looks good to me, only thing i can point at is that you should write mysql infront of fetch_array:

 

$aray = $this->db->mysql_fetch_array($result);

[corillo181]

it's call a costume class.

 

[Barand]

Currently, your array variable $aray only exists inside the body() function. Make it a class variable and refer to it as $this->aray

 

[corillo181]

i tried it i add it as a class variable when i try doing

 

var $aray;

 

function body(){

$this->aray = fetch_array()

}

 

function name(){

return $this->aray['name']

}

 

 

 

the variable comes out empty.

[Barand]

Have you called the body() method to get the data?

[corillo181]

i tried doing some test using that way and this are the results

<?php

class artistpro{
var $id;
var $db;
var $aray;

function artistpro($id){
	$this->id = $id;
	$this->db = new DB();
}

function body(){
	$query = "SELECT * FROM tra_artist WHERE artist_id='{$this->id}'";
	$result = $this->db->query($query);
	$this->aray = $this->db->fetch_array($result);

var_dump($this->aray['name']);// = artist name
var_dump($this->aray);// all values in array			
		}

function name(){
var_dump($this->aray['name']);// = NULL
}

function age(){	
var_dump($this->aray['name']);// = NULL
}

function genre(){
var_dump($this->aray['genre']);// = NULL
}
}
?>

[corillo181]

AAAH yes Barand i never called the body method to perform the actions..

 

thank you.

[Barand]

I'd call $this->body() from the artistpro() function so you always get the data when you create new object.