0

I'm storing a product Bean, by this way: 

$product = R::dispense( 'product' ); 
$product->name = $_POST['name']; 
$product->description = $_POST['description']; 
$product->price = $_POST['price']; 
$product->category = $_POST['category']; 
R::store( $product );

How can I indicate that the category's attribute is an id reference (or FK) to the category Bean? I want get the category Bean like this way: 

$products = R::find( 'product' ); 
foreach( $products as $product ) 
   $productCategory = $product->category->name;
tshepang
  • 12,111
  • 21
  • 91
  • 136
mauriblint
  • 1,802
  • 2
  • 29
  • 46
  • 2
    TIP! Instead of setting each property individually you can automatically fill a bean with a $_POST array using: $bean->import($_GET); $bean->import($_POST, "name,year"); //only these fields – furier Jun 20 '12 at 09:41

1 Answers1

1

The way I would do it is this IF you don't have the database table already configured:

$product = R::dispense( 'product' ); 
$product->name = $_POST['name']; 
$product->description = $_POST['description']; 
$product->price = $_POST['price']; 
$product->category = R::load('category',$_POST['category']); 
R::store( $product );

BUT I believe if your database has a foreign index assigned for category and it points to the category table, then you can do what you did above. So on your product table, have a column category_id and make it a foreign index to category.id and it should work. I can test it later and give you a more definitive answer, but this is just going off of what I know offhand.

Tim Withers
  • 12,072
  • 5
  • 43
  • 67
  • Thanks! when a set the category attributte like a Beans, automatically create de column an FKeys! it's brilliant :D – mauriblint May 04 '12 at 17:03