if you want to fetch like this, try this
<?php echo $this->Html->link($this->Andante->fetchLanguage('aside_addasfriend',
$opt_as), array('controller' => 'relationships', 'action' => 'addfriend',
$current_user['id'], $user_data['User']['id']), array('class' => 'btn')); ?>
--
Lep pozdrav, Tilen Majerle
http://majerle.eu
2012/8/8 Andante Cheng <[email protected]>
> Dear all:
> I would be grateful if you could help me on this issue what I have been
> working on it few days:
>
> my problem is: about passing multiple paramters from view (html helper:
> link) to an action ($arg1 = null, $arg2 = null) that the passed parameter
> became empty & null strings
>
> 1. First, the link in html is:
>
> <?php echo
> $this->Html->link($this->Andante->fetchLanguage('aside_addasfriend',
> $opt_as), array('controller' => 'relationships', 'action' => 'addfriend',
> 'A_user_id' => $current_user['id'], 'B_user_id' =>
> $user_data['User']['id']), array('class' => 'btn')); ?>
>
> where the excepted values are: (for example)
> 'A_user_id' => $current_user['id'], 'B_user_id' =>
> $user_data['User']['id']
> $A_user_id = 1;
> $B_user_id = 2;
>
> 2. And the action is like:
>
> public function addfriend($A_user_id = null, $B_user_id = null) {
> $A_user_id = $this->passedArgs['A_user_id'];
> $B_user_id = $this->passedArgs['B_user_id'];
>
> //check isset or not
> if ($A_user_id = null || $B_user_id = null) {
> $this->Session->setFlash('Invalid user id');
> $this->redirect($this->referer());
> } else {
> //$A_user_id = intval($A_user_id);
> //$B_user_id = intval($B_user_id);
> //create entity in Table Relationships
> if ($this->Relationship->save($data = array('A_user_id' => $A_user_id,
> 'B_user_id' => $B_user_id, 'relationship_created' => date("Y-m-d H:i:s"))))
> {
> $relationship_id = $this->Relationship->id;
> //create entity in Table Relationshiplogs
> if ($this->Relationshiplog->save($data = array('relationship_id' =>
> $relationship_id, 'A_user_id' => $A_user_id, 'B_user_id' => $B_user_id,
> 'logtype' => 'A_addfriend', 'event_datetime' => date("Y-m-d H:i:s")))) {
> //create entity in Table Notificationlogs
> if($this->Notificationlog->save($data = array('user_id' => $B_user_id,
> 'type' => 'relationship', 'language_code' => 'relationship_addfriend',
> 'value1' => $A_user_id, 'value2' => $B_user_id, 'created' => date("Y-m-d
> H:i:s")))) {
> $this->redirect($this->referer());
> } else {
> $this->Session->setFlash('Could not send notification (step:3)');
> $this->redirect($this->referer());
> }
> } else {
> $this->Session->setFlash('Could not create log in table Relationshiplogs
> (step:2)');
> $this->redirect($this->referer());
> }
> } else {
> $this->Session->setFlash('Could not save row in table Relationship
> (step:1)');
> $this->redirect($this->referer());
> }
>
> }
> }
>
> where the problem came out...
> 3. error
>
> Database Error
>
> Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column
> 'B_user_id' cannot be null
>
> SQL Query: INSERT INTO `fortuneinn_renew`.`relationships` (`A_user_id`,
> `B_user_id`, `relationship_created`) VALUES (*'', NULL*, '2012-08-08
> 08:43:31')
>
> Notice: If you want to customize this error message, create
> app\View\Errors\pdo_error.ctp
> Stack Trace
> CORE\Cake\Model\Datasource\DboSource.php line 461 →
> PDOStatement->execute(array)
> CORE\Cake\Model\Datasource\DboSource.php line 427 →
> DboSource->_execute(string, array)
> CORE\Cake\Model\Datasource\DboSource.php line 1009 →
> DboSource->execute(string)
> CORE\Cake\Model\Model.php line 1730 → DboSource->create(Relationship,
> array, array)
> APP\Controller\RelationshipsController.php line 30 → Model->save(array)
> [internal function] → RelationshipsController->addfriend()
> CORE\Cake\Controller\Controller.php line 485 →
> ReflectionMethod->invokeArgs(RelationshipsController, array)
> CORE\Cake\Routing\Dispatcher.php line 186 →
> Controller->invokeAction(CakeRequest)
> CORE\Cake\Routing\Dispatcher.php line 161 →
> Dispatcher->_invoke(RelationshipsController, CakeRequest, CakeResponse)
> APP\webroot\index.php line 92 → Dispatcher->dispatch(CakeRequest,
> CakeResponse)
>
> The problem is that the passed parameter became empty & null strings...
> '', null. I tried many ways (intval, isset...etc) but all in vain.
> I googled many information about the format of passing multiple variables
> but still don't get it.
> Does anyone knows about the answer to my question? Thanks
>
> Best Regards,
>
> Andante Cheng
>
> --
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
