| Intellisoft Home | | | About Us | | | Contact Us | |||||
![]() |
||
Home Trainings & Seminars Project Management Managing IT Outsourcing Email Marketing PHP Programming Introduction to MySQL MS SQL Server BI Data Interpretation & Analysis Article Library Master Trainer Vinai's articles are published in books, magazines & newspapers
7 Ways to Succeed as a Project Manager
appeared in the Recruit Section of The Straits Times
Creating Database Applications Using PHP
Home > Trainings & Seminars > Creating Database Applications Using PHP
Course Duration: 4 Weeks - Part Time Course on PHP in Singapore
Monday & Wednesday evenings, 3 hours each session. Total 24 Hours
Course Contents: Creating Database Applications Using PHP
You Will Learn How To
- Write effective, efficient PHP scripts
- Embed PHP scripts in HTML pages to create dynamic Web pages
- Manipulate data from Web page forms
- Track users as they navigate your site with cookies and other PHP features
- Structure PHP code using user-defined functions and external libraries
- Develop database-enabled Web applications using MySQL ( You can also get an Introduction to MySQL database in a separate training class too)
Course BenefitsPHP is a scripting language used to create dynamic, complex and robust Web pages. It can seamlessly integrate with a wide range of database servers, including Oracle, MySQL and Microsoft SQL Server. In this introductory course, you gain a solid foundation for incorporating PHP techniques. Extensive hands-on exercises provide you with the skills to produce dynamic Web pages, retrieve and manipulate data, track user navigation, and integrate database content.
Who Should Attend
Those creating dynamic, database-driven Web sites. Basic experience with HTML is assumed. Programming or PHP experience is helpful but not required.
Hands-On Training
In this course, you develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web page. Exercises include:
- Accessing command line arguments from PHP scripts
- Generating Web pages dynamically using PHP
- Retrieving and manipulating form data
- Personalizing Web site content using cookies
- Tracking user navigation on your Web site
- Integrating database content to generate dynamic Web pages
- Building modular scripts to enable code reusability
Creating Database Applications Using PHP
Introduction to PHP
- Origins of PHP in the open source community
- Availability across multiple platforms
- Installing as a module for Apache Web Server and Microsoft Internet Information Server
- Running as a CGI engine for other Web servers
PHP language building blocks
- Comparing PHP with other Web scripting languages
- Investigating PHP data types
- Integers
- Floating point values
- Strings
- Booleans
Writing PHP scripts
- Storing values in scalar variables
- Employing ordinary and associative arrays
- Writing conditional expressions
- Implementing loops such as while, for and foreach
- Building complete scripts incorporating loops and conditional expressions
Writing Web Pages with PHP
Interacting with the server
- Outlining Web protocols
- Embedding PHP code into HTML pages
- Employing shortcuts to display single PHP values
- Determining how data is sent from forms to PHP scripts
- Creating dynamically-generated hyperlinks to call PHP scripts
Manipulating user input
- Presenting the user with input options via different HTML form elements
- Retrieving form data with $_POST and $_GET arrays
- Validating retrieved data
- Strategies for handling invalid input
- Storing state information using cookies
Applying Advanced Scripting Techniques
Exploiting the built-in functionality of PHP
- Formatting date and time information
- Manipulating string data
- Reading and writing data using file I/O functions
- Investigating other built-in features
Structuring PHP code
- Writing user-defined functions to structure your code
- Passing arguments and default values to functions
- Returning data from functions
- Accessing global variables
- Building code libraries for reusability
- Incorporating external PHP scripts with require and require_once
Building Complete Web Applications
Managing errors
- Investigating the HTTP header
- Suppressing on-screen error messages on production servers
- Configuring the php.ini file to control error messages
Handling problematic situations
- Troubleshooting problems when manipulating data
- Redirecting the browser to other pages
- Modifying the PHP configuration file to suit your needs
- Developing debugging strategies
Establishing database connectivity
- Creating and managing database connections
- Sending queries to the database server employing the most efficient methods
- Retrieving query results as associative arrays
- Looping through databases
- Displaying returned data on Web pages
- Avoiding potential problems by managing quotes and backslashes in data
- Closing the database connection
Certification:
Certificate of attendance would be given to participants.Materials:
Notes in folders will be provided.Class Size:
8-12 participantsCourse Dates: Monday & Wednesday evenings for 4 weeks.
January 19, 2009. 6:30pm to 9:30pm, Singapore
February 23 to 24 , 2009. 6:30pm to 9:30pm, Singapore
Profile of Intellisoft Systems and Trainer Vinai Prakash
Founded in 2003, Intellisoft Systems has been providing consultancy to businesses, and training at local colleges and private institutions. Vinai Prakash holds an MBA from Australia . Armed with 22 years of solid management experience, he is the CEO of 2 companies in the Intellisoft Systems Group.As the seasoned professional and master trainer at Intellisoft Systems, Vinai helps companies to improve their skills in Project Management, IT Outsourcing, Business Intelligence & Electronic Marketing. He does this through his Group Training and one-to-one consultation programs.
Vinai is an expert at Database programming, Database Design and teaching MySQL. He has been developing database applications since 1986 and is an expert at MySQL database management system.
Call (65) 6296-2995 or (65) 9877-3485 to enquire about the PHP training course, or email to training@intellisoft.com.sg
Subscribe to our
Learning for Life Newsletter
Get Exclusive
Articles & Resources
Not available elsewhere.
Plus Training News for seminars & workshops
sent direct to your mailbox
Our Management articles have been published in Today's Manager, a Singapore Institute of Management publication.
Telephone: (65) 9877 3485 email: info@intellisoft.com.sg © Intellisoft Systems, 2003-2009
| · · · · · · | Intellisoft Home | | | About Us | | | Contact Us | ||||