Repository navigation
Expand file tree
/
Copy pathdatabase_notes.rtf
More file actions
73 lines (68 loc) · 2.1 KB
/
Copy pathdatabase_notes.rtf
File metadata and controls
73 lines (68 loc) · 2.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
{\rtf1\ansi\ansicpg1252\cocoartf1561\cocoasubrtf400
{\fonttbl\f0\fswiss\fcharset0 Helvetica;\f1\fmodern\fcharset0 CourierNewPSMT;\f2\froman\fcharset0 Times-Roman;
\f3\fnil\fcharset0 HelveticaNeue;}
{\colortbl;\red255\green255\blue255;\red38\green38\blue38;\red29\green30\blue31;}
{\*\expandedcolortbl;;\csgenericrgb\c14902\c14902\c14902;\csgenericrgb\c11373\c11765\c12157;}
\margl1440\margr1440\vieww10800\viewh8400\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0
\f0\fs24 \cf0 BEFORE GOING PRODUCTION: change dbc.php $production = true; // changes which connection credentials to use\
\
\
// for local testing.\
$link = mysqli_connect("localhost", "root", "root", "test");\
\
// for production - not yet tested.\
$link = mysqli_connect("localhost", "miccou3_test", "password", \'93test\'94);\
\
\
ACCESS ON LOCAL HOST- MAMP directory must be at PhaserRepos/TestZone/AngryWipes/AngryWipes\
\
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0
{\field{\*\fldinst{HYPERLINK "http://localhost:8888/databaseDisplay.php"}}{\fldrslt \cf0 http://localhost:8888/databaseDisplay.php}}\
\
\
\
// CREATE THE TABLE FOR RECORDING USERS COMPLETING\
// MIGHT REPLACE UNIT WITH AN ENUM (\'91SICU, \'91MICU\'92, \'91CLC\'92, ).\
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0
\f1\fs26 \cf2 \expnd0\expndtw0\kerning0
CREATE TABLE angry_wipes_test(\
unit VARCHAR(30) NOT NULL,\
comp_date DATE NOT NULL);\
\
// INSERT INTO ANGRY WIPES TABLE\
INSERT INTO `angry_wipes_test`( `unit`, `comp_date`) VALUES ('SICU','2017-11-21');\
\
\
\fs36 AREAS:\
\pard\pardeftab720\sl280\partightenfactor0
\f2\fs28 \cf0 1E\
2W\
5E\
6W\
7W\
Admin\
Audiology\
BMTU\
CLC\
Cath_Lab\
ED\
Environmental\
GI\
IR\
Kitchen\
MICU\
MRI\
Pain_Clinic\
Primary_Care\
RDU\
Radiology\
SCI\
SICU\
Student\
Woman's_Care
\f3\fs36 \cf3 \
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0
\f1 \cf2 \
\
}