- Messages
- 122
- Reaction score
- 0
- Points
- 26
Good day to all,
please help rearding in PHP,not inserting in the database, what problem in this code?, please refer below, thank you.
<!DOCTYPE html>
<html>
<head>
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
</head>
<?php
session_start();
include 'authorize.php';
include '../config/config.php';
$results = $conn->query("SELECT patient_id, first_name, middle_name, last_name , age, gender, birthday, address, cp_number, CS, PH, OBSCORE, LMP, EDC, DateAdded, AOG, Weight, BP, Temperature, AccImg FROM tblpatients");
$noOfMale = $conn->query("SELECT COUNT(*) as 'noOfMale' FROM tblpatients WHERE gender='Male'")->fetch();
$noOfFemale = $conn->query("SELECT COUNT(*) as 'noOfFemale' FROM tblpatients WHERE gender='Female'")->fetch();
$totalPhr = $noOfMale['noOfMale'] + $noOfFemale['noOfFemale'];
include 'user_data.php';
function e($x){
return htmlspecialchars(stripslashes(trim($x)));
}
if(isset($_POST["register"])){
include '../config/config.php';
$fname = e($_POST['fname']);
$mname = e($_POST['mname']);
$lname = e($_POST['lname']);
$age = $_POST['age'];
$gender = $_POST['gender'];
$bday = $_POST['bday'];
$addr = e($_POST['addr']);
$cp = $_POST['cp'];
$cs = e($_POST['cs']);
$ph = e($_POST['ph']);
$obs = e($_POST['obs']);
$lmp = e($_POST['lmp']);
$edc = e($_POST['edc']);
$timeNow = time();
$aog = e($_POST['aog']);
$weight = e($_POST['weight']);
$bp = e($_POST['bp']);
$temp = e($_POST['temp']);
$imgfile = $_FILES['upload-image']['name'];
$tmp_dir = $_FILES['upload-image']['tmp_name'];
$imgsize = $_FILES['upload-image']['size'];
echo $imgfile;
if (empty($imgfile)) {
header("Location: show-patient.php?error=Please select an image file. $imgfile");
}
else
{
if(fname == null){
try
{
$upload_dir = '../images/dp/';
$imgext = strtolower(pathinfo($imgfile, PATHINFO_EXTENSION));
$valid = array('jpeg', 'jpg', 'png', 'gif');
$uploadimg = $fname . "_" . rand(1000, 1000000) . "." . $imgext;
if (in_array($imgext, $valid)) {
if ($imgsize < 5000000) {
move_uploaded_file($tmp_dir, $upload_dir.$uploadimg);
//insert into tbluser
$destination = $upload_dir.$uploadimg;
include '../config/config.php';
$stmt = $conn->prepare("SELECT patient_id FROM tblpatients where first_name=:fname");
$stmt->bindParam("fname", $fname) ;
$stmt->execute();
$count=$stmt->rowCount();
if($count == 0){
$stmt = $conn->prepare("INSERT INTO `tblpatients`( `first_name`, `middle_name`, `last_name`, `age`, `gender`, `birthday`, `address`, `cp_number`, `CS`, `PH`, `OBSCORE`, `LMP`, `EDC`, `DateAdded`, `AOG`, `Weight`, `BP`, `Temperature`, `AccImg`) VALUES (:fname, :mname, :lname, :age, :gender, :bday, :addr, :cp, :addr, :cs, h, bs, :lmp, :edc, :dateadded, :aog, :weight, :bp, :temp, :imgpath);");
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':mname', $mname);
$stmt->bindParam(':lname', $lname);
$stmt->bindParam(':age', $age);
$stmt->bindParam(':gender', $gender);
$stmt->bindParam(':bday', $bday);
$stmt->bindParam(':addr', $addr);
$stmt->bindParam(':cp', $cp);
$stmt->bindParam(':cs', $cs);
$stmt->bindParam('h', $ph);
$stmt->bindParam('bs', $obs);
$stmt->bindParam(':lmp', $lmp);
$stmt->bindParam(':edc', $edc);
$stmt->bindParam(':dateadded', $timeNow);
$stmt->bindParam(':aog', $aog);
$stmt->bindParam(':weight', $weight);
$stmt->bindParam(':bp', $bp);
$stmt->bindParam(':temp', $temp);
$stmt->bindParam(':imgpath', $destination);
$stmt->execute();
echo "<meta http-equiv='refresh' content='0'>";
}
else
{
}
}
else
{
header("Location: show-patient.php?error=Sorry, the file is too large.");
}
}
else
{
header("Location: show-patient.php?error=File is not supported.");
}
}
catch(PDOException $x)
{
$errorTitle = "Database Error!";
$error = $e->getMessage();
}
}
else
{
$errorTitle = "Error!";
$error = "Please retype your password correctly!";
echo "<script type='text/javascript'>
$(document).ready(function(){
$('#errormodal').modal('show');
});
</script>";
}
}
$conn = null;
}
?>
<body class="hold-transition skin-red sidebar-mini">
<div class="wrapper">
<header class="main-header">
<nav class="navbar navbar-static-top" role="navigation">
<a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
<span class="sr-only">Toggle navigation</span>
</a>
<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<img src="<?php echo $_SESSION['AccImg'];?>" class="user-image" alt="User Image">
<span class="hidden-xs"><?php echo $_SESSION['user_fullname'] ?></span>
</a>
<ul class="dropdown-menu">
<li class="user-header">
<img src="<?php echo $_SESSION['AccImg'];?>" class="img-circle" alt="User Image">
<p>
<?php echo $_SESSION['user_fullname'] ?> - Admin
<small>Member since <?php echo $_SESSION['membersince']?></small>
</p>
</li>
</ul>
</li>
</ul>
</div>
</nav>
</header>
<aside class="main-sidebar">
<section class="sidebar">
<div class="user-panel">
<div class="pull-left image">
<img src="<?php echo $_SESSION['AccImg'];?>" class="img-circle" alt="User Image">
</div>
<div class="pull-left info">
<p><?php echo $_SESSION['user_fullname'] ?></p>
<a href="#"><i class="fa fa-circle text-success"></i> Admin</a>
</div>
</div>
<ul class="sidebar-menu">
<li class="header">Control Panel</li>
<li class="active"><a href="sh-patient.php"><i class="fa fa-user"></i> <span>Patient</span></a></li>
<li ><a href="sh-products.php"><i class="fa fa-product-hunt"></i> <span>Products</span></a></li>
</ul>
</section>
</aside>
<div class="content-wrapper">
<section class="content-header">
<h1>
Patients
<small></small>
</h1>
<ol class="breadcrumb">
<li><a href="sh-patient.php"><i class="fa fa-dashboard"></i> Admin</a></li>
<li class="active">show patients</li>
</ol>
</section>
<div class="example-modal">
<div class="modal" id="addModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Add new Patient</h4>
</div>
<div class="modal-body">
<form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>" method="POST" enctype="multipart/form-data">
<div class="form-group has-feedback">
<input pattern="[a-zA-Z\s]{1,}" title="Letters only!" type="text" required="" class="form-control" placeholder="First Name" name="fname">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input pattern="[a-zA-Z\s]{1,}" title="Letters only!" type="text" required="" class="form-control" placeholder="Middle Name" name="mname">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input pattern="[a-zA-Z\s]{1,}" title="Letters only!" type="text" required="" class="form-control" placeholder="Last Name" name="lname">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input type="number" required="" class="form-control" placeholder="Age" name="age">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<select class="form-control" name="gender">
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
</div>
<div class="form-group has-feedback">
<input type="date" required="" class="form-control" name="bday" placeholder="Date of Birth">
<span class="glyphicon glyphicon-calendar form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="Address" name="addr">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input type="number" required="" class="form-control" placeholder="Cellphone Number" name="cp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="CS" name="cs">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="PH" name="ph">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="OBSCORE" name="obs">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="LMP" name="lmp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="EDC" name="edc">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="AOG" name="aog">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="WEIGHT" name="weight">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="BP" name="bp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="TEMPERATURE" name="temp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<input type="file" name="upload-image" class="input-group" accept="image/*">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
<input type="submit" class="btn btn-primary" name="register" value="Confirm"></input>
</div>
</form>
</div>
</div>
</div>
</div>
<section class="content">
<div class="row">
<div class="col-md-4">
<div class="info-box bg-red">
<span class="info-box-icon"><i class="fa fa-users"></i></span>
<div class="info-box-content">
<span class="info-box-text">Patients</span>
<span class="info-box-number"><?php echo $totalPhr?></span>
<button type="button" class="btn btn-primary btn-md pull-right btn-flat" data-toggle="modal" data-target="#addModal">
Add new Patient
</button>
</div>
</div>
</div>
</div>
<div class="box">
<div class="box-header">
<h3 class="box-title">Patients</h3>
</div>
<div class="box-body">
<div class="table-responsive">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>ID</th>
<th>First Name</th>
<th>Middle Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Gender</th>
<th>Birthday</th>
<th>Address</th>
<th>Cellphone No.</th>
<th>CS</th>
<th>PH</th>
<th>OBSCORE</th>
<th>LMP</th>
<th>EDC</th>
<th>Date Added</th>
<th>AOG</th>
<th>Weight</th>
<th>Blood Pressure</th>
<th>Temperature</th>
<th>AccImg</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
while($r = $results->fetch()){
echo "<tr>";
echo "<td>".$r['patient_id']."</td>";
echo "<td>".$r['first_name']."</td>";
echo "<td>".$r['middle_name']."</td>";
echo "<td>".$r['last_name']."</td>";
echo "<td>".$r['age']."</td>";
echo "<td>".$r['gender']."</td>";
echo "<td>".$r['birthday']."</td>";
echo "<td>".$r['address']."</td>";
echo "<td>".$r['cp_number']."</td>";
echo "<td>".$r['CS']."</td>";
echo "<td>".$r['PH']."</td>";
echo "<td>".$r['OBSCORE']."</td>";
echo "<td>".$r['LMP']."</td>";
echo "<td>".$r['EDC']."</td>";
$dateadded = date("F j, Y, g:i a", $r["DateAdded"]);
echo "<td>".$dateadded."</td>";
echo "<td>".$r['AOG']."</td>";
echo "<td>".$r['Weight']."</td>";
echo "<td>".$r['BP']."</td>";
echo "<td>".$r['Temperature']."</td>";
echo "<td>".$r['BP']."</td>";
echo "<td>".$r['AccImg']."</td>";
echo "<td><a data-toggle='modal' data-target='#editmodal' href='edit-patients.php?uid=".$r["UID"]."'> <span class='glyphicon glyphicon-pencil'></span></a> | <a data-toggle='modal' data-target='#deletemodal' href='delete-patients.php?uid=".$r["UID"]."'><span class='glyphicon glyphicon-trash'></span></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</section>
</div>
<footer class="main-footer">
<div class="pull-right hidden-xs">
Making Life Easier
</div>
All rights reserved.
</footer>
</div>
<script src="../plugins/jQuery/jquery-2.2.3.min.js"></script>
<script src="../bootstrap/js/bootstrap.min.js"></script>
<script src="../dist/js/app.min.js"></script>
<?php
if(isset($_GET['error'])){
$errorTitle = "Error!";
$error = $_GET['error'];
echo "<script type='text/javascript'>
$(document).ready(function(){
$('#errormodal').modal('show');
});
</script>";
}
if(isset($_GET['success'])){
$successTitle = "Succes!";
$success = $_GET['success'];
echo "<script type='text/javascript'>
$(document).ready(function(){
$('#successmodal').modal('show');
});
</script>";
}
?>
<div class="modal modal-success" id="successmodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title"><?php if(isset($success)) echo $successTitle?></h4>
</div>
<div class="modal-body">
<p><?php if(isset($success)) echo $success?></p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-outline pull-right" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="modal modal-danger" id="errormodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title"><?php if(isset($error)) echo $errorTitle?></h4>
</div>
<div class="modal-body">
<p><?php if(isset($error)) echo $error?></p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-outline pull-right" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="modal modal-danger" id="deletemodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
</div>
</div>
</div>
<div class="modal modal-default " id="editmodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
</div>
</div>
</div>
<script src="../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../plugins/datatables/dataTables.bootstrap.min.js"></script>
<script src="../plugins/slimScroll/jquery.slimscroll.min.js"></script>
<script src="../plugins/fastclick/fastclick.js"></script>
<script src="../dist/js/demo.js"></script>
<script>
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false
});
});
$(document).ready(function()
{
$('.modal').on('hidden.bs.modal', function(e)
{
$(this).removeData();
}) ;
});
</script>
</body>
</html>
please help rearding in PHP,not inserting in the database, what problem in this code?, please refer below, thank you.
<!DOCTYPE html>
<html>
<head>
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
</head>
<?php
session_start();
include 'authorize.php';
include '../config/config.php';
$results = $conn->query("SELECT patient_id, first_name, middle_name, last_name , age, gender, birthday, address, cp_number, CS, PH, OBSCORE, LMP, EDC, DateAdded, AOG, Weight, BP, Temperature, AccImg FROM tblpatients");
$noOfMale = $conn->query("SELECT COUNT(*) as 'noOfMale' FROM tblpatients WHERE gender='Male'")->fetch();
$noOfFemale = $conn->query("SELECT COUNT(*) as 'noOfFemale' FROM tblpatients WHERE gender='Female'")->fetch();
$totalPhr = $noOfMale['noOfMale'] + $noOfFemale['noOfFemale'];
include 'user_data.php';
function e($x){
return htmlspecialchars(stripslashes(trim($x)));
}
if(isset($_POST["register"])){
include '../config/config.php';
$fname = e($_POST['fname']);
$mname = e($_POST['mname']);
$lname = e($_POST['lname']);
$age = $_POST['age'];
$gender = $_POST['gender'];
$bday = $_POST['bday'];
$addr = e($_POST['addr']);
$cp = $_POST['cp'];
$cs = e($_POST['cs']);
$ph = e($_POST['ph']);
$obs = e($_POST['obs']);
$lmp = e($_POST['lmp']);
$edc = e($_POST['edc']);
$timeNow = time();
$aog = e($_POST['aog']);
$weight = e($_POST['weight']);
$bp = e($_POST['bp']);
$temp = e($_POST['temp']);
$imgfile = $_FILES['upload-image']['name'];
$tmp_dir = $_FILES['upload-image']['tmp_name'];
$imgsize = $_FILES['upload-image']['size'];
echo $imgfile;
if (empty($imgfile)) {
header("Location: show-patient.php?error=Please select an image file. $imgfile");
}
else
{
if(fname == null){
try
{
$upload_dir = '../images/dp/';
$imgext = strtolower(pathinfo($imgfile, PATHINFO_EXTENSION));
$valid = array('jpeg', 'jpg', 'png', 'gif');
$uploadimg = $fname . "_" . rand(1000, 1000000) . "." . $imgext;
if (in_array($imgext, $valid)) {
if ($imgsize < 5000000) {
move_uploaded_file($tmp_dir, $upload_dir.$uploadimg);
//insert into tbluser
$destination = $upload_dir.$uploadimg;
include '../config/config.php';
$stmt = $conn->prepare("SELECT patient_id FROM tblpatients where first_name=:fname");
$stmt->bindParam("fname", $fname) ;
$stmt->execute();
$count=$stmt->rowCount();
if($count == 0){
$stmt = $conn->prepare("INSERT INTO `tblpatients`( `first_name`, `middle_name`, `last_name`, `age`, `gender`, `birthday`, `address`, `cp_number`, `CS`, `PH`, `OBSCORE`, `LMP`, `EDC`, `DateAdded`, `AOG`, `Weight`, `BP`, `Temperature`, `AccImg`) VALUES (:fname, :mname, :lname, :age, :gender, :bday, :addr, :cp, :addr, :cs, h, bs, :lmp, :edc, :dateadded, :aog, :weight, :bp, :temp, :imgpath);");
$stmt->bindParam(':fname', $fname);
$stmt->bindParam(':mname', $mname);
$stmt->bindParam(':lname', $lname);
$stmt->bindParam(':age', $age);
$stmt->bindParam(':gender', $gender);
$stmt->bindParam(':bday', $bday);
$stmt->bindParam(':addr', $addr);
$stmt->bindParam(':cp', $cp);
$stmt->bindParam(':cs', $cs);
$stmt->bindParam('h', $ph);
$stmt->bindParam('bs', $obs);
$stmt->bindParam(':lmp', $lmp);
$stmt->bindParam(':edc', $edc);
$stmt->bindParam(':dateadded', $timeNow);
$stmt->bindParam(':aog', $aog);
$stmt->bindParam(':weight', $weight);
$stmt->bindParam(':bp', $bp);
$stmt->bindParam(':temp', $temp);
$stmt->bindParam(':imgpath', $destination);
$stmt->execute();
echo "<meta http-equiv='refresh' content='0'>";
}
else
{
}
}
else
{
header("Location: show-patient.php?error=Sorry, the file is too large.");
}
}
else
{
header("Location: show-patient.php?error=File is not supported.");
}
}
catch(PDOException $x)
{
$errorTitle = "Database Error!";
$error = $e->getMessage();
}
}
else
{
$errorTitle = "Error!";
$error = "Please retype your password correctly!";
echo "<script type='text/javascript'>
$(document).ready(function(){
$('#errormodal').modal('show');
});
</script>";
}
}
$conn = null;
}
?>
<body class="hold-transition skin-red sidebar-mini">
<div class="wrapper">
<header class="main-header">
<nav class="navbar navbar-static-top" role="navigation">
<a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
<span class="sr-only">Toggle navigation</span>
</a>
<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<img src="<?php echo $_SESSION['AccImg'];?>" class="user-image" alt="User Image">
<span class="hidden-xs"><?php echo $_SESSION['user_fullname'] ?></span>
</a>
<ul class="dropdown-menu">
<li class="user-header">
<img src="<?php echo $_SESSION['AccImg'];?>" class="img-circle" alt="User Image">
<p>
<?php echo $_SESSION['user_fullname'] ?> - Admin
<small>Member since <?php echo $_SESSION['membersince']?></small>
</p>
</li>
</ul>
</li>
</ul>
</div>
</nav>
</header>
<aside class="main-sidebar">
<section class="sidebar">
<div class="user-panel">
<div class="pull-left image">
<img src="<?php echo $_SESSION['AccImg'];?>" class="img-circle" alt="User Image">
</div>
<div class="pull-left info">
<p><?php echo $_SESSION['user_fullname'] ?></p>
<a href="#"><i class="fa fa-circle text-success"></i> Admin</a>
</div>
</div>
<ul class="sidebar-menu">
<li class="header">Control Panel</li>
<li class="active"><a href="sh-patient.php"><i class="fa fa-user"></i> <span>Patient</span></a></li>
<li ><a href="sh-products.php"><i class="fa fa-product-hunt"></i> <span>Products</span></a></li>
</ul>
</section>
</aside>
<div class="content-wrapper">
<section class="content-header">
<h1>
Patients
<small></small>
</h1>
<ol class="breadcrumb">
<li><a href="sh-patient.php"><i class="fa fa-dashboard"></i> Admin</a></li>
<li class="active">show patients</li>
</ol>
</section>
<div class="example-modal">
<div class="modal" id="addModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Add new Patient</h4>
</div>
<div class="modal-body">
<form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>" method="POST" enctype="multipart/form-data">
<div class="form-group has-feedback">
<input pattern="[a-zA-Z\s]{1,}" title="Letters only!" type="text" required="" class="form-control" placeholder="First Name" name="fname">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input pattern="[a-zA-Z\s]{1,}" title="Letters only!" type="text" required="" class="form-control" placeholder="Middle Name" name="mname">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input pattern="[a-zA-Z\s]{1,}" title="Letters only!" type="text" required="" class="form-control" placeholder="Last Name" name="lname">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input type="number" required="" class="form-control" placeholder="Age" name="age">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<select class="form-control" name="gender">
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
</div>
<div class="form-group has-feedback">
<input type="date" required="" class="form-control" name="bday" placeholder="Date of Birth">
<span class="glyphicon glyphicon-calendar form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="Address" name="addr">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input type="number" required="" class="form-control" placeholder="Cellphone Number" name="cp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="CS" name="cs">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="PH" name="ph">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="OBSCORE" name="obs">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="LMP" name="lmp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="EDC" name="edc">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="AOG" name="aog">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="WEIGHT" name="weight">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="BP" name="bp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input title="Letters only!" type="text" required="" class="form-control" placeholder="TEMPERATURE" name="temp">
<span class="glyphicon glyphicon-user form-control-feedback"></span>
</div>
<input type="file" name="upload-image" class="input-group" accept="image/*">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
<input type="submit" class="btn btn-primary" name="register" value="Confirm"></input>
</div>
</form>
</div>
</div>
</div>
</div>
<section class="content">
<div class="row">
<div class="col-md-4">
<div class="info-box bg-red">
<span class="info-box-icon"><i class="fa fa-users"></i></span>
<div class="info-box-content">
<span class="info-box-text">Patients</span>
<span class="info-box-number"><?php echo $totalPhr?></span>
<button type="button" class="btn btn-primary btn-md pull-right btn-flat" data-toggle="modal" data-target="#addModal">
Add new Patient
</button>
</div>
</div>
</div>
</div>
<div class="box">
<div class="box-header">
<h3 class="box-title">Patients</h3>
</div>
<div class="box-body">
<div class="table-responsive">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>ID</th>
<th>First Name</th>
<th>Middle Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Gender</th>
<th>Birthday</th>
<th>Address</th>
<th>Cellphone No.</th>
<th>CS</th>
<th>PH</th>
<th>OBSCORE</th>
<th>LMP</th>
<th>EDC</th>
<th>Date Added</th>
<th>AOG</th>
<th>Weight</th>
<th>Blood Pressure</th>
<th>Temperature</th>
<th>AccImg</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
while($r = $results->fetch()){
echo "<tr>";
echo "<td>".$r['patient_id']."</td>";
echo "<td>".$r['first_name']."</td>";
echo "<td>".$r['middle_name']."</td>";
echo "<td>".$r['last_name']."</td>";
echo "<td>".$r['age']."</td>";
echo "<td>".$r['gender']."</td>";
echo "<td>".$r['birthday']."</td>";
echo "<td>".$r['address']."</td>";
echo "<td>".$r['cp_number']."</td>";
echo "<td>".$r['CS']."</td>";
echo "<td>".$r['PH']."</td>";
echo "<td>".$r['OBSCORE']."</td>";
echo "<td>".$r['LMP']."</td>";
echo "<td>".$r['EDC']."</td>";
$dateadded = date("F j, Y, g:i a", $r["DateAdded"]);
echo "<td>".$dateadded."</td>";
echo "<td>".$r['AOG']."</td>";
echo "<td>".$r['Weight']."</td>";
echo "<td>".$r['BP']."</td>";
echo "<td>".$r['Temperature']."</td>";
echo "<td>".$r['BP']."</td>";
echo "<td>".$r['AccImg']."</td>";
echo "<td><a data-toggle='modal' data-target='#editmodal' href='edit-patients.php?uid=".$r["UID"]."'> <span class='glyphicon glyphicon-pencil'></span></a> | <a data-toggle='modal' data-target='#deletemodal' href='delete-patients.php?uid=".$r["UID"]."'><span class='glyphicon glyphicon-trash'></span></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</section>
</div>
<footer class="main-footer">
<div class="pull-right hidden-xs">
Making Life Easier
</div>
All rights reserved.
</footer>
</div>
<script src="../plugins/jQuery/jquery-2.2.3.min.js"></script>
<script src="../bootstrap/js/bootstrap.min.js"></script>
<script src="../dist/js/app.min.js"></script>
<?php
if(isset($_GET['error'])){
$errorTitle = "Error!";
$error = $_GET['error'];
echo "<script type='text/javascript'>
$(document).ready(function(){
$('#errormodal').modal('show');
});
</script>";
}
if(isset($_GET['success'])){
$successTitle = "Succes!";
$success = $_GET['success'];
echo "<script type='text/javascript'>
$(document).ready(function(){
$('#successmodal').modal('show');
});
</script>";
}
?>
<div class="modal modal-success" id="successmodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title"><?php if(isset($success)) echo $successTitle?></h4>
</div>
<div class="modal-body">
<p><?php if(isset($success)) echo $success?></p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-outline pull-right" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="modal modal-danger" id="errormodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title"><?php if(isset($error)) echo $errorTitle?></h4>
</div>
<div class="modal-body">
<p><?php if(isset($error)) echo $error?></p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-outline pull-right" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="modal modal-danger" id="deletemodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
</div>
</div>
</div>
<div class="modal modal-default " id="editmodal" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
</div>
</div>
</div>
<script src="../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../plugins/datatables/dataTables.bootstrap.min.js"></script>
<script src="../plugins/slimScroll/jquery.slimscroll.min.js"></script>
<script src="../plugins/fastclick/fastclick.js"></script>
<script src="../dist/js/demo.js"></script>
<script>
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false
});
});
$(document).ready(function()
{
$('.modal').on('hidden.bs.modal', function(e)
{
$(this).removeData();
}) ;
});
</script>
</body>
</html>