+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Update instead insert (/showthread.php?tid=78493)
Update instead insert - pippuccio76 - 01-28-2021
HI i have two model :
User :
protected $allowedFields = ['id','email','password','user_activation_hash','id_stato_users','pin','tipo_utente','refertatore','sconto','updated_at','last_login'];
protected $allowedFields = ['id_user','nome','cognome','data_nascita','telefono','nome_studio','numero_iscrizione_ordine','anno_iscrizione_ordine','piva','id_comuni','indirizzo','civico','cap','pec','sdi','note','normativa_ministero_salute','termini','privacy','comunicazioni'];
this is a part of controller's method :
Code:
if($this->validate($rules)){
$post = $this->request->getPost();
// generate random hash for email verification (40 char string)
$user_activation_hash = sha1(uniqid(mt_rand(), true));
$post['user_activation_hash'] = $user_activation_hash;
//setto lo stato come 1 (da cliccare sul link)
$post['id_stato_users'] = 1;
//setto tipo utente come dentista(1)
$post['tipo_utente'] = 1;
$rand = rand(0, 999999);
$post['pin'] = str_pad($rand, 6, '0', STR_PAD_LEFT);
$res=$user_model->save($post);
$post['id_user']=$user_model->insertID;
log_message('debug',"post_id_user " . $post['id_user']);
$res2=$dentistiModel->save($post);
log_message('debug','dentistiModel last query ' . $dentistiModel->getLastQuery() );
//DEBUG
//$last_query = $model->getLastQuery();
if ($res AND $res2) {
if($this->send_user_activation_hash_by_email($post['email'],$post['pin'],$user_activation_hash))
{
$data['messaggi_ok'] = 'Registrazione andata a buon fine conferma il tuo indirizzo email cliccando sul link che ti abbiamo inviato';
$data ['redirect'] =base_url().'/user/login';
echo view('common/messaggi_ok',$data );
}else{
$data['messaggio_errore'] = 'Problemi invio mail con link ';
$data ['redirect'] =base_url().'/user/login';
echo view('common/messaggi_errore',$data );
}
}else {
$data['messaggio_errore'] = 'Problemi registrazione dentista';
$data ['redirect'] =base_url().'/user/login';
echo view('common/messaggi_errore',$data );
}this is the log :
Code:
INFO - 2021-01-28 19:26:52 --> CSRF cookie sent
INFO - 2021-01-28 19:26:52 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2021-01-28 19:27:30 --> CSRF cookie sent
INFO - 2021-01-28 19:27:30 --> CSRF token verified
INFO - 2021-01-28 19:27:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
DEBUG - 2021-01-28 19:27:30 --> post_id_user 25
DEBUG - 2021-01-28 19:27:30 --> dentistiModel last query UPDATE `dentisti` SET `nome` = 'Stefano', `cognome` = 'Banchelli', `numero_iscrizione_ordine` = '212212', `anno_iscrizione_ordine` = '2025', `note` = '64656465', `normativa_ministero_salute` = '1', `termini` = '1', `privacy` = '1', `comunicazioni` = '1', `id_user` = 25
WHERE `dentisti`.`id_user` IN (25)
INFO - 2021-01-28 19:27:34 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
INFO - 2021-01-28 19:27:34 --> CSRF cookie sentwhy don't insert but update ?
RE: Update instead insert - neoneeco - 01-28-2021
Hi
I dont kknows why, but you can read : https://codeigniter.com/user_guide/models/model.html?highlight=save
Its about $id
RE: Update instead insert - pippuccio76 - 01-28-2021
(01-28-2021, 01:32 PM)neoneeco Wrote: Hichange to insert instead save , the record are inserted but return false , why ?
I dont kknows why, but you can read : https://codeigniter.com/user_guide/models/model.html?highlight=save
Its about $id
can i use transaction on model->save() and model->insert?
RE: Update instead insert - InsiteFX - 01-28-2021
If the $id is in the database table it will do an update, if not it will do an insert.
RE: Update instead insert - pippuccio76 - 01-28-2021
(01-28-2021, 09:53 PM)InsiteFX Wrote: If the $id is in the database table it will do an update, if not it will do an insert.In the second table i havent field id
RE: Update instead insert - demyr - 01-29-2021
I have tried to organize your coding a bit and asked you a question within the code area below. Could you please check?
PHP Code:
if($this->validate($rules)){
//$post = $this->request->getPost();
// generate random hash for email verification (40 char string)
$user_activation_hash = sha1(uniqid(mt_rand(), true));
$user_activation_hash = $this->$this->request->getVar('user_activation_hash');
$id_stato_users = 1;
$tipo_utente = 1;
$rand = rand(0, 999999);
$pin = str_pad($rand, 6, '0', STR_PAD_LEFT);
$data = [
'user_activation_hash' => $user_activation_hash,
'id_stato_users' => $id_stato_users,
'tipo_utente' => $tipo_utente,
'pin' => $pin
];
$res=$this->UserModel->save($data); // rename your model please. Name should be capital
$id_user=$this->UserModel->getInsertID;
log_message('debug',"post_id_user " . $id_user);
$res2=$this->DentistiModel->save($data); // Why saving the same data for a different model?
RE: Update instead insert - pippuccio76 - 01-29-2021
(01-29-2021, 04:50 AM)demyr Wrote: I have tried to organize your coding a bit and asked you a question within the code area below. Could you please check?
PHP Code:if($this->validate($rules)){
//$post = $this->request->getPost();
// generate random hash for email verification (40 char string)
$user_activation_hash = sha1(uniqid(mt_rand(), true));
$user_activation_hash = $this->$this->request->getVar('user_activation_hash');
$id_stato_users = 1;
$tipo_utente = 1;
$rand = rand(0, 999999);
$pin = str_pad($rand, 6, '0', STR_PAD_LEFT);
$data = [
'user_activation_hash' => $user_activation_hash,
'id_stato_users' => $id_stato_users,
'tipo_utente' => $tipo_utente,
'pin' => $pin
];
$res=$this->UserModel->save($data); // rename your model please. Name should be capital
$id_user=$this->UserModel->getInsertID;
log_message('debug',"post_id_user " . $id_user);
$res2=$this->DentistiModel->save($data); // Why saving the same data for a different model?
i save data for different model because i have a two type of user , the first part (a simple registration data) i save into a table users , the second part is specific of the type of user and i save it in the specific table
RE: Update instead insert - demyr - 01-29-2021
(01-29-2021, 05:05 AM)pippuccio76 Wrote: i save data for different model because i have a two type of user , the first part (a simple registration data) i save into a table users , the second part is specific of the type of user and i save it in the specific table
I asked because I wanted to be sure if you have the same columns in your second table?
Btw, did you set auto increment for ID in your db table?
RE: Update instead insert - pippuccio76 - 01-29-2021
(01-29-2021, 05:19 AM)demyr Wrote:(01-29-2021, 05:05 AM)pippuccio76 Wrote: i save data for different model because i have a two type of user , the first part (a simple registration data) i save into a table users , the second part is specific of the type of user and i save it in the specific table
I asked because I wanted to be sure if you have the same columns in your second table?
Btw, did you set auto increment for ID in your db table?
I have id in user autoincrement , in dentisti i have id_user (foreign key of user ) without id
RE: Update instead insert - demyr - 01-29-2021
Would you try insert instead of save ?