Internet Application Development with PHP and MySQL
Creating a static website and updating it manually may not be a difficult task for most people after acquiring the basic skills. But when it comes to web pages that contain more advanced features such as message board, discussion forum, product query and member login capabilities, the dynamic part comes into play and you need to grasp further concepts and skills before you can make your website work dynamically and interactively.
A dynamic website can change its content dynamically to meet the user’s needs and provide relevant information, such as text, images and other data, by accessing information in a connected database. Dynamic web pages are controlled by computer programs. Every time the website manager adds an article, graphic, product, or news to the site, it will automatically appear in the places it is supposed to. A dynamic website has a high degree of functionality and is indispensable in enabling e-commerce.
In this course you will learn to develop database-driven dynamic websites using PHP and MySQL, which are popular tools employed in the development of many powerful websites including Facebook and Youtube.
On course completion, participants are able to use Dreamweaver to create dynamic websites that are capable of using forms to access data sources, generating emails, incorporating member login, and creating dynamic contents by retrieving required graphic and text data from databases.
Learn how to design and create database-driven dynamic web applications and enhance the functionality of your websites with PHP and MySQL.
-Learn key practical skills through lectures, demonstrations and hands-on exercises
-Acquired the best practice techniques from industry-experienced instructor
By the end of the course you should have a good understanding of PHP and MySQL and be able to create database-driven interactive websites with the skills learned.
-Qualified and experienced instructor
-Easy-to-follow, step-by-step learning approach
-Evening and weekend class options
1. The need for dynamic application – Creating a dynamic web site
Designing a dynamic application
2. Customizing content according to customer needs – Passing data between pages
Retrieving data from URL
Sending data with hyperlinks
Setting and retrieving cookies
3. Collecting customers’ requests – Creating web forms
The essence of web forms
Designing web forms
Validating customers’ input – client-side and server side validating
4. Providing instant feedback to customers – Connecting to the database
Connecting to a database
Retrieving and displaying records from database
5. Keeping customers up-to-date – Enriching web pages with live data
Designing web pages with dynamic images and texts
6. Enabling customers to locate what they want – Developing search functions
Preparing the search page
Defining search criteria.
7. Forming a customer database – Implementing membership scheme
Restricting Access to Pages