Php Training Report

(1)

A

REPORT

ON

PHP&MYSQL

ELPIS TECNOLOGIES

Submitted to

Department of Computer Science & Engineering

In partial fulfilment of the requirements

For the degree of

BACHELOR OF TECHNOLOGY

IN

COMPUTER SCIENCE

By

VIKAS YADAV

Roll No.0924010126

Under the guidance of

Mrs Payal Kansal

(2)

DECLARATION

We hereby declare that this submission is our own work and that, to the best of our

knowledge and belief, it contains no material previously published or written by another neither person nor material which to a substantial extent has been accepted for the award of any other degree or diploma of the university or other institute of higher learning, except where due acknowledgment has been made in the next.

Name : Vikas Yadav Roll No.: 092410126 Date : 11/11/13

(3)

ACKNOWLEDGEMENT

I take this opportunity to bestow, form my heart, my deep sense of gratitude and indebtedness to my

Mrs. Payal Kansal for her valuable and continuous encouragement. I am grateful to her for her

tireless and consistent supervision and help she rendered to me throughout the course of my experimentation and subsequently in my preparation of this dissertation. I am thankful to DEV SIR CEO of ELPIS TECNOLOGIES. , for their unconditional and most willing support during preparation of the project report.

VIKAS YADAV SDEC GHAZIABAD

(4)

ABOUT THE TRAINING

During Industrial Training at ELPIS TECNOLOGIES NOIDA, I studied about Php & Mysql and its basics.

(5)

Chapter Title Page no.

Certificate 1

Copy of training certificate 2

Declaration 3 Acknowledgement 4 About Training 5 Table of Contents 6 Abstract 7

1.INTRODUCTION 8

Some Basics 9 Operators Syntax Arrays 10 Functions

2.HTML 12

Heading Title Paragraph 13

3.MYSQL 14

Data base Sql and/or operators RDBMS

4. Inroduction to PHP 15

5. Conclusion

17

6. Refrence

18

(6)

Abstract

PHP 5 introduces abstract classes and methods. Classes defined as abstract may not be instantiated, and any class that contains at least one abstract method must also be abstract. Methods defined as abstract simply declare the method's signature - they cannot define the implementation. When inheriting from an abstract class, all methods marked abstract in the parent's class declaration must be defined by the child; additionally, these methods must be defined with the same (or a less restricted) visibility. For example, if the abstract method is defined as protected, the function implementation must be defined as either protected or public, but not private. Furthermore the signatures of the methods must match, i.e. the type hints and the number of required arguments must be the same. For example, if the child class defines an optional argument, where the abstract method's signature does not, there is no conflict in the signature. This also applies to constructors as of PHP 5.4. Before 5.4 constructor signatures could differ. That’s the theory for defining a regular class in PHP, so let’s go one step further and ask ourselves: what’s an abstract class? In the simplest sense, an abstract class is a class that cannot (and should not) be instantiated. This may sound a little illogical for beginning programmers, but there are situations where this concept makes a lot of sense. Anyone who has spent considerable time using the object model provided by PHP 4 knows what a class is, but just in case you’ve forgotten this concept, let’s go over the basics quickly. In PHP a class is merely a set of statements that perform a specific task, and its definition contains both properties and methods, which act as the blueprint from which to create –- or instantiate -– independent objects.

(7)

CHAPTER-1

Introduction

PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. PHP is now installed on more than 244 million websites and 2.1 million web servers. Originally created by Rasmus Lerdorf in 1995, the reference implementation of PHP is now produced by The PHP Group. While PHP originally stood for Personal Home Page, it now stands for PHP: Hypertext Preprocessor, a recursive acronym. PHP code is interpreted by a web server with a PHP processor module, which generates the resulting web page: PHP commands can be embedded directly into an HTML source document rather than calling an external file to process data. It has also evolved to include a command-line interface capability and can be used in standalone graphical applications. PHP is free software released under the PHP License, which is incompatible with the GNU General Public License (GPL) due to restrictions on the usage of the term PHP. PHP can be deployed on most web servers and also as a standalone shell on almost every operating system and platform, free of charge. PHP is an acronym for "PHP Hypertext Pre-processor” PHP is a widely-used, open source scripting language PHP scripts are executed on the server PHP costs nothing, it is free to download and use

(8)

Some Basics:

