Hi guys, I am currently working on a school management system using nodeJS and would like to implement a scratch card verification system on the platform, just like it is on jamb's website. Any idea how to go about this?

look at this sample


var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "username",
  password: "password",
  database: "verify"
});



}


con.connect(function(err) {
  if (err) throw err;
  con.query("SELECT * FROM pin WHERE id = 'id'"function (err, result, fields) {
    if (err) throw err;
    console.log(pin);
  });
});

}




con.connect(function(err) {



var pin = Math.floor(1000 + Math.random() * 9000);

  if (err) throw err;
  console.log("Connected!" ) ;
  var sql = "INSERT * FROM pin WHERE id = 'id'";
  con.query(sql, function(err, result) {
    if (err) throw err;

    console.log(pin);
  });
});


}
}

create an html layout and give the input an id as Id and label as Enter pin in the home.html . feel free to debug the code.

You can also add a column to the table to track used cards

rayyspark:
You can also add a column to the table to track used cards

it means that a query will delete or move the used cards and display them on an HTML table. That is the logic

proxy20:


it means that a query will delete or move the used cards and display them on an HTML table. That is the logic

yes, it can be done that way. It can also be updated as used card.

proxy20:
look at this sample


var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "username",
  password: "password",
  database: "verify"
});



}


con.connect(function(err) {
  if (err) throw err;
  con.query("SELECT * FROM pin WHERE id = 'id'"function (err, result, fields) {
    if (err) throw err;
    console.log(pin);
  });
});

}




con.connect(function(err) {



var pin = Math.floor(1000 + Math.random() * 9000);

  if (err) throw err;
  console.log("Connected!" ) ;
  var sql = "INSERT * FROM pin WHERE id = 'id'";
  con.query(sql, function(err, result) {
    if (err) throw err;

    console.log(pin);
  });
});


}
}

It's weird to see people still posting code on NairaLand these days Captain. How are you doing?

DanielTheGeek:


It's weird to see people still posting code on NairaLand these days Captain. How are you doing?

I am fine bro.