iT-Professional Arvind: 2017

Saturday, May 27, 2017

JDBC Connectivity With MySQL

Friday, May 26, 2017

PHP(Hyper Text Preprocessor)

PHP

PHP for beginners and professionals provides deep knowledge of PHP scripting language. Our PHP tutorial will help you to learn PHP scripting language easily. This PHP tutorial covers all the topics of PHP such as introduction, control statements, functions, array, string, file handling, form handling, regular expression, date and time, object-oriented programming in PHP, math, PHP mysql, PHP with ajax, PHP with jquery and PHP with XML.

What is PHP

PHP stands for HyperText Preprocessor.
PHP is an interpreted language, i.e. there is no need for compilation.
PHP is a server side scripting language.
PHP is faster than other scripting language e.g. asp and jsp.

PHP Example

In this tutorial, you will get a lot of PHP examples to understand the topic well. The PHP file must be save with .php extension. Let's see a simple PHP example.

File: hello.php

1. <!DOCTYPE>

2. <html>

3. <body>

4. <?php

5. echo "<h2>Hello by PHP</h2>";

6. ?>

7. </body>

8. </html>

PHP Features

There are given many features of PHP.

Performance: Script written in PHP executes much faster then those scripts written in other languages such as JSP & ASP.
Open Source Software: PHP source code is free available on the web, you can developed all the version of PHP according to your requirement without paying any cost.
Platform Independent: PHP are available for WINDOWS, MAC, LINUX & UNIX operating system. A PHP application developed in one OS can be easily executed in other OS also.
Compatibility: PHP is compatible with almost all local servers used today like Apache, IIS etc.
Embedded: PHP code can be easily embedded within HTML tags and script.

Install PHP

To install PHP, we will suggest you to install AMP (Apache, MySQL, PHP) software stack. It is available for all operating systems. There are many AMP options available in the market that are given below:

WAMP for Windows
LAMP for Linux
MAMP for Mac
SAMP for Solaris
FAMP for FreeBSD
XAMPP (Cross, Apache, MySQL, PHP, Perl) for Cross Platform: It includes some other components too such as FileZilla, OpenSSL, Webalizer, OpenSSL, Mercury Mail etc.

MySql

MySQL

1. Database Fundamentals:

· What is a database? & What is SQL?

· MySQL Introduction

2. Database Design

· What is Normalization?

· What is ER (Entity-relationship) Modeling?

3. MySQL Basic:

· MySQL Create Database & MySQL Data Types

· MySQL SELECT Statment with Examples

· MySQL WHERE Clause with Examples - AND, OR, IN, NOT IN

· MySQL query INSERT INTO Table with Examples

· MySQL UPDATE & DELETE Query with Example

4. Data Sorting:

· Sorting in MySQL : ORDER BY, DESC and ASC
· MySQL GROUP BY and HAVING Clause
· MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ )

MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT
. MySQL IS NULL & IS NOT NULL
. MySQL AUTO_INCREMENT with Examples
. MYSQL - ALTER, DROP, RENAME, MODIFY
. MySQL LIMIT & OFFSET
MySQL SubQuery with Examples
MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
. MySQL UNION
. Views in MySQL Tutorial: Create & Drop with Examples
. MySQL INDEXES - Create, Drop & Add Index

15. Mysql Transactions:

· COMMIT and ROLLBACK
.Date/Time Functions & SQL Date/Time Types

17.Mathematical Functions

MOD()	Returns the remainder
LN()	Returns the natural logarithm of the argument
LOG10()	Returns the base-10 logarithm of the argument
LOG2()	Returns the base-2 logarithm of the argument
LOG()	Returns the natural logarithm of the first argument
-	Minus operator
%	Modulo operator
PI()	Returns the value of pi
+	Addition operator
POW(), POWER()	Returns the argument raised to the specified power
RADIANS()	Returns argument converted to radians
RAND()	Returns a random floating-point value
ROUND()	Rounds the argument
SIGN()	Returns the sign of the argument
SIN()	Returns the sine of the argument
SQRT()	Returns the square root of the argument

Saturday, May 20, 2017

Html5

HTML5 Tutorial

HTML5 provides details of all 40+ HTML tags including audio, video, header, footer, data, datalist, article etc. This HTML tutorial is designed for beginners and professionals.

HTML5 is a next version of HTML. Here, you will get some brand new features which will make HTML much easier. These new introducing features make your website layout clearer to both website designers and users. There are some elements like <header>, <footer>, <nav> and <article> that define the layout of a website.

Why use HTML5

It is enriched with advance features which makes it easy and interactive for designer/developer and users.

It allows you to play a video and audio file.

It allows you to draw on a canvas.

It facilitate you to design better forms and build web applications that work offline.

It provides you advance features for that you would normally have to write JavaScript to do.

The most important reason to use HTML 5 is, we believe it is not going anywhere. It will be here to serve for a long time according to W3C recommendation.

HTML History

Since the early days of the World Wide Web, there have been many versions of HTML:

Year                          Version

1989                           Tim Berners-Lee invented www

1991                           Tim Berners-Lee invented HTML

1993                           Dave Raggett drafted HTML+

