+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Best Practices (https://forum.codeigniter.com/forumdisplay.php?fid=12)
+--- Thread: Insert batch didn't update the created_at field? (/showthread.php?tid=77667)
Insert batch didn't update the created_at field? - mrardiyansyah - 10-01-2020
I am wondering why when I insert data using "insertBatch" the create_at field is still NULL?
is there anyone here can explain it?
RE: Insert batch didn't update the created_at field? - nc03061981 - 10-04-2020
You have some code
Set this:
$this->$useTimestamps = true;
$this = $yourModel
RE: Insert batch didn't update the created_at field? - mrardiyansyah - 10-31-2020
(10-04-2020, 02:11 AM)nc03061981 Wrote: You have some code
Set this:
$this->$useTimestamps = true;
$this = $yourModel
Yes, I have set useTimestamps = true in the model, but oddly it doesn't update in the database. Why?
RE: Insert batch didn't update the created_at field? - paulbalandan - 10-31-2020
Did you include the created at field in the allowed fields?
RE: Insert batch didn't update the created_at field? - mrardiyansyah - 10-31-2020
(10-31-2020, 06:19 AM)paulbalandan Wrote: Did you include the created at field in the allowed fields?Of course, I did. Same as in the documentaion.
PHP Code:
protected $useTimestamps = true;
protected $useSoftDeletes = true;
protected $createdField = 'created_at';
protected $updatedField = 'updated_at';
protected $deletedField = 'deleted_at';
RE: Insert batch didn't update the created_at field? - paulbalandan - 11-01-2020
Can you post your model code?
RE: Insert batch didn't update the created_at field? - wdeda - 11-01-2020
I had the same problem, which is intermittent, because it occurs in certain processes and not in others, without any indication of why. I also noticed that when there are no problems it updates both the created_at and updated_at fields, with exactly the same date and time. The solution I found was to define created_at, update_at and deleted_at, with a null value; created_at plus null with default "current timestamp" and "updated_at" plus null with attribute "n update current timestamp"
The update is done via form, as below.
Model:
PHP Code:
<?php namespace App\Models;
// 20200512
use CodeIgniter\Model;
class ArtistsMoviesModel extends Model
{
protected $table = 'artist_movie';
protected $primaryKey = 'id';
protected $returnType = 'object';
protected $Timestamps = true;
protected $useSoftDeletes = true;
protected $allowedFields = ['artist_id', 'movie_id', 'position', 'charact', 'act1', 'act2', 'act3', 'act4', 'act5'];
}
Controller:
PHP Code:
public function artmov()
{
helper('form');
$model = new ArtistsMoviesModel();
$header = array(
'icon' => 'favicon',
'css' => 'tables',
'title' => 'Atualização da tabela \'artist_movie\' - wdeda',
'action' => '/search/allmedia/',
'placeholder' => 'Pesquisar'
);
$rules = [
'artist_id' => 'required',
'movie_id' => 'required'
];
if ($this->validate($rules)) {
$model->insert([
'artist_id' => $this->request->getVar('artist_id'),
'movie_id' => $this->request->getVar('movie_id'),
'position' => $this->request->getVar('position'),
'charact' => $this->request->getVar('charact'),
'act1' => $this->request->getVar('act1'),
'act2' => $this->request->getVar('act2'),
'act3' => $this->request->getVar('act3'),
'act4' => $this->request->getVar('act4'),
'act5' => $this->request->getVar('act5'),
]);
echo view('templates/headerx', $header);
echo view('tables/artmov-success');
echo view('templates/footerfb');
} else {
echo view('templates/headerx', $header);
echo view('utils/artmov');
echo view('templates/footerfb');
}
}
View:
PHP Code:
<!-- 20200514 -->
<div class="content-container">
<section class="section-tools">
<h4></h4>
<div class="form-content">
<form method="post" action="/tables/artmov/">
<table cellpadding="0" cellspacing="1" style="width: 90%;">
<tr>
<td class="tdright">Artist_id:</td>
<td class="tdleft"><input name="artist_id" size="10" /></td>
</tr>
<tr>
<td class="tdright">Movie_id:</td>
<td class="tdleft"><input name="movie_id" size="10" /></td>
</tr>
<tr>
<td class="tdright">Posição:</td>
<td class="tdleft"><input name="position" size="10" /></td>
</tr>
<tr>
<td class="tdright">Personagem:</td>
<td class="tdleft"><input name="charact" size="10" /></td>
</tr>
<tr>
<td class="tdright">Act1:</td>
<td class="tdleft"><input name="act1" size="10" /></td>
</tr>
<tr>
<td class="tdright">Act2:</td>
<td class="tdleft"><input name="act2" size="10" /></td>
</tr>
<tr>
<td class="tdright">Act3:</td>
<td class="tdleft"><input name="act3" size="10" /></td>
</tr>
<tr>
<td class="tdright">Act4:</td>
<td class="tdleft"><input name="act4" size="10" /></td>
</tr>
<tr>
<td class="tdright">Act5:</td>
<td class="tdleft"><input name="act5" size="10" /></td>
</tr>
<tr>
<tr>
<td class="tdright" style="padding-top:10px"><input type="submit" name="submit" value="Submit" /></td>
</tr>
</table>
</form>
</div>
<ul>
<div class="tab-content">
<div class="filters">
<h3>Última Atualização</h3>
<?php
$db = db_connect();
$query = $db->table('names')
->orderBy('id', 'desc')
->limit('1')
->get();
foreach ($query->getResult() as $row);
?>
<ul>
<li class="li-all">
<span class="span-all">Id:<span class='wd-space'> </span><?php echo $row->id; ?><br />
<span class="span-all">Nome:<span class='wd-space'> </span><?php echo $row->name; ?><br />
</li>
<?php
$db = db_connect();
$query = $db->table('movies')
->orderBy('id', 'desc')
->limit('1')
->get();
foreach ($query->getResult() as $row);
?>
<li class="li-all">
<span class="span-all">Id:<span class='wd-space'> </span><?php echo $row->id; ?><br />
<span class="span-all">Título:<span class='wd-space'> </span><?php echo $row->title; ?><br />
</li>
</ul>
<div class="validation my-3 btn-warning">
<?php echo \Config\Services::validation()->listErrors() ?>
</div>
</section>
</div>