Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

PHP and MySQL Course, PHP Training Course in Bangalore

No Reviews Yet

Malleshpalya, Bangalore

Course ID: 14514

Malleshpalya, Bangalore

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

Siyaram Yadav

Engineering

About Siyaram Yadav

6 years of experience in PHP. He is an expert in php and mysql training.
No reviews currently Be the First to Review

About the Course

PapSys Technologies PHP and MySQL course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP version 5.

PHP is a language written for the web, quick to learn, easy to deploy and provides substantial functionality required for e-commerce.

This course introduces the PHP framework and syntax, and covers in depth the most important techniques used to build dynamic web sites.

Students learn how to connect to any ODBC-compliant database, and perform hands on practice with a MySQL database to create database-driven HTML forms and reports.

E-commerce skills including user authentication, data validation, dynamic data updates, and shopping cart implementation are covered in detail. Students also learn how to configure PHP and the Apache Web Server.

Topics Covered

PHP and MySQL Course Syllabus:

Overview Of PHP

Static vs. Dynamic Web Sites
Dynamic Content from Databases
Developing Dynamic Internet Applications
Client-Side Scripting vs. Server-Side Scripting
Overview of PHP Advantages and Capabilities
Configuring php.ini
PHP vs. ASP

Conditional Constructs

True and False Expressions
if, else and elseif
switch/case Statement
The ? (Ternary) Operator
Timestamps

PHP Functions

Introduction to Functions
Declaring Functions
Scope
Passing Arguments to Functions
Local and Global Scope
Passing Arguments to Functions by Value and Reference
Returning Values from a Function
Using Include Files
The Require Statement
Recursion
Dynamic Function Calls
Predefined PHP Functions

Arrays in PHP

What are Arrays?
Usage of Arrays in PHP
Array Indexing
Initializing Arrays
Operating on Arrays
Sorting Arrays
One-Dimensional Arrays
Multi-Dimensional Arrays
Associative Arrays
Array Functions
Forms and Arrays in Web Applications

Working with Data Files in PHP

Searching File Contents With Regular Expressions
Changing and Editing File Contents
Splitting and Joining Information Inside Files
String Functions
Regular Expression Functions
Reading, Writing and Deleting Files
Handling File Permissions
File Locking
Reading Directory Contents
Creating and Deleting Directories

Configuring and Using MySQL

MySQL as a Client/Server Solution
Introduction to MySQL Capabilities as a Powerful RDBMS
Installing and Configuring MySQL
Connecting to MySQL
PHP Functions Specific to MySQL
Executing SQL Calls
SELECT
INSERT
FETCH
UPDATE
DELETE
Using PHP MyAdmin to configure MySQL

Basic Scripting and Looping Constructs

PHP Scripting Fundamentals
Print Statement
Code Blocks
Primitive Data Types
Defining Constants and Variables
Looping Constructs
while
do… while
for
exit & break

Introduction to the Apache Web Server

Apache Configuration Files
Configuring Apache for PHP
WWW Sites within Apache
Apache Virtual Hosts
Website Properties

PHP Operators

Logical Operators
Relational Operators
Bitwise Operators
Other Operators

Working with Databases and Forms

Configuring PHP For Database Support
PHP's Database APIs
PHP's SQL API
MySQL vs. Access
MySQL vs. SQL Server
Database Drivers
Database Driver Class Wrappers
ODBC
Simple SQL Queries via PHP
Tracking Visitors with Session IDs
Populating Forms
Retrieving Data from Forms

Enabling E-Commerce

Required Characteristics of an E-Commerce Site
Authentication and Authorization
Data Validation
Building a Custom Shopping Cart
Persisting Shopping Cart Data Over Multiple Pages
Criteria for Evaluating Third Party Shopping Cart Solutions
Open Source vs. Commercial Shopping Cart Solutions
Order Processing via the Web
Implementing Order System Security using SSL
Using Mail Servers (SMTP and Sendmail) for Client Communication
Configuring E-mail Output Parameters

Using Cookies with PHP

Purpose of Cookies
Cookie Myths
Setting Cookies
Retrieving Cookies
Expiring Cookies
Deleting Cookies
Storing Arrays in Cookies

Miscellaneous PHP Tasks

Error Logging
Session Management and Maintaining State
Web Application Architecture
Using Environment Variables
Changing Execution by Redirecting to Other URLs
Embedding JavaScript within PHP
Using the HTTP Protocols to Pass Data
Showing Different Content to Different Browsers
Getting IP Addresses from Visitors

Who should attend

Any Graduates

Pre-requisites

No

What you need to bring

Note Book, pen, etc.

Key Takeaways

Students learn how to connect to any ODBC-compliant database, and perform hands on practice with a MySQL database to create database-driven HTML forms and reports. E-commerce skills including user authentication, data validation, dynamic data updates, and shopping cart implementation are covered in detail. Students also learn how to configure PHP and the Apache Web Server.

Reviews

No reviews currently Be the First to Review

Discussions (1)

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Php MySQL training Post your requirement now
Enquire

Enquire

Submit your enquiry for PHP and MySQL Course, PHP Training Course in Bangalore

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Sankar San

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