Re: user status enum

That looks ok, I think. Did you try that?

One thing I noticed is that your form won't have $id in the action, so
$this->User->id = $id; won't always work the way you expect. I usually
do something along these lines:

function change_status($id=null)
{
if (empty($this->data))
{
$this->data = $this->User->read(null, $id);
}
else
{
/* $id is in $data['User']
*/
if ($this->User->save($this->data))
{
$this->Session->setflash('User status has been updated!');
$this->redirect('/users');
}

On Sun, May 3, 2009 at 1:01 PM, Paulos23 <paulitostheone@gmail.com> wrote:
>
> Ok Brian so i ll use tinyint.But after that i make default 1 for
> active and when i wanr to change it to inactive nothing happen.I am
> using a checkbox coz i think it's the most appropriate for my
> needs.Can you help me if i am wrong?Here is my code:
>
> view
> <?php
>        echo $form->create('User', array('action' => 'change_status'));
>        echo $form->input('User.status', array ('type' =>
> 'checkbox','label'=> 'Status','options'=>array(1=>'Active',
> 0=>'Inactive')));
>        echo $form->input('id', array('type'=>'hidden'));
>        echo $form->end('Save');
> ?>
>
> controller
> function change_status($id=null){
>        $this->User->id = $id;
>                if (empty($this->data)) {
>                        $this->data = $this->User->read();
>                } else {
>                        if ($this->User->save($this->data)) {
>                        $this->Session->setflash('User status has been updated!');
>                        $this->redirect('/users');
>                        }
>                }
>        }
>
> Ty in advance!
>
> On May 3, 7:24 pm, brian <bally.z...@gmail.com> wrote:
>> Cake has no official support forENUM. (there may be ways to use them,
>> of course)
>>
>> The simplest way to deal with this would be to change your column to
>> (mysql version):
>>
>> active BOOLEAN DEFAULT FALSE (or TRUE, whichever you want)
>> or
>> active BIT(1) DEFAULT 0 (or 1)
>> or
>> active TINYINT(1) DEFAULT 0 (or 1)
>>
>> .. which, for mysql, amounts to the same thing.
>>
>> If you foresee having more than 2 types ofstatus, create a table,
>> statuses, give users a status_id andUserhasOneStatus.
>>
>> On Sun, May 3, 2009 at 11:30 AM, Paulos23 <paulitosthe...@gmail.com> wrote:
>>
>> > Hi Cake people,
>> > I have a problem in settinguserstatus.In particular i have a field
>> > in users table which is calledstatusand i have set it toenum
>> > ('active','inactive') default 'active'.now in users/views/
>> > change_status i want to have a select tag to setstatusas active or
>> > inactive.Here is the code:
>>
>> > <?php
>> >        echo $form->create('User', array('action' => 'change_status'));
>> >        echo $form->input('User.status', array ('type' => 'select','label'=>
>> > 'Status','options'=>array(1=>'active',0=>'inactive')));
>>
>> >        echo $form->input('id', array('type'=>'hidden'));
>> >        echo $form->end('Save');
>> > ?>
>>
>> > Now in users_controller i want a change_status fanction to edit the
>> > changes.But when i select a choice nothing happen.Can you please help
>> > me ?
>>
>> > My code in controller:
>>
>> > function change_status($id=null){
>> >        $this->User->id = $id;
>> >                if (empty($this->data)) {
>> >                        $this->data = $this->User->read();
>> >                } else {
>> >                        if ($this->User->save($this->data)) {
>> >                        $this->Session->setflash('Userstatushas been updated!');
>> >                        $this->redirect('/users');
>> >                        }
>> >                }
>> >        }
>>
>>
> >
>

--~--~---------~--~----~------------~-------~--~----~
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
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---