ࡱ > C E B t ` =, bjbj 4r ! H
4 4 4 8 4 d `5
bl 6 .6 .6 .6 |7 9 9 9 k k k k k k k $ n h p l
< 59 ^ 9 < < l .6 |7 l ]D ]D ]D < " .6
|7 k ]D < k ]D ]D 6 a 6
r
3d 6 6 `@L 4 @ b =j 2l 0 bl b q A J q 8 3d 3d q
f @ 9 v K: T ]D : D : 6 9 " 9 9 l l C j 9 9 9 bl < < < <
$ .
.
This lab should get you familiarized with accessing MySQL databases over the web using PHP.
Reminder At the end of the class, save the files from D:/sokkit/site/ and D:/sokkit/mysql/data to your x-drive or removable media, as these are shared directories and their content is deleted when you log out.
Submission requirements: Both electronic and paper submission. All the files pertaining to this lab should be available as a zip file on your X drive, in IT420/lab10/lab10_m07xxx.zip, where 07xxx is your alpha. Hard copies of all files should be submitted in class. Due date Tuesday, March 28 2006 before lab.
You will receive up to 80 points for completing the work and 20 points for an oral quiz based on your understanding of the PHP/MySQL code.
Preliminaries:
In previous labs/classes you have created the vp5fund database in MySQL, to hold the data for the VP-5 MWR Fund Raiser application. The following tables were created:
Items(ItemName, Price)
Orders(OrderID, ShippingAddress)
ItemsOrdered(OrderID, ItemName, Quantity)
If you saved your database, it is time to restore it now. If you do, there should be a vp5fund directory in D:/sokkit/mysql/data, to hold all the data for the vp5fund database.
If you did not save your database, you can create the database and the tables in it by running the SQL statements in createVp5FundTables.txt file from the website. First, download createVp5FundTables.txt and save it somewhere, lets say on X:/IT420/Lab10/createVp5FundTables.txt
To start the MySQL Monitor (command-line interface to MySQL) from the Windows command line (Start(run(cmd):
D:
cd D:/sokkit/mysql/bin
mysql u root //to start the MySQL monitor as user root
source X:/IT420/Lab10/createVp5FundTables.txt //to run the SQL statements in the file you saved
You can check that the database and tables were created:
From the MySQL monitor command line:
show databases; //lists all databases on the MySQL server. vp5fund should be one of them
use vp5fund; //chose the vp5fund database to work with
show tables; //lists all the tables in the current database (vp5fund)
describe items; //display the structure of the items tables
Now you are ready to connect to the vp5fund database from PHP.
PART 1: Connect to MySQL from PHP
Remember that all PHP functions will return a value of false if the operation is not successful. This is good news because you can (and should) test for the success or failure of functions (much like you did when opening/writing/reading files).
You will use the following PHP function to connect to MySql. Understand this is just a generic connection to the MySql DBMS and NOT to a specific database within MySql:
mysql_connect (hostname, user_name, password);
hostname is the host or server name where MySql resides, the user_name is the name of the user connecting to the db server, and password is the password for the user. In our lab configuration your hostname is localhost. The user_name for your current configuration is root. The password is empty . These are the values for the parameters, when youll test the function.
After a connection to MySql is established, you can connect to a particular database using:
mysql_select_db(database_name, connection)
database_name is the name of the database, and connection is the identifier for the connection returned by mysql_connect.
Open the Crimson Editor, create the file connect_db.php and save it to the D:sokkit/site folder.
TASK:
In the connect_db.php file write a function my_connect_db to open a db connection and select a database
Input parameters:
db server name
user name optional, default value root
password optional, default value
database name
Return value:
FALSE if errors occurred
database connection if everything OK
Test your function: Copy the following code to a new test.php file saved in D:/sokkit/site:
From the browser, run HYPERLINK "http://localhost/test.php" http://localhost/test.php
You should receive the message Everything OK. If you do not get this message, check for errors in my_connect_db function.
PART 2: Query the database
Save the source for the following input form in D:/sokkit/site/searchOrders.html:
Orders Search Page
VP-5 Fund Raiser Orders Search
TASK:
The purpose of the form is to allow a user to search for some particular orders, more specifically for orders with shipping address containing some user-input search term, or all orders if no search term is specified.
Write the code for the processSearchOrders.php file executed when the used clicks the Search button:
Use the my_connect_db function you defined earlier to connect to the vp5fund database.
Create a variable $sql that will hold the SQL query to extract the needed information from the v5fund database. You should find all the order ids, shipping address, and the total amount to be paid, including a 5% tax, for orders with shipping address containing the user-input search term.
Submit the SQL query to the database using
$mysql_result = mysql_query($sql, $connection);
The $connection is the current connection identifier returned by the my_connect_db function in case of success. $sql is a variable holding the SQL query to be submitted to the database. Thus, if $connection is valid and $sql holds a valid query, the results of the query are stored in the variable $mysql_result.
Display the results. If there are no orders returned, display an explicative message. If there are any orders returned, display the results in a table. Here is a sample output for this case:
OrderIDShippingAddressTotal Amount (with 5% tax)1420 Web Foot Ln, Stevensville MD 2166685.052214 Taylor Avenue, Annapolis, MD94.50
Here is some basic PHP code for a table:
echo "";
echo "| OrderID | ShippingAddress | TotalAmount |
|---|
";
or, if you prefer the pure html, then the following is equivalent:
| OrderID | ShippingAddress | TotalAmount |
|---|
Disconnect from the database.
Test you program. Run searchOrders.html from the browser, input some search term, submit the search and check if the results displayed match the data in the vp5database.
PART 3: Insert into the database
Until now we assumed that data related to orders is already in the tables in vp5fund database. Now you will write a program to allow the user to create orders that you will save into the database.
This is how the input form for the VP-5 fund raiser orders looks like:
TASK
Add code to your processOrder.php file (executed by server when the previous form is submitted) to save order data from VP-5 Fund Raiser application into the Orders and Itemsordered tables in the vp5fund database. Make sure that you create a new order in the Orders table only if some item is indeed ordered (the quantity is specified and is higher than 0). Similarly, only items ordered (the quantity is specified and is higher than 0) should appear in the ItemsOrdered table. Remember that the OrderID is created automatically by the DBMS, since the OrderID column was created with AUTO_INCREMENT keyword. Also make sure that the ItemName values you insert into the ItemsOrdered table correspond to the names existing in the Items table, since the ItemName in OtemsOrdered is a foreign key referencing ItemName column in Items table.
Display appropriate message in order confirmation screen. If for any reason the data cannot be saved in the database, an error message should be displayed. This is a sample output if the order was successfully saved.
Part 4: Application start menu
TASK:
Write a front end for this VP-5 MWR Fund Raiser Application. The user should have two choices: either place an order, in which case the appropriate form to allow for user orders should be displayed (Part 3), or to search for orders, in which case the appropriate form to allow for order searches should be displayed (Part 2).
IT 420 Lab (21 March 2006)
Web Databases - PHP and MySQL
VP-5 Fund Raiser Orders Search
Top of Form
Shipping Address HTMLCONTROL Forms.HTML:Text.1 HTMLCONTROL Forms.HTML:Submitbutton.1 Bottom of Form
VP-5 MWR
Your order is as follows: 1 Tee Shirts 2 Ball Caps 3 Patches
Total Quantity: 6 Total Amount(with 5% sales tax): $85.05 Shipping Address: 420 Web Foot Ln, Stevensville MD 21666
Order Processed. 11:50, 7 March 2006
VP-5 MWR Fund Raiser
Top of Form
ItemQuantityMad Fox Tee Shirts HTMLCONTROL Forms.HTML:Text.1 VP-5 Ball Caps HTMLCONTROL Forms.HTML:Text.1 Mad Fox Patches HTMLCONTROL Forms.HTML:Text.1 Shipping Address HTMLCONTROL Forms.HTML:Text.1 HTMLCONTROL Forms.HTML:Submitbutton.1 Bottom of Form
* 4 : C P Z ^ _ g h 1 2 3 K p r ʿݴݬ틃{s{s h{= CJ aJ hU CJ aJ hSD CJ aJ hSD hSD 5>*CJ aJ hij CJ aJ h h: CJ aJ h CJ aJ h h
CJ aJ h hij CJ aJ h}J 5>*CJ aJ h=k CJ aJ hUe CJ aJ h8D CJ aJ h}J CJ aJ h}J h}J CJ aJ * ] ^ _ 2 3 i
I L c 7 \ gd
& F gdSlx gdN
& F gdN ) a) <,
=
F
M
V
W
d
g
h
i
k , ̾wk]w]wkwkwU h[F_ CJ aJ hSD hN 6CJ ]aJ hSD hN >*CJ aJ hSD hN CJ aJ hX' CJ aJ hn!* CJ aJ hN CJ aJ hX' hGu 5>*CJ aJ hX' hX' 5>*CJ aJ h}J CJ aJ hSD hSD 5>*CJ aJ h~-= hSD CJ aJ h~-= CJ aJ hUe CJ aJ hU CJ aJ h{= CJ aJ hjX CJ aJ , N Z
G
X
\
7 > ? B C G _ \ p q ȺȺȲ貢|qf hX' 5>*CJ aJ h{e 5>*CJ aJ h hN CJ aJ hSD h[F_ CJ aJ h] CJ aJ hZ CJ aJ h[F_ CJ aJ hGa CJ aJ h8 CJ aJ j h h CJ aJ h CJ aJ hmd CJ aJ hSlx CJ aJ hN CJ aJ hs CJ aJ h_? CJ aJ h? CJ aJ #\ 4 p q x y ' ( / 0 1 gd gdq gdX gdN
& F gd8 { 1 9 ' ( . / 1 I Z d h | } hQm h 5h hK( hq 5hK( hq 56 hq 56 hq hGa hL hX hL hX 6hL hX 5hX CJ aJ hX 6h| \ hX 6h hX 6h hX 5hX h>m CJ aJ h hN 5>*CJ aJ 1 % P v . / 5 U V gdq
& F
gdlQ
& F
gdlQ gdlQ gd - . 5 A V _ x . / бйЦйzйvrv h_ hf h
hlQ 5>* h
hQm 5>* h
h4 5>* hQm 5hy hQm 0J j hQm Uj hQm U hQm hQm h 5 h h \J h D hQm hO[ hlQ h \J hlQ hlQ 6] h \J 6] hlQ hlQ hF h , 0 1 & - O W ^ - 5 = E F G I J K L 7$ 8$ H$ gd(1 gdq
4 F c E G H J L M N R S X Y Z [ w 4 5 7 @ N V ~ wow h1^ CJ aJ hUe^ CJ aJ h5) CJ aJ hkE& CJ aJ hUe^ hf 5CJ aJ hUe^ 5CJ aJ hUe^ hUe^ 5CJ aJ h CJ aJ hf CJ aJ h hq CJ aJ hL CJ aJ j hf UmH nH u h(1 h(1 h(1 hL h1^ h
hf h_ +L M N O P Q R S Y [ 5 7 G H x y ^`gd5) gd5) gd9
& F gd9 h^hgd9
& F gdkE& gdf gd ~
e H U X c d h j u } 1 2 = G K P U Y b p q r s 輴̔̌~ h,k 5\ h| 5\ h)9 CJ aJ h9c CJ aJ h8 h ' h5) 6hk= h5) 5h5) h5) h5) 6h5) CJ aJ h|. CJ aJ h^ CJ aJ h8 h8 6CJ aJ h8 CJ aJ h9 CJ aJ hkE& CJ aJ h CJ aJ 1y r s { $$If a$gdbKy gd)9
& F gd5) gd5) ^gd5) Z! [! \! x! y! {! ! ! ! $" %" &" :" >" G" H" ]" " ŽŪvnc h1^ h1^ CJ aJ hR CJ aJ h
h
5>*CJ aJ h
hR 5>*CJ aJ hk= CJ aJ h1^ CJ aJ h
CJ aJ h5) CJ aJ h,k h)9 h,k h,k CJ aJ h)9 CJ aJ h9 h9 h9 hb h9 h| h| CJ aJ h| 5\ h9 5\ h,k 5\% i ` ` ` $If gdbKy kd $$If T 0 0 0 0 F 0 0 0 0 0 6 3 4 a b T i ` ` ` $If gdbKy kd $$If T 0 0 0 0 F 0 0 0 0 0 6 3 4 a b T - . ^ i d d _ _ V V _ V `gd,k gd,k gd)9 kdU $$If T 0 0 0 0 F 0 0 0 0 0 6 3 4 a b T ! [! \! z! {! %" &" G" H" # # V# W# Y# Z# [# \# ]# ^# _# `# a# b# c# gd5) h^hgd5)
& F gd5) gd)9 `gd,k " " #
# # # *# J# W# X# h# i# l# m# o# # # # $ $ 3$ C$ L% & & & ' (' ' ' ' ƴƨ|t|ltdYQY h CJ aJ h}hD hbKy CJ aJ h6H7 CJ aJ h? CJ aJ hP CJ aJ hw
1 CJ aJ h}hD h}hD CJ aJ h&D CJ aJ hP CJ aJ hbKy 5CJ aJ h&D h}hD 5CJ aJ "j h}hD CJ UaJ mH nH u h}hD CJ aJ hR h1^ 5CJ aJ h1^ hf CJ aJ h1^ hR CJ aJ h1^ CJ aJ hbKy CJ aJ c# d# e# f# g# h# n# o# & & ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' gdbKy gd}hD ' ' ' ' ' ' ' ' ( 1( ) ) ) ) ) ) ) ) ") #) %) 1) >) @) P) S) ]) ^) `) a) ) ) ) ) ) ) ) ޝxiax j h~-= U j &G
h~-= CJ UVaJ j hbKy UhbKy hbKy 5CJ aJ hDgl hbKy 5CJ aJ hH4l j hH4l Uh h CJ aJ h+6 CJ aJ hOL CJ aJ hub CJ aJ hk= CJ aJ h h 5>*CJ aJ h CJ aJ hbKy CJ aJ "j hbKy CJ UaJ mH nH u$' ' ' ' ' ' ) ) ) ) ) ) ) ) ) ) ) ) ) ) !) ") $) %) @) ^) _) `) a) $a$gd\
a) ) ) ) ) ) ) ) ) { r $$If a$t kd+ $$If F 6 3 4 a p $If gdf gdf ) ) ) ) ) ) ) ) ) * N* * * * + + .+ /+ N+ O+ P+ Q+ S+ T+ c+ d+ + + + + + + + + + + + + + + + + + ʼ쥝쎆wo j} h~-= U j%G
h~-= CJ UVaJ j hbKy U jG
hbKy CJ UVaJ j$ hbKy U jG
hbKy CJ UVaJ hbKy CJ aJ hb hbKy 5CJ \aJ hb hbKy CJ aJ j h~-= U j%G
h~-= CJ UVaJ hbKy j hbKy UhbKy CJ aJ *) ) * * * * * * * * N* * * * } x gdbKy gdbKy @&gdbKy gdbKy gdbKy gd^t gdf gdf \ kd $$If 0 6 3 4 a p
* * * + + + + + .+ R+ S+ { h kd $$If 0 6 3 4 a p $If $$If a$ gd}hD gd}hD
S+ T+ c+ + + $If o kd9 $$If F 6 3 4 a p + + + + + $If o kd
$$If F 6 3 4 a p + + + + + $If o kd $$If F 6 3 4 a p + + + + + + + + + ", #, $, %, &, (, ;, <, =, Žܹ h CJ aJ h=! j h~-= U j%G
h~-= CJ UVaJ hbKy CJ aJ hbKy j hbKy Uj+ h~-= U j%G
h~-= CJ UVaJ + + + + + $If o kdy $$If F 6 3 4 a p + + &, ', (, * W kd $$If 0 6 3 4 a p $If $$If a$o kd $$If F 6 3 4 a p (, 7, 8, 9, :, ;, <, =, gd}hD gd}hD 2 1h:p\
/ =!*"#$% D y K h t t p : / / l o c a l h o s t / t e s t . p h p y K 4 h t t p : / / l o c a l h o s t / t e s t . p h p $$If !v h5 5^5 #v #v^#v :V 0 0 0 0 0 6 , 5 / 3 4 T $$If !v h5 5^5 #v #v^#v :V 0 0 0 0 0 6 , 5 / 3 4 T $$If !v h5 5^5 #v #v^#v :V 0 0 0 0 0 6 , 5 / 3 4 T D d
h b
c $ A ? ? 3 " ` ? 2 d 7[ KE# @ U
`!8 7[ KE# ) | xcdd``~ ,@30p31ex$00Yr @PP sd>0H0 DE&Ǣ C@Î%rGl> d0 %H:`\7 $$If !v h5 5
5_ #v #v
#v_ :V 6 , 5 3 4 p > D d
b
c $ A ? ? 3 " ` ? 2 X3 Ǣk4 d
`!\ X3 Ǣk4R 4 \ * xmQJA}{\"h.()"!~mE*iK?CJa}ɮ{psf潙YA '~ MK5e#.ΠhLQ+~zA aN]FJcLPJ˝X,ˠTCʑzGPwRQiόaڭY$h >B 0xY.:O {Nj-~ilԻZΐJ-q6ng8}8..Kr&v県UMvx3^K],uc1FE:g~ $$If !v h5 5_ #v #v_ :V 6 , 5 3 4 p $$If !v h5 5
#v #v
:V 6 , 5 3 4 p D d
h b
c $ A ? ? 3 " ` ? 2 _ rZUT ; o ?
`!3 rZUT " | xmJA]sM$&4VVH^ZADF^ CXWM"rcvoYA+ ;8~e9t
r=e%Ƹ kC|&7¬ˬ$犔5[dN-^.uQoJ$ n*'}#e3ܿ/Jnj,eՉ&,s} Xq7}<ϲe/߳7F~۫b`6Ǟhq8E:5\1̖ $$If !v h5 5
5_ #v #v
#v_ :V 6 , 5 3 4 p D d
h b
c $ A ? ? 3 " ` ? 2 ^ , u_/ h : ?
`!2 , u_/ h " | xmAJAEu$ILqH
APA^ C4WqBERqdj~uWT {8~e9t
r}c%?h FB L1JnYYI.)g$ȜZ*"]ңޔ mI>_WO|F9`/JnTʪM$s}_S%v~Gyeo^_~+F~^\e7b`6G8_` LP%Fo7X1 $$If !v h5 5
5_ #v #v
#v_ :V 6 , 5 3 4 p D d
h b
c $ A ? ? 3 " ` ? 2 ` vU t/S
<
`!4 vU t/S
" | xmJAƿ]c hV
He*IC-lI~3 Y~
c^m 7 <<X1
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 ; < = > ? @ A ^ D H e G I K J M L O N P Q R S T V U W X Y Z [ ] \ b c _ ` a d h f g i s j k l m n o p q r v w x y z { | } ~ R o o t E n t r y / F 0iQLF 8 D a t a
: t W o r d D o c u m e n t . 4r O b j e c t P o o l
`@L0iQL _ 1 2 0 4 4 3 0 3 3 6 U\g `@L`@L P R I N T C o m p O b j m O b j I n f o
! " # $ % & ' ) , - 0 1 2 3 4 5 6 8 ; < ? @ A B C D E G J K N O P Q R S T U W Z [ \ _ ` a b c d e f g i l m p q r s t u v x y z { | } ~ { - ! ! - ! ! - ! ! @@@ - ! ! . 2
@ Arial #
R ww 0wA
f - 2
MD '
U\g Forms.HTML:Text.1 Embedded Control Forms.HTML:Text.1 9q 2 U\g < I N P U T T Y P E = " T E X T " M A X L E N G T H = " 5 0 " S I Z E = " 3 3 " N A M E = " a d d r e s s " V A L U E = " M D " > D e f a u l t O c x N a m e 3 1 1 1 ` ) 4 O C X D A T A O C X N A M E ( _ 1 2 0 4 4 3 0 3 3 5 U\g `@L`@L P R I N T Z @@@ - ! 3 ! 3 - ! ! 2 - ! 2 ! 1 - ! ! 0 - ! 0 - ! . 4 . @ Arial #
8P ww 0w1#fY -
2
. S - ! - 2
. earch '
U\g Forms.HTML:Submitbutton.1 Embedded Control Forms.HTML:Submitbutton.1 9q 2 U\g < I N P U T T Y P E = " s u b m i t " A C T I O N = " p r o c e s s o r d e r . p h p " V A L U E = " S e a r c h " M E T H O D = " p o s t " > D e f a u l t O c x N a m e 5 1 1 1 C o m p O b j } O b j I n f o O C X D A T A
O C X N A M E ( _ 1 2 0 4 2 0 1 4 8 9 " U\g `@L`@L P R I N T C o m p O b j ( m O b j I n f o * { " - ! ! ! ! - ! ! - ! ! qod - ! ! " . 2
@ Arial <
=R ww 0w.
fX -
2
1 '
U\g Forms.HTML:Text.1 Embedded Control Forms.HTML:Text.1 9q 2 U\g < I N P U T T Y P E = " T E X T " M A X L E N G T H = " 3 " S I Z E = " 3 " N A M E = " t e e q t y " V A L U E = " 1 " > D e f a u l t O c x N a m e 4 { " O C X D A T A + O C X N A M E . " _ 1 2 0 4 2 0 1 4 8 8 U\g `@L`@L P R I N T / - ! ! ! ! - ! ! - ! ! qod - ! ! " . 2
@ Arial <
=R ww 0wc
f -
2
2 '
U\g Forms.HTML:Text.1 Embedded C C o m p O b j 7 m O b j I n f o 9 O C X D A T A : O C X N A M E = $ ontrol Forms.HTML:Text.1 9q 2 U\g < I N P U T T Y P E = " T E X T " M A X L E N G T H = " 3 " S I Z E = " 3 " N A M E = " c a p q t y " V A L U E = " 2 " > D e f a u l t O c x N a m e 1 1 { " - ! ! ! ! _ 1 2 0 4 4 3 0 3 3 4 U\g `@L`@L P R I N T > C o m p O b j F m O b j I n f o H - ! ! - ! ! @@@ - ! ! " . 2
@ Arial #
R ww 0wf: -
2
3 '
U\g Forms.HTML:Text.1 Embedded Control Forms.HTML:Text.1 9q 2 U\g < I N P U T T Y P E = " T E X T " M A X L E N G T H = " 3 " S I Z E = " 3 " N A M E = " p a t c h q t y " V A L U E = " 3 " > D e f a u l t O c x N a m e 2 1 { = - ! ! - ! ! O C X D A T A ! I O C X N A M E L $ _ 1 2 0 4 4 3 0 3 3 3 ( $ U\g `@L`@L P R I N T M @ - ! ! @@@ - ! ! . 2
@ Arial #
R ww 0w"f5 - = 2
! 420 Web Foot Ln, Stevensville MD
'
U\g Forms.HTML:Text.1 Embedded Control Forms.HTML:Text.1 9q C o m p O b j # & V m O b j I n f o X O C X D A T A % ' Y O C X N A M E ] $ 2 U\g < I N P U T T Y P E = " T E X T " M A X L E N G T H = " 5 0 " S I Z E = " 3 3 " N A M E = " a d d r e s s " V A L U E = " 4 2 0 W e b F o o t L n , S t e v e n s v i l l e M D 2 1 6 6 6 " > D e f a u l t O c x N a m e 3 1 E 2 P @@@ - ! O ! O _ 1 2 0 4 4 3 0 3 3 2 * U\g `@L`@L P R I N T ^ l C o m p O b j ) , h } O b j I n f o j - ! ! N - ! N ! M - ! ! L - ! L - ! J P . @ Arial #
8P ww 0w(f -
2
J S - ! - 2
J ubmit Order '
U\g Forms.HTML:Submitbutton.1 Embedded Control Forms.HTML:Submitbutton.1 9q 2 U\g < I N P U T T Y P E = " s u b m i t " A C T I O N = " p r o c e s s o r d e r . p h p " V A L U E = " S u b m i t O r d e r " M E T H O D = " p o s t " > D e f a u l t O c x N a m e 5 1 Oh +'0 O C X D A T A + - k O C X N A M E n $ 1 T a b l e 9 u Nq S u m m a r y I n f o r m a t i o n ( 0 o )&ɍ03Ȣ(jR_HlkMwHzSrlyMw`l#TUM:Qf\lgAmbyX]o积 #mGr`6ǾpD:52 1 $$If !v h5 5
5_ #v #v
#v_ :V 6 , 5 3 4 p N D d
h b
c $ A ? ? 3 " ` ? 2 ]wm1Tyr t o
`!l ]wm1Tyr6 ) | : xm=KA=%U@6*!
VhapBH@C^%洰 "H*uf/\fg9
V ȕ)3jg(R(Kc̼xzx*dE
r2IGB_ÒX S "9ٜ БзlI@> +!ysV{"JJ
ij4E?rf]b?In7'u<|Ou{67/٬}b=ТM$y:>.p8G }:zH e,k,e`B $$If !v h5 5
5_ #v #v
#v_ :V 6 , 5 3 4 p $$If !v h5 5
5_ #v #v
#v_ :V 6 , 5 3 4 p K D d
b
c $ A ? ? 3 " ` ? 2 sqrƋW q
`!i sqrƋWd P \ 7 xmQJ1}lVDDtTd
1TKUqBV(hW ~>~ $$If !v h5 5_ #v #v_ :V 6 , 5 3 4 p , 8
X d p
| , Lab 6 Triggers and Introduction to PHP mckenna Normal.dot adina 62 Microsoft Office Word @ 2T @ @ T*I@ L ) ՜. +,D ՜. +, D o c u m e n t S u m m a r y I n f o r m a t i o n 8 w M a c r o s 6 `@L`@L V B A 4 `@L`@L d i r d h p
US Naval Academy < ! ) Lab 6 Triggers and Introduction to PHP Title 8 @ _PID_HLINKS A l R h t t p : / / l o c a l h o s t / t e s t . p h p V 0* pH d ProjectQ ( @=
l @E J<
rstdole>s t d o l e (
h %^ *\ G{00020430- C
0046}#2 .0#0#C:\ WINDOWS\ System32\e2.tlb# OLE Automation ` ENormalENCr m aF( *\C
MB !OfficgO f i cg
!G{2D F8D04C-5 BFA-101B -BDE5gAA5e42ggr am Files\Common Microsof t Shared\@10\MSO`.DLL#
10.0 Ob Library% xMSFAs> M SD FBs 3@ dD452EE@1-E08F0A-8 -0260 8C4D0BB4dsdFM20L'B p&/ ; "~1 D|~ C00}#@8@# ў50 A 1388D86A -BFC8-4B 06-AE87- 32782083578C6DOC UME~1\ADMINI LOCALS Temp\Word8.c8.exdd=" .E
.`M A This Document(G T i s Dlc ue n 2 ` H 1ByZ z,[TC""+ - [C x ( DefaultOcxName4, 9, 0, MSForms, HTMLText+ DefaultOcxName3111, 3, 2, MSForms, HTT h i s D o c u m e n t 3 5 _ V B A _ P R O J E C T P R O J E C T 2 7 P R O J E C T l k 8 N MLText- DefaultOcxName5111, 2, 3, MSForms, HTMLSubmit) DefaultOcxName11, 8, 6, MSForms, HTMLText) DefaultOcxName21, 7, 7, MSForms, HTMLText ME P S" S S" s s < < < ( 1 N o r m a l . T h i s D o c u m e n t ( % % *h 0 % * ` % * ( X *! ( *# % *%X % *'P x 8 X
* \ R 8 0 0 5 * # 8 2 * \ R 8 0 0 5 * # 7 d x Attribut e VB_Nam e = "Thi sDocument"
Bas1Normal.VGlobal!SpaclFalse Creatabl Pre decla Id Tru
BExpose Temp lateDeriv$Custom izC1ControlDefa@ultOcxm4 , 9, 0, MSFs, HTMLTex! 3111, 3, 2"5" ! $E`SubmiF"8(, 6"237, QE ay * \ G { 0 0 0 2 0 4 E F - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 4 . 0 # 9 # C : \ P R O G R A ~ 1 \ C O M M O N ~ 1 \ M I C R O S ~ 1 \ V B A \ V B A 6 \ V B E 6 . D L L # V i s u a l B a s i c F o r A p p l i c a t i o n s * \ G { 0 0 0 2 0 9 0 5 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 8 . 3 # 0 # D : \ P r o g r a m F i l e s \ M i c r o s o f t O f f i c e \ O F F I C E 1 1 \ M S W O R D . O L B # M i c r o s o f t W o r d 1 1 . 0 O b j e c t L i b r a r y * \ G { 0 0 0 2 0 4 3 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 2 . 0 # 0 # C : \ W I N D O W S \ S y s t e m 3 2 \ s t d o l e 2 . t l b # O L E A u t o m a t i o n * \ C N o r m a l * \ C N o r m a l MB (* \ G { 2 D F 8 D 0 4 C - 5 B F A - 1 0 1 B - B D E 5 - 0 0 A A 0 0 4 4 D E 5 2 } # 2 . 3 # 0 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ O f f i c e 1 0 \ M S O . D L L # M i c r o s o f t O f f i c e 1 0 . 0 O b j e c t L i b r a r y * \ G { 0 D 4 5 2 E E 1 - E 0 8 F - 1 0 1 A - 8 5 2 E - 0 2 6 0 8 C 4 D 0 B B 4 } # 2 . 0 # 0 # C : \ W I N D O W S \ s y s t e m 3 2 \ F M 2 0 . D L L # M i c r o s o f t F o r m s 2 . 0 O b j e c t L i b r a r y * \ G { 1 3 8 8 D 8 6 A - B F C 8 - 4 B 0 6 - A E 8 7 - 3 2 7 8 2 0 8 3 5 7 8 C } # 2 . 0 # 0 # C : \ D O C U M E ~ 1 \ A D M I N I ~ 1 \ L O C A L S ~ 1 \ T e m p \ W o r d 8 . 0 \ M S F o r m s . e x d # M i c r o s o f t F o r m s 2 . 0 O b j e c t L i b r a r y .E
.`M
E T h i s D o c u m e n t 0 ; 4 5 8 d 0 5 0 0 T h i s D o c u m e n t [C 㝨)AM$ ` ' Wordk VBA Win16~ Win32 Mac VBA6# Project- stdole` Normal Officeu MSFormsC ThisDocument< _Evaluate DefaultOcxName4& DefaultOcxName3111N DefaultOcxName5111H DefaultOcxName311# DefaultOcxName511՜ DefaultOcxName11 . DefaultOcxName211. Documentj ` ID="{67B80D73-B285-4D57-857B-B23493AB0CB2}"
Document=ThisDocument/&H00000000
Name="Project"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="5F5D9275AE8B098F098F098F098F"
DPB="BEBC73D68D6AED6BED6BED"
GC="1D1FD0B37013711371EC"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
&H00000002={000209F2-0000-0000-C000-000000000046};Word8.0;&H00000000
[Workspace]
ThisDocument=0, 0, 0, 0, C
U\g U\g "U\g ThisDocument T h i s D o c u m e n t P R O J E C T w m ) C o m p O b j 1 q @ @ @ N o r m a l CJ _HaJ mH sH tH d @ d 2$b H e a d i n g 1 d d @& [$\$ # 5B* CJ KH$ OJ QJ \aJ ph f \ @ \ z; H e a d i n g 2 $ < @& 56CJ OJ QJ \]^J aJ V @ V @+ H e a d i n g 3 $ < @& 5CJ OJ QJ \^J aJ D A@ D D e f a u l t P a r a g r a p h F o n t R i@ R T a b l e N o r m a l 4
l 4 a ( k@ ( N o L i s t 4 U@ 4 9 H y p e r l i n k >*ph3f L ^@ L 9 N o r m a l ( W e b ) d d [$\$ B*ph F b@ F 2$b H T M L C o d e CJ OJ PJ QJ ^J aJ o( e@ " 2$b H T M L P r e f o r m a t t e d 7
2 (
Px 4 #\'*.25@9 B*CJ OJ QJ ^J aJ ph R g@ 1R 2$b H T M L T y p e w r i t e r CJ OJ PJ QJ ^J aJ o( ( O A( 2$b h t m l 1 ph 8 h@ Q8 2$b
H T M L V a r i a b l e 6]. O a. 2$b d e f a u l t 2 ph . O q. 2$b k e y w o r d 2 ph w , O , 2$b s t r i n g 2 ph ( O ( 2$b e m p h a s i s 4 @ 4 >m H e a d e r
! 4 @ 4 >m F o o t e r
! F V@ F ]O F o l l o w e d H y p e r l i n k >*B* ph f \@ f =!
z - T o p o f F o r m $&d P a$ <CJ OJ QJ ^J aJ l ]@ l =! z - B o t t o m o f F o r m $$d N a$ <CJ OJ QJ ^J aJ =$ K L F =$ r ] ^ _ 2 3 i I L c 7 \ 4 p q x
y
' ( /
0
1
% P v . / 5 U V 0 1 & - O W ^ - 5 = E F G I J K L M N O P Q R S Y [ 5 7 G H x y r s { - . ^ [ \ z { % & G H V W Y Z [ \ ] ^ _ ` a b c d e f g h n o ! ! ! ! ! ! ! ! ! ! ! ! ! ! !! "! $! %! @! ^! _! `! a! ! ! ! ! ! ! ! ! ! " " " " " " " " N" " " " " " # # # # # .# R# S# T# c# # # # # # # # # # # # # # # # &$ '$ ($ 7$ 8$ 9$ :$ ;$ >$ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0 z
0 z
0 z
0 z
0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @ 0 y 0 0 @ 0 y 0 0 @ 0 y 0 0 @ 0 y 0 0 @ 0 @ 0 @ 0 @ 0 y 0 0 4
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 y 080 E % P v - 5 = E s { [ f g h n o >$ { 0 0 { 0 0 { 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ۊ 0 0
?vۊ 0 0 ۊ 0 0 { 0 0 ۊ 00 @Eۊ 00 ۊ 00 ۊ 00 ۊ 00 ۊ 00 ۊ 00 0 0 @ 0 ۊ 00 ۊ 00 00 @ 0 00 @ 0 ۊ 00 tF{ 0 0 ۊ 0 0
Fۊ 0 0 ۊ 0 0
ۊ 0 0 ۊ 0 0 ۊ 0 0 ۊ 0 0 Fۊ 0 0 ۊ 0 0 { 0 0 0 0 0 0 0 Ŋ| G G G G G J , ~ " ' ) + =, ! # % * , / 5 \ L y c# ' a) ) * S+ + + + + (, =, " $ & ' ( ) + - . 0 1 2 3 4 6 7 8 <, . =$ X= ] _ c " $ 8 X Z o [[[[[[[
%} ; 8 F M @ p L (
B
F
B
K
B
L
B
S ? G W =$ K @ t F M ^ t L t O C X s 1 O C X s 2 >$ >$ ]j ;
]j ]j \
]j
]j
]j
]j
]j
" " >$ " " >$ 8 *urn:schemas-microsoft-com:office:smarttagsCity 9 *urn:schemas-microsoft-com:office:smarttagsState : *urn:schemas-microsoft-com:office:smarttagsStreet ; *urn:schemas-microsoft-com:office:smarttagsaddress TaE 4 9 J O C F L N R b c h @ E
@
E
q
v
{
> C
-
Z
h
|
! ' 1 4 5 A C Q W [ ^ k N e
I U X c e h V Y s z { $ 9 E _ f ] e i u ! ! ! ! ! ! ! ! !! "! $! %! X! ]! `! a! " " >$ = h \ `
}
! / 4 = B i l $ ' + . 4 X \ ^ d ^ b ! ! ! ! ! ! ! ! !! "! $! %! `! a! )" *" f" m" >$ 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 F M V W d g h 4 F c ! ! ! ! ! ! ! ! ! !! "! $! %! 1! 9! =! >! @! P! S! ]! `! a! a! f! h! q! ! ! ! ! ! ! ! ! ! ! " " " " " " " " " " " " " " " " # # .# Q# T# c# # # # # # # # # # # # # %$ 8$ 8$ >$ ! ! ! ! ! ! ! ! !! "! $! %! `! a! >$ y? Ǵ :%KΟ F*t M?t P3B" |&E\1 dxE$ ;[WZXP A`") IiZe j+z?\iܱ":P X4 6I0*\ ~^"2h>\M2- 7 * |s =$: I Hc|s d d [4 h P 4 == d d jB >
4 )&L4 E |v 4 kiP u%4 pK ) [2|v %;6W;} =$: q +;yWy ===$: .> ;^? #E|v !_F4 acO kiP $DS EV LfYjB Y=$: xk _4 gD` 2d k q |vh P yWy | Y d d |> W;}=$: m w 7n! I% kE& X' n!* @+ |. Q/ O0 w
1 (1 +6 C*7 6H7 8 t8
A< ~-= {= ]> @ &D 8D }hD 8E YE MF &F \J }J M O O 2TO ]O +"Q lQ m|Q (X N[ O[ | \ Od\ @] 1^ Ue^ [F_ Ga 2$b e[b 9c md Ue {e g 6g k:g ,!h '(i l"j $/j 7j H4l Dgl Qm jm s ^t hGu !v x Slx bKy { | \} f ^ P, L W& OB jX D p z; D h ij
W J qM 5) db ] ub n ^ D
_? P Y ,J R
Y = PU N u d )9 k= n $ 7 b =! r zE # L + | ?b q E" Gu y W< oy 9 Z ;a ? ? O N 4 X ,k U * 5l % * 8 X | dv v _ SD
U} n# p A r s { a! ! ! ! ! ! ! ! ! # # # # .# R# S# T# c# # # # # # # # # # # # # # # # &$ '$ ($ >$ 3 Y0 @ x
=$ @ U n k n o w n G z T i m e s N e w R o m a n 5 S y m b o l 3& : A r i a l ; W i n g d i n g s 7& V e r d a n a O1 C o u r i e r C o u r i e r N e w ?5 z C o u r i e r N e w " 1 h ̩F&> Z ) < ) < ! * 4 d ! ! w[ 2Q XR
? hGu 2 ( L a b 6 T r i g g e r s a n d I n t r o d u c t i o n t o P H P m c k e n n a a d i n a 8
F Microsoft Office Word Document
MSWordDoc Word.Document.8 9q