Saturday, May 27, 2017

JDBC Connectivity With MySQL




at No comments:

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.


at No comments:

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





at 1 comment:

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.


at No comments:
Subscribe to: Posts (Atom)

JDBC  Connectivity With MySQL

  • Python
    Python Python is a powerful high-level, object-oriented programming language created by Guido van Rossum. It has simple easy-...
  • Html5
    HTML5 Tutorial HTML5   provides details of all 40+ HTML tags including audio, video, header, footer, data, dat...
  • MySql
    MySQL 1.       Database Fundamentals: ·          What is a database? & What is SQL? ·          MySQL Introduction 2.       ...