Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,163,622 members, 7,854,627 topics. Date: Saturday, 08 June 2024 at 10:13 PM

Tips :How To Create An Online Student Result Checker App - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Tips :How To Create An Online Student Result Checker App (2103 Views)

Download Online Student Admission System Using PHP With Free Source Code / Contact Us For Your School Portal With Result Checker Using Scratch Cards / with how Much Can I create An Online Retail Website And APP? (2) (3) (4)

(1) (Reply) (Go Down)

Tips :How To Create An Online Student Result Checker App by ProsperChild: 10:11am On Apr 02, 2020
A lot of people are in the dark on how to create a simple online result checker.

Here is some few guide. Understanding this tips we save u hundred of thousand naira, buying a software that u can create and manage effectively on your own.


1. You need to understand HTML/CSS and javascript. You need to know how to use Javascript with REGEX. To validate users PIN $ Serial No details.

2. You need to know how work with database.(Back-end framework)

we have a lot of databases, example Mariadb, Sql bench, Mysql etc.
For beginner n to make thing simple go for MYSQL..
You should understand mysql commands, Data relationship, one-to many etc.
3.Frontend-framework I recommend use PHP( That means u got to study php language and learn how to create simple user registration forms)

4.Should know how to create membership in php that expired at a given time.This concept will be useful to throw a javascript alert that users card pin has expired or count remaining days.

5.You musy understand Triggers. How to use trigger whenever an event is called.Like update, insert, delete.etc.

Trigger is useful, because when you generare a PIN
Using a php technology on the front-end( Learn how to generate random number that stored in the database) U can call trigger to indicate that row is inserted n set or change field column name (Open)a status that is Closed. and another field column Used By &Username.This is very important if u want to create a )PIN that is tied to one user. Although tied to one users u can set the column field as unique so that no duplicate records will be accepted.However Triggers will enable the admin to know which database field column is OPEN or CLOSED so that HE or SHE can generate more PIN for new users.

Your database schema Should look like this
Create a database and give it a name.

Tips use ur Generated unique Id to vaildate users input using REGEX (Regular expression)
concept

We shall create this together. Dont leave this Trend it is gonna be exciting trends.We shall build exciting apps!


Details later

1 Like

Re: Tips :How To Create An Online Student Result Checker App by Journi2America(m): 1:36pm On Apr 05, 2020
ProsperChild:
A lot of people are in the dark on how to create a simple online result checker.

Here is some few guide. Understanding this tips we save u hundred of thousand naira, buying a software that u can create and manage effectively on your own.


1. You need to understand HTML/CSS and javascript. You need to know how to use Javascript with REGEX. To validate users PIN $ Serial No details.

2. You need to know how work with database.(Back-end framework)

we have a lot of databases, example Mariadb, Sql bench, Mysql etc.
For beginner n to make thing simple go for MYSQL..
You should understand mysql commands, Data relationship, one-to many etc.
3.Frontend-framework I recommend use PHP( That means u got to study php language and learn how to create simple user registration forms)

4.Should know how to create membership in php that expired at a given time.This concept will be useful to throw a javascript alert that users card pin has expired or count remaining days.

5.You musy understand Triggers. How to use trigger whenever an event is called.Like update, insert, delete.etc.

Trigger is useful, because when you generare a PIN
Using a php technology on the front-end( Learn how to generate random number that stored in the database) U can call trigger to indicate that row is inserted n set or change field column name (Open)a status that is Closed. and another field column Used By &Username.This is very important if u want to create a )PIN that is tied to one user. Although tied to one users u can set the column field as unique so that no duplicate records will be accepted.However Triggers will enable the admin to know which database field column is OPEN or CLOSED so that HE or SHE can generate more PIN for new users.

Your database schema Should look like this
Create a database and give it a name.

Tips use ur Generated unique Id to vaildate users input using REGEX (Regular expression)
concept

We shall create this together. Dont leave this Trend it is gonna be exciting trends.We shall build exciting apps!



You can also use Reset password principle.. You can then use Regex to vaidate the card serial n card pins.
THE USERS IS PRESENTED WITH2 0R 3 TEXT BOXES
YOU FIRST CHECK IF THE REGISTRATION NO EXIST IN THE DATABASE FOR THE TEXTBOX1
SECONDLY USE CHECK IF THE CARD SERIAL NO IS VALIDATED BY THE REGEX
THEN UPDATE THE DATABASE RECORDS WITH THE NEW PIN AS IF THE PERSON PASSWORD IS LOST.PERFORM A VALIDATION CHECK TO ENSURE THAT NO DUPLICATE CARD PIN IS INSERTED............DETAILS LATER

