₦airaland Forum

Pls I have a Result Checker application developed with PHP, but my problem now is how to code the pin so that a student can use the same PIN for the entire session (first, second and third term) . With a maximium of 10 usage each term. Thanks

ckizen:
Pls I have a Result Checker application developed with PHP, but my problem now is how to code the pin so that a student can use the same PIN for the entire session (first, second and third term) . With a maximium of 10 usage each term. Thanks

. Pls can someone help me out with the right code??

ckizen:
. Pls can someone help me out with the right code??

The 'right code' must be structured in line with the existing one. No one can just start writing codes for a portion of an application they dont have access to.
In summary, for anyone to be able to help you, they need to have the whole of the initial application source code. Its understandable if you dont want to paste it here but just find someone you can send it to.

THIS IS IS SOURCE CODE TO CHECK IT.

<?php
include("Connection/connection.php";
session_start();
$pin =$_POST['tCpin'];
$session =$_POST['session'];
$term = $_POST['term'];
$class = $_POST['class'];



$sql="SELECT * FROM card_pin WHERE PIN ='$pin' and STATUS ='UNUSED' ";
$result=mysql_query($sql);


// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

$_SESSION['pin'] = $pin;
$_SESSION['session'] = $session;
$_SESSION['term'] = $term;
$_SESSION['class'] = $class;


if($count==1){
header("location:Students_in_a_class.php";
}
else {
header("location:No_student_found.php";
}
?>

what you posted here is not enough for anyone to help you.
One needs to see how all authentications are being done and the structure of your DB amongst other things.
Like I said before, post your complete code or show it to someone privately.
Good luck.

onyengbu:
what you posted here is not enough for anyone to help you.
One needs to see how all authentications are being done and the structure of your DB amongst other things.
Like I said before, post your complete code or show it to someone privately.
Good luck.

Gbam!