Friday, 12 May 2017

foreach in views EJS Express Show nothing (Nodejs)

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