<?php
require_once '../../library/config_admin.php';
require_once '../library/functions.php';
checkUser();
$action = isset($_GET['action']) ? $_GET['action'] : '';
switch ($action) {
case 'add':
addUniversity();
break;
case 'modify':
modifyUniversity();
break;
case 'delete':
deleteUniversity();
break;
default:
// if action is not defined or unknown
// move to main University page
header('Location: index.php');
}
/*
Add a University
*/
function addUniversity()
{
$name = $_POST['txtName'];
//$parentId = $_POST['hidParentId']; /// pata nahi kaun sa bhanwar hai
$sql = "INSERT INTO universities (`Name`) \r\n VALUES ('{$name}')";
$result = dbQuery($sql) or die('Cannot add University' . mysql_error());
header('Location: index.php');
<?php
include 'functions.php';
if (!empty($_POST)) {
if (!empty($_POST['submit'])) {
$submit = $_POST['submit'];
if ($submit == 'add') {
if (!empty($_POST['universityName'])) {
$universityName = $_POST['universityName'];
$isExecutedSuccessful = addUniversity($universityName);
}
} elseif ($submit == 'rename') {
if (!empty($_POST['selectedUniversity']) && !empty($_POST['universityName'])) {
$selectedUniversity = $_POST['selectedUniversity'];
$universityName = $_POST['universityName'];
$isExecutedSuccessful = renameUniversity($selectedUniversity, $universityName);
}
} else {
if ($submit == 'remove') {
if (!empty($_POST['selectedUniversity'])) {
$selectedUniversity = $_POST['selectedUniversity'];
$isExecutedSuccessful = removeUniversity($selectedUniversity);
}
}
}
}
}
if (!empty($isExecutedSuccessful)) {
echo queryStatusMessage($isExecutedSuccessful);
} else {
echo emptyFormMessage();
echo '<td><input type="text" name="newCounty" value="' . '"/>' . '</td></tr>';
echo '<tr><td>College System:</td>';
echo '<td><input type="text" name="newCollegeSystem" value="' . '"/>' . '</td></tr>';
echo '<tr><td>Founded:</td>';
echo '<td><input type="number" name="newFounded" size="5" min="1900" max="2016" value="' . '"/>' . '</td></tr>';
echo '<tr><td>Acceptance Rate<br> (Fall 2015):</td>';
echo '<td><input type="number" name="newRate" min="1" max="100" value="' . '"/>' . '%</td></tr>';
echo '<tr><td>Students:</td>';
echo '<td><input type="number" size="8" name="newStudents" value="' . '"/>' . '</td></tr>';
echo '<tr><td>Admissions Phone:</td>';
echo '<td><input type="text" size="12" name="newPhone" value="' . '"/>' . '</td></tr>';
echo '<tr><td>Admissions Website:</td>';
echo '<td><input type="text" size="12" name="newWebsite" value="' . '"/>' . '</td></tr>';
echo '<tr><td><input type="submit" name="addUniversity" value="Add"></td></tr>';
if (isset($_POST['addUniversity'])) {
if (addUniversity()) {
echo "<p><b>New School Added Successfully. Returning to previous menu</b></p>";
echo '<meta http-equiv="refresh" content="2; url=editSchools.php">';
} else {
echo "<p><b>Failed to Add New School</b></p>";
}
}
echo '</table>';
echo '</form>';
echo '</div>';
}
if (isset($_GET['univId']) and $_GET['univId'] != -1 and !isset($_GET['newSchool'])) {
echo '<div>';
echo '<form method="post">';
echo '<input type="hidden" name="id" value="' . $_GET['univId'] . '">';
echo '<table>';
