Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Hi, This is a HTML, CSS, JavaScript and PHP based assignment. I attached a zip folder where you will get all the information about it. But the thing is, It has to be done in a server called TWA...

1 answer below »
Hi, This is a HTML, CSS, JavaScript and PHP based assignment. I attached a zip folder where you will get all the information about it.
But the thing is, It has to be done in a server called TWA server. Which is we used for the university. I'll give you the description how to work on that server. It's easy. You can create any file like example.html, example.css, example.php XXXXXXXXXXIt will work automatically. If you read the instructions carefully you'll understand how to how to work with this.
Please ensure me a good expert on this.Thanks regards
twaassignmentautumn2019-5-vg5zwujp.zip
Answered Same Day May 25, 2021

Solution

Mohd answered on May 27 2021
153 Votes
PHP/1.PNG
PHP/2.PNG
PHP/3.PNG
PHP/4.PNG
PHP/5.PNG
PHP/6.PNG
PHP/generalpractice (1).sql
-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https:
www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 27, 2019 at 10:17 AM
-- Server version: 10.1.25-MariaDB
-- PHP Version: 5.6.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
*!40101 SET NAMES utf8mb4 */;
--
-- Database: `generalpractice`
--
-- --------------------------------------------------------
--
-- Table structure for table `consultation`
--
CREATE TABLE `consultation` (
`ID` int(11) NOT NULL,
`pateint_id` int(11) NOT NULL,
`consult_date` date NOT NULL,
`note` varchar(50) NOT NULL,
`diagnosis` varchar(50) NOT NULL,
`treatment` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `consultation`
--
INSERT INTO `consultation` (`ID`, `pateint_id`, `consult_date`, `note`, `diagnosis`, `treatment`) VALUES
(1, 1, '2019-05-08', 'dfghjkl', 'dftghjnkm', 'sdftghjkl,');
-- --------------------------------------------------------
--
-- Table structure for table `pateint`
--
CREATE TABLE `pateint` (
`ID` int(11) NOT NULL,
`Surname` varchar(50) NOT NULL,
`firstName` varchar(50) NOT NULL,
`Subu
` varchar(200) NOT NULL,
`Phone_number` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`Consultation_date` date NOT NULL,
`Consultation_Notes` varchar(500) NOT NULL,
`Diagnosis` varchar(500) NOT NULL,
`Treatment` varchar(500) NOT NULL,
`password` varchar(50) NOT NULL,
`address` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `pateint`
--
INSERT INTO `pateint` (`ID`, `Surname`, `firstName`, `Subu
`, `Phone_number`, `email`, `Consultation_date`, `Consultation_Notes`, `Diagnosis`, `Treatment`, `password`, `address`) VALUES
(1, 'Je
y', 'Alex', 'ghnjm,', '78457845845', '[email protected]', '2019-05-08', 'dfghjkl,', 'dftghjnkml,', 'sdftghjkl,', '1234', 'sdfghjkdfgvhjnkldfghjnkdfghjn');
-- --------------------------------------------------------
--
-- Table structure for table `staff`
--
CREATE TABLE `staff` (
`ID` int(11) NOT NULL,
`employee_id` varchar(50) NOT NULL,
`surname` varchar(50) NOT NULL,
`firstname` varchar(50) NOT NULL,
`passowrd` varchar(50) NOT NULL,
`category` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `consultation`
--
ALTER TABLE `consultation`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `pateint`
--
ALTER TABLE `pateint`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `staff`
--
ALTER TABLE `staff`
ADD PRIMARY KEY (`ID`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `consultation`
--
ALTER TABLE `consultation`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `pateint`
--
ALTER TABLE `pateint`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;COMMIT;
*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
PHP/TWA/addPatient.php
TWA






Id





    
    
    

Surname


    
    
    
FirstName


    

    

Subu



    
Phone_numbe


    
    
email


    
    
Consultation_date


    
    
Consultation_Notes



Diagnosis


    
Treatment


    
Password


    
address





alert('Thanks for Submitting')";
        
     }
     else
     { echo "";
     }
    
    
}
?
PHP/TWA/connection.php
?php
$conn=@mysqli_connect('localhost','root','','generalpractice') or die (@mysqli_e
or());
@mysqli_select_db('generalpractice',$conn);
?
PHP/TWA/Details.php
TWA

        Id        Last Name        First Name        Phone Number        Action
        $row[0]        $row[1]        $row[2]        $row[3]        
View



";
}

mysqli_close($conn);
}
?



PHP/TWA/footer.php

Contact Here
ncbvgdhvcbdbvhjb jbvndvg, Pateint Email Address vchdghcdgfg dsfhvfhdg hdfgdsnbgfh hgfhdgfhjdbfdfghjdgfjfghd .
PHP/TWA/index.php
TWA!!!

        Id        Last Name        First Name        Phone Number        Email        Full Address
        $row[0]        $row[1]        $row[2]        $row[3]        $row[4]        $row[5]
";
}

mysqli_close($conn);
}
?





PHP/TWA/login.php
?php
session_start();
if (!isset($_SESSION['logged_in'])) {
$nav ='nav.php';
}
elseif($_SESSION['logged_in'] == 'True') {
header('Location: index');
}
else{
$nav ='navconnected.php';
$idsess = $_SESSION['connection.php'];
}
e
or_reporting(0);
?
!DOCTYPE html
html
head
meta http-equiv="Content-Type" content="text/html; charset=utf-8"
title>CWA-Assign3 |participate
title
head
ody style="background-color:#784512"
div class="container"
nav class="navbar navbar-expand-lg navbar-dark bg-light"
CWA-Assign3
a

utton class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarColor03" aria-controls="navbarColor03" aria-expanded="false" aria-label="Toggle navigation"
span

utton