[go: up one dir, main page]
Scribd
Upload
79 views27 pages

PHP Programming

PHP Programming discusses topics related to PHP including its background, installation, comments, variables, conditions, loops, functions, file handling, and database handling. It provides details on how to install PHP, write comments, define variables and functions, use control structures like if/else and loops, handle files, and connect to databases like MySQL.

Uploaded by

avadhanulak
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
79 views27 pages

PHP Programming

PHP Programming discusses topics related to PHP including its background, installation, comments, variables, conditions, loops, functions, file handling, and database handling. It provides details on how to install PHP, write comments, define variables and functions, use control structures like if/else and loops, handle files, and connect to databases like MySQL.

Uploaded by

avadhanulak
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
You are on page 1/ 27

PHP Programming

Topics
• Background and History of PHP
• Installation
• Comments in PHP
• Variables
• Conditions
• Loops
• Functions
• File Handling
• Database Handling (MySQL, MSSQL, ODBC)
Background
• Personal Home Page – C kind of scripts
written in Perl language, by Rasmus
Lerdorf in 1995.
• He called the language as PHP/FI –
Personal Home Page / Forms Interpreter.
• 1997 Version 2.0 was released
• Then came 3.0, 4.0. They were called
PHP simply
• Recent version is PHP 5.2.3
Installation
• Apache server need to be installed first
• The config file for apache server will be present
in the conf folder under the apache installed
directory
• Set the DocumentRoot to the path where the
PHP files will be stored
• Install PHP. Point apache conf directory when it
asks so and select the appropriate web server.
• Move the PHP.ini file to C:\WNDOWS directory
PHP Comments
• All php files are saved with extension .php
• The can be written in notepad or any text
editor
• Single line comment
– // this is single line comment
• Multi line comment
– /*….
This is a multi line comment */
Sample PHP
<html>
<body>
<?php echo “hello”; ?>
</html>

The above program will display hello in the


browser
Variables
• Variables start with a $ symbol
• Variables can contain _ or numbers or
alphabets
• $ should be followed by _ or alphabet and
not by a number
• PHP is loosely typed language. There is
no strict data typing
• Variable can be assigned with any values
Conditions
• If else
if(condn) {….}
elseif(condn) {….}
else { ….}
• Switch case
switch(var)
{
case c1: statements;break
.
.
Default: statements; break;
}
Loops
• For
for(intialisation;condition;increment/decrement)
{ statements }
• While
while(condn) { ….}
• Do While
do {….} while(condn);
Functions and Parameters
• PHP functions need to be defined with key
word function
• It can have zero or more values
(parameters)
• Functions may or may not return values
• If a function need to return value, the last
statement of the function should be return
– return value;
Functions
• Parameter less function
<?php
function sayHi()
{
echo “hi”;
}
?>
This can be called as <?php sayHi(); ?> in the
program
Functions
• Parameterized function
<?php
function greet($name)
{
echo “Hello “ . $name;
}
?>
This can be called <?php greet(‘Ram’);?>
This gives an output Hello Ram
Functions
• Function returning value
<?php
function add($a,$b)
{
return ($a + $b);
}
?>
When called like <?php echo add(1,2);?> we will
get an output 3 in the browser.
File Handling
• This involves 5 tasks
– Opening a file
– Reading data from a file
– Displaying the read data
– Writing contents to another file
– Closing a file
Opening a file
• $fp = fopen(‘filename’,’mode’);
• Eg $fp = fopen(‘c:\abc.txt’,’r’);
– This opens a file abc.txt in read only mode
• Available modes:
– r – read only
– w – write only
– w+ - read write
– A – append – adding to the end
Reading a file
• Several methods are available
– fread(filepointer,no of bytes to read)
– fgetc(filepointer) – Reads character by character
– fgets(filepointer) – Reads line by line
• The read content can be stored in a variable
• $data = fread($fp,10) – this reads 10 characters
from file pointed by file pointer $fp and stores in
$data
• If we want to read characters till end, we need to
use a loop with condition checking for End of File
Writing to file
• We can use echo $data, to print the contents
read from the file to browser
• Or we can open another file in write mode and
put the contents to that file using either of these
methods
– fwrite(filepoiner,data);
– fputc(filepointer,char); - writes character by character
– fputs(filepointer,line); - writes line by line
• Eg - fwrite($fpw,$data);
Closing a file
• feof(fp) – Checks for end of file.
• Returns –1 if EOF is reached. Otherwise
returns 0
• To close a file use fclose(filepointer)
method
• Eg. fclose($fp);
– This closes the file pointed by $fp.
Database Handling
• PHP can connect to
– MySQL
– MSSQL
– Access and other databases like oracle,
postgre sql etc
• There are separate methods available for
connecting to the databases
MySQL and MSSQL
Connection
• mysql_connect(dbserver,userid,password)
• mssql_connect(dbserver,userid,password)
– These methods are used for connecting to MySQL
and MSSQL server using a userid and password
• $con = mysql_connect(‘localhost’,’root’,’root’);
– This gets a connection to the local mysql server using
the credentials root and root
– If server cannot be connected, it will throw an error
stating the problem
• Note: Mysql and MSSQL can be accessed in identical
way except for the preceeding mysql or mssql. So will
use mysql henceforth.
MySQL Select DB
• mysql_select_db(connection,dbname)
• mysql_select_db($con,”test”);
– This will select the db test under the
server localhost
– If unable to select the database, an
error will be thrown
MySQL Execute Query
• mysql_query(connection,sql statement);
• This will execute the sql statement on the
database and store the result in a variable
• Eg
– $rs = mysql_query($con,select stmt);
– The rows of select statement will be stored in $rs
– $row = mysql_fetch_array($rs);
• This will fetch a row and store in $row
• Values can be accessed like - $row[“ID”] – returns value of
column ID in the fetched row.
MySQL and MSSQL Close
• To close a db connection we have close
method
– mysql_close(connection);
– mssql_close(connection);

• Example
– mysql_close($con);
– mssql_close($con);
ODBC Data handling
• Connect to a data source
– odbc_connect(dsn,uname,pwd);
– DSN – Data Source Name
– Go to Control Panel -> Administrative Tools ->
Datasources (ODBC)
– Click on ODBC and select System DSN tab.
– Click Add and choose Access Database
(mdb) and click Finish
– In the dialog that appears, give DSN Name
and Description
ODBC Data handling Contd..
– Click on Select under Database section
– Choose a mdb (access database file) and give
OK

• $conn=odbc_connect('nwind','','');
– Here nwind is the DSN that we have created in
our system to access a database
– We have not given any user name or
password during DSN creation
– So those fields are left empty.
Selecting rows from a table
• $rs = odbc_exec($conn,$sql);
– $conn – connection string
– $sql – SQL query to select rows from table
– $rs is the result set of the query execution
• odbc_fetch_row($rs)
– This command fetches row by row from the result set
• $cid = odbc_result($rs,"CustomerID");
– This command fetches value for the column
CustomerID from the current row and stores it in the
variable $cid.
Closing Connection
• odbc_close(connection)
– This function closes the connection obtained
and releases the same to the connection pool

• odbc_close($conn);
– The connection defined by $conn is released
and no query can be executed using this
connection variable hence forth.

You might also like