FuelPHP Forums

Cool

Something like this

Class Controller_Category extends \Controller{

public function action_index($category) {

echo $category;

}

http://domain.com/category/computer will echo computer

A Huzz wrote on Saturday 20th of August 2011:

Something like this

Class Controller_Category extends \Controller{

public function action_index($category) {

echo $category;

}

http://domain.com/category/computer will echo computer

I read docs again, I understood how to make http://domain.com/category/computer url, but do not understood how extract data
http://domain.com/category/computer/laptop What I should write in code If I want to extract some rows from table?
I do not understand how it will work.
for example:
$data = Model_laptop::find('all'); But if I will write other query like http://domain.com/category/computer/netbooks
or http://domain.com/category/computer/laptop/dell
how to extract from url "laptop" or "netbooks"? $data = Model_laptop::find('all', array('where'=>array('brand_name'=>'dell')));? But If I will have more than 200 category / subcategry- I should every category write in code or I can do make "smart" code which can automatically extract from url and write $data = Model_NAME-OF-CATEGORY::find('all'); I do not found any examples.
'poor and non universal' solution for one variable:

  public function action_index($name = 'index'){
          switch ($name){
              case 'index':
                  $data = Model_Prod::find('all');
                  break;
              case 'laptop':
                  $data = Model_Laptop::find('all');
                  break;
              default:
                  echo "something wrong url Adress";
                  $data = Model_Prod::find('all');
                  break;
          }

          $this->response->body = View::factory('welcome/index')->set('data',$data);
    }

Dear Huzzi! Thank you for the answer.
I understood how to send some variables like $category, $subcategory, $product-name-ID
But I do not understand how write in code in "Model_QUERY::" these variables.
Look at this:
//example
$data = Model_$CATEGORY::find('all'); // sure that example is not work. query not be Model_$category - but how I should write normal code?
(Very bad, and not working code)

public function action_index($category = 'category', $subcategory = 'null', $product-name-ID = 'null')
{

    if(isset($category))
    {
        if(isset($subcategory))
        {
            if(isset($product-name-ID))
            {
                $data = Model_$product-name-ID::find('all');
            }else{
            $data = Model_$subcategory::find('all');
        }
        }else{
            $data = Model_$category::find('all');
        }

    }else{
        //redirect to home page
    }
}

I just beginner in Mysql. But I want to make some simple tables:
Laptops,
Mobile phone,
PC components,
Household appliances and etc. With data.
Therefore I asked how to extract from URL variables, and insert them in Model_$category and extract data from table.
I want to make my version of that web site http://goo.gl/PP6a6

Dmitry Barko wrote on Tuesday 23rd of August 2011:

CREATE TABLE `laptops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(45) CHARACTER SET latin1 NOT NULL,
  `price` varchar(45) CHARACTER SET latin1 NOT NULL,
  `photo` varchar(45) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

your database design is completely wrong.. you don't need mulitple table for for categories. you need the database structure something like this:

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `parent_id` int(4) NOT NULL,
  `name` varchar(100) NOT NULL,
  `seo_name` varchar(100) NOT NULL,
  `description` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `parent_id`, `name`, `seo_name`, `description`) VALUES
(1, 0, 'Computer', 'Computer', 'Computers'),
(2, 1, 'Laptop', 'Laptop', 'Laptop computers'),
(3, 1, 'Desktop', 'Desktop', 'Desktop computers'),
(4, 0, 'Software', 'Software', 'Softwares');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `cat_id` int(4) NOT NULL,
  `name` varchar(150) NOT NULL,
  `seo_name` varchar(150) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `cat_id`, `name`, `seo_name`, `description`) VALUES
(1, 2, 'HP Laptop', 'HP-Laptop', 'Dual Core processor\r\n2GB RAM\r\n2TB Hard Disk\r\nFloppy Disk\r\nUSB Drive'),
(2, 2, 'Dell Laptop', 'Dell-Laptop', 'Dual Core processor\r\n2GB RAM\r\n2TB Hard Disk\r\nFloppy Disk\r\nUSB Drive');

sorry, i use db class not orm.. hope someone else can help you. good luck.