class.php

<?php

class Item extends Data {

	public function getSelectCategory($category_name) {

		$category_name = "%$category_name%";

		$SQL = "SELECT category_id, category_name 
				FROM category 
				WHERE category_name LIKE :category_name
				AND status='1'
				";
		$query = $this->link->prepare($SQL);
		$query->bindParam( ":category_name" , $category_name );
		$query->execute();

		if ( $query->rowCount() ){
			return $query->fetchAll(PDO::FETCH_ASSOC);
		}

		return false;
	}

}