coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?


Please select a Location.


Submit your enquiry for PHP - MySQL Programming Training( Basic to Advanced)

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Umasankar

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer


course photo

PHP - MySQL Programming Training( Basic to Advanced)

BTM Layout 2nd Stage, Bangalore


No Reviews Yet
0 Interested

About the Course

PHP MySQL class will be focused on Core PHP and MySQL programming from Basic to Advanced.

At the end this course students able to write PHP - MySQL code independently.

Topics Covered

Part 1 – Basic PHP Programming
Session 01 - Internet Basic
• What is DNS?
• Name-to-Address Resolution
• How Internet Works
• Browser Architecture
• How Browser Works
• How HTTP & HTTPS works
Session 02 - Introduction to PHP
• What is PHP?
• What is MySQL?
• Where to get PHP and MySQL?
• How PHP and MySQL fit the Web
Session 03 - Installation XAMPP, xDebug, Netbeans • Installation of XAMPP
• Configuration of Apache HTTP Server
• Configuration of MySQL
• Configuration of phpmysqladmin
• Installation and configuration of Netbeans
• Installation and Configuration of xDebug
Session 04 - PHP Fundamentals • Configuration of PHP
• How PHP works
• Mixing PHP and HTML
• Different types of comments
Session 05 - Basis of HTML, CSS, JavaScript • What is HTML?
• What is JavaScript?
• What is CSS?
• How to include HTML, CSS & JavaScript in PHP
Session 06 - Debugging PHP with Netbeans & XDebug • Break point
• Call stack
• Step by step procedure to debug PHP Script
Session 07 - Variable and Constants • Constants
• Constants using define
• Constants using const
• Rules for Variables
• Scope of Variables
• Global Variables - Superglobals
Session 08 - Different data types
• String, Integer, Floating point numbers, Boolean, Array, Object, NULL
Session 09 - Operators
• Arithmetic Operators
• Assignment Operators
• Bitwise Operators
• Comparison Operators
• Error Control Operators
• Execution Operators
• Incrementing/Decrementing Operators
• Logical Operators
• String Operators
• Array Operators
• instanceof Operators
• Scope Resolution Operator (::)
• Operator Precedence
Session 10 - PHP output
• echo
• print
• print_r
• var_dum
• printf
• Difference among them
• Language construct and function
Session 11 - Array
• What Are Arrays?
• Accessing Array elements
• Array - Indexing by Number
• Associative Arrays - Indexing by Strings
Session 12 - Branching & Conditional Statement
• If
• If ... Else
• If... Elseif ... Else
• Nested If
• Switch Case
• Nested Switch Case
Session 13 - Loops
• For
• While
• Do ... While
• Foreach
• Loop Control (break and continue)
• Nested Loops
Session 14 - Functions
• Function Definition
• Function Scope
• Arguments and Return Values
• Pass by value, Pass by reference
• Return by value, Return by reference
Session 15 - Form Processing
• Review of HTML Forms (check boxes, text fields, radio buttons)
• Retrieving Form Data using GET ,POST REQUEST HTTP method
• Difference among HTTP methods
• Submitting to Itself
Session 16 - Cookies
• Setting Cookies
• Accessing Cookies
• Accessing Cookies(Verifying isset)
• Deleting Cookies
Session 17 - Sessions
• Introduction to Sessions and Cookies
• Password-protecting Pages
Session 18 - PHP Email
• Sending email
• Sending email with Attachment
Session 19 - PHP Functions ( Frequently used functions )
• Date and Time functions
• Directory functions
• Error logging functions
• Math functions
• String functions
• Calendar functions
• include, require , include_once, require_once
Session 20 - PHP Filters
• Filter functions
• Filter Lists
Session 21 - Error and Exception Handling
• Simple "die()" statements
• Custom errors and error triggers
• Error reporting
• Exception Handling
Session 22 - File Handling
• Files and Directories
• Read and Writing Files
• Working with Directories
• About File Permissions
• Uploading file to server
Session 23 - Best Practices
• Coding Conventions
• Making modularity

Part 2 - Advanced PHP Programming
Session 24 - Working with Browser In-Builder debugger
• Network
• Inspector
• Profiler
• Style Editor
• Debugger
• Console
Session 25 - Working with firebug
• Installing firebug in firefox
• Debuging using firebug
Session 26 - MySQL
• The Command-Line Client
• Connecting to Database Server
• Creating & Selecting Databases &Tables
• Displaying Databases & Tables
Session 27 - PhpMySQLAdmin
• Connecting to Database Server
• Creating Database
• Creating, Editing, Modifying Tables
• SQL Language
• Creating Databases, Tables, and Fields
Session 28 - PHP MySQL
• Connecting from PHP to MySQL
• Executing SQL Queries
• Retrieving Query Results
• Putting It All Together
Session 29 - Object Oriented Programming in PHP
• Creating Class & Objects
• Calling functions through Objects
• Constructors and Destructors
• Autoloading Classes
• Constructors and Destructors
• Visibility
• Object Inheritance
• Static Property and Method
• Class Abstraction
• Object Interfaces
• Traits
• Overloading
• Object Iteration
• Magic Methods
• Final Keyword
• Object Cloning
• Comparing Objects
• Type Hinting
• Late Static Bindings
• Objects and references
• Object Serialization

1) Details of HTML, JavaScript, CSS, Any PHP Framework will not be included in this course
2) Assignment will be provided on daily basis. Trainees need to finish the assignment before coming to next class.

Who should attend

Anyone who is looking to learn PHP Server Side Scripting Language from Basic to Advance. Who wants to work in their company project without any further PHP Programming training from their supervisor


Student should have basic computer knowledge like working in Windows, Just they should know about logon to the system.

Student should have some knowledge about HTML, CSS, JavaScript.

I will take care about the installation of IDE, Editor, online teaching software setup extra.

Student can contact me 1 or 2 days before the workshop, I need to install IDE, Editor and online teaching software setup ready for him to run the class smoothly.

What you need to bring

As It is class room session, Students should bring good Laptop, notepad, pen.

Laptop should have Windows XP, Windows Vista, Windows 7, Windows 8 OS installed.

If they miss two or three of the sessions / topics, can reach me, I will take separate class to cover the missing sessions.

Key Takeaways

My training will be focused with practical example of PHP & MySQL Programming language.

Students will gather more knowledge about PHP & MySQL Programming language.

Students able to write professional looking code independently.

Students able to debug their code and fix the bugs independently.

Students can directly work in their company PHP & MySQL projects directly without any PHP & MySQL Programming training from the supervisor / company

Students can also optimise the code to improve the performance.
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Umasankar Natarajan picture

Umasankar Natarajan

B.E., M.B.A., PMP

I have 22 Years experience - 20+ years of software design & development experience and 2 years of Non IT experience.

I have practically worked C, C++ , PHP, MySQL for 18+ years in different software companies like Tata Elxsi, Mphasis, Aricent, Mindtree.

I worked 8+ years as Project Manager, where I worked many excel vba project to create dashboard and automate project reports.

I completed 25+ realtime project in Software Industries. Out of which I have done 21+ C & C++ Real time projects. 15+ Excel Projects for Automation, Dashboard and report generation.

6+ PHP MySQL Real time Projects.

I can teach you Excel VBA Macro Programming in depth with practical examples.

I can teach you C and C++ Programming in depth with practical examples. Also I will teach C & C++ with memory level debugging.

I can teach you PHP - MySQL programming in depth with practical examples.
Seats Left-

Students Interested 0

Course Id: 26804