CRUD APP WITH SORT IN NODE EXPRESS AND MONGODB

-

 CRUD APP WITH SORT IN NODE EXPRESS AND MONGODB

wriitten in ecma script6 

Dependencies -

 


 File structure  -


Server.js file - 


//requirements 

const express = require('express');

const mongoose = require('mongoose');

const bodyparser = require('body-parser')

const app = express();

 

// database connection

mongoose.connect('mongodb://localhost:27017/testone',{ useNewUrlParser: true ,useUnifiedTopology: true})

.then(()=>console.log("databse is connected"))

.catch((err)=>console.log(err))

 

 

// database schema

var itemSchema = new mongoose.Schema({

    name : String,

    surname :String,

    event : String

})

 

// database collection creation

var item = new mongoose.model('item',itemSchema)

 

// setting view engine to ejs

app.set('view engine','ejs')

 

// using body parser because of  json

app.use(bodyparser.urlencoded({extended:true}))

 

 

// getting request from the client 

app.get('/',(req,res)=>{

    res.render('index');

})

 

// getting add item request

app.get('/additem',(req,res)=>{

    

    item.find({},(err,items)=>{

        if(err)

        {

            console.log("item is not display")

        }

        else{

            res.render('additem',{items:items})

        }

    })

})

 

// edit request

app.get('/edit/:id',(req,res)=>{

    item.findById(req.params.id,(err,items)=>{

        if(err)

        {

            console.log("not found")

        }

        else{

            res.render('edit',{items:items})

        }

    })

}) 

 

 

 

 

// editing the post request by the client

app.post('/edit/:id',(req,res)=>{

 

    item.findByIdAndUpdate(req.params.id,req.body,(err)=>{

        if(err){

            res.redirect('edit/' + req.params.id);

        }

        else {

            console.log('item saved');

            res.redirect('/additem');

        }

    })

})

 

 

// sorting on the basis of client

app.get('/sort',(req,res)=>{

    res.render('sort')

})

 

// finding data provide  by the client  

app.post('/sorted',(req,res)=>{

    item.find({event: req.body.find},(err,items)=>{

        if(err)

        {

            console.log(err)

        }

        else{

            res.render('sorted',{items:items})

        }

    })

})

 

 

 

// sorting on the basis of the list

app.get('/sortedone/:id',(req,res)=>{

    console.log(req.params.id)

    item.findById(req.params.id,(err,items)=>{

        if(err)

        {

            console.log("not found")

        }

        else{

            console.log(items.event)

            item.find({event: items.event},(err,items)=>{

                if(err)

                {

                    console.log(err)

                }

                else{

                    res.render('sortedone',{items:items})

                }

            })

        }

    })

}) 

 

 

// deleting data 

app.get('/delete:id',(req,res)=>{

    item.findByIdAndRemove(req.params.id,(err)=>{

        if(err){

            console.log(err)

        }

        else {

            res.redirect('/additem')

        }

    })

})

 

 

// saving data 

app.post('/additem',(req,res)=>{

    var itemdata = new item(req.body)

   itemdata.save().then(result=>{

        res.redirect('/additem');

        console.log("item saved");

    }).catch((err)=>{

        res.send("error saving data")

    })

})

 

 

// port 

app.listen('3000',(req,res)=>{

    console.log("server started");

})

 



Index.ejs file - 


<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Document</title>

</head>

 

<body>

    <h1>welcome to my page</h1>

    <a href="/additem">add item</a>

    

   

</body>

</html>


Additem.ejs file - 


<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>hello</title>

</head>

<style>

    table {

      font-family: arial, sans-serif;

      border-collapse: collapse;

      width: 100%;

    }

    

    td, th {

      border: 1px solid #dddddd;

      text-align: left;

      padding: 8px;

    }

    

    tr:nth-child(even) {

      background-color: #dddddd;

    }

    </style>

