Creating Web Applications Using PHP & SQL

Learn how to create Dynamic, Online Applications – like Shopping Carts, Customer Databases, Online Stores, Accounting Systems, Membership Systems, all using PHP programming language, and the SQL Relational Database.

PHP is a scripting language used to create dynamic, complex and robust Web pages. It can seamlessly integrate with a wide range of SQL database servers, including OracleMySQL and Microsoft SQL Server.

In this Introductory course on PHP programming, you gain a solid foundation for incorporating PHP techniques in your online, web based applications, and learn how to interface it with any SQL database.

 SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6296-2995 for Details. SkillsFuture credits ready for Singaporeans.

Practical, Hands-On Exercises & Techniques to Gain a Solid Understanding of:

  1. Creating a User Login & Authentication System
  2. Sending Form Data to the SQL Database
  3. Using Sessions & Cookies in PHP pages
  4. Insert, Update, Delete, Select and Display data from SQL Database into the Web
  5. Search the Database and Display only Matching Results using PHP
  6. Use Pagination to Control Results Per Page
  7. Advanced Features & Structured Code Writing Tips

Course Duration: 3 Full Days – on PHP & SQL

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.

Course Objectives

Learn PHP at Intellisoft
Learn PHP at Intellisoft

You Will Learn How To:

  • Install, Setup and Create a database using SQL Commands
  • Insert, Update, Delete Records in SQL database tables
  • Write Queries against the SQL database & Retrieve data using specific criteria
  • 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

Target Audience

Participants who are interested in creating dynamic, database-driven Web sites.

 

Course Outline

In this course, you will develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web application.

Exercises include:

  • Creating A SQL Database, Creating Tables, Fields, and Inserting Records in the SQL Database tables
  • Selecting Data from the SQL database using various filtering criteria techniques.
  • Sort, Format and Convert SQL data using specific SQL Functions and features.
  • 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 re-usability
Introduction to PHP

  • Origins of PHP in the open source community
  • Availability across multiple platforms
  • Installing as a module for Apache Web Server
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
  • 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
  • Embedding PHP code into HTML pages
  • 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
  • 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 re-usability
  • 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
  • Displaying returned data on Web pages
  • Avoiding potential problems by managing quotes and backslashes in data
  • Closing the database connection

Pre-Requisites

Those creating dynamic, database-driven Web sites.  Basic experience with HTML is assumed. Prior Programming or PHP experience is helpful but not required.

Course Objectives

Learn PHP at Intellisoft
Learn PHP at Intellisoft

You Will Learn How To:

  • Install, Setup and Create a database using SQL Commands
  • Insert, Update, Delete Records in SQL database tables
  • Write Queries against the SQL database & Retrieve data using specific criteria
  • 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

Go To Top

Target Audience

Participants who are interested in creating dynamic, database-driven Web sites.

 

Go To Top

Course Outline

In this course, you will develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web application.

Exercises include:

  • Creating A SQL Database, Creating Tables, Fields, and Inserting Records in the SQL Database tables
  • Selecting Data from the SQL database using various filtering criteria techniques.
  • Sort, Format and Convert SQL data using specific SQL Functions and features.
  • 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 re-usability
Introduction to PHP

  • Origins of PHP in the open source community
  • Availability across multiple platforms
  • Installing as a module for Apache Web Server
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
  • 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
  • Embedding PHP code into HTML pages
  • 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
  • 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 re-usability
  • 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
  • Displaying returned data on Web pages
  • Avoiding potential problems by managing quotes and backslashes in data
  • Closing the database connection

Go To Top

Pre-Requisites

Those creating dynamic, database-driven Web sites.  Basic experience with HTML is assumed. Prior Programming or PHP experience is helpful but not required.

Go To Top

Microsoft Access 2010 Training at Intellisoft

Claim SDF & PIC Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.

skills-future-training

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

computer-training-participants

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need below. We'll be glad to help you!

Some of the companies that experienced our trainings

How To Register

Register for the 3 Days of PHP & SQL Training today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at +65 6296-2995, SMS / WhatsApp: +65 9066 – 9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding PHP & SQL training.

We also offer Customized Corporate Training for PHP with SQL or Oracle Database. If you have a group of 10 or more participants, we can conduct this training at your office too. Contact us for details.

Create Web Applications
&
Enhance Your Productivity

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!