Thanks.
But in custom queries like:
$this->query('UPDATE `bm_aros` SET `alias`...
We need to use:
$this->query('UPDATE ' . $this->database prefix. '`bm_aros` SET `alias`...
I dont remember if is databaseprefix or just only prefix.
hydra12 escribió:
> I could be wrong, but I don't think you have to do anything to use the
> database prefix. That's configured in database.php.
>
> On Jan 19, 1:21 pm, Josoroma <[EMAIL PROTECTED]> wrote:
>
>> I have an afterSave function inside a model, my two questions are:
>>
>> #1 How do i use the database prefix?
>>
>> #2 Do i need to sanitize $data['User']['username'] and $data['User']
>> ['id']?
>>
>> Thanks in advance.
>>
>> function afterSave(){
>>
>> $data = $this->read();
>> $this->query('UPDATE `bm_aros` SET `alias` = \'' . $data['User']
>> ['username'] . '\' WHERE `model` = \'User\' AND `foreign_key` = ' .
>> $data['User']['id']);
>> return true;
>>
>> }
>>
> >
>
>
--
-----------------------------------------
José Pablo Orozco Marín
[EMAIL PROTECTED]
Tel. +506 820-7280
Por favor, visite mi pasión:
http://www.SukiaLogic.com/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