<body>

    <h3>this is a place where you add item</h3>

    <h2>sort on a basis of event</h2>

    <form action="/sorted" method="POST">

        <input type="text" name="find" placeholder="event name ">

      

        <button>search</a></button>

        </form>

 

        <h3>add items </h3>

    <form action="/additem" method="post">

    <input type="text" name="name" placeholder="name">

    <input type="text" name="surname" placeholder="surname">

    <input type="text" id="myText" name="event" placeholder="rangoli"  value="rangoli" readonly>

    <!-- <input type="text" id="myText" name="event" placeholder="rangoli"  value="rangoli" > -->

    <button type="submit">submit</button>

    </form>

    <br>

    <h3>view items</h3>

    <table>

        <tr>

            <th>no.</th>

            <th>name</th>

            <th>surname</th>

            <th>event</th>

            <th>action</th>

            <th>action</th>

            <th>action</th>

          </tr>

          <% for(let i = 0; i < items.length ; i++ ){ %>

            <tr>

                

              <td> <%= i %></td>

              <td> <%= items[i].name %></td>

              <td> <%= items[i].surname %></td>

              <td> <%= items[i].event %></td>

              <td>  <a href="/edit/<%= items[i]._id %>">edit</a></td>

              <td>  <a href="/delete<%=items[i]._id  %>">delete</a></td>

              <td>  <a href="/sortedone/<%=items[i]._id  %>">see participants</a></td>

            </tr>

 

        <% } %>

    </table>

    

 

 

    

</body>

 

</html>


edit .ejs file - 


<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Document</title>

</head>

<body>

    <h1>this is this</h1>

 

    <form  method="post">

        <input type="text" name="name" placeholder="name" value="<%= items.name %>">

        <input type="text" name="surname" placeholder="surname" value="<%= items.suname %>">

        <input type="text" id="myText" name="event" placeholder="rangoli" defaultvalue="rangoli" value="<%= items.event %>">

        <button type="submit">submit</button>

</body>

</html>



Sort.ejs file - 


<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>sort</title>

</head>

<style>

    table {

      font-family: arial, sans-serif;

      border-collapse: collapse;

      width: 100%;

    }

    

    td, th {

      border: 1px solid #dddddd;

      text-align: left;

      padding: 8px;

    }

    

    tr:nth-child(even) {

      background-color: #dddddd;

    }

    </style>

<body>

    <h1>this is a sorting page</h1>

 

    <form action="/sorted" method="POST">

    <input type="text" name="find" placeholder="event name ">

    <button type="submit">submit</button>

    </form>

</body>

</html>


Sorted.ejs file - 

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>sort</title>

</head>

<style>

    table {

      font-family: arial, sans-serif;

      border-collapse: collapse;

      width: 100%;

    }

    

    td, th {

      border: 1px solid #dddddd;

      text-align: left;

      padding: 8px;

    }

    

    tr:nth-child(even) {

      background-color: #dddddd;

    }

    </style>

<body>

    <h1>this is a sorting page</h1>

 

   

    <table>

        <tr>

            <th>name</th>

            <th>surname</th>

            <th>event</th>

          </tr>

          <% for(let i = 0; i < items.length ; i++ ){ %>

            <tr>

              <td> <%= items[i].name %></td>

              <td> <%= items[i].surname %></td>

              <td> <%= items[i].event %></td>

    

            </tr>

 

        <% } %>

    </table>

</body>

</html>


Sortedone.ejs file -


<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>sort</title>

</head>

<style>

    table {

      font-family: arial, sans-serif;

      border-collapse: collapse;

      width: 100%;

    }

    

    td, th {

      border: 1px solid #dddddd;

      text-align: left;

      padding: 8px;

    }

    

    tr:nth-child(even) {

      background-color: #dddddd;

    }

    </style>

<body>

    <h1>this is a sorted one page</h1>

 

   

    <table>

        <tr>

            <th>name</th>

            <th>surname</th>

            <th>event</th>

          </tr>

          <% for(let i = 0; i < items.length ; i++ ){ %>

            <tr>

              <td> <%= items[i].name %></td>

              <td> <%= items[i].surname %></td>

              <td> <%= items[i].event %></td>

    

            </tr>

 

        <% } %>

    </table>

</body>

</html>

 




 

Comments

Post a Comment

All time Best Post

Write a program that declares a class named Person. It should have instance variables to record name, age and salary. Use new operator to create a Person object. Set and display its instance variables.

-
Image
 Program -  import java.util.*; public class persondata { public static void main(String[]args) { person a = new person(); a.set(); System.out.println("your data is \n\n"); a.display(); } }  class person { private String name; private int age; private int salary;   public void display() { System.out.println("your name is :"+name); System.out.println("your age is :"+age); System.out.println("your salary is "+salary); } public void set(){ Scanner sc = new Scanner(System.in); System.out.println("enter your name"); name = sc.next(); System.out.println("enter your age"); age = sc.nextInt(); System.out.println("enter your salary"); salary = sc.nextInt(); } } outpiut -   
Read more

IMAGE CRUD OPERATION USING EXPRESS MONGOOSE MULTER

