<?phpclass Product{ var $db; var $id; var $name; var $code; var $category; // __construct() // takes an integer ID to lookup in the database or an array/object to load directly function Product($id) { if (is_int($id)) { global $db; $this->db = $db; // database handler $this->id = $id; // get product data from db $query = sprintf(" SELECT product.id, product.name, product.code, product.category_id, product_category.name AS category FROM product LEFT JOIN product_category ON product_category.id = product.category_id WHERE product.id = %d", $this->id); $result = $this->db->get_row($query); $this->name = $result->name; $this->code = $result->code; $this->category = $result->category; } else { $this->id = $id->id; $this->name = $id->name; $this->code = $id->code; $this->category = $id->category; } } /** * these functions return characteristics of the object * @access PUBLIC * @return STRING */ function getId() { return $this->id; } function getName() { return $this->name; } function getCode() { return $this->code; } function getCategory() { return $this->category; } /** * return list of products * @access STATIC * @return ARRAY */ function getListByCategory($categoryId) { global $db; // get all products into array $query = sprintf(" SELECT product.id, product.name, product.code, product.category_id, product_category.name AS category FROM product LEFT JOIN product_category ON product_category.id = product.category_id WHERE category_id = %d ORDER BY id ASC", $categoryId); $result = $db->get_results($query); // init $productList = array(); foreach ($result as $key => $obj) { $productList[] = new Product($obj); } return $productList; }}?>