Re: Problem encountered: about passing multiple paramters from view (html helper: link) to an action ($arg1 = null, $arg2 = null) that the passed parameter became empty & null strings

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 <andantecheng@gmail.com>

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 cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
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 cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.