Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP

Kerala Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP

Overview of PHP (Formerly Personal Home Pages)

PHP stands for PHP Hypertext Preprocessor. Normally, it runs on a web server.

Benefits of using PHP

Client-side scripts(JavaScript) are run faster but it has some limitations. The limitations are we can view the source code hence it is less secure. On the other hand PHP is executed on the server and the result is sent back to the client(browser) so it is impossible to view the source code.

Benefits of PHP are given below

  • As PHP can be easily embedded into HTML moreover its easiness to convert a static web site into dynamic one.
  • It is compatible with almost all databases
  • It is platform independent can run on almost all OS (Windows, Linux, MAC)
  • It is simple and easy to learn
  • It uses very small amount of system resources
  • to run and faster.
  • PHP provides security to prevent malicious attacks.
  • Open source community supports PHP
  • It is a free s/w by all means hence can be used to develop all types of web sites

Basics of PHP

A) Setting up the development environment

Step 1

  • Install a PHP compatible web Server (Eg. Abyss Web Server For Windows)

Step 2

  • Install PHP interpreter.
    After installing the web server type http://localhost in the address bar the following screen will be available.
    Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 1

B) Writing and running the script

Take a note pad and type the code, PHP code should begin with <?php andend with ?>. Save this file in the root directory of the web server with extension php.

Step 1
Take a notepad and type (he following and save it as first.php on C:\Abyss Web ServeAhtdocs.
<?php
echO”My first PHP web page”;
?>

Step 2
Start the web server if it is off

Step 3
Type as “http://localhost/firstphp” in the address bar.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 2

C) Combining HTML and PHP
Both are closely related. We can write PHP code in between HTML code using <?php and ?>.
Eg:
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 3

D) Comments in PHP
We can make some text as a comment i.e. not as part of the program Single line(//) and multi line (starts with /* and ends with */)

<HTML>
<HEAD>
<TITLE>
My first php page </TITLE>
</HEAD>
<BODY>
<?php
/* This program is used to display a message “Welcome to php” */ echo “<H2>Welcome to php</H2>”; //shows a message?>
</BOD Y>
</HTML>

E) Output statements in PHP
i) echo and print are used to display all types of data but echo is used to produce multiple outputs. Parenthesis is optional,

eg:
echo “ first output”, “second output”;
or
echo (“ first output”, “second output”);
print “only one output”;
or
print (“only one output”);
The difference between echo and print

EchoPrint
Take more than one parameterOnly one parameter
Does not return any valueReturns TRUE or l on successful print and FALSE otherwise
Fasterslower

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 5

ii) var_dump()
This is used to display both data type and value of variables.
Syntax: var_dumpl(variablel, vanable2,etc…);

Eg:

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 6
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 7

Fundamentals of PHP

Variables

A variable name starts with $ symbol followed by the name of the variable. There is no need to declare a variable before using it. PHP automatically determines the data type based upon the value stored in it.
Syntax: $variable_name=value;

Rules for naming a variable in PHP

  • Begins with $ symbol followed by an alphabet or under score(a-zA-Zand _)
  • Digits(O-9)can be used after 2 characters.(Eg. $_1 ,$al ,$s12,etc)
  • Variable names are case sensitive.
  • Special characters cannot used except under score.

Data type

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 8

A) Core data types
Integer, Float/ Double and String, these data types are similar data types of C++. The size of integer or float is depending upon the OS.

  • Integer—Two types—ye and +ve.. PHPdoesnot support unsigned integer data type.
    Eg: 8172, -22, etc.
  • Float/ Double -:Numbers with decimal point.
    Eg: 81.72, 7E-1 0(7 * 1010 —Mantissa and Exponent method), 123E1 2(123*1012)
  • String: Combination of characters enclosed in quotes(single or double quotes) Eg: “BVM”,’HSS’, Computer Science’, etc.
  • Boolean: Used to store two values(states) TRUE or FALSE.
    Eg: values are yes/no, on/off, 1/0, true/false
    <?php
    Sx=false; Il assign the value FALSE to $x.
    $y=1; //assign the value TRUE to $y.

B) Special data types

  • Null-: Specialdata type with value NULL. This is the default value to a variable, if we do not set a value to it.
    $rn=null;
  • Array -: Array is a collection of elements. With the same name we can store many elements.
    Three types of array
    Indexed array-:
    Associated array-:
    Multi dimensional array-:
  • Object -; Similar in C++ and must be declared explicitly. At first a class is declared and then objects can be created using the command new.
  • Resources -: It is not an actual data type rather it is a special variable that hold references to file handler, data base object, etc.

