<?php
include 'includes/header.php';
$objSql = new SqlClass();
if (isset($_POST['submit'])) {
$new_standard = $objSql->sanitize($_POST['new_standard']);
$sql = "INSERT INTO bm_standard_master(standard) values('" . $new_standard . "')";
$record = $objSql->executeSql($sql);
if (!$record) {
header('location:add_new_standsrd.php?error');
}
}
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Add New Standard</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
<li class="active"> Add New Standard </li>
</ul>
</div>
<!-- page heading end-->
<!--body wrapper start-->
<section class="wrapper">
<!-- page start-->
<div class="row">
<div class="col-lg-6">
}
$objSql1 = new SqlClass();
$getStandardSql = "SELECT id,standard FROM bm_standard_master";
$standards = $objSql1->executeSql($getStandardSql);
$objSql2 = new SqlClass();
$getSubjectSql = "SELECT id,subject FROM bm_subject_master";
$subjects = $objSql2->executeSql($getSubjectSql);
$objSql3 = new SqlClass();
$getLevelSql = "SELECT id,level FROM bm_level_master";
$levels = $objSql3->executeSql($getLevelSql);
if (isset($_POST['save_question'])) {
/*echo '<pre>';
print_r($_POST);
echo '</pre>';*/
$objSql4 = new SqlClass();
$_POST = $objSql4->sanitize($_POST);
$db_columns = array('standard', 'subject', 'author', 'question_level', 'status', 'marks', 'question_type', 'question', 'answer');
$column_sring = implode(',', $db_columns);
$column_vals = "'" . $_POST['standard'] . "'";
$column_vals .= ',' . "'" . $_POST['subject'] . "'";
$column_vals .= ',' . "'" . $_POST['author'] . "'";
$column_vals .= ',' . "'" . $_POST['level'] . "'";
$column_vals .= ',' . "'" . $_POST['status'] . "'";
$column_vals .= ',' . "'" . $_POST['marks'] . "'";
$column_vals .= ',' . "'" . $_POST['question_type'] . "'";
if (isset($_POST['question_type']) && $_POST['question_type'] == 'objective') {
$obj_question_array = array('question' => $_POST['obj_question'], 'option_a' => $_POST['option_a'], 'option_b' => $_POST['option_b'], 'option_c' => $_POST['option_c'], 'option_d' => $_POST['option_d']);
$obj_question = json_encode($obj_question_array);
//echo $obj_question;
$column_vals .= ',' . "'" . $obj_question . "'";
$column_vals .= ',' . "'" . $_POST['obj_answer'] . "'";
<?php
include 'includes/header.php';
$objSql = new SqlClass();
$subject = '';
if (isset($_GET['id'])) {
$record_id = $objSql->sanitize($_GET['id']);
$sql = "SELECT id,subject FROM bm_subject_master WHERE id='{$record_id}'";
$query = $objSql->executeSql($sql);
if ($query) {
$record = $objSql->fetchRow($query);
$subject = $record['subject'];
}
}
if (isset($_POST['submit'])) {
$record_id = $objSql->sanitize($_GET['id']);
$subject = $objSql->sanitize($_POST['subject']);
$sql = "UPDATE bm_subject_master SET subject='{$subject}' WHERE id='{$record_id}'";
$record = $objSql->executeSql($sql);
if ($record) {
header('location:manage_subjects.php?updated');
}
}
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Edit Subject</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
<?php
include 'includes/header.php';
$objSql = new SqlClass();
$level = '';
if (isset($_GET['id'])) {
$record_id = $objSql->sanitize($_GET['id']);
$sql = "SELECT id,level FROM bm_level_master WHERE id='{$record_id}'";
$query = $objSql->executeSql($sql);
if ($query) {
$record = $objSql->fetchRow($query);
$level = $record['level'];
}
}
if (isset($_POST['submit'])) {
$record_id = $objSql->sanitize($_GET['id']);
$level = $objSql->sanitize($_POST['level']);
$sql = "UPDATE bm_level_master SET level='{$level}' WHERE id='{$record_id}'";
$record = $objSql->executeSql($sql);
if ($record) {
header('location:manage_levels.php?updated');
}
}
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Edit Level</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
<?php
include 'includes/header.php';
$objSql = new SqlClass();
if (isset($_POST['submit'])) {
$new_level = $objSql->sanitize($_POST['new_level']);
$sql = "INSERT INTO bm_level_master(level) values('" . $new_level . "')";
$record = $objSql->executeSql($sql);
if (!$record) {
header('location:add_new_level.php?error');
} else {
header('location:manage_levels.php');
}
}
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Add New Level</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
<li class="active"> Add New Level </li>
</ul>
</div>
<!-- page heading end-->
<!--body wrapper start-->
<section class="wrapper">
<!-- page start-->
<?php
include 'includes/header.php';
$objSql = new SqlClass();
if (isset($_POST['submit'])) {
$new_subject = $objSql->sanitize($_POST['new_subject']);
$sql = "INSERT INTO bm_subject_master(subject) values('" . $new_subject . "')";
$record = $objSql->executeSql($sql);
if (!$record) {
header('location:add_new_subject.php?error');
}
}
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Add New Subject</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
<li class="active"> Add New Subject </li>
</ul>
</div>
<!-- page heading end-->
<!--body wrapper start-->
<section class="wrapper">
<!-- page start-->
<div class="row">
<div class="col-lg-6">
<?php
include 'includes/header.php';
$objSql = new SqlClass();
$standard = '';
if (isset($_GET['id'])) {
$record_id = $objSql->sanitize($_GET['id']);
$sql = "SELECT id,standard FROM bm_standard_master WHERE id='{$record_id}'";
$query = $objSql->executeSql($sql);
if ($query) {
$record = $objSql->fetchRow($query);
$standard = $record['standard'];
}
}
if (isset($_POST['submit'])) {
$record_id = $objSql->sanitize($_GET['id']);
$standard = $objSql->sanitize($_POST['standard']);
$sql = "UPDATE bm_standard_master SET standard='{$standard}' WHERE id='{$record_id}'";
$record = $objSql->executeSql($sql);
if ($record) {
header('location:manage_standards.php?updated');
}
}
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Edit Standard</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
