Introduction to webprogramming using PHP and MySQL

M D ANANDA RAJ,
Assistant Professor,
Department of computer science
Loyola College, chennai-600 034
profmdloyola@gmail.com
8/3/2017 1
Introduction to
Web Programming using
PHPand MYSQL

Contents
• Introduction
• History
• Important concepts
• Php
• Mysql
• Database concepts
8/3/2017 2

What is Scripting language?
• Scripting language is the one which is used to
develop contents in the web
• Write the code by using predefined tags
<html> contents </html>
• Example :
• HTML, JAVASCRIPT, VBSCRIPT, CSS , XML
8/3/2017 3

What is Client & Server
Client:
client is the system which is looking for
some service
Eg: the system end user using in the lab
Server:
server is the system which is providing
service for the clients (end user)
Eg: server in the computer lab
8/3/2017 4

Client side…
• Client side scripting language executed from
the client machine(System)
example : HTML , CSS, JAVASCRIPT, VBSCRIPT
- Not secured
- any user can view the original by seeing the
view source option in the browser
- any user can view the source code
and modify
8/3/2017 5

Server side …
• Server side scripting language executed from the
server machine(System)
example : ASP , PHP , JSP
- Very much secured
- User cannot view the original source code by
seeing the view source option in the browser it
will show only the html code
- user cannot modify the source code
8/3/2017 6

web contents
• Web can be classified in to two types
1.static page
-contents will not change remain as it is
-user input interaction not possible
2. Dynamic page :
- Contents can be updated very easily
- user input and interaction is possible
8/3/2017 7

What is Open source?
• In software development Open source is the
concept or philosophy that promotes free
distribution of software product without any
license fees.
• Example: open source
• Operating System: Linux
• Script language : PHP,PERL, PYTHON
• Browser : Mozilla Firefox
• Photo Editor : GIMP
• Office : Open Office
8/3/2017 8

Open source development model
View/Modify the source code of an application or software.
he source code of an application or software.
Open source software is released to the development community
and undergoes a secondary phase of evolution, but closed source
software is developed in isolation with a small team of developers.
Developer support and large community to help.
Open Source is more secure and bugs and vulnerabilities are fixed
often.
 source software is released to the development community and
undergoes a secondary phase of evolution, but closed source
software is developed in isolation with a small team of developers.
Developer support and large community to help.
Open Source is more secure and bugs and vulnerabilities are fixed
often.
8/3/2017 9

Advantages…
• Free source code
• No need pay license fees
• No need to depend on vendors
• Easy to fix the error with online support
• Support from forum all around the world
• Updated software version
• Quality and customizable software
• Cost cheaper than licensed software
8/3/2017 10

Disadvantages…
• Users need to update very frequently
• Incompatibility issue with software and
hardware
• Bad codes
• Software quality assurance process is not
transparent
• No financial benefit for the developers
8/3/2017 11

What is wamp?
• WAMP is a web server used to execute php
and mysql in client machine
• A- APACHE
• M- MySQL
• P- PHP
• W- WINDOWS
It is “ APACHE MYSQL PHP FOR WINDOWS
LAMP : APACHE MYSQL PHP FOR LINUX
8/3/2017 12

WAMP ARCHITECTURE…
8/3/2017 13

PHP-Introduction
• PHP == ‘Hypertext Preprocessor’
• Open-source, server-side scripting language
• Used to generate dynamic web-pages
• PHP scripts reside between reserved PHP
tags
– This allows the programmer to embed PHP
scripts within HTML page
– Free to download and use
8/3/2017 14

Overview of PHP…
• Easy learning
• Syntax Perl- and C-like syntax. Relatively easy
to learn.
• Large function library
• Embedded directly into HTML
• Interpreted, no need to compile
• Supports many databases like oracle, MySQL
etc
8/3/2017 15

Php…
• Interpreted language, scripts are parsed at
run-time rather than compiled
• Executed on the server-side
• Source-code not visible by client
– ‘View Source’ in browsers does not display the PHP code
• Various built-in functions allow for fast
development
• Compatible with many popular databases
8/3/2017 16

