{
if (!is_dir('uploads')) {
die('Upload folder not exists');
} elseif (!is_writable('uploads')) {
die('Not enough permission on uploads folder');
}
}
$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'] . "'";
<?php
include 'includes/header.php';
$objSql = new SqlClass();
$sql = "SELECT id,standard FROM bm_standard_master";
$records = $objSql->executeSql($sql);
?>
<!-- page heading start-->
<div class="page-heading">
<h3>Manage Standards</h3>
<ul class="breadcrumb">
<li>
<a href="index.php">Dashboard</a>
</li>
<li class="active"> Manage Standards </li>
</ul>
</div>
<!-- page heading end-->
<!--body wrapper start-->
<section class="wrapper">
<!-- page start-->
<?php
if (isset($_GET['updated'])) {
?>
<div class="row">
<div class="col-lg-12">
<div class="alert alert-success">Standard Updated Successfully</div>
</div>
</div>
<?php
function display_scroll_text($type)
{
$sql = "SELECT * from scroll_text where status='1' and place_displayed='{$type}'";
$objSql1 = new SqlClass();
$record1 = $objSql1->executeSql($sql);
return $record1;
}
<?php
session_start();
ob_start();
include "../lib/db.php";
$objSql = new SqlClass();
if (isset($_POST['login'])) {
$username = $_REQUEST['username'];
$password = md5($_REQUEST['password']);
$query = "SELECT * FROM bm_admin WHERE username ='******' AND password ='******' and status='active'";
$objSql->setAdvanceErr(true);
if ($record = $objSql->executeSql($query)) {
if ($objSql->getNumRecord()) {
while ($row = $objSql->fetchRow($record)) {
$_SESSION['adminuser'] = $username;
$_SESSION['admin_login'] = "******";
$_SESSION['admin_sessid'] = $row['id'];
header("Location:index.php");
exit;
}
} else {
$_SESSION['msg'] = "Login Credentials didn't match";
header("Location:login.php");
exit;
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?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>
function makecount($table, $field, $value)
{
$query = "select count(" . $field . ") from " . $table . " where " . $field . "='" . $value . "'";
//echo $query;
$objSql = new SqlClass();
$res = $objSql->executeSql($query);
$row = $objSql->fetchRow($res);
return $row;
}
