</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="marks">Marks</label>
<div class="col-sm-9">
<input class="form-control" name="marks" id="marks" placeholder="Type Marks in Number">
</div>
</div>
</div>
<div class="col-lg-6">
<div class="form-group">
<label class="col-sm-3 control-label" for="level">Question Level</label>
<div class="col-sm-9">
<select class="form-control" id="level" name="level" required="required">
<option disabled selected>Select Level</option>
<?php
while ($level = $objSql3->fetchRow($levels)) {
?>
<option value="<?php
echo $level['id'];
?>
"><?php
echo $level['level'];
?>
</option>
<?php
}
?>
</select>
</div>
</div>
<section class="panel">
<header class="panel-heading">
All Standards
</header>
<div class="panel-body">
<table class="display table table-bordered table-striped" id="dynamic-table">
<thead>
<tr>
<th width="70%">Standard</th>
<th>Edit</th>
<th>Trash</th>
</tr>
</thead>
<tbody>
<?php
while ($record = $objSql->fetchRow($records)) {
?>
<tr>
<td><?php
echo $record['standard'];
?>
</td>
<td><a href="edit_standard.php?id=<?php
echo $record['id'];
?>
"><i class="fa fa-edit"></i></a></td>
<td><a href=""><i class="fa fa-trash text-danger"></i></a></td>
</tr>
<?php
}
?>
<?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
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>
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;
}
