Skip to content

Instantly share code, notes, and snippets.

View GurunadhPachappagari's full-sized avatar
🎯
Focusing

Gurunadh pachappagari GurunadhPachappagari

🎯
Focusing
2 followers · 1 following
  • None
  • palakkad
View GitHub Profile
@GurunadhPachappagari
GurunadhPachappagari / added_e_patient.php
Last active April 28, 2021 15:04
<html>
<body>
<?php
echo '<body style="background-color:#383A59; color:white">';
$PATIENTID=$_POST["id"];
$PATIENTNAME=$_POST["name"];
$PATIENTADDRESS=$_POST["address"];
$PATIENTCONTACT=$_POST["contact_number"];
$PATIENTGENDER=$_POST["gender"];
try {
@GurunadhPachappagari
GurunadhPachappagari / adding_data.php
Created April 27, 2021 17:11
<html>
<body>
ID <?php echo $_POST["id"]; ?><br>
Name <?php echo $_POST["name"]; ?><br>
Address <?php echo $_POST["address"]; ?><br>
Contact <?php echo $_POST["contact_number"]; ?><br>
Gender <?php echo $_POST["gender"]; ?><br>
<?php
$PATIENTID=$_POST["id"];
$PATIENTNAME=$_POST["name"];
@GurunadhPachappagari
GurunadhPachappagari / create_tables.sql
Created April 27, 2021 17:10
-- Author : Pachappagari gurunadh
-- done:
-- Death_Records -
-- Visitor -
-- Nurse -
-- Admit_Room -
-- Doctor -
-- Emergency_Patient -
-- Patient -
@GurunadhPachappagari
GurunadhPachappagari / practice.sql
Created April 5, 2021 17:13
-- Lab 03
-- creating a table with some attributes
create table books
(name varchar(30) primary key,
ssid varchar(30));
-- add attribute
@GurunadhPachappagari
GurunadhPachappagari / task4.sql
Created March 30, 2021 10:14
-- Q01
-- a.
-- create view doctor_epatient_nurse as
-- (
-- select doctor.name as doctor_name,
-- doctor.id as doctor_id,
-- emergency_patient.id as e_patient_id,
-- emergency_patient.name as e_patient_name,
-- nurse.id as nurse_id,
@GurunadhPachappagari
GurunadhPachappagari / data_creation.sql
Created March 23, 2021 09:42
-- PATIENT TABLE FORMAT (id, name, address, contact_number, gender)
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801001', 'Captain Jack Sparrow', '1-1, Black Pearl Island, Atlantic Ocean', '2715144000', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801003', 'Elizabeth Swann', '34-(90/A) High Land, California', '9752762770', 'female');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801002', 'Gellert Grindelwald', '22-121, Maldives, Indian Ocean', '8558134440', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801004', 'Harry Potter', '4, Privet Drive, Little Whinging, Surrey', '7603341062', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801005', 'Ronald Weasley', 'The main, Tree house, Amazon Forest', '8132047892', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gend