PHP & MySQL

Dynamic Web Training Pty Ltd.
Adelaide, Brisbane, Canberra, Melbourne, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' The combination of PHP and the MySQL database now provides the most widely used solution for creating dynamic websites. Together with the Apache web server, these free software applications provide the foundation for many standard web hosting plans. During the course you will learn how to hand-code a dynamic website, using a development environment on your local computer that matches the server environment where your site will eventually be hosted.

Who should do this course?
Anyone looking to hand-code a database-driven website using PHP and MySQL. Students should have already completed Dreamweaver 8: Website Development course or have the equivalent experience and understanding of HTML and CSS.

About the course:
During the 4 days, this course will step you through how to build an entire dynamic website, ensuring that you will have the necessary experience, skills and confidence to build your own dynamic website later on. You will learn how to

* install and configure the Apache, PHP, and MySQL software,
* write commands in Structured Query Language (SQL), the language used to query and modify the MySQL database,
* gather and process information from forms,
* handle file uploads,
* create an online gallery, and
* password-protect your pages.


Content:

Unit 1: Introducing the Course

* Getting familiar with the course methodology and format
* Understanding the course objectives and prerequisites
* Why PHP and MySQL?

Unit 2: Installing the Software

* Installing Notepad++ (text editor) and WinMerge (file comparison utility)
* Installing Apache
* Installing PHP
* Configuring Apache to work with PHP and testing PHP
* Checking your PHP settings

Unit 3: Writing PHP Scripts

* Using variables
* Commenting scripts
* Using arrays to store multiple values
* Using quotes correctly
* Loops and functions
* Displaying PHP output

Unit 4: Using Includes to Streamline Your Workload

* Including content from other files
* Identifying the current page with PHP
* Creating pages with variable content
* Dealing with missing include files
* Displaying a random image
* Using includes securely

Unit 5: Bringing Forms to Life

* Gathering information from a form with PHP
* Sending email from a form
* Validating user input
* Handling multiple choice form elements
* Redirecting to another page

Unit 6: Uploading Files

* Checking that your server supports uploads
* Creating an upload directory
* Checking filenames
* Refusing large files
* Restricting file types
* Preventing files from being overwritten

Unit 7: Managing Files with PHP

* Checking that PHP has the necessary permissions
* Reading files in a single operation
* Read/write operations
* Replacing content in a file
* Appending content to a file
* Exploring the file system

Unit 8: Generating Thumbnail Images

* PHP’s image manipulation functions
* Generating a scaled down version of an image
* Resizing an image automatically on upload
* Giving each thumbnail a unique name

Unit 9 : Simple Login and Multipage Forms

* Session management with PHP
* Creating and destroying session variables
* Using sessions to restrict authentication
* Setting a session time limit
* Passing information through multipage forms

Unit 10: Setting up MySQL and phpMyAdmin

* Installing and configuring MySQL
* Installing and configuring phpMyAdmin
* Launching phpMyAdmin
* Installing the MySQL GUI Tools

Unit 11: Getting Started with the MySQL Database

* Introduction to database management
* Setting up the MySQL database
* Creating MySQL user accounts
* Connecting to MySQL with PHP
* Finding the number of records in a database query
* Displaying the results of a query

Unit 12: Creating a Dynamic Online Gallery

* Planning the image gallery
* Passing information with a query string
* Displaying database results in a multicolumn table
* Selecting subsets of records
* Navigating through long record sets

Unit 13: Managing Content

* Safeguarding your data from SQL injection attacks
* Writing SQL queries
* Setting up a content management system
* Creating the necessary database table
* Inserting, updating, and deleting records

Unit 14: Solutions to Common PHP/MySQL Problems

* Extracting characters, words, paragraphs, and sentences from text
* Manipulating dates
* Working with multiple database tables
* Finding records with no matching foreign key
* Using lookup tables to resolve many-to-many relationships
* Deleting records with dependent foreign keys

Unit 15: Securing Your Website from Intruders

* Encrypting methods
* Using one-way and two-way encryption
* Registering new users
* Updating user details


...''

Phone:1300 888 724, +61 2 9957 1366

School Address:

Level 11
32 Walker Street
North Sydney NSW 2060

Level 12
379 Collins Street
Melbourne VIC 3000

C/- Support Technology
Level 6, 371 Queen St
Brisbane QLD 4000

C/- Training Choice
Level 12, 15 London Circuit
Canberra ACT 2600

C/- Hire Intelligence
Level 4, 74 Pirie Street
Adelaide SA 5000

Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Travel Agencies: Brisbane, Melbourne, Sydney

Search other schools for PHP & MySQL training resources.

ColdFusion MX 7
Advanced ColdFusion MX 7 Development
Fireworks CS3: Web Graphic Creation
Authorware 7
Advanced Authorware Development
Captivate 3.0
Adobe RoboHelp 7
Freehand
Contribute 3
HTML
Advanced PHP Web Development
Advanced Website Design Using CSS
CSS Masterclass
Acrobat 8
Photoshop CS3
Illustrator CS3
InDesign CS3
Excel 2007 Level 1
Excel 2007 Level 2

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.