1995                           HTML Working Group defined HTML 2.0

1997                           W3C Recommendation: HTML 3.2

1999                           W3C Recommendation: HTML 4.01

2000                           W3C Recommendation: XHTML 1.0

2008                           WHATWG HTML5 First Public Draft

2012                           WHATWG HTML5 Living Standard

2014                           W3C Recommendation: HTML5

2016                           W3C Candidate Recommendation: HTML 5.1

From 1991 to 1999, HTML developed from version 1 to version 4.

In year 2000, the World Wide Web Consortium (W3C) recommended XHTML 1.0. The XHTML syntax was strict, and the developers were forced to write valid and "well-formed" code.

In 2004, W3C's decided to close down the development of HTML, in favor of XHTML.

In 2004, WHATWG (Web Hypertext Application Technology Working Group) was formed. The WHATWG wanted to develop HTML, consistent with how the web was used, while being backward    compatible with older versions of HTML.

In 2004 - 2006, the WHATWG gained support by the major browser vendors.

In 2006, W3C announced that they would support WHATWG.

In 2008, the first HTML5 public draft was released.

In 2012, WHATWG and W3C decided on a separation:

What is New in HTML5?

The DOCTYPE declaration for HTML5 is very simple:

<!DOCTYPE html>

The character encoding (charset) declaration is also very simple:

<meta charset="UTF-8">

HTML5 Example:

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Title of the document</title>
</head>

<body>
Content of the document......
</body>

</html>

The default character encoding in HTML5 is UTF-8.

New HTML5 Elements

The most interesting new HTML5 elements are:

New semantic elements like <header>, <footer>, <article>, and <section>.

New attributes of form elements like number, date, time, calendar, and range.

New graphic elements: <svg> and <canvas>.

New multimedia elements: <audio> and <video>.

HTML 5 Example

Let's see a simple example of HTML5.

1.    <!DOCTYPE>

2.    <html>

3.    <body>

4.    <h1>Write Your First Heading</h1>

5.    <p>Write Your First Paragraph.</p>

6.    </body>

7.    </html>

List of HTML 5 Tags

Tag

Description

<article>

This element is used to define an independent piece of content in a document, that may be a blog, a magazine or a newspaper article.

<aside>

It specifies that article is slightly related to the rest of the whole page.

<audio>

It is used to play audio file in HTML.

<bdi>

The bdi stands for bi-directional isolation. It isolates a part of text that is formatted in other direction from the outside text document.

<canvas>

It is used to draw canvas.

<data>

It provides machine readable version of its data.

<datalist>

It provides auto complete feature for textfield.

<details>

It specifies the additional information or controls required by user.

<dialog>

It defines a window or a dialog box.

<figcaption>

It is used to define a caption for a <figure> element.

<figure>

It defines a self-contained content like photos, diagrams etc.

<footer>

It defines a footer for a section.

<header>

It defines a header for a section.

<main>

It defines the main content of a document.

<mark>

It specifies the marked or highlighted content.

<menuitem>

It defines a command that the user can invoke from a popup menu.

<meter>

It is used to measure the scalar value within a given range.

<nav>

It is used to define the navigation link in the document.

<progress>

It specifies the progress of the task.

<rp>

It defines what to show in browser that don't support ruby annotation.

<rt>

It defines an explanation/pronunciation of characters.

<ruby>

It defines ruby annotation along with <rp> and <rt>.

<section>

It defines a section in the document.

<summary>

It specifies a visible heading for <detailed> element.

<svg>

It is used to display shapes.

<time>

It is used to define a date/time.

<video>

It is used to play video file in HTML.

<wbr>

It defines a possible line break.

Tag	Description
<article>	This element is used to define an independent piece of content in a document, that may be a blog, a magazine or a newspaper article.
<aside>	It specifies that article is slightly related to the rest of the whole page.
<audio>	It is used to play audio file in HTML.
<bdi>	The bdi stands for bi-directional isolation. It isolates a part of text that is formatted in other direction from the outside text document.
<canvas>	It is used to draw canvas.
<data>	It provides machine readable version of its data.
<datalist>	It provides auto complete feature for textfield.
<details>	It specifies the additional information or controls required by user.
<dialog>	It defines a window or a dialog box.
<figcaption>	It is used to define a caption for a <figure> element.
<figure>	It defines a self-contained content like photos, diagrams etc.
<footer>	It defines a footer for a section.
<header>	It defines a header for a section.
<main>	It defines the main content of a document.
<mark>	It specifies the marked or highlighted content.
<menuitem>	It defines a command that the user can invoke from a popup menu.
<meter>	It is used to measure the scalar value within a given range.
<nav>	It is used to define the navigation link in the document.
<progress>	It specifies the progress of the task.
<rp>	It defines what to show in browser that don't support ruby annotation.
<rt>	It defines an explanation/pronunciation of characters.
<ruby>	It defines ruby annotation along with <rp> and <rt>.
<section>	It defines a section in the document.
<summary>	It specifies a visible heading for <detailed> element.
<svg>	It is used to display shapes.
<time>	It is used to define a date/time.
<video>	It is used to play video file in HTML.
<wbr>	It defines a possible line break.

top menu