hey guys i'm trying to parse my data in routes to views in EJS , my code is like this
<% for(datas in data) { %>
<ul class="list-group">
<li class="list-group-item">
<h3>Setoran tanggal : <%= moment(data.created_at).format('L') %></h3>
<br>
Ananda berhasil mendapat nilai <%= data.nilai %> pada setoran nya, dengan keterangan
<br>
<br>
<blockquote>
<p><%= data.keterangan %></p>
<footer><cite title="Source Title"><%= data.nama_lengkap_musyrif %></cite></footer>
</blockquote>
<br>
<p>Dengan meraih halaman</p>
</li>
</ul>
<% } %>
data.nilai shows nothing when i'm trying to loop. and here's my routes
var query1 = "SELECT data_santri_setoran .*, nama_lengkap_musyrif FROM data_santri_setoran INNER JOIN data_musyrif ON data_santri_setoran.nim = data_musyrif.nim WHERE date(data_santri_setoran.created_at) = '"+ moment().format('YYYY-MM-DD') +"'";
connection.query(query1,function(err,rows){
if(err){
res.render('error',{
responseCode : res.statusCode,
error : 'Terjadi kesalahan',
message : err
});
}
res.render('aktifitas/setoran',{
auth : req.user,
data : rows,
moment : moment
});
});
and the rows shows like this
[ RowDataPacket {
id: 6,
nis: '1012017041',
halaman: '["10","11","12"]',
nilai: 'B',
keterangan: 'mayan lha',
nim: '1032017031',
created_at: 2017-05-12T14:44:54.000Z,
updated_at: 2017-05-11T14:44:54.000Z,
nama_lengkap_musyrif: 'Fadhil Ali Sirojjudin' } ]
via Abdan Syakuro
No comments:
Post a Comment