Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR JAVASCRIPT

javascripte

  coursesRouter.get('/:id',expressAsyncHandler(async(req,res)=>{
    const pageSize = 1;
    const page = Number(req.query.pageNumber) || 1;
    const courseId = req.params.id;
    const course =    await db('id').from('courses').where('id','=',courseId)
    const courseName = course[0].name
    const sections = await db('course_name').from('sections').where('course_name','=',courseName).limit(pageSize).offset(pageSize * (page - 1))
    const count = await db('course_name').from('sections').count('sections')
    console.log( Math.ceil( count[0]/pageSize));
    res.send({sections , page, pages: Math.ceil( count[0]/pageSize)})
})) 
Source by www.visions-tec.de #
 
PREVIOUS NEXT
Tagged: #javascripte
ADD COMMENT
Topic
Name
8+9 =