Operators in PHP

Operators are the symbols used to perform an operation
a) Assignment operator(=)
The value of RHS is assigned to LHS variable. If $a=10 and $b=3 then $a=$b. This statement sets the value of $a and $b are same ,i.e. it sets a to 3.

b) Arithmetic operators
It is a binary operator. It is used to perform addition (+), subtraction(-), division(/), multiplication(*) ,modulus(%-givesthe remainder).
Eg. If $x=10 and $y=3then

$x+$y$x-$y$x*$y$x/$y$x%$y
137303.3331

c) Relational (Comparison) operators
It is used to perform comparison or relational operation between two values and returns either true or false.
Eg: If $X=10and $Y=3then

$X<$Y$X<=$Y$X>$Y$X>=$Y$X>==$Y$X!=$Y
falsefalsetruetruefalsetrue

d) Logical operators
Here (and , &&), (or, ||), xorare binary operators and not(!) is a unary operator. It is used to combine relational operations and it gives either true or false
If $X=true and $Y=false then

$x && $x$X && $Y$Y && $X$Y &&$Y
truefalseFalsefalse

Both operands must be true to get a true value in the case of && operation If $X=true and $Y=false then

$X and $X$X and $Y$Y and $X$Y and $Y
truefalseFalsefalse

Both operands must be true to get a true value in the case of ‘and’ operation If $X=true and $Y=false then

$X || $X$X || $YSY || $X$Y || $Y
truetruetruefalse

Either one of the operands must be true to get a true value in the case of || operation If $X=true and $Y=false then

$X or $X$X or $Y$Y or $X$Y or $Y
truetruetruefalse

Either one of the operands must be true to get a true value in the case of or operation If SX=true and $Y=false then

$X xor $X$X xor $Y$Y xor $X$Y xor $Y
truetruetruefalse

Either one of the operands must be true to get a true value in the case of xor operation If $X= true and $Y=false then

l$X!$Y
falsetrue

e) String addition operator(‘.’, ‘.=’)
This is also called concatenation operator. It joins(concatenates) two strings and forms a string.
They are and ‘.=’.
Eg:
$x= “BVM HSS
$y= “ Kalparamba”;
$z=$x.$y;

  • Here the variable z becomes “BVM HSS Kalparamba”.
    $x.=$y;
  • Here the variable $x becomes “BVM HSS Kalparamba”.

f) Combined operators.
It is also called short hands
If $X=1O and $Y= 3 then

Arithmetic Assignment ExpressionEquivalent Arithmetic ExpressionThe value of $X becomes
$X+=$Y$X=$X+$Y13
$X-=$Y$X=$X-$Y7
$X*=$Y$X=$X*$Y30
$X/=$Y$X=$X/$Y3.333
$X%=$Y$X=$X%$Y1

g) Increment and decrement operators.
1) pre increment (++variable)
Eg:
lf$x=10then
echo(++$x); -> It prints 10+1=11

2) post increment (variable++)
lf $x=10then
echo($x++); -> It prints 10 itself.

3) pre decrement—variable)
lf $x=10then
echo(—$x); It prints 10-1=9

4) post decrement(variable—)
lf $x=10then
echo($x—);-> It prints 10 itself.

h) Escape sequences
It Is a character preceded by a back slash(\)

OperatorDefinitionExampleOutput
\“To print”echo TPHPr“PHP’
\’To print1echo”X\ian”X’ian
\nNew lineecho “BVM \nHSS”BVM HSS
\tTo print tabecho”BVM\tHSS”BVM HSS
\rPrint carriage return
\$To printsecho”100\$”100$
\\To print \echo”\\n is used as newline”\n is used as new line

Control Structures in PHP

In general the execution of the program is sequential, we can change the normal execution by using the control structures.

simple if

Syntax:

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 9

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 10

The first expression evaluated and selects the statements with matched case value.

Loops in PHP

a) while loop
It is an entry controlled loop The syntax is given below
Loop variable initialised
while(expression)

{
Body of the loop;
Update loop variable;
}

b) do-while loop
This loop will execute at least once. The body of the loop will be executed until the expression becomes false,

do
{
Body of the loop;
Update loop variable;
}while(expression);

