DIG 3134 - Lecture 1: Rules and Organization And Diagnostic Quiz Michael Moshell University of Central Florida

1. Media Software Design DIG 3134 - Lecture 1: Rules and Organization And Diagnostic Quiz Michael Moshell University of Central Florida

2. The Objectives: • To be employable … • or – to become an employer/entrepreneur

3. The Objectives: • To be employable … • or – to become an employer/entrepreneur • Digital Media objectives: • Students need specific technical skills! • Students need to know Programming! • Students need to know teamwork • Students must be problem-solvers.

4. The Prerequisites: • HTML and CSS (DIG2500 ) • Javascript and Programming (DIG 3480c) • You need courage and time • This will be an Intensecourse

5. What’s the course? • Programming in PHP + mySQL • “But ... I’m not a programmer!” • Right. That’s why you are here. • When we are done, you WILL be • a programmer.

6. So ... who ARE you? • A Digital Media professional is skilled • in TECHNOLOGY, equipped with • CREATIVITY and experienced in • PROBLEM SOLVING: • * Analyzing Problems • * Designing and Building Solutions

7. The Goals: • Problem-solving and debugging • PHP language • mySQL database design and language • Improve your HTML skills • Understand and use XML

8. Consequences? • You stand out from the crowd. • The other people took the easy way. • The higher, the fewer!

9. And the REAL payoff? • Learn how to systematically • attack and solve complex problems • (Even if you never program again...) 9

10. What you’ll learn • Server-side scripting – PHP • Form processing • Cookies + Validation + Regular Expressions • Sessions + Authentication • File processing • Image libraries + APIs • Relational databases / MySQL • SimpleXML • Objects + Classes • Security

11. Expectations and Performance • UCF recently was rated by Newsweek as one • Of USA’s universities with lowest expectations. • NOT ANY MORE. • If you don’t work hard in this course,

12. Expectations and Performance • UCF recently was rated by Newsweek as one • Of USA’s universities with lowest expectations. • NOT ANY MORE. • If you don’t work hard in this course, • my responsibility is to flunk you. • Those who survive will have a valuable degree.

