Post on 13-Apr-2017
WEB TECHNOLOGY USING HTML5 WITH PHP AND MYSQL-BY N.DURAIARASAN CMS & CTS MADURAI
NEED OF WEB APPLICATIONS Web applications have revolutionized the way a
business isconducted or day-to-day tasks are performed.
These applications enable organizations and individuals to share and access information from anywhere and at any time.
With the phenomenal advent of open source products owing to low development cost and customizable source code,
HTML5, PHP & MYSQL is fast emerging as the highly preferred scripting languages for developing Web Applications.
HTML AND HTML 5 HTML is the markup
language used by web developers to create web [ages. It is written in the format of HTML elements containing tags bracketed in angle brackets like ‘<html>’
HTML elements form the structure blocks of all websites.
Web browsers don’t display HTML tags and scripts, but use them to interpret the content of the page.
HTML5 is the fifth version of HTML and complete version of HTML standard of the WWW (World Wide Web Consortium)
The aim of HTML5 is to improve the language by support of latest multimedia while keeping it user friendly and easily readable by humans and consistently understood by computers and devices such as web browsers
WHAT IS IN HTML 5These the portion include in the 5th version of HTML5. They are.
HTMLCSS
JAVASCRIPT JQUERYCANVAS
GEO LOCATION HTML5 is attempting to discover and codify this error handling, so that browser developers can all standardize and greatly reduce the time and money
CSS Cascading Style Sheets (CSS) provide easy
and effective alternatives to specify various attributes for the HTML tags.
Using CSS, you can specify a number of style properties for a given HTML element.
Each property has a name and a value, separated by a colon (:). Each property declaration is separated by a semi-colon (;).
.amazing {border: 1px solid blue;}#surprizing {border: 1px solid blue;}
JAVASCRIPTIt is client side scripting language.
Is used to add dynamism and interactivity to Web pages.
Is an object-based language and treats every element as an object.
Provides various types of built-in objects, which help to make a Web page dynamic and interactive.
A JavaScript will be included in HTML files using <script> tag.
<script>function Hello() { alert("Hello, World"); } </script>
JQUERY Helps in finding, traversing, and manipulating HTML
elements inside an HTMLdocument.
Helps you to animate HTML elements, handle events, and make your applicationsrich and interactive.
CONTROLS LIKE Autocomplete Datepicker Accordion
Can be included by using the following syntax:<script type= "text/javascript"src="@Url.Content("~/Scripts/jquery-1.7.1.js")"></script>
CANVAS canvas element for 2D drawing. It is a vector
graphics is integral part of HTML5 <canvas> - an area you can paint/render as you
like. Mainly used for games. <canvas> Tag : it is used for draw graphic on
web page. <!DOCTYPE> <html> <body> <canvas id="canvasid" width="300"
height="200" style="border:4px solid #F00;"> </canvas> </body> </html>
GEOLOCATION GeoLocation of user browsing any website
especially if it comes to mobile devices. GeoLocation API in HTML5 helps identify
location of user browsing any website (provided user allows it)
Up-to-date local information Showing Points-of-interest near the user Turn-by-turn navigation (GPS) The getCurrentPosition() Method - Return
Data for The latitude, longitude and accuracy properties are always returned.
PHP LANGUAGE PHP is a server-side scripting language
designed primarily for web development but also used as a general-purpose programming language. Originally created by Rasmus Lerdorf in 1994.
The PHP processor only parses code within its delimiters. Anything outside its delimiters is sent directly to the output and not parsed by PHP. The only open/close delimiters allowed by PSR-1[3] are "<?php" and "?>" or <?= and ?>
Eg : <?php echo “display it”; ?>
PHP SYNTAX PHP variables must begin with a “$” sign Case-sensitive ($Foo != $foo != $fOo) /* C-style comments These can span multiple lines */ Syntax Perl- and C-like syntax. Relatively
easy to learn. Large function library Embedded directly into HTML Interpreted, no need to compile Open Source server-side scripting language
designed specifically for the web.
PHP EXAMPLES
PHP Control StructuresPHP Control Structures Control Structures: Are the structures within a language that allow us to control the flow of execution through a program or script. Grouped into conditional (branching) structures (e.g. if/else) and repetition structures (e.g. while loops). Example if/else if/else statement:
if ($foo == 0) {echo ‘The variable foo is equal to 0’;
}else if (($foo > 0) && ($foo <= 5)) {
echo ‘The variable foo is between 1 and 5’;}else {
echo ‘The variable foo is equal to ‘.$foo;}
FUNCTIONSFUNCTIONS
Functions MUST be defined before then can be called
Function headers are of the format
Note that no return type is specified Unlike variables, function names are not case
sensitive (foo(…) == Foo(…) == FoO(…))
function functionName($arg_1, $arg_2, …, $arg_n)
FUNCTIONS EXAMPLEFUNCTIONS EXAMPLE
<?php // This is a function
function foo($arg_1, $arg_2) { $arg_2 = $arg_1 * $arg_2; return $arg_2;}
$result_1 = foo(12, 3); // Store the function echo $result_1; // Outputs 36echo foo(12, 3); // Outputs 36
?>
MYSQL DATABASE PHP can work with various database systems.
MySQL is a popular open-source database system mostly work with PHP.
MySQL is a database system used on the web MySQL is a database system that runs on a server MySQL is ideal for both small and large
applications MySQL is very fast, reliable, and easy to use MySQL uses standard SQL MySQL compiles on a number of platforms MySQL is free to download and useEg:mysql> create table emp(eid int,ename char(43));
MYSQL INSTALLING OS MySQL runs on more than 20 platforms,
giving users the kind of flexibilitythat puts them in control. Windows, Linux and Solaris are the mostpopular operating systems for running MySQL. Versions of MySQL arecurrently available for the following operating systems;• Windows (multiple) • Mac OS/X • SCO• Linux (multiple) • HP-UX • Open BSD• Solaris • IBM AIX • SGI Irix• FreeBSD • QNX • Novell NetWare
PHPMYADMINTHIS IS THE IDE OF MYSQL WORKING
MYSQL + PHP QUERY WITH CODING
THANK YOU