* for loop
The syntax of for loop is given below For(initialisation; testing; updation)

{
Body of the for loop;
}

continue and break in loops Continue is used to skip one iteration and continue the loop with next value. But break is used to terminate the execution of the current control structure such as for, for each, while, do while or switch.

Arrays in PHP

In PHP array is a collection of key and value pairs. Unlike C++, in PHP we can use either non negative integers or strings as keys.

Different types of arrays in PHP

  • Indexed arrays
  • Associate arrays
  • Multi dimensional arrays.

Indexed arrays-: The elements in an array can be distinguished as first or second or third etc. by the indices and the index of the first element is zero. In PHPthe function arrayO is used to create an array.
Syntax: $array_name=array(value1 ,value2, );
OR
$array_variable[key]=value;
Eg:$mark=array(60,70,80);
$course=amay(“Science”,”Commence”,”Humanities’);
OR
$mark[0]=60;
$mark[1]=70;
$mark[2]=80;
$course=”Science”;
$course=”Commerce”;
$course=”Humanities”;
Eg:
<!DOCTYPE HTML>
<html lang=”eii”>
<head>
<title>
We are learning PHP
</title>
</head>
<body bgcoior=”cyan”>
<?php
$course=amay(“Science”, “Commerce”,”Humanities’);
for($i=0;$i<3;$i++)
echo $course[$i].”,”;
?>
</body>
</html>
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 12

The function print_r can be used for printing an array.
Syntax: print_r(array_name);

Eg:
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 60

Associative arrays

Arrays with named keys and string indices are called associative jarrays.
Syntax: $varibale_name=array(key1=>value1, key2=>value2,etc);

Eg:
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 15
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 16

for each loops (Extension of for loop)

The number of elements in an array is not known in advance foreach loop is used. Two types

1) for ($array_variable_name as $value)
No need to specify the starting inde and ending index, the array pointer is moved one by one.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 17
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 18

b) foreach($array_variable_name as key=> $value)
Here the value of the current array element is assigned to $value and the key is assigned to $key.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 19
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 20

FunctionsinPHP

Two types user defined and built in functions.

User-defined functions

The key word function is used to declare a function in PHP.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 21
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 22
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 23

Built-in functions

a) Date() -:Returns date and time.
Syntax: date(format[, timestamp]);

FormatPurpose
dday of the month(0-31)
mmonth(1-12)
Yyear
Iday of the week(Eg.Monday)

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 24

b) String functions

  • chr()-: Returns a character corresponding to the ASCI I. Eg. chr(ascii value);
  • strlen()- Returns the number of characters in a string strlen(string);
  • strops()- Returns the position of the first occurrence of a string inside another string. strpos(main string, substring, start position);
  • strcmp()- Compares two stings, strcm p(stri ng 1 ,stri ng2);

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 25
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 26

Three tier architecture in PHP

Tier 1 (Front end Tool): Browser/ Client uses HTML or HTML embedded with JavaScript.
Tier 2 (Middle end Tool)- Web Server(Apache /Microsoft IIS)
Tier 3 (Back end Tool)-Database(MySQL/Oracle) This means end user uses Browser(Tier 1) and send requests to the Web Server(Tier 2). The Web Server retrieves data from the Data Base(Tier 3). For this activities user interface, application programs, data storage etc are separated into layers(Tiers)

PHP forms

This is used to collect information from the client and send it to the Web Server by pressing the submit button. The server receives the data and collects the appropriate data from the data base and send it back as a response.

PHP global variables

A variable declared as global then it can be accessed from any where in the program.

  • Superglobal arrays : This is a special variable – available to all programs.
SuperglobalPurpose
SGLOBALSGlobal scope variables available. .
$_SERVERInformation about the server
$_GETData passed using the HTTP GET method
$_POSTData passed using the HTTP POST method
$_REQUESTData passed via HTTP request
$_FILESData passed by an HTML file input
$_SESSIONCurrent session data specific to the user
$_COOKIEData stored on the browser.

A) PHP$GLOBALS
PHP stores all global variables in an arräy calied $GLOBALS[index].
Index is the name of the variable.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 27
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 28
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 29

B) PHP $_SERVER
This returns the paths and script locations.

CodeDescription
$_SERVER [‘PHP_SELF]Returns the currently executing file name
$_SERVER [‘SERVER_NAME’]Returns the host server name
$_SERVER [‘SCRIPT_NAME’]same as $_SERVER[‘PHP_SELF’]

Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 30
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 31

