PHP and MySQL-Based Evaluation Management System Source Code

Download code – PHP and MySQL-Based Evaluation Management System

PHP and MySQL-Based Judging Management System

The Judging Management System is a web-based application developed using PHP and MySQL. This system provides an automated way to manage and score event contests. It is designed for organizations to efficiently handle contest judging with a user-friendly interface and useful features.

How the Judging Management System Works

This system helps organizations manage contests and calculate scores automatically. Staff members can register for free by filling out a simple form. Once registered, organizers can create multiple events and sub-events, add contestants and judges, and set judging criteria. Judges use a system-generated code to input scores for contestants.

The system also provides various tallying features, such as:

Overall tally
Tally by judges
Contestant ranking
Event placing

Features and Functionalities

For Organizers:

Manage event and sub-event lists
Configure sub-event settings
Add contestants and judges
Set judging criteria
Manage score sheets
View live scores
Review contestant scores per judge
Deduct points if necessary
Generate final and overall results
Manage organizer’s personal and company details
Add or edit tabulator users

For Tabulators:

View live scores
Check contestant scores per judge
Deduct contestant points
Generate final and overall results

For Judges:

Enter and update contestant scores
View tally

How to Set Up and Run the System

Requirements:

Install a local web server like XAMPP

Installation Steps:

Open XAMPP Control Panel and start Apache and MySQL.
Extract the downloaded source code file.
Copy the extracted folder and paste it into the htdocs directory in XAMPP.
Open a web browser and go to PHPMyAdmin (http://localhost/phpmyadmin).
Create a new database named jms_db.
Import the jms_db.sql file located inside the db folder.
Open the system in a browser at http://localhost/php-jms/.

index PHP

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Insert and view using php, mysql and AJAX</title>
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript">
$(function() {
$(".submit_button").click(function() {
var textcontent = $("#content").val();
var dataString = 'content='+ textcontent;
if(textcontent=='')
{
alert("Enter some text..");
$("#content").focus();
}
else
{
$("#flash").show();
$("#flash").fadeIn(400).html('<span class="load">Loading..</span>');
$.ajax({
type: "POST",
url: "action.php",
data: dataString,
cache: true,
success: function(html){
$("#show").after(html);
document.getElementById('content').value='';
$("#flash").hide();
$("#content").focus();
}  
});
}
return false;
});
});
</script>
<style type="text/css">
.container { 
width:500px; 
margin:0 auto; 
}
a{
text-decoration:none;
}
h2 {
font-size:20px; 
color:#03C;
}
.load {
color:#06C;
}
input { 
float:right;
}
.space { 
margin-bottom:25px; 
margin-top:10px;
}
.showbox { 
border-bottom:1px #09C solid; 
width:490px; 
color:#033;
font-weight:bold;
word-wrap:break-word;
padding:10px; 
font-size:14px; 
font-family:Tahoma, Geneva, sans-serif; 
margin-bottom:5px;
}
</style>
</head>

<body>
 
<div class="container">

<div class="main">
<form  method="post" name="form" action="">
<textarea style="width:500px; font-size:14px; height:60px; font-weight:bold; resize:none;" name="content" id="content" ></textarea><br />
<input type="submit" value="Post" name="submit" class="submit_button"/>
</form>
</div>
<div class="space"></div>
<div id="flash" align="left"  ></div>
<div id="show" align="left"></div>
</div>
</body>
</html>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Insert and view using php, mysql and AJAX</title>

$(function() {

$(".submit_button").click(function() {

var textcontent = $("#content").val();

var dataString = 'content='+ textcontent;

if(textcontent=='')

{

alert("Enter some text..");

$("#content").focus();

}

else

{

$("#flash").show();

$("#flash").fadeIn(400).html('<span class="load">Loading..</span>');

$.ajax({

type: "POST",

url: "action.php",

data: dataString,

cache: true,

success: function(html){

$("#show").after(html);

document.getElementById('content').value='';

$("#flash").hide();

$("#content").focus();

}

});

}

return false;

});

</script>

.container {

width:500px;

margin:0 auto;

}

text-decoration:none;

}

h2 {

font-size:20px;

color:#03C;

}

.load {

color:#06C;

}

input {

float:right;

}

.space {

margin-bottom:25px;

margin-top:10px;

}

.showbox {

border-bottom:1px #09C solid;

width:490px;

color:#033;

font-weight:bold;

word-wrap:break-word;

padding:10px;

font-size:14px;

font-family:Tahoma, Geneva, sans-serif;

margin-bottom:5px;

}

</style>

</head>

<body>

</form>

</div>

</div>

</body>

</html>

db PHP

<?php
 
$conn = new PDO('mysql:host=localhost;dbname=comment', 'root', '');
 

?>

<?php

$conn = new PDO('mysql:host=localhost;dbname=comment', 'root', '');

comment SQL

-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 05, 2013 at 11:28 AM
-- Server version: 5.5.20
-- PHP Version: 5.3.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `2my4edge`
--

-- --------------------------------------------------------

--
-- Table structure for table `comment`
--

CREATE TABLE IF NOT EXISTS `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(11) NOT NULL,
  `ip_add` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` (`id`, `msg`, `ip_add`) VALUES
(1, 'hellow', '127.0.0.1'),
(2, '''arun', '127.0.0.1'),
(3, '''arunkumar''', '127.0.0.1');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

-- phpMyAdmin SQL Dump

-- version 3.4.9

-- http://www.phpmyadmin.net

-- Host: localhost

-- Generation Time: Aug 05, 2013 at 11:28 AM

-- Server version: 5.5.20

-- PHP Version: 5.3.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

-- Database: `2my4edge`

-- --------------------------------------------------------

-- Table structure for table `comment`

CREATE TABLE IF NOT EXISTS `comment` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`msg` varchar(11) NOT NULL,

`ip_add` varchar(40) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- Dumping data for table `comment`

INSERT INTO `comment` (`id`, `msg`, `ip_add`) VALUES

(1, 'hellow', '127.0.0.1'),

(2, '''arun', '127.0.0.1'),

(3, '''arunkumar''', '127.0.0.1');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;