Good Day fellow programmers. I'm working on a school portal system for a secondary school. They intend to sell scratch cards to parents for result checking.
How do I add this functionality?

Ochiske:
Good Day fellow programmers. I'm working on a school portal system for a secondary school. They intend to sell scratch cards to parents for result checking.
How do I add this functionality?

Simple, just create a table with all scratch card pin in it, immediately the parent/user enters the pin into your system to check result, validate the entered pin with your records, then change the status to active, lock the card pin to the user, it cant be used with another acct.

Ochiske:
Good Day fellow programmers. I'm working on a school portal system for a secondary school. They intend to sell scratch cards to parents for result checking.
How do I add this functionality?

Follow the directions of the poster above and you won't miss your way

talk2hb1:

Simple, just create a table with all scratch card pin in it, immediately the parent/user enters the pin into your system to check result, validate the entered pin with your records, then change the status to active, lock the card pin to the user, it cant be used with another acct.

I can get your whatsapp contact bro?

Ochiske:


I can get your whatsapp contact bro?

<=>
Signature

talk2hb1:

Simple, just create a table with all scratch card pin in it, immediately the parent/user enters the pin into your system to check result, validate the entered pin with your records, then change the status to active, lock the card pin to the user, it cant be used with another acct.

Exatly what i wanted to say. i have done this once... Works this same way.

d answer has been posted on nairaland

To spice the answer up.

The pin table should be divided into 'used' and 'unused'

Once a pin is entered and correct, move it to 'used' in conjunction with the user and maybe 'times_used'. Subsiquently, if a pin is entered and is not found in 'unused', search used...and if the user is same, display result as you increment 'times_used'.


You know you should thank me.

talk2hb1:

Simple, just create a table with all scratch card pin in it, immediately the parent/user enters the pin into your system to check result, validate the entered pin with your records, then change the status to active, lock the card pin to the user, it cant be used with another acct.

Though I don't know how to go about challenges like this now, but I will never solve this way. What will happen if someone get an unauthorized access to my database table? Generate another sets of PIN? there should be better way.

babatope88:


Though I don't know how to go about challenges like this now, but I will never solve this way. What will happen if someone get an unauthorized access to my database table? Generate another sets of PIN? there should be better way.

If someone have access to your database, then the person doesn't need to create new pin, all the person need to do is download the your database instead of adding new pin

I have a ready made online Secondary results checking script for sale, demo available on request.

just create a random number I store it in data and show it out in admin panel 4 u to print it out

INSTEAD OF CREATING A TABLE THAT CAN EASILY BE HACKED, Y NOT CREATE AN ALGORITHM FOR CHECKING ANY PIN ENTERED IN THE SITE TO VERIFY IF ITS AN ORIGINAL SCRATCH PIN..

frankg1:
INSTEAD OF CREATING A TABLE THAT CAN EASILY BE HACKED, Y NOT CREATE AN ALGORITHM FOR CHECKING ANY PIN ENTERED IN THE SITE TO VERIFY IF ITS AN ORIGINAL SCRATCH PIN..

Which Original Pin?
If I can reverse engineer your algorithm with machine learning forget everything is done

You can save contents of your database to a cloud somewhere and you use a connecting string to connect it to it.

Windows Server R2 2012 can be good here.
That way you cannot easily download the database if hacked. Before you deploy check for SQL injections , Blind SQL Injections , Heartbleed injections , XSS and several other forms of take over.

babatope88:


Though I don't know how to go about challenges like this now, but I will never solve this way. What will happen if someone get an unauthorized access to my database table? Generate another sets of PIN? there should be better way.

Find good ways to generate your pins, else people (like me) will generate our own.

Don't use time stamps and all those base64 stuff. Contact me for more details

logicalhumour:
Find good ways to generate your pins, else people (like me) will generate our own.

Don't use time stamps and all those base64 stuff. Contact me for more details

I'm not building anything like that. No need of contacting you.

babatope88:


I'm not building anything like that. No need of contacting you.

I thought you talked of 'PIN'. Ok oo, farewell.

talk2hb1:

Which Original Pin?
If I can reverse engineer your algorithm with machine learning forget everything is done

LOL. OGA DONT JUST BLOW BIG ENGLISH WITHOUT BACKUP. THERE IS NO PRACTICAL WAY U CAN BREAK THAT KIND OF ALGORITHM WITHOUT THE ORIGINAL SOURCE CODE...WHICH WILL BE STORED ON THE SERVER. MACHINE LEARNING IS MACHINE LEARNING.

The method might be simple,all that matters is security.

frankg1:

LOL. OGA DONT JUST BLOW BIG ENGLISH WITHOUT BACKUP. THERE IS NO PRACTICAL WAY U CAN BREAK THAT KIND OF ALGORITHM WITHOUT THE ORIGINAL SOURCE CODE...WHICH WILL BE STORED ON THE SERVER. MACHINE LEARNING IS MACHINE LEARNING.

This is not english classs bro even if it were, it can't be instantiated. Hope you understand me

logicalhumour:
To spice the answer up.

The pin table should be divided into 'used' and 'unused'

Once a pin is entered and correct, move it to 'used' in conjunction with the user and maybe 'times_used'. Subsiquently, if a pin is entered and is not found in 'unused', search used...and if the user is same, display result as you increment 'times_used'.


You know you should thank me.

Pls can you help with the code sample?