PHP& MySQL Technology

 Home / PHP& MySQL Technology

PHP&MySQL Technology

What is PHP ?

PHP stands for PHP Hypertext Preprocessor. “PHP is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly.” When someone visits your PHP web page, your web server processes the PHP code. It then sees which parts it needs to show to visitors (content and pictures) and hides the other stuff (file operations, math calculations, etc.) then translates your PHP into HTML. After the translation into HTML, it sends the web page to your visitor’s web browser.

What PHP does?

It is also helpful to think of PHP in terms of what it can do for you. PHP will allow you to: Reduce the time to create large websites. Create a customized user experience for visitors based on information that you have gathered from them. Open up thousands of possibilities for online tools. Allow creation of shopping carts for e-commerce websites.

What is MYSQL ?

  • MySQL is a database server
  • MySQL is ideal for both small and large applications
  • MySQL supports standard SQL
  • MySQL compiles on a number of platforms
  • MySQL is free to download and use
Introduction
  • The Origin of PHP
  • PHP is better than Its alternatives
  • Interfaces to External systems
  • How PHP works with the Web Server
  • Hardware and Software requirements
  • What a PHP script looks like
  • Saving data for later
  • Receiving user input
  • Repeating code
Basic PHP Development
  • How PHP scripts work
  • Basic PHP syntax
  • PHP data types
  • Displaying type information
  • Testing for a specific data type
  • Changing type with Set type
  • Operators
  • Variable manipulation
  • Dynamic variables
  • String in PHP
Control Structures
  • The if statement
  • Using the else clause with if statement
  • The switch statement
  • Using the ? operator
  • The while statement
  • The do while statement
  • The for statement
  • Breaking out of loops
  • Nesting loops
  • Summary
Functions
  • What a function
  • Defining a function
  • Returning value from function
  • User-defined functions
  • Dynamic function calls
  • Variable scope
  • Accessing variable with the global statement
  • Function calls with the static statement
  • Setting default values for arguments
  • Passing arguments to a function by value
  • Passing arguments to a function by reference
  • Testing for function existence
Arrays
  • Single-Dimensional Arrays
  • Multidimensional Arrays
  • Casting Arrays
  • Associative arrays
  • Accessing arrays
  • Getting the size of an array
  • Looping through an array
  • Looping through an associative array
  • Examining arrays
  • Joining arrays
  • Sorting arrays
  • Sorting an associative arrays
Working With The File System
  • Creating and deleting a file
  • Reading and writing text files
  • Working with directories in PHP
  • Checking for existence of file
  • Determining file size
  • Opening a file for writing, reading, or appending
  • Writing Data to the file
  • Reading characters
Working With Forms
  • Forms
  • Super global variables
  • The server array
  • A script to acquire user input
  • Importing user input
  • Accessing user input
  • Combine HTML and PHP code
  • Using hidden fields
  • Redirecting the user
  • File upload and scripts
Working With Regular Expressions
  • The basic regular expressions
  • PCRE
  • Matching patterns
  • Finding matches
  • Replace patterns
  • Modifiers
  • Breakup Strings
Classes And Objects
  • Objects oriented programming
  • Define a class
  • An Object
  • Creating an object
  • Object properties
  • Object methods
  • Object constructors and destructors
  • Class constants
  • Class inheritance
  • Abstract classes and methods
  • Object serialization
  • Checking for class and method existence
  • Exceptions
  • Iterators
  • Summary
Introduction To Database
  • Introduction to SQL
  • Connecting to the MYSQL
  • Selecting a database
  • Finding out about errors
  • Adding data to a table
  • Acquiring the value
  • Finding the number of rows
  • Inserting data
  • Entering and updating data
  • Executing multiple queries
Cookies
  • The anatomy of a cookie
  • Setting a cookie with PHP
  • Deleting a cookie
  • Creating session cookie
  • Working with the query string
  • Creating query string
Session
  • What is session
  • Starting a session
  • Working with session variables
  • Destroying session
  • Passing session Ids
  • Encoding and decoding session variables
Disk Access, I/O, Math And Mail
  • HTTP connections
  • Writing to the browser
  • Getting input from forms
  • Output buffering
  • Session handling
  • Regular expression
  • Common math
  • Random numbers
  • File upload
  • File download
  • Environment variables
  • E-mail in PHP
Joomla (Content Management System and Web Application Framework)
  • Detail discussion of component, module, mambots and complete workflow of Joomla
  • How to create component & module in Joomla
  • Customization of existing component and modules
  • Overview of Joomla 1.5
Smarty (Library For Creating HTML Templates)
  • Discussion of smarty
  • Discussion of variable and function and its uses
  • Practical application of smarty
PEAR (PHP Extension and Application Repository)
  • Discuss framework and distribution system for reusable PHP components
  • Discussion of pear
  • Practical application of pear in combination with smarty
Cake PHP (Rapid Development Framework)
  • Discussion of cake PHP framework
  • Model, View, Controller Architecture
  • View Helpers for AJAX, Javascript, HTML Forms and more
  • Built-in Validation
  • Application Scaffolding
  • Application and CRUD code generation via Bake
  • Access Control Lists
  • Data Sanitization
  • Security, Session, and Request Handling Components
  • Flexible View Caching
  • Practical application of cake PHP framework
  • AJAX (Asynchronous JavaScript and XML)
  • Introduction to AJAX
  • Introduction to XMLHttpRequest Object
  • Method and Properties of XMLHttpRequest
  • Application of AJAX in web application
osCommerce (Open Source Shopping Cart)
  • Introduction to Shopping Cart
  • Introduction to osCommerce opensource
  • Discussion of various module of osCommerce
  • Customization of existing template and module

IT Training (CDC)

WebPro Technology provides professional SEO and PHP training in Delhi. Our training program will full
fill the present industry needs.
  • .NET Technology
  • Java Technology
  • PHP& MySQL Technology
  • Android
  • ERP Training
  • CRM Training
  • AutoCad 3D

What People Say’s

  Excellent work!!! Working with Webpro technology was a real pleasure, they were so confident with their efforts in upgrading and redesigning my site that they did the work without asking for upfront payment. I have been disappointed with past designers that's what originally brought me to them. The support that I received from them after the previous work was done is wonderful and that's why I came back to them for the redesign of the site. Webpro technology will always be my first choice when it comes to any future projects. - Mark Adraison   customer
  Excellent work!!! Working with Webpro technology was a real pleasure, they were so confident with their efforts in upgrading and redesigning my site that they did the work without asking for upfront payment. I have been disappointed with past designers that's what originally brought me to them. The support that I received from them after the previous work was done is wonderful and that's why I came back to them for the redesign of the site. Webpro technology will always be my first choice when it comes to any future projects. - Lucia Penelope   customer
  Excellent work!!! Working with Webpro technology was a real pleasure, they were so confident with their efforts in upgrading and redesigning my site that they did the work without asking for upfront payment. I have been disappointed with past designers that's what originally brought me to them. The support that I received from them after the previous work was done is wonderful and that's why I came back to them for the redesign of the site. Webpro technology will always be my first choice when it comes to any future projects. - Diyana Florence   customer