<html>
<body>
<?php
$pageTitle = "Task 5";
include './menu.inc';
include "connection.php";
?>
<?php
//////////////////////////////Task
5//////////////////////////
//Declaration of the the valiables to be used
$practiceNumber=empty($_POST["practiceNumber"]) ? 0 :
$_POST["practiceNumber"];
$Name=empty($_POST["Name"]) ? 'Null' : $_POST["Name"];
$specialty=empty($_POST["specialty"]) ? 'Null' : $_POST["specialty"];
$fees=empty($_POST["fees"]) ? 0 : $_POST["fees"];
$selectMe=empty($_POST['hospital'])? 0 : $_POST["hospital"];
$ErrorMsg ="";
//////////////////////////insert
Records//////////////////////////////////
, if(isset($_POST['btnSuc'])) {
if($selectMe =='0'){
$ErrorMsg="Please select one of the options on the
drop down list ";
$AlertStyle="alert alert-warning";
}
else
if($selectMe =='Add'){
if($practiceNumber =='0'){
$ErrorMsg="Please insert value to
add record";
$AlertStyle="alert alert-warning";
}else{
$sqlss="INSERT INTO
doctors(practiceNumber,specialty,fee,Name)
VALUES
('$practiceNumber','$specialty','$fees','$Name')";
$result=mysqli_query($con,$sqlss);
if($result){
echo "<script>location.href =
'task5.php';</script>";
echo "row has been inserted";
}
}
}
///////////////////////////delete
Records/////////////////////////////////
if($selectMe=='Delete'){
if($practiceNumber =='0'){
$ErrorMsg="Please value to delete ";
$AlertStyle="alert alert-warning";
}
else{
$qer="DELETE from doctors WHERE
practicenumber='$practiceNumber'";
$results=mysqli_query($con,$qer);
if($results){
echo $selectMe;
echo "<script>location.href =
'task5.php';</script>";
}
}
}
///////////////////////////Update
Records/////////////////////////////////
<body>
<?php
$pageTitle = "Task 5";
include './menu.inc';
include "connection.php";
?>
<?php
//////////////////////////////Task
5//////////////////////////
//Declaration of the the valiables to be used
$practiceNumber=empty($_POST["practiceNumber"]) ? 0 :
$_POST["practiceNumber"];
$Name=empty($_POST["Name"]) ? 'Null' : $_POST["Name"];
$specialty=empty($_POST["specialty"]) ? 'Null' : $_POST["specialty"];
$fees=empty($_POST["fees"]) ? 0 : $_POST["fees"];
$selectMe=empty($_POST['hospital'])? 0 : $_POST["hospital"];
$ErrorMsg ="";
//////////////////////////insert
Records//////////////////////////////////
, if(isset($_POST['btnSuc'])) {
if($selectMe =='0'){
$ErrorMsg="Please select one of the options on the
drop down list ";
$AlertStyle="alert alert-warning";
}
else
if($selectMe =='Add'){
if($practiceNumber =='0'){
$ErrorMsg="Please insert value to
add record";
$AlertStyle="alert alert-warning";
}else{
$sqlss="INSERT INTO
doctors(practiceNumber,specialty,fee,Name)
VALUES
('$practiceNumber','$specialty','$fees','$Name')";
$result=mysqli_query($con,$sqlss);
if($result){
echo "<script>location.href =
'task5.php';</script>";
echo "row has been inserted";
}
}
}
///////////////////////////delete
Records/////////////////////////////////
if($selectMe=='Delete'){
if($practiceNumber =='0'){
$ErrorMsg="Please value to delete ";
$AlertStyle="alert alert-warning";
}
else{
$qer="DELETE from doctors WHERE
practicenumber='$practiceNumber'";
$results=mysqli_query($con,$qer);
if($results){
echo $selectMe;
echo "<script>location.href =
'task5.php';</script>";
}
}
}
///////////////////////////Update
Records/////////////////////////////////
