PHP & MySQL Practice It Learn It
Published on 10. March 2013
35 pages
978-1-4566-1442-3 (ISBN)
Description
PHP & MySQL Practice It Learn It: This manual teaches the Programming stuffs in using PHP programming language in an easy-to-follow style. A variety of examples make learning these Concepts with PHP both fun and practical. This manual is organized in such a manner that students and programmers with basic prior knowledge of Programming can find it easy, crisp and readable. Each Chapter contains many example programs throughout the book, along with additional examples for further practice.
KEY FEATURES
Systematic approach throughout the book
Programming basics in PHP without requiring previous experience in another language
Simple language has been adopted to make the topics easy and clear to the readers
Topics have been covered with numerous illustrations and tested PHP programs
Enough examples have been used to explain various Programming Constructs effectively. This book also consists of tested programs so as to enable the readers to learn the logic of programming
Discusses all generic concepts of Computer Programming concepts such as Conditional and Looping Structures and Array in detail with aided examples
Use of Various Programming terms like variables and expressions, functions are simplified
A number of diagrams have been provided to clear the concepts in more illustrative way
Samples are presented in easy to use way through Wamp.
KEY FEATURES
Systematic approach throughout the book
Programming basics in PHP without requiring previous experience in another language
Simple language has been adopted to make the topics easy and clear to the readers
Topics have been covered with numerous illustrations and tested PHP programs
Enough examples have been used to explain various Programming Constructs effectively. This book also consists of tested programs so as to enable the readers to learn the logic of programming
Discusses all generic concepts of Computer Programming concepts such as Conditional and Looping Structures and Array in detail with aided examples
Use of Various Programming terms like variables and expressions, functions are simplified
A number of diagrams have been provided to clear the concepts in more illustrative way
Samples are presented in easy to use way through Wamp.
More details
Content
- Intro
- PHP & MySQL Practice It Learn It
- Copyright © 2012 Jitendra Patel PHP & MySQL Practice It Learn It
- Section 1: Getting Started with PHP.
- What is PHP?
- Features of PHP
- History of PHP
- Relationship between Apache, MySQL and PHP (AMP Module)
- Structure of PHP Program
- Installing a WAMP on Windows
- Testing the Installation
- Writing PHP Program
- Developing Real PHP Products
- Working with PHP Project
- Basic PHP Program
- PHP structure and syntax
- 1. Standard PHP tags
- 2. Miscellaneous PHP Tags
- Comments in PHP
- Creating and Saving PHP pages
- W.A. PHP SCRIPT to display name & address
- Script Code
- Output
- Section 2: Variables, Datatypes and Operators with PHP.
- Variables in PHP
- Variable Naming Rules
- PHP Data Types
- Variable functions
- Using Constants in PHP
- Value Type
- Reference Type
- Operators in PHP
- Arithmetic Operators
- Bitwise Operators
- Comparison Operators
- Compound Assignment Operators
- Incrementing/Decrementing Operators
- Logical Operators
- W.A. PHP SCRIPT to perform all arithmetic operation on two integers scanned from user.
- Script Code
- Output
- W.A.PHP SCRIPT to find avg. of three no. read from users.
- Script Code
- Output
- W.A.PHP SCRIPT to convert temp from Fahrenheit to Celsius unit using eq: C=(F-32)/1.8.
- Script Code
- Output
- W.A.PHP SCRIPT to find no. of years, months, and days from entered no. of days using "%".
- Script Code
- Output
- W.A.PHP SCRIPT to swap any two no. using third variable.
- Script Code
- Output
- Section 3: PHP Conditional Structures: if,switch.
- W.A.PHP SCRIPT to show that given no is even or odd.
- Script Code
- Output
- W.A.PHP SCRIPT to find maximum number among three nos.
- Script Code
- Output
- W.A.PHP SCRIPT to menu driven using switch case statement.
- Script Code
- Output
- W.A.PHP SCRIPT using switch case such that given a month displays the season.
- Script Code
- Output
- Section 4: PHP Iterative Structures: for, while, do.while.
- W.A.PHP SCRIPT to find out average of 1 to 10 numbers using while loop.
- Script Code
- Output
- W.A. PHP SCRIPT to find out odd and even numbers from 1 to10 numbers.
- Script Code
- Output
- W.A. PHP SCRIPT to find palindrome numbers from 1 to 100.
- Script Code
- Output
- W.A. PHP SCRIPT to find Armstrong numbers from 1 to 1000
- Script Code
- Output
- W.A. PHP SCRIPT to find factorial numbers from 1 to 1000
- Script Code
- Output
- W.A. PHP SCRIPT to check whether the entered number is prime or not
- Script Code
- Output
- W.A. PHP SCRIPT to print Fibonacci series
- Script Code
- Output
- W.A.PHP SCRIPT to display the following output using for, while and do.while loop
- Script Code using for:
- Script Code using while:
- Script Code do.while:
- Section 5: Using arrays in PHP
- W.A.PHP SCRIPT to print array
- Script Code
- Output
- W.A.PHP SCRIPT to print 2-Dimensional array.
- Script Code
- Output
- W.A.PHP SCRIPT to demonstrate use of associative array.
- Script Code
- Output
- W.A.PHP SCRIPT to find out sum of two matrices.
- Script Code
- Output
- W.A.PHP SCRIPT to find out multiplication of two matrices.
- Script Code
- Output
- Section 6: String Handling in PHP
- W.A.PHP SCRIPT to demonstrate various string functions.
- Script Code
- Output
- Section 7: User Defined Functions in PHP
- PHP Functions
- Creating a PHP Function
- Passing parameters in functions
- Returning values from PHP Functions
- W.A.PHP SCRIPT to demonstrate the use of user defined function
- Script Code
- Output
- W.A.PHP SCRIPT to demonstrate the use of default argument in function
- Script Code
- Output
- Script Code
- Section 8: Object Oriented Programming in PHP
- W.A.PHP SCRIPT to demonstrate the use of class and object.
- Output
- W.A.PHP SCRIPT to demonstrate the use of inheritance.
- Script Code
- Output
- Section 9: Moving data between pages using PHP
- Script Code
- Output
- W.A.PHP SCRIPT to demonstrate the use of session and cookie
- Script Code demonstration of Session:
- Output
- Script Code demonstration of Cookie:
- Output
- Section 10: Graphics Programming using PHP
- What is the GD Library?
- Introduction to PHP Image Functions
- Functions to Get image size
- Functions to Draw line
- Functions to Draw a horizontal char
- Functions to Draw a vertical char
- Functions to Dispose image color
- Functions to Define transparent color
- Functions to Copy image part and resize the image
- Functions to Create new image
- Functions to Create new image..
- Functions to Draw a dashed line
- Functions to Free memory of image
- Functions to Fill color
- Functions to Draw a polygon and fill color
- Functions to Create a rectangle
- Functions to Fill border area color
- Functions to Get font height
- Functions to Get font width
- Functions to Export image in browser or file
- Functions to Open and close interlace
- Functions to Draw a line
- Functions to Load font
- Functions to Draw a polygon
- Functions to Draw a rectangle
- Functions to Draw a horizontal string
- Functions to Draw a vertical string
- Functions to Get image width
- Functions to Get image height
- Functions to Calculate True Type font total area size
- Functions to Draw TrueType font
- Functions to Get point color
- Functions to Get color
- Functions to Get color
- Functions to Get color
- Functions to Set color with index
- Functions to Get color with index
- Functions to Get total color in color tray
- Functions to JPEG file change to WBMP file
- Testing Your GD Installation
- W.A.PHP SCRIPT to Create Rectangle with Text
- Script Code
- Output
- W.A.PHP SCRIPT to Work with Fonts
- Script Code
- Output
- W.A.PHP SCRIPT to Draw Lines
- Script Code
- Output
- W.A.PHP SCRIPT to Draw an Ellipse
- Script Code
- Output
- W.A.PHP SCRIPT to draw SolidEllipse
- Script Code
- Output
- W.A.PHP SCRIPT to draw Arcs & Pies
- Script Code
- Output
- Section 11: Working with data in MySQL using PHP
- What is Database?
- RDBMS Terminology:
- MySQL Database:
- Before You Begin:
- Downloading MySQL:
- W.A.PHP SCRIPT to connect to MySQL.
- Script Code
- Output
- W.A.PHP SCRIPT to create database in MySQL
- Script Code
- Output
- W.A.PHP SCRIPT to create table in MySQL
- Script Code
- Output
- W.A.PHP SCRIPT to insert records in table in MySQL
- Script Code
- Output
- W.A.PHP SCRIPT to retrieve and display records in table in MySQL
- Script Code
- Output
- W.A.PHP SCRIPT to change or update records in table in MySQL
- Script Code
- Output
- W.A.PHP SCRIPT to delete records in table in MySQL
- Script Code
- Output
- W.A.PHP SCRIPT to search and display records in table in MySQL
- Script Code
- Output