-
Image
  IMAGE CRUD OPERATION USING EXPRESS MONGOOSE MULTER Dependencies Used -    File Structured -  Server.js file -  // requirements    const express = require ( 'express' ) const imgModel = require ( './db/user' ) const mongoose = require ( 'mongoose' ) const multer   = require ( 'multer' ) const path = require ( 'path' ) const app = express ();   // serving static files  app . use ( express . static ( 'public' ));     // connecting to database  mongoose . connect ( 'mongodb://localhost:27017/testten' , { useNewUrlParser: true , useUnifiedTopology: true , useFindAndModify: false   }) . then (() => console . log ( "database is connected" )) . catch (( err ) => console . log ( err ))   // multer destination set    var storage = multer . diskStorage ({      destination: "./public/uploads/" ,      filename : ( req , file , cb ) => {   ...
Read more

connect websocket to binance api and store t he true value in the db

-
  const WebSocket = require( 'ws' ); const bitcoindata = require( '../model/bitcoindata.model' ); function connectToBinanceWebSocket() {    // Connect to Binance's WebSocket API for the BTC/USDT trading pair    const socket = new WebSocket( 'wss://stream.binance.com:9443/ws/btcusdt@kline_1m' );    // Handle messages received from the WebSocket   socket.on( 'message' , (data) => {      const message = JSON.parse(data);      if (message.e === 'kline' ) {        const candle = message.k;       console.log( `[${new Date(candle.t).toLocaleTimeString()}] Open: ${candle.o}, High: ${candle.h}, Low: ${candle.l}, Close: ${candle.c}` );        if (candle.x == true ) {         console.log({candle})         bitcoindata.crea...
Read more

express session login system using node express mongodb

-
Image
express session login system using node express mongodb Dependencies used -  File -  Server.js file -  const express = require ( 'express' ); const mongoose = require ( 'mongoose' ); const bcrypt = require ( 'bcrypt' ) const session = require ( 'express-session' ) const mongoDBSession = require ( 'connect-mongodb-session' )( session ); const bodyparser = require ( 'body-parser' ); const userModel = require ( './models/user' ) const student = require ( './student' ) const app = express ();   const mongoURI = 'mongodb://localhost:27017/testsix'     mongoose . connect ( 'mongodb://localhost:27017/testsix' ,{ useNewUrlParser: true , useUnifiedTopology: true , useCreateIndex: true , }) . then (() => console . log ( "database is connected" )) . catch (( err ) => console . log ( err ))   app . set ( 'view engine' , 'ejs' )   app . use ( bodyparser . urlencod...
Read more

how to delete image from the folder directly from a Request (MULTER)

-
imported item -  const   path  =  require ( 'path' ) const   fs  =  require ( 'fs' ) // code : router . get ( '/delete/:id' , isAuth , async  ( req , res ) => {      await    addBlogmodel . findByIdAndRemove ( req . params . id ,( err , items ) => {          if ( err ){              res . send ( "sory we have some issuse" )         }          else         {              const   path  =  './public/uploads/' + items . image              try  {                  f...
Read more

calculate rsi

-
Image
  const newFunction = async () => {       // https://stackoverflow.com/questions/70452789/node-js-find-the-same-rsi-as-tradingview       // https://gist.github.com/jmoz/1f93b264650376131ed65875782df386       // https://stackoverflow.com/questions/50203625/calculate-rsi-based-on-kraken-ohlc       // topdown1.count({}, function( err, count){           //  console.log( "Number of data in db :", count );           // topdown1.find(async (err,items)=>{                 // if(err){                   //      console.log(err)                 // }                 // else{                     const ticker = await exchange . fetchTicker ( '...
Read more

java program for 1 to 10 print using while loop

-
 program-  public class Main {     public static void main(String[] args)     {         int i=0;                  while ( i<10 )         {             i++;             System.out.println(i);                      }     } } Output :- 1 2 3 4 5 6 7 8 9 10
Read more

How to fetch last one minute volume of BTC in CCXT Nodejs.

-
Image
  const exchange = new ccxt . binance (); async   function   getLastOneMinuteVolume () {     try {       const binance = new ccxt . binance ();       const symbol = "BTC/USDT" ;     //   const symbol = "USDT";       const ohlcv = await binance . fetchOHLCV ( symbol , "1m" );         console . log ( ohlcv [ ohlcv . length - 1 ])       const lastCandle = ohlcv [ ohlcv . length - 1 ];       const volume = lastCandle [ 5 ];     //   console.log(lastCandle[5])       console . log ( "Last one minute volume:" , volume );     } catch ( error ) {       console . error ( error );     }   }   //   getLastOneMinuteVolume();   setInterval ( getLastOneMinuteVolume , 1000 ) first data in array is volume in USDT , last is volume in BTC , second is price.
Read more