PHP & MySQL Training Course

This PHP & MySQL Training course in Singapore will teach you about the concept of PHP scripting language. PHP with MySQL is quick to learn, easy to deploy and provides many of the programming tools a web developer could wish for all in a single, free, cross-platform, open-source package.

PHP is a programming language for making dynamic and interactive Web pages. PHP is the widely-used, free, and efficient alternative to competitors such as Microsoft’s ASP. In our PHP tutorial you will learn about PHP, and how to execute scripts on your server.

OBJECTIVES

After this Php and MySql training course, delegates will:

• Get up to speed with tried-and-true programming strategies
• Gain valuable tips and tricks for using the PHP language and syntax.
• Step through relational database design, production and management
• Learn how to streamline PHP’s interaction with MySQL, SQL, and relational databases
• Watch how PHP’s sessions and cookies can be used to quickly build full-scale web applications
• Learn how to re-use code using functions and includes
• Glimpse at PHP’s inner workings to understand how to build secure and performance conscience programs, including proper use of references, global variables and scope.

• Overview of the Case Study – The e-Store
  • Populating Web pages from a database
  • User-driven queries/browse
  • Data Entry and Validation
  • User Authentication and Management
  • Reporting
• Learning PHP
  • PHP Basics
  • Conditions and Branches
  • Loops
  • Variables and Arrays
  • Strings
  • Functions
• MySQL databases
  • Database Basics
  • Loading a Database
  • MySQL command Interpreter
  • Creating a database
  • Modifying a database
  • Administering a database
• Developing an application using PHP and MySQL
  • The e-Store
  • MySQL functions in PHP
  • Querying a database
  • User-Driven Querying
  • Previous and Next Browsing
  • Inserts, Updates, and Deletes
  • User Authentication and Management
  • Ordering and Shipping