ALL THE DOCUMENTS ARE PROVIDED,

ONLY THING THERE IS ' jquery.sparkline.2.1.2.js ' needs to be downloaded:

HERE IS THE CSS CODE:

header h1.mdl-layout-title {

font-size: 32px;

color: white;

}

header h1 span {

color: #ff6e40;

}

.profile {

background-color: #263238;

display: flex;

align-items: center;

justify-content: center;

flex-wrap: wrap;

padding: 10px;

}

.profile span {

font-size: 90%;

}

.avatar {

width: 96px;

height: 96px;

border-radius: 50%;

display: block;

}

.page-content {

margin: 10px;

}

main header {

margin: 0;

min-height: 40px;

padding-left: 10px;

padding-top: 5px;

}

main header h4 {

margin: 0;

font-size: 18px;

}

.card-lesson {

min-width: 200px;

min-height: 100px;

}

.card-lesson > .mdl-card__actions {

display: flex;

box-sizing: border-box;

align-items: center;

}

.card-lesson > .mdl-card__title {

align-items: flex-start;

}

.card-lesson > .mdl-card__title > h4 {

margin-top: 0;

}

.card-lesson > .mdl-card__title, .card-lesson > .mdl-card__supporting-text, .card-lesson > .mdl-card__actions, .card-lesson > .mdl-card__actions > .mdl-button {

_color: #fff;

}

.inlinesparkline {width: 70%;}

HERE IS THE 'includes' FOLDER --> header.inc.php:

CRM Admin

account_box

Messages

notifications

Notifications

for="fixed-header-drawer-exp">

search

id="fixed-header-drawer-exp">

HERE IS THE 'includes' FOLDER --> left-nav.inc.php:

John Locke

johnlocke@example.com

dashboard Dashboard

message Messages

event Tasks

call Orders

settings Configure

view_list Catalog

contacts Customers

insert_chart Analytics

HERE IS THE 'employees.xml ':

1

Adams

Andrew

1962-02-18T00:00:00-07:00

2002-08-14T00:00:00-06:00

11120 Jasper Ave NW

Edmonton

AB

Canada

T5K 2N1

+1 (780) 428-9482

+1 (780) 428-3457

andrew@chinookcorp.com

2

Edwards

Nancy

1

1958-12-08T00:00:00-07:00

2002-05-01T00:00:00-06:00

825 8 Ave SW

Calgary

AB

Canada

T2P 2T3

+1 (403) 262-3443

+1 (403) 262-3322

nancy@chinookcorp.com

3

Peacock

Jane

2

1973-08-29T00:00:00-06:00

2002-04-01T00:00:00-07:00

1111 6 Ave SW

Calgary

AB

Canada

T2P 5M5

+1 (403) 262-3443

+1 (403) 262-6712

jane@chinookcorp.com

4

Park

Margaret

2

1947-09-19T00:00:00-06:00

2003-05-03T00:00:00-06:00

683 10 Street SW

Calgary

AB

Canada

T2P 5G3

+1 (403) 263-4423

+1 (403) 263-4289

margaret@chinookcorp.com

5

Johnson

Steve

2

1965-03-03T00:00:00-07:00

2003-10-17T00:00:00-06:00

7727B 41 Ave

Calgary

AB

Canada

T3B 1Y7

1 (780) 836-9987

1 (780) 836-9543

steve@chinookcorp.com

6

Mitchell

Michael

1

1973-07-01T00:00:00-06:00

2003-10-17T00:00:00-06:00

5827 Bowness Road NW

Calgary

AB

Canada

T3B 0C5

+1 (403) 246-9887

+1 (403) 246-9899

michael@chinookcorp.com

7

King

Robert

6

1970-05-29T00:00:00-06:00

2004-01-02T00:00:00-07:00

590 Columbia Boulevard West

Lethbridge

AB

Canada

T1K 5N8

+1 (403) 456-9986

+1 (403) 456-8485

robert@chinookcorp.com

8

Callahan

Laura

6

1968-01-09T00:00:00-07:00

2004-03-04T00:00:00-07:00

923 7 ST NW

Lethbridge

AB

Canada

T1H 1Y8

+1 (403) 467-3351

+1 (403) 467-8772

laura@chinookcorp.com

HERE IS THE filter-employees.php:

?>

Filter

---

Some example expressions: /Employees/Employee[City='Calgary'] /Employees/Employee[EmployeeId=3]

Employees

Id	First Name	Last Name	Title	Address	City	Phone

Exercise 6XML and PHP CRM Admin Demonstrate your ability to read in and display an XML file in PHP along with the ability to filter that XML data using XPath expressions. Instructions: (Download the required files: exerciseb.zip to complete this exercise) You have been provided with an XML file named employees.xml. Examine this file Alter filter-employees.php so that it reads in employees.xml using whichever method you wish (you will find that SimpleXML is the easiest) and displays some of its information in a table as shown in Figure 6.1 Add a simple form that allows the user to enter in an XPath expression that filters the XML data using XPath as shown in Figure 6.1 1. 2. 3. D 1 Admin John Locke Filter Enter xpath Cutonen Read in data from employees.xml file and display it within a table Exercise 6XML and PHP CRM Admin Demonstrate your ability to read in and display an XML file in PHP along with the ability to filter that XML data using XPath expressions. Instructions: (Download the required files: exerciseb.zip to complete this exercise) You have been provided with an XML file named employees.xml. Examine this file Alter filter-employees.php so that it reads in employees.xml using whichever method you wish (you will find that SimpleXML is the easiest) and displays some of its information in a table as shown in Figure 6.1 Add a simple form that allows the user to enter in an XPath expression that filters the XML data using XPath as shown in Figure 6.1 1. 2. 3. D 1 Admin John Locke Filter Enter xpath Cutonen Read in data from employees.xml file and display it within a table