PHP is a scripting language – it gets interpreted instead of being compiled like C++ and Java. Unlike JavaScript which is executed by the web browser, all PHP code is executed on the web server. The syntax is very similar to Perl and C. Variables are case sensitive, function names are not, and statements must be terminated with a semicolon. PHP code should be placed between <? Code?> or <? Php code?> tags. The second method is preferred so your scripts are XML compatible. There is no limitation as to where PHP code can be inserted. To see information about how PHP is configured, version information, and the settings of all environment variables (e.g., HTTP_USER_AGENT and QUERY_STRING), call the phpinfo () function in any script. The php.ini file is the main configuration file for PHP. It can be edited by the system administrator to change any of the configuration settings. A change to this file requires the web server be restarted since the file is only read once when the web server starts up. (The phpinfo() function reports the location of

Operators:

A. Assignment

1. = += -= /= *= %= ++ -- - like most programming languages. 2. .= - string concatenation operator (see strings section). B. Arithmetic

1. + - * / % - like most programming languages. C. Comparison

1. == != < > <= >= - like most programming languages. Also <> is the same as !=. 2. === - true if arguments are equal and the same data type.

3. !== - true if arguments are not equal or they are not of the same data type. D. Logical

1. && || ! - like most programming languages (&& and || short-circuit) 2. and or - like && and || but have lower precedence than && and ||. 3. xor - true if either (but not both) of its arguments are true.

Syntax:

A PHP script can be placed anywhere in the document. A PHP script starts with <?php and ends with ?>:

(9)

Arrays:

A. Summary of all array functions in the PHP core:

B. Arrays can have any size and contain any type of value. No danger of going beyond array bounds.

$my array [0] = 25; $my array [1] = "Bisons";

C. PHP arrays are associative arrays which allow element values to be stored in relation to a key value

Rather than a strict linear index order. $capitals ["CO"] = "Denver";

$capitals ["AR"] = "Little Rock"; 6 D. Initialize an array:

$colors = array ("red", "green", "blue");

Print ("The 2nd color is $colors[1]."); // prints green

$capitals = array ("CO" => "Denver", "AR" => "Little Rock"); Print ("$capitals [CO]"); // prints Denver, no quotes around key i

Functions:

A. Functions may be declared anywhere in the source code (i.e., they do not need to be defined before they

are called as C++ requires).

B. Function names are case-insensitive, though it is usually good form to call functions as they appear in their

(10)

1. General form:

Function func_name ($param_1, $param_2, ..., $param_n) { // code

Return $retval; // optional: can return a scalar or an array }

2. Call: $result = func_name ($arg1, $arg2, ..., $argn);

(11)

CHAPTER-2

Html:

HTML (Hyper Text Mark up Language) is a language for specifying how text and graphics appear on a web page When you visit a web site (e.g., www.google.com)your web browser retrieves the HTML web page and renders it The HTML page is actually stored on the computer that is hosting the web site and the page is sent to your browser To see what HTML looks like go to your web browser View menu and select View Source. HTML is written in the form of HTML elements consisting of tags enclosed in angle brackets (like <html>), within the web page content. HTML tags most commonly come in pairs like <h1> and </h1>, although some tags represent empty elements and so are unpaired, for example <img>. The first tag in a pair is the start tag, and the second tag is the end tag (they are also called opening tags and closing tags). In between these tags web designers can add text, further tags, comments and other types of text-based content.

Headings:

HTML allows you to create sections in a document using Headings, there are six levels of headings

The ﬁrst level creates the most signiﬁcant heading, e.g., <H1> this is a major section </H1>

And the sixth level creates the least signiﬁcant heading, e.g.,

<H6> this is a minor section </H6> after each heading you insert the text and images that Pertain to that section, like you would do in MS Word

Title:

A title is usually displayed on the top bar of a web browser’s window when you visit a web

(12)

Site The title will now be displayed in the main web browser window, just on the top bar <Title> Your title text goes here </title> <title> is the start tag and </title> is the end tag

Paragraph:

The <p> tag is used to start a paragraph the </p> tag is used to end a paragraph <p> the text in between the two tags is your paragraph ... </p> the </p> tag is optional, HTML assumes that

You are in the same paragraph until it encounters the next <p> tag you can force a line break using the <by> tag

Body:

<Title> Your title goes here </title> </head>

<Body>

Your content goes here ... Paragraphs, images, Lists, links, texts, headings, etc.

</body> </html>

(13)

CHAPTER-3

Mysql:

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons: MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.

Data base:

A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds. Other kinds of data stores can be used, such as files on the file system or large hash tables in memory but data fetching and writing would not be so fast and easy with those types of systems.

Sql and &or operators:

The AND operator displays a record if both the first condition AND the second condition are true. The OR operator displays a record if either the first condition OR the second condition is true.

Rdbms:

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.

(14)

CHEPTER-4

Introduction to PHP

What You Should Already Know

Before you continue you should have a basic understanding of the following:

 HTML

 CSS

 JavaScript

If you want to study these subjects first, find the tutorials on our Home page.

What is PHP?

 PHP is an acronym for "PHP Hypertext Preprocessor"  PHP is a widely-used, open source scripting language  PHP scripts are executed on the server

 PHP costs nothing, it is free to download and use

What is a PHP File?

 PHP files can contain text, HTML, CSS, JavaScript, and PHP code

 PHP code are executed on the server, and the result is returned to the

browser as plain HTML

 PHP files have extension ".php"

What Can PHP Do?

 PHP can generate dynamic page content

 PHP can create, open, read, write, and close files on the server  PHP can collect form data

 PHP can send and receive cookies

 PHP can add, delete, modify data in your database

 PHP can restrict users to access some pages on your website  PHP can encrypt data

With PHP you are not limited to output HTML. You can output images, PDF files, and even Flash movies. You can also output any text, such as XHTML and XML.

(15)

Why PHP?

 PHP runs on various platforms (Windows, Linux, Unix, Mac OS X, etc.)  PHP is compatible with almost all servers used today (Apache, IIS, etc.)  PHP supports a wide range of databases

 PHP is free. Download it from the official PHP resource: www.php.net  PHP is easy to learn and runs efficiently on the server side

(16)

CHEPTER-5

Conclusion:

PHP is a great tool for writing dynamic web pages. Non-technical users can easily learn a few handy tricks to make their web pages easier to manage, and more useful. Because its syntax resembles most C-like languages, any Computer Science student is able to learn it very quickly. When creating a PHP enhanced pages, there are a few things we must remember.PHP is a server side technology, and does not work in a browser. The filename must have .php extension.PHP enhanced pages can contain a mixture of HTML and PHP code.PHP code must be enclosed in <?php?> tag. For more PHP information and tips, please visit php.net, or do a web search. You'll find tons of PHP-related material. Happy coding! Do you want your Perl code on one server to call

your PHP functions on another? "Impossible!" you say? Not with XML-RPC. XML-RPC is a standard way for any application to make requests and receive responses from methods write