1 Like 1 Share

Re: Tips :How To Create An Online Student Result Checker App by ProsperChild: 1:52pm On Apr 06, 2020
ProsperChild:
A lot of people are in the dark on how to create a simple online result checker.

Here is some few guide. Understanding this tips we save u hundred of thousand naira, buying a software that u can create and manage effectively on your own.


1. You need to understand HTML/CSS and javascript. You need to know how to use Javascript with REGEX. To validate users PIN $ Serial No details.

2. You need to know how work with database.(Back-end framework)

we have a lot of databases, example Mariadb, Sql bench, Mysql etc.
For beginner n to make thing simple go for MYSQL..
You should understand mysql commands, Data relationship, one-to many etc.
3.Frontend-framework I recommend use PHP( That means u got to study php language and learn how to create simple user registration forms)

4.Should know how to create membership in php that expired at a given time.This concept will be useful to throw a javascript alert that users card pin has expired or count remaining days.

5.You musy understand Triggers. How to use trigger whenever an event is called.Like update, insert, delete.etc.

Trigger is useful, because when you generare a PIN
Using a php technology on the front-end( Learn how to generate random number that stored in the database) U can call trigger to indicate that row is inserted n set or change field column name (Open)a status that is Closed. and another field column Used By &Username.This is very important if u want to create a )PIN that is tied to one user. Although tied to one users u can set the column field as unique so that no duplicate records will be accepted.However Triggers will enable the admin to know which database field column is OPEN or CLOSED so that HE or SHE can generate more PIN for new users.

Your database schema Should look like this
Create a database and give it a name.

Tips use ur Generated unique Id to vaildate users input using REGEX (Regular expression)
concept

We shall create this together. Dont leave this Trend it is gonna be exciting trends.We shall build exciting apps!


Details later



How is it going guys..


Before we start, lemme give u reference link to understand the use of REGEX .You can download the code n Re-use it for your Application

Regex operation will be used in our forms to validate the input of our users such as card serial no: pin no n the rest of it..


webreference.com/programming/php/search/2.html

Make sure u understand how to integrate it on your studentResult checker App


Data structure will be created soon..Dont leave this trend.

I will be right back

1 Like

Re: Tips :How To Create An Online Student Result Checker App by ProsperChild: 3:53pm On Apr 06, 2020
Journi2America:


You can also use Reset password principle.. You can then use Regex to vaidate the card serial n card pins.
THE USERS IS PRESENTED WITH2 0R 3 TEXT BOXES
YOU FIRST CHECK IF THE REGISTRATION NO EXIST IN THE DATABASE FOR THE TEXTBOX1
SECONDLY USE CHECK IF THE CARD SERIAL NO IS VALIDATED BY THE REGEX
THEN UPDATE THE DATABASE RECORDS WITH THE NEW PIN AS IF THE PERSON PASSWORD IS LOST.PERFORM A VALIDATION CHECK TO ENSURE THAT NO DUPLICATE CARD PIN IS INSERTED............DETAILS LATER
Journi2America:


You can also use Reset password principle.. You can then use Regex to vaidate the card serial n card pins.
THE USERS IS PRESENTED WITH2 0R 3 TEXT BOXES
YOU FIRST CHECK IF THE REGISTRATION NO EXIST IN THE DATABASE FOR THE TEXTBOX1
SECONDLY USE CHECK IF THE CARD SERIAL NO IS VALIDATED BY THE REGEX
THEN UPDATE THE DATABASE RECORDS WITH THE NEW PIN AS IF THE PERSON PASSWORD IS LOST.PERFORM A VALIDATION CHECK TO ENSURE THAT NO DUPLICATE CARD PIN IS INSERTED............DETAILS LATER
Journi2America:


You can also use Reset password principle.. You can then use Regex to vaidate the card serial n card pins.
THE USERS IS PRESENTED WITH2 0R 3 TEXT BOXES
YOU FIRST CHECK IF THE REGISTRATION NO EXIST IN THE DATABASE FOR THE TEXTBOX1
SECONDLY USE CHECK IF THE CARD SERIAL NO IS VALIDATED BY THE REGEX
THEN UPDATE THE DATABASE RECORDS WITH THE NEW PIN AS IF THE PERSON PASSWORD IS LOST.PERFORM A VALIDATION CHECK TO ENSURE THAT NO DUPLICATE CARD PIN IS INSERTED............DETAILS LATER



