You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
app.get('/products/:page',(req,res)=>{constpage_size=3;// 각 페이지의 최대 항목 수constpage=req.params.page||1// if page is null then 1, 현재 페이지 번호console.log(page);constsql='SELECT * FROM 게시글';maria.query(sql,(err,rows,fields)=>{for(leti=0;i<rows.length;i++){console.log('rows'+JSON.stringify(rows[i]));rows[i].작성일자=moment(rows[i].작성일자).format('YYYY-MM-DD');}console.log("rows: "+rows[1].date);if(err)cosole.log('QUERY FAIL\n'+err);elseres.render('mainpage.ejs',{list:rows});});});
The text was updated successfully, but these errors were encountered:
/* show post list *//* Offset Pagination */app.get('/:page',(req,res)=>{constpage_size=3;// 각 페이지의 최대 항목 수constpage=Number(req.params.page||1)console.log(req.params);console.log(`SELECT * FROM 게시글 limit ${page-1}, ${page+4}`);// select * from 게시글 limit 0,5// offset부터 limit까지constsql=`SELECT * FROM 게시글 ORDER BY 게시글ID DESC LIMIT ${page-1}, ${page+2};`;maria.query(sql,(err,rows,fields)=>{for(leti=0;i<rows.length;i++){console.log('rows'+JSON.stringify(rows[i]));rows[i].작성일자=moment(rows[i].작성일자).format('YYYY-MM-DD');}console.log("rows: "+rows[1].date);if(err)console.log('query is not excuted. select fail...\n'+err);elseres.render('mainpage.ejs',{list:rows});});});
개요
게시판 목록을 구현한다.
결과
진행
mainpage.ejs
The text was updated successfully, but these errors were encountered: