×
There is no substitute for HARD WORK.
--Your friends at LectureNotes
Close

Note for Introduction To PHP - IP By Digbijay Patil

  • Introduction To PHP - IP
  • Note
  • 8 Topics
  • 1593 Views
  • 53 Offline Downloads
  • Uploaded 3 months ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

Introduction to PHP5 with MySQL Svein Nordbotten Svein Nordbotten & Associates Bergen 2009 1

Text from page-2

Preface This publication is an extract of text and illustrations from an online course offered at several institutions in 2006-2008. The course curriculum was David Sklar: Learning PHP 5 O'Reilly. (2004) This publication is referred to as Sklar in the course. It is based on a set off applications which all are fully developed and explained. Bergen 2009, Svein Nordbotten 2

Text from page-3

Contents Preface .......................................................................................................................................................... 2 Session 1: Static web applications ............................................................................................................ 6 Basics ..................................................................................................................................................... 6 Web applications .................................................................................................................................. 6 HTML - Hypertext Markup Language .................................................................................................... 7 HTML Format ........................................................................................................................................ 8 Texts ...................................................................................................................................................... 8 Links ...................................................................................................................................................... 9 Images ................................................................................................................................................. 10 Lists ..................................................................................................................................................... 11 Tables .................................................................................................................................................. 12 Forms .................................................................................................................................................. 12 Frames................................................................................................................................................. 14 CSS, JavaScript and XML...................................................................................................................... 15 Session 2: Dynamic applications by PHP ................................................................................................. 16 Dynamic web sites .............................................................................................................................. 16 CGI and PERL ....................................................................................................................................... 17 Applications Program Interfaces ......................................................................................................... 18 PHP Language...................................................................................................................................... 18 Approach in this course ...................................................................................................................... 19 Simple example ................................................................................................................................... 19 Guessing example ............................................................................................................................... 21 Session 3: Dynamic application without database ................................................................................. 24 Market research .................................................................................................................................. 24 System design ..................................................................................................................................... 24 Market research .................................................................................................................................. 25 Market analysis ................................................................................................................................... 30 Session 4: Introducing the MySQL database........................................................................................... 33 3

Text from page-4

Dynamic applications and databases .................................................................................................. 33 Creation of a reference database to you personal library. ................................................................. 33 Menu page .......................................................................................................................................... 34 Listing the content of the database .................................................................................................... 37 Searching the database for a book reference. .................................................................................... 39 Deleting rows in the database ............................................................................................................ 44 Removing database............................................................................................................................. 45 Session 5: Polling with MySQL database................................................................................................. 47 Opinion polls ....................................................................................................................................... 47 Application design............................................................................................................................... 47 Database ............................................................................................................................................. 48 Application menu ................................................................................................................................ 48 Creating records and a list of panel members .................................................................................... 49 Processing, statistics and rotation ...................................................................................................... 53 Session 6: File processing ........................................................................................................................ 58 Maintaining files.................................................................................................................................. 58 Fetching files ....................................................................................................................................... 59 Uploading files .................................................................................................................................... 62 Session 7: Functions in PHP .................................................................................................................... 65 Functions ............................................................................................................................................. 65 Authorization and authentication....................................................................................................... 66 Authorization ...................................................................................................................................... 70 PIN code assignment........................................................................................................................... 70 Authentication .................................................................................................................................... 71 Function library ................................................................................................................................... 72 Logging ................................................................................................................................................ 72 Logging function.................................................................................................................................. 73 Example environment ......................................................................................................................... 73 Parsing................................................................................................................................................. 75 Session 8: Information retrieval.............................................................................................................. 79 General model..................................................................................................................................... 79 Index module ...................................................................................................................................... 80 4

Lecture Notes