Yeah that method work.

Buh make sure that you create a table where a trigger we store the users information with newid.

At the front end php is employed to fetch the Trigger table ofcourse validation should be performed yea to ensure only one pin is tied to one individual.This will check if a user already exist in the database that bears the new.id value contain in the Trigger row table..


Security of our data is utmost concern.

we shall use PDO and not procedural PHP langguage.

Details later

1 Like

Re: Tips :How To Create An Online Student Result Checker App by ProsperChild: 3:56pm On Apr 06, 2020
ProsperChild:




Yeah that method work.

Buh make sure that you create a table where a trigger we store the users information with newid.

At the front end php is employed to fetch the Trigger table ofcourse validation should be performed yea to ensure only one pin is tied to one individual.This will check if a user already exist in the database that bears the new.id value contain in the Trigger row table..


Security of our data is utmost concern.

we shall use PDO and not procedural PHP langguage.

Details later
Re: Tips :How To Create An Online Student Result Checker App by Anonime1105(m): 9:55am On Apr 07, 2020
ProsperChild:
A lot of people are in the dark on how to create a simple online result checker.

Here is some few guide. Understanding this tips we save u hundred of thousand naira, buying a software that u can create and manage effectively on your own.


1. You need to understand HTML/CSS and javascript. You need to know how to use Javascript with REGEX. To validate users PIN $ Serial No details.

2. You need to know how work with database.(Back-end framework)

we have a lot of databases, example Mariadb, Sql bench, Mysql etc.
For beginner n to make thing simple go for MYSQL..
You should understand mysql commands, Data relationship, one-to many etc.
3.Frontend-framework I recommend use PHP( That means u got to study php language and learn how to create simple user registration forms)

4.Should know how to create membership in php that expired at a given time.This concept will be useful to throw a javascript alert that users card pin has expired or count remaining days.

5.You musy understand Triggers. How to use trigger whenever an event is called.Like update, insert, delete.etc.

Trigger is useful, because when you generare a PIN
Using a php technology on the front-end( Learn how to generate random number that stored in the database) U can call trigger to indicate that row is inserted n set or change field column name (Open)a status that is Closed. and another field column Used By &Username.This is very important if u want to create a )PIN that is tied to one user. Although tied to one users u can set the column field as unique so that no duplicate records will be accepted.However Triggers will enable the admin to know which database field column is OPEN or CLOSED so that HE or SHE can generate more PIN for new users.

Your database schema Should look like this
Create a database and give it a name.

Tips use ur Generated unique Id to vaildate users input using REGEX (Regular expression)
concept

We shall create this together. Dont leave this Trend it is gonna be exciting trends.We shall build exciting apps!


Details later



FOLLOWING.... cool cool cool
Re: Tips :How To Create An Online Student Result Checker App by Anonime1105(m): 10:00am On Apr 07, 2020
ProsperChild:




Yeah that method work.

Buh make sure that you create a table where a trigger we store the users information with newid.

At the front end php is employed to fetch the Trigger table ofcourse validation should be performed yea to ensure only one pin is tied to one individual.This will check if a user already exist in the database that bears the new.id value contain in the Trigger row table..


Security of our data is utmost concern.

we shall use PDO and not procedural PHP langguage.

Details later

.......noted
Re: Tips :How To Create An Online Student Result Checker App by ProsperChild: 10:44am On May 18, 2020
Anonime1105:


.......noted


Items you need before u can follow the tutorials

1 Notedpad++ or PHPSTORM or any good webauthoring tools

2. MYSQL APACHE/MARIADB ..You advice to download n integrate MYSQL8 Into MYSQL Apache, because The new MYSQL 8 has appreciable business logic.

3. Test your Pin n card serial numbers on Regex101.com
So that users pin $ serial details can be pregmatch on your application

Example
Let assume that $p= (_post('pin')) # grab the user input from the textbox 'pin'

Add the following in your if block:

if (!pregmatch("/ FNB[0-9] / $p"wink(
header(location : ' error.php')
)



Note: that FNB[0-9] will accept FNB0123456789 or FNB with any range of number ftom 0 to 9
Details coming shortly!
This is just example.

(1) (Reply)

About Matlab / What Can I Do With Programming? / Why Do Big Companies Outsource Their Software Projects?

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 50
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.