Microsoft PowerPoint - PHP-MySQL

Document Sample
Microsoft PowerPoint - PHP-MySQL Powered By Docstoc
					Case Study:         and

      Fast, Easy and Cheap
Alternate Presentation Title
      Why PHP and MySQL?
• Like Peanut Butter & Jelly – made for each
• Free and powerful
• Same programming concepts you know,
  just different terminology
• Craigslist,Yahoo! Finance, Wikipedia
             What is Open Source?
Open source is a development method for software that harnesses the power of
   distributed peer review and transparency of process. The promise of open
   source is better quality, higher reliability, more flexibility, lower cost, and an
   end to predatory vendor lock-in.

The Open Source Initiative (OSI) is a non-profit corporation formed to educate
   about and advocate for the benefits of open source and to build bridges among
   different constituencies in the open-source community.

One of our most important activities is as a standards body, maintaining the
   Open Source Definition for the good of the community. The Open Source
   Initiative Approved License trademark and program creates a nexus of trust
   around which developers, users, corporations and governments can organize
   open-source cooperation.
               What You’ll Need
• Reference Guides
   – HTML – online or book
   – PHP & MySQL – book is recommended
• Software
   –   WAMP – prepackaged Windows Apache MySQL PHP distribution
   –   Editor: NotePad++
   –   FTP: for file transfer to host website
   –   Optional: NaviCat for MySQL for Database Administration
• Hardware
   – Development PC: Windows, Browser and Internet
   – Website host: ISP or System i
             Getting Started
•   Become familiar with HTML
•   Read through the basics of PHP & MySQL
•   Download and install WAMP
•   Download and install NotePad++
•   Write and run your first PHP program
        Designing your Website
• Data
  – First field in every table is ROWID
  – Data capture and update
• Screens
  –   Users like pretty websites – use lots of graphics
  –   Consistent design – CSS for style, headers and footers
  –   Minimize use of gimmicks, they get tiring over time
  –   Design for the user, what is it that they want?
   Programming Your Website
• There ain’t nothing like an interpretive
  language - prototyping
• Write the basic program
• See How it Looks
• Modify
• Enhance
• Structure and comment
                    Go Live
• Web Hosting
    – Web Space, Traffic, Applications, Support,
      Domain Name Registration
•   Upload your database and code
•   Testing
•   Updating
•   Backups – code and data
                Online Resources
• HTML –
• PHP –
• PHP Libraries
•   MySQL –
•   WAMP –
•   BROWSER – View Page Source
•   OpenSource Applications –
•   GOOGLE – whatever you want is out there
              My Resources
• Browser – Firefox Mozilla, also test w/IE
• PHP/MySQL Reference – Beginning PHP and MySQL 5 by
  W. Jason Gilmore
• Website – (small business)
• Notepad++
• Navicat for MySQL
• I haven’t programmed in 25 years and never
  developed an interactive website
• I had to learn everything: PHP, MySQL,
  Web hosting, etc.
• Initial design for data & screens: 1 day
• Initial website coding: 1 week
• Data and image capture: 1 month
• Constant improvements

Shared By: