| « back» Enquiry Now
PHP / MySQL Training Program
Both PHP and MySQL are increasingly popular open-source technologies and this course has been designed to give you the skills to fully utilise the power and flexibility they offer.
This four day, practical, exercise-driven course will cover the fundamentals of using MySQL and PHP and will provide a firm grounding in each technology and explore how they allow you to build sophisticated, bespoke web applications.
This course is designed for those new to working with PHP, MySQL and SQL (there is a two-day version of this course for those with some existing knowledge of programming in PHP). Feel free to tailor the following course outline to your exact requirements if you wish.
Eligibility & Course Duration
Must know at least one programming language.
20 weeks (3 days x 2 hours per week).
Flexible practical hours.
Course Fees & Payment Method
Fees: Rs. 25,000/-
1st Installment - Rs. 5,000
2nd, 3rd, 4th and 5th - Rs. 5,000 each
PHP/MYSQL Programing Certification Course Outline
- Introduction
- » Why use PHP and MySQL?
- » The PHP programming environment
- » Overview of SQL
- Setting up a Test Bed
- » Decisions about a testing environment
- » WAMP/MAMP
- » Installing Apache, PHP and MySQL on your computer
- » Testing on a remote Server
- » Deciding on Development tools
- » Using PHPMyAdmin
- Variables in PHP
- » Using loose typed variables
- » Assigning variables
- » Overview of numeric, string and other types
- » Assigning a variable to itself
- Logical operators
- » Arithmetic operators
- » Logical operators
- » Comparisons
- » Operator precedence
- Numbers in PHP
- » Making calculations
- » Using built-in numeric functions
- » Incrementing and decrementing
- Strings in PHP
- » Concatenating strings
- » Trimming strings
- » Removing slashes and other 'harmful' characters
- » String functions
- Questions and answers
- Control structures in PHP
- » The If statement
- » FOR loops
- » While loops
- » The Switch
- Security Features
- » Validating Entries
- Database fundamentals
- » Structuring a database
- » Using tables
- » Table relationships
- » Common data types
- Creating a database
- » Structuring a database
- » Using tables
- » Table relationships
- » Common data types
- Transferring information between PHP pages
- » Using PHPmyAdmin
- » Adding a table
- » Populating a table with types and data
- » Browsing a table
- Getting PHP to connect to MySQL
- » Using the mysql_connect() function
- » Using the mysql_select_db() function
- » Testing a connection
- » Writing a sample error trap
- Querying MySQL using PHP
- » Writing SQL queries
- » Using Select, Insert, Update and Delete
- » Querying MySQL and returning results
- » Interpreting the returned array
- Building a Web Application
- » Creating pages to:
- Add entries
- Modify entries
- List entries
- Filter entries
- Transferring information between PHP pages
- » GET and POST
- » Different form field types
- » Self-referencing forms
- » Form handlers
  | 
