Student Feedback system for College in PHP(SOurce code)

[Rituparna Nag]

(12-27-2012 03:32 PM)Sandeep Wrote:  Here we have developed the a faculty feedback system, which is generally used in the college to rate the faculty based on the performance...Here we have 2 modules such as administrator, student.

Administrator is the one who creates the student account by adding all student info and assigning the username and password.
Admin als0 checks the result once all students entered the feedback..
We can start the development from the login page, where we have given the option to login as admin and student...Here since we have only one admin account, so no need to create the a database to store admin info...so the admin username is "admin" and password is "sandeep"...select admin in the radio button and login

You can perform all admin actions such as login to the account and check result..

I fyou entered the student user and password and selected student option, then it will show all student information and let you enter the feedback based on the subject..

Before we can look into the php code, you need to create a database called "feed" with two tables in it..one as student and another one as take

student table has fields:-

usn, name, branch, age, batch, sem, username, password

take table has fields:

sub, id, first, second, third, fourth, fifth, sixth, seventh, eighth, ninth, teneth, eleventh, twelveth, thirteenth,

Following is the PHP code to login to admin or student account(Depnds on radio button selected):_

Quote:$username=$_POST['user'];
$password=$_POST['pass'];
$selected_radio = $_POST['usr'];
session_start();
$_SESSION['user_id']=$username;
echo $_SESSION['user_id'];
if($selected_radio=='admin')
{
if($username=='admin' && $password=='sandeep')
{
echo "Login Succesful
";
echo "
Welcome Admin
";
echo "
[url=\"http://localhost/feedback/add.html\"]Add new student[/url]

";
echo "[url=\"http://localhost/feedback/result.html\"]Check results[/url]
";
}
}
else if($selected_radio=='stud')
{
$dbDatabase = "feed";
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "";
$sConn = mysql_connect($dbServer, $dbUser, $dbPass) or die("Couldn't connect to database server");

$dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase");

$query="select * from student where username='$username' && password='$password'";

$data=mysql_query($query,$sConn);

if($data)
{
echo "
Login successful
";
echo "
Welcome $username
";
echo "
Student Information

";

$info = mysql_fetch_array( $data );

Print "";
Print "Name: ".$info['name'] . " ";
Print "Usn: ".$info['usn'] . " ";
Print "Batch: ".$info['batch'] . " ";
Print "Sem: ".$info['sem'] . " ";
echo "

[url=\"http://localhost/feedback/feeder.html\"]Enter Feedback now[/url]
";
}
else
{
echo "Invalid username and Password combination
";
}
}

?>

and to add the student informatio by the admin..here is the PHP code

Quote:$usn=$_POST['usn'];
$name=$_POST['name'];
$branch=$_POST['branch'];
$age=$_POST['age'];
$batch=$_POST['batch'];
$sem=$_POST['sem'];
$username=$_POST['username'];
$password=$_POST['password'];
$dbDatabase = "feed";
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "";

$sConn = mysql_connect($dbServer, $dbUser, $dbPass) or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase");
$query="insert into student values('{$usn}','{$name}','{$branch}','{$age}','{$batch}', '{$sem}','{$username}','{$password}')";
if(mysql_query($query,$sConn))
{
echo "
Student details added to the database
";
echo"
[url=\"http://localhost/feedback/add.html\"]Add more student[/url]";
}
else
{
echo "
Student already exist[b]
";
echo "[/b][b][url=\"http://localhost/feedback/add.html\"]Back[/url]
";
}
?>

PHP code to calculate the result of faculty performance is:

Quote:$sub=$_POST['sub'];
$dbDatabase = "feed";
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "";
$sConn = mysql_connect($dbServer, $dbUser, $dbPass) or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase");
$query="SELECT * FROM take WHERE sub='$sub'";
$data=mysql_query($query,$sConn);
$count=0;
$cin=0;
while($row = mysql_fetch_array($data))
{
$count=$count+($row['2']+$row['3']+$row['4']+$row['5']+$row['6']+$row['7']+$row['8']+$row['9']+$row['10']+$row['11']+$row['12']+$row['13']+$row['14']);
$cin++;
}
echo "[b]Number of students given feedback is ";
echo $cin;
echo "

The result for ";
echo $sub;
$total=65*$cin;
$per=($count/$total)*100;
echo " is ";
echo $count;
echo "

Percentage score for ";
echo $sub;
echo " is ";
echo $per;
?>

As you can see, all this developed using WAMP server, download and install it and check this code

To know more about using the wamp server, please check..
http://www.vtuforum.com/Thread-Install-C...cal-server

The webfront end is developed in HTML is available to download, i have attached with this post and download the whole packages and check it

[/b][/b]

---

[b]1.please assign the filenames to save the forms.

2.what is the use of this take table ?

3. I cant understand why you have used first, second , third ... thirteenth for attribute names. [/b]

[Sandeep]

@Rituparna Nag:
As you can see, take.php is just meant to take the input for the different feedback from user and insert into the database

first, second, third are all the different feedback point classified like(syllabus, presentation, coverage). Its just the name of the variable. Please check take.php

Quote:$first=$_POST['comm'];
$second=$_POST['punc'];
$third=$_POST['cond'];

We are just taking the posted data and placing in such variables, later we can jump into the table using insert. Hope it clear your doubt

[Meke]

I have a problem with this, i changed mysql to mysqli and did a few changes to but now when i add students, it only says student already exist....

[Sandeep]

I dont know what is the problem, can you put your code somewhere, may be github and pass the link. I can give a try

[Meke]

(02-04-2016 09:32 AM)Sandeep Wrote:  I dont know what is the problem, can you put your code somewhere, may be github and pass the link. I can give a try

(02-04-2016 09:32 AM)Sandeep Wrote:  
  add.php (Size: 957 bytes / Downloads: 19)

[Meke]

(02-04-2016 09:32 AM)Sandeep Wrote:  I dont know what is the problem, can you put your code somewhere, may be github and pass the link. I can give a try

Any Solutions?

[abbubakar]

where is admin and student radio buttons?

[ayeshaa]

in login.html form where are radio buttons ? that select user or admin mode. and how connection is building between login.html and login.php files ? kindly reply soon. and also send index file plz.

[swasthik p k]

(06-20-2014 12:38 AM)Sandeep Wrote:  in take.php where are we getting "user_id" for "$id=$_GET['user_id'];" from?

[shashikantsngh]

(12-27-2012 03:34 PM)Sandeep Wrote:  These are the remaining files

sir can u mail me complete project including sql file please on my emailID