StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcakePhp and a foreign key : i cannot write the foreign key in the view
primarykey
Id
9308272
data
AcceptedAnswerId
9309365
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-02-16T09:05:15.373
FavoriteCount
0
LastActivityDate
2012-02-18T01:49:56.077
LastEditDate
2012-02-18T01:49:56.077
LastEditorUserId
702255
OwnerUserId
702255
ParentId
0
PostTypeId
1
Score
1
ViewCount
3627
LastEditorDisplayName
text
Body
i've got a problem with a foreign key field : i created a <code>categories</code> table with <code>MySQLWorkbench</code>, which is linked by a <code>1:n</code> relation to another table : <code>Articles</code>. It seems to work, because in <code>Articles</code>, there is a <code>categories_id</code> "INT" field . I baked the whole project, everything works fine, except this foreign key : instead of an input that would receive the "number" i would write to specify the <code>categories_id</code> number, there is a kind of empty "select" (list) that contains nothing, so i cannot enter any number for the <code>categories_id</code> field in my database : here's the image : <img src="https://i.stack.imgur.com/To43F.png" alt="my categories input"> If i try to "force" and add an "article" (so without the category), there is this error : <blockquote> Error: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (<code>ecommerce</code>.<code>articles</code>, CONSTRAINT <code>fk_articles_categories</code> FOREIGN KEY (<code>categories_id</code>) REFERENCES <code>categories</code> (<code>id</code>) ON DELETE NO ACTION ON UPDATE NO ACTION) </blockquote> And here's my <code>add.ctp</code> file (it is written <code>input</code> for the <code>categories_id</code>, so i don't know what to change) : <pre><code><div class="articles form"> <?php echo $this->Form->create('Article');?> <fieldset> <legend><?php echo __('Add Article'); ?></legend> <?php echo $this->Form->input('nom'); echo $this->Form->input('prix'); echo $this->Form->input('categories_id'); ?> </code></pre> Thanks for your help <hr> EDIT: here's what i added : <pre><code>class Article extends AppModel { var $belongsTo = array( 'Category' => array( 'className' => 'Category', 'foreignKey' => 'category_id' ) ); } </code></pre> and : <pre><code>class Category extends AppModel { var $hasMany = array( 'Article' => array( 'className' => 'Article', 'foreignKey' => 'category_id' ) ); } </code></pre> and in the controller (<code>add()</code>) : <pre><code>public function add() { //$this->set('categories',$this->Article->Category->find('all')); //$c = $this->Article->Category->find('all', array("recursive"=>-1, 'fields'=>array('id', 'nom'))); $c = $this->Article->Category->find('list'); $this->set('cat', $c); </code></pre> but in my view, <code>pr($cat)</code> returns an empty Array... <pre><code><?php echo $this->Form->input('nom'); echo $this->Form->input('prix'); echo $this->Form->input('category_id', array('option'=>$cat)); pr($cat); ?> </code></pre>
Tags
<cakephp><foreign-keys><foreign-key-relationship>
Title
cakePhp and a foreign key : i cannot write the foreign key in the view
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPaul
UserOwnerUserId
1. USPaul
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.