Dynamic Pages PowerPoint Presentation

Dynamic Pages PowerPoint Presentation

2016-02-23 63K 63 0 0

Description

– . Quiz . #10. Lecture Code:. . 953622. http://decal.aw-industries.com. Web Design:. Basic to Advanced Techniques. Web Design:. Basic to Advanced Techniques. Today’s Agenda. Quiz & Attendance. ID: 228507

Embed code:

Download this presentation



DownloadNote - The PPT/PDF document "Dynamic Pages" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.

Presentations text content in Dynamic Pages

Slide1

Dynamic Pages – Quiz #10Lecture Code: 953622

http://decal.aw-industries.com

Web Design:

Basic to Advanced Techniques

Slide2

Web Design:Basic to Advanced Techniques

Today’s Agenda

Quiz & Attendance

Announcements

Dynamic Pages –

Part

2

Questions about Final

Project

Finish Quiz &

Attendance

Discussion

Slide3

Announcements

Final Project – Layout due tonightPhotoshop of main page and navigationFinal Project – Due 5/5Discussion After Lecture

Web Design:

Basic to Advanced Techniques

Slide4

Cool Final Project Topics!

Blob in a BoxCal for DummiesPortfolio sitesJournalsVideo Product CompaniesRecipies

Favorite quote: “(

e.g., no unicorns

)”

Slide5

Web Design:

Basic to Advanced Techniques

Spring 2010Tuesdays 7-8pm200 Sutardja-Dai Hall

Dynamic Pages – Part 2

Web Design:

Basic to Advanced Techniques

Slide6

What is MySQL?

Client Side

Web BrowserHTTP Request (visit website)Interpret and render received files

Server Side

Web ServerServe WebsiteSend HTML and CSS filesSend images

Execute JavaScript

Send JavaScript code

PHP and MySQL

Runs in your browser– on the client side

Web Design:

Basic to Advanced Techniques

Slide7

What is

MySQL?

MySQL

is a brand of database software

Relational database management system

Named after original developer’s daughter: My

Closely used with PHP, and partial reason for success

Used by Google,

Wikipedia

,

Facebook

,

YouTube

Slide8

Other Systems

MySQLPostgreSQLSQLiteMicrosoft SQL Server

Notice “SQL”more later…

Slide9

Where do Databases Fit In?

Slide10

Where do Databases Fit In?

Web Design:

Basic to Advanced Techniques

Client

Server

.

Slide11

Use Cases

Directory ServicesUser authenticationBankingReservationsBrowser cacheMany, many things!

Almost all web applications use some sort of database technology

What about our Cal student information?

Our grades?

Slide12

SQL

Structured Query Language

Databases are not just a repository of information

Can ask the database questions about the data

How many students are enrolled in the

DeCal

?

What is their average attendance rate?

How many have turned in all assignments?

Which student is doing the best in the course?

Does a user with this password exist?

Need to maintain the data

Create, Read, Update, Delete

Slide13

CRUD

Create

"INSERT INTO

`products`

(

`name`

,

`price`

) VALUES

(‘

T

onka truck’, ‘13.00’)"

Read

"SELECT `index`, `name` FROM `products`"

Update

“UPDATE `products` SET `price` = 20.00 WHERE `name` = ‘Tonka truck’”

Delete

“DELETE

FROM

`products`

WHERE

`name` = ‘Tonka truck’”

Slide14

How is Data Stored in a Database?

P_IDNAMEPRICE1Kerbie & BanTownhouse10.002Tonka Truck20.003Brain Yo-Yo13.00

Varchar

Decimal

Integer

Unique “key”

Products

Slide15

How is Data Stored in a Database?

A: In Relational Tables

Each table has a name

Columns have labels

Each column stores a different type of data

An entry in a database appears as a ROW

Each column in the row has a value

All rows have a key – a unique identifier

Typically an integer

Slide16

Data Types

Integer

Double

Float

Varchar

Longtext

Boolean

Slide17

Relationships

Let’s model…relationships: Girlfriend and Boyfriend

G_IDNAME1Jessica2Porschea3Jane

B_IDNAMEG_ID1Bob32Kensington23Billy1

Girlfriends

Boyfriends

Slide18

Boyfriend(s)

Porschea seduces Billy…

G_IDNAME1Jessica2Porschea3Jane

B_IDNAMEG_ID1Bob32Kensington23Billy1

2

Girlfriends

Boyfriends

Slide19

Girlfriend(s)

Bob picks up the slack…

G_IDNAME1Jessica2Porschea3Jane

B_IDNAMEG_ID1Bob?2Kensington23Billy2

Girlfriends

Boyfriends

Slide20

Better Relationship

G_IDNAME1Jessica2Porschea3Jane

B_IDNAME1Bob2Kensington3Billy

Girlfriends

Boyfriends

G_IDB_ID22233111

Relationships

Porschea and Kensington

Porschea and Billy

Jane and Bob

Jessica and Bob

Modeling

Slide21

Relationship Types

“One to Many”“Many to Many”

Girlfriends

Boyfriends

Girlfriends

Boyfriends

Relationships

Slide22

phpMyAdmin

Slide23

CRUD

Create

INSERT

INTO

[table] ([field]) VALUES ([value])

Read

SELECT [fields]

FROM

[table] WHERE [condition]

Update

UPDATE [table] SET [field] = [value] WHERE

[condition]

Delete

DELETE

FROM

[table] WHERE [condition]

Slide24

SQL Examples

S_IDNameGrade555567JonathanA555568AmberC555572AlexF555573TimA555574MikeB

Students

How do we find the name of all students with an A?How do we delete Alex’s row?How do we edit Amber’s grade from an F to an A?How do we add Alex with an A?

SELECT Name FROM Students WHERE Grade = A

DELETE FROM Students WHERE S_ID = 555572

UPDATE Students SET Grade = A WHERE S_ID = 555568

INSERT INTO Students (Name, Grade) VALUES (‘Alex’, ‘A’)

Has someone modified the table before us?

Slide25

PHP and MySQL

Print titles from all the entries in our

blogs

table

Slide26

PHP and MySQL

Get contents of a blog with a requested title

View.php?title=Octopi and Unicorns

Slide27

PHP and MySQL

Insert new entry into blogs table

Slide28

PHP and MySQL

Slide29

Dynamic Pages– Quiz #10Lecture Code: 953622

http://decal.aw-industries.com

Web Design:

Basic to Advanced Techniques


About DocSlides
DocSlides allows users to easily upload and share presentations, PDF documents, and images.Share your documents with the world , watch,share and upload any time you want. How can you benefit from using DocSlides? DocSlides consists documents from individuals and organizations on topics ranging from technology and business to travel, health, and education. Find and search for what interests you, and learn from people and more. You can also download DocSlides to read or reference later.