</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; }