C) PHP $_REQUEST
When a user click a submit button, $_REQUEST gathers all data. $_REQUEST is an array that contains $_GET, $_POST and $_cookie superglobals.

D) PHP $_POST
When the user presses the submit button and the method=post then the data is passed to the server and we can access the data by using the variable $_POST[‘variable name’];

E) PHP S_GET
When the user presses the submit button and the method=get then the data is passed to the seÑer and we can access the data by using the variable $_GET[’vanable namel;

GET and POST comparison

The difference between GET and POST method is given below.

Get methodPost method
1. Faster1. Slower
2. To send small volume of data.2. To send large volume of data
3. Up to 2000 characters3. No limit
4. Less secure4. More secure
5. Data visible during submission5. Data not visible during submission
6. Page link can be book marked6. Page link can never be book marked.

Connecting PHP to database(MySQL)

Establishing connection to MySQL database

To access data from the data base, the PHP program first establish a connection to the data base server(MySQL) and then specify the data base to use.Consider the following

  • Open a connection to MySQL.
  • Secify the data base we want to open.
  • Retrieve data from or insert data in to dat base.
  • Close the connection.

Step 1
Open a connection to MySQL
For this rnysql_connect function is used. A link identifier is returned when connected successfully otherwise a NULL value.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 32
echo connected Successfully’;
mysql_dose($dbhandle);
?>

Note : In the above specify the password you given in MVSQL installation.

The out put is as given below.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 33

Step 2
Specify the data base you want to open
MySQL server may contain many data bases. mysql_select_db() is a function used to select particular data base. It return true if it finds the data base otherwise false.
Syntax: mysql_select_db($database);

Eg:
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 34
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 35

Step 3
Reading data from data base
Two steps

a) Execute the SQL query on the data base using the function mysql_query()
Syntax:
$result_set=mysql_query(query,connection);

b) Insert a row using the function mysql_fetch_array()
Sresult_set=mysql_query(query, connection);
$fetched_row=mysql_fetch_array($result_set);

Example 1 :
Let us do the following program The structure of a table is given to store the details of marks scored by students in an exam

DataTypeDescription
RegNoNumericUnique
namecharupto 30 characters
coursechar
marks of 6 subjectsnumericsix separate columns

Write SQL statements for the creation of the table and the following requirements.

Step 1.
For this take MySQL and do the following
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 36

a) Insert data into the fields(min 3 records)
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 37

b) Display the details of all students.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 38

Step 2:
Take a notepad and type the following then save it asform1.html

<html>
<body>
<form method-’post” action=”dbsample3.php”>
<center>RegisterNo:
<inputtype=”text” name=”regno”><br>
<input type=”submit” value=”Show Result”>
</center>
</form>
</body>
</html>

Step 3.
Take another notepad then type the following and save itasdbsampleS.php
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 41
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 42
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 43

Step 4.
Run the file forml .html and do the following
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 44

Example 2

Step 1.
Take a notepad and type the following. Save it as form2.html.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 45

Step 2
Take another notepad then type the following and save it as dbsample4.php
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 46
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 47
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 48

Step 3.
Run the file form2.html and do the following
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 49

Creating a new table using PHP

It is possible to create a new table using PHP.
Syntax: $SQL=”create table <table name> (column_name1 data type constraint,etc)”; $select_query=mysql_query($SQL);

Eg:
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 50
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 51
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 52

Inserting data into a table using PHP

It is also possible to insert values in to a table using PHP program

Syntax:
$SQL=”insert into <table name> values (valuel, value2,…);
$select_query=mysql_query($SQL);

Ex:
Step 1.
Take a notepad .then type the following and save it asform3.html
<html>
<body>
<form method-’post” action-’table2.php”>
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 54

Step 2.
Take another notepad and type the following then save it as table2.php.
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 55

Step 3.
Run the file form3.html and do the following
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 56
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 57

Updating data in a table using PHP

It is also possible to change or update values in a row by using PHP.
$SQL=”Update ctable_name> set ccolumn_name>= new_value where condition.
$select_query=mysql_query($SQL);

Ex:
If you want to change the amount deposited by Jose from 2000 to 3000. Do the following.

Step 1.
Take a notepad, then type the following and save it asform3.html
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 58
Plus Two Computer Science Notes Chapter 10 Server Side Scripting Using PHP 59

Plus Two Computer Science Notes