History of php…
In 1994 developed by Rasmus Lerdorf developed
he called the Personal Home Page or PHP
PHP 2 released 1997 (PHP now stands for
Hypertext Processor)
PHP3 released in 1998 (2 versions)
PHP4 released in 2000 (6 versions).
PHP5.0.0 released July 13, 2004 (1000s of
libraries and functions
PHP5.0.5 released Sept. 6, 2005 for maintenance
and bug fixes (21 versions)
PHP 6.0 is the latest version
8/3/2017 17

Features of php…
• Simplicity
• Portability
• Speed
• Open source
• Extensible
• Database support
8/3/2017 18

Hello.php
• Open the note pad
<html>
<?php
Echo “hello good morning”;
?>
</html>
Save this code as hello.php under
c:wampwwwanandhello.php
8/3/2017 19

Data types supported by PHP:
• Integers 0,1,2,3etc
• Float/ Double – real numbers 0.1, 0.2, 0.3, etc
• String – ‘A’, “Loyola College” etc
• Boolean – True or False
• Array – set of values – {0,1,2,3}or
{0.1,0.2,0.3}or {‘A’, ‘B’, ‘C’} or {“kumar”,
Santhosh”, “Karthick”} etc
8/3/2017 20

Variable declaration
Variables are used for storing values, such as numbers, strings or
function results, so that they can be used many times in a script .All
variables in PHP start with a $ sign symbol.
Syntax:
$var_name = value;
<?php
$txt = "Hello World!";
$number = 16;
?>
Note : PHP a variable does not need to be declared before being
set.PHP automatically converts the variable to the correct data
type, depending on how they are set.
8/3/2017 21

PHP Variable….
• PHP variables must begin with a “$” sign
• Case-sensitive ($Name != $NAME != $NaMe)
• Global and locally-scoped variables
– Global variables can be used anywhere
– Local variables restricted to a function or class
• Certain variable names reserved by PHP
– Form variables ($_POST, $_GET)
– Server variables ($_SERVER)
– Etc.
8/3/2017 22

constants
• PHP constants: Constants are like variables
except that once they are defined they cannot
be changed or undefined. The value cannot be
changed during the script.
• Eg:
<?php
define("MSG", “good morning");
echo MSG;
?>
8/3/2017 23

Looping
• Most of the time when we write code, we want the same
block of code to run a number of times for this purpose we
can use looping statements code to perform this task.
• PHP supports the following:
• while - loops through a block of code if and as long as a
specified condition is true
• do...while - loops through a block of code once, and then
repeats the loop as long as a special condition is true
• for - loops through a block of code a specified number of
times
• foreach- loops through a block of code for each element in
an array
8/3/2017 24

Example for each
• Example:
<?php
$arr=array("one", "two", "three");
foreach ($arr as $value)
{
echo "Value: " . $value . "<br />";
?>
8/3/2017 25

cookies
• A cookie is often used to identify a user. A
cookie is a small file that the server embeds
on the user's computer.
• Each time the same computer requests a
page with a browser, it will send the cookie
too.
• With PHP, you can both create and retrieve
cookie values.
8/3/2017 26

What is a PHP Session?
• When you work with an application, you open it, do
some changes, and then you close it. This is much like a
Session. The computer knows who you are. It knows
when you start the application and when you end
• Session variables solve this problem by storing user
information to be used across multiple pages (e.g.
username, password etc). By default, session variables
last until the user closes the browser.
• Session variables hold information about one single
user, and are available to all pages in one application.
8/3/2017 27

MySQL…
MySQL, the most popular Open Source SQL database
management system
It is developed and supported by MySQL AB. MySQL AB is a
commercial company, founded in 1995 by the MySQL
developers.
The MySQL® software delivers a very fast, multi-threaded,
multi-user, and robust SQL (Structured Query Language)
database server.
The MySQL software is Dual Licensed. Users can choose to
use the MySQL software as an Open Source product and
also as commericial licence
8/3/2017 28

MySQL…
• MySQL is a very popular, open source
database.
• Officially pronounced “my Ess Que Ell” (not
my sequel).
• Handles very large databases; very fast
performance.
8/3/2017 29

MySQL storage engines…
• MyISAM –default engine
• InnoDB – features like foreign key,locking
• MERGE – integration of table
• MEMORY (HEAP) – suit for short time storage
• BDB (BerkeleyDB)- hash based storage
• EXAMPLE – used for programmers
• ARCHIVE –to store large amount of data
• CSV – to store data in text files
• BLACKHOLE –only for testing purpose
• ISAM – to store non transactional tables
8/3/2017 30

Introduction to webprogramming using PHP and MySQL

More Related Content

Similar to Introduction to webprogramming using PHP and MySQL

Recently uploaded