13. The Fun Part: • Working on competitive game projects • Learning how to solve puzzles • (Why doesn't this work?)

14. Attendance: • Lecture Class attendance is mandatory – Counts for 5% of course grade (that's half a letter grade!)

15. Programming Assignments • This course doesn't have labs, alas • You will work on your own computer at home • I will provide assistance in office hours • TR 12:30 to 1:15 PM • * W 12:30 to 2:15 PM* (unless nobody comes!) • ++ Appointments are available. • Ask in class, or • Call me at 407 694 6763

16. Projects: Done on your own computer OR lab computer Posted to sulley.dm.ucf.edu for testing Standardized URL: sulley.dm.ucf.edu/~jsmith/DIG3134/projects.html (I will provide your accounts ASAP.) BEFORE or ON the due date! Late work is not accepted in this course.

17. Computing Environment: • Dreamweaver MX 2004 or better edits PHP very nicely (Or: Free: Notepad++, Codelobster...) WAMP: Windows-Apache, MySQL, PHP MAMP: Macintosh-Apache, MySQL, PHP We demonstrate today, help you install. www.wampserver.com www.mamp.info

18. Review the course Website at www.cs.ucf.edu/~jmmoshell/DIG3134 Review the Syllabus and Schedule

19. Website Review: WSR DIG4104c (Web Design Workshop) - Mobile Website Design – You will on 3 occasions, critique their designs (and learn something)

20. And now, for the Show:

21. Two Tier Web Architecture: Request: HTTP Client: e. g. FireFox On your PC Web Server: e. g. Apache On sulley.dm.ucf.edu

22. Two Tier Web Architecture: Request: HTTP .html Files Client: e. g. FireFox On your PC Web Server: e. g. Apache On sulley.dm.ucf.edu

23. Two Tier Web Architecture:HTML .html files Request: HTTP Client: e. g. FireFox On your PC Web Server: e. g. Apache On sulley.dm.ucf.edu Response: HTTP/HTML (or other doctypes:PDF,etc) (client doesn’t see PHP)

24. Two Tier Web Architecture:PHP Request: HTTP Client: e. g. FireFox On your PC Web Server: e. g. Apache On sulley.dm.ucf.edu Response: HTTP/HTML (or other doctypes:PDF,etc) (client doesn’t see PHP) .php files help Apache CREATE html Tagged data

25. Three Tier Web Architecture:MySQL Request: HTTP Client: e. g. FireFox On your PC Web Server: e. g. Apache On sulley.dm.ucf.edu Response: HTTP/HTML (or other doctypes:PDF,etc) (client doesn’t see PHP) .php files ask MySQL For info; put into HTML form Request:SQL Database Mgt System: MySQL Reply:ASCII .frm, .MYD, .MYI files

26. Three Tier Web Architecture:MySQL Request: HTTP Client: e. g. FireFox On your PC Web Server: e. g. Apache On sulley.dm.ucf.edu Response: HTML (client doesn’t see PHP) .php files ask MySQL For info; put into HTML form Examples (what they call for:) Customer: - Shopping Cart DB Administrator: - PHPmyAdmin Managers,etc: - Specialized PHP code Request:SQL Database Mgt System: MySQL Reply:ASCII .frm, .MYD, .MYI files

27. PHP:A Recursive Definition • PHP stands for: • PHP Hypertext Processor • But … aren’t circular definitions illegal? • Sure they are. But who will punish us, in this case? • It is processed by the ZEND engine, which is normally built into Apache the web server.

28. MySQL: • An open source database management system. • SQL: Structured Query Language. • Relational databases, an IBM invention • SQL, also from IBM • Basic concept: The TABLE.

29. Writing code in this class • I recommend using WAMP (if you’re a Windows user.). • A French project: includes Apache, MySQL and PH • www .wampserver.com - in French and English • If you’re a Mac user, the equivalent package is MAMP • www.mamp.info << Guided tour of MAMP on my laptop >> << Guided tour of Dreamweaver: WYSIWYG and Syntax-Directed Editor Models

30. The Great Game Shootout On Thursday you will be divided into teams of four: Black 1 Black 2 … Black 9 Gold 10 Gold 11 … Gold 19 These teams will COMPETE by playing the games developed by other teams. 30

31. The Great Game Shootout On the following Thursday, I will announce something like this: GOLD 3 will host the competition. BLACK 17 will compete against GOLD 7. The GOLD 3 group will come to the podium and run their Software. (Which one? Your team picks the best candidate.) 31 31

32. The Great Game Shootout • Why would I spend time having you PLAYING these games? • It may encourage you to study the game (problem-solving) • It may encourage you to study the software (looking for • weak points) • 3. It might suggest that you use your OWN version of the game to practice your skills, before the shoot-out. • ROUND ZERO on Thursday next: • I'll provide the software • You get to see how it all works 32 32 32

33. Writing code in this class • I recommend local development and online deployment. • Local development: run your own Apache and MySQL. • Advantages: • Server may be inaccessible • You may not want public to stumble on your work • You can fix code that is already deployed, then upload it. • Online deployment: • Your computer should not be serving to the Internet • Too many ways for evil people to take it over. • Too much responsibility to keep it alive 24/7 • SO: Deploy on a commercial server, or (in this class) on • sulley.dm.ucf.edu

34. Write your own code! • Four people, one program? • ALL FOUR are required to develop versions of the program. • * You may help each other – but NOT write code together • * Select “best of four” to show, if your team is called upon • If it fails, you should designate a backup program to use. • ** NOTE: I will grade INDIVIDUAL PROGRAMS and I will • be specifically looking for DUPLICATED CODE. • That’s a No-No. 34 34 34

35. Remediation • YOUR RESPONSIBILITY: • If you don’t understand something, COME SEE ME • Do not “hope you’ll get it” and fall behind. • I will NOT give remedial lectures. If you all flunk, too bad. • However, I WILL spend however much time it takes, • working one-on-one, •  Pro-actively  35 35 35

36. FOR THURSDAY, WHAT? If you bomb this quiz, go drop the course. If you do sorta-OK on the quiz, then go to your DIG3480c notes and figure out what you SHOULD have done. If you are fine with the quiz, If MAC, find and install MAMP Else If Wintel, find and install WAMP Else you're Linux, and cool already. 36 36 36 36

37. MAMP, WAMP - wazzat? MAMP: Macintosh Apache, MySQL, PHP www.mamp.info WAMP: you get the picture. www.wampserver.com It's a local hosting system so that you can develop and test PHP even when you don't have a live connection to Sulley. Alternative: Upload every file to Sulley. TEDIOUS. That’s only for show-and-tell. 37 37 37 37 37

38. And now the Diagnostic Quiz You are free to use any knowledge you gained today ... Open book and notes … But I realize that it may not have baked into your brains yet ... simpsonstrivia.com 38

39. And now the Cheat Sheet This is a self-grading quiz. You probably know already if you had answers to the questions. I will give you an answer sheet to check your work. Good idea: Check your own answers. BETTER idea: Swap papers with your neighbor and check THEIR answers. You might learn something. You may leave when done. See you Thursday! 39