Computer Technology Information

Showing posts with label web. Show all posts

Sunday, May 01, 2016

Select Distinct Column Name From Database Mysql Query

Following are the query mention below to select distinct column from the database table in Mysql.

SELECT DISTINCT column_name FROM table_name;

For example you have column in a table which have duplicate result but you want to show only distinct result from the duplication of the columns.

Sunday, January 12, 2014

What is JavaScript and How to Enable JavaScript In Google Chrome

What is JavaScript?

Java Script is Client Side Programming Language used for reducing the server load by adding information at client side.

To Enable JavaScript in your browser, follow these instructions:
Open Google Chrome Web Browser then customize setting and select setting
In setting select "Show advanced setting"
Then select privacy Tab Click on "Content Setting"

Then a dialog window will open Look at "JavaScript" section and then Allow "All Sites To Run JavaScript(Recommended)"
Click ok to save setting and then close it.
Then Close setting tab and close web browser.
Now, Open the browser and open page it will run JavaScript of the webpages.
It's the Simple way to Enable JavaScript in Google Chrome.

Saturday, January 11, 2014

HTML First HELLO WORLD Page

HTML is a Markup Language used to develop static page on the web.It's very simple and Easy Markup Language.To Develop a simple HTML page you require a text editor and a web browser to run and display a Web Page.

HTML Text Editor:

NotePad (Notepad++)
Microsoft FrontPage
Adobe Dream Weaver

HTML Support All Web Browser.

First HTML Sample Page

Code:
<html>
<head>
<title> HELLO WORLD </title>
</head>
<body>
<h1 align="center"><font color="blue" >HELLO WORLD </font></h1>
</body>
</html>

Write that upper code into notepad or dream weaver software and save this with .html or .html extension.
paste your page path on the web browser e.g C:/Users/Desktop/ComputerInformationTechnology.html and see your first hello world page on the WEB.

HTML is used to define the Structure of the Web Page.It's most usually used markup language on the Web.

Learn CSS (Cascading Style Sheet)

What is CSS?

CSS stands for Cascading Style Sheet.Cascading style sheet is used for styling the HTML Tags or Element.
HTML 4.0 provide facility to work with CSS.
There are three ways to add CSS in HTML

Inline Cascading Style Sheet
Internal Cascading Style Sheet
External Cascading Style Sheet

Inline Cascading Style Sheet is most power full and it's written in the HTML tag e.g <p style='color="red"'></p>.It mean in paragraph font color is red.

Internal Cascading Style Sheet is written on the head tag of the HTML page.It is less powerful then inline and More power full then External Cascading Style Sheet.e.g
<Head>
<style>
p { color: red;}
/* Comment in CSS */
</style>
</Head>
It also mean color of paragraph in HTML code is Red.

External Cascading Style Sheet is used externally by making a separate file with .css extension. we can add this file into the head tag of the HTML page.e.g.
<Head>
<link rel="stylesheet" type="text/css" href="compinfotechnology.css">
</Head>

Friday, January 10, 2014

Learn HTML (Make Your Own Static Web Page)

What is HTML?

HTML stands for Hyper Text Markup Language is a pure markup language which is used to develop static pages on the web.It's not a programming language and also it's not case sensitive language.HTML is a widely used markup language.
HTML Main Syntax:
<HTML> Starting Tag of HTML

<HEAD>
<TITLE>In the title tag we write title of the website which is shown on the web browser tab</TITLE>
</HEAD>
<BODY>

MY First Page IN HTML
In The Body of HTML we can make header footer content of the website or a webpage.We use HTML tag i.e <h1>For Heading</h1><p> For Paragraph </p> <li> For listing </li> etc.
</BODY>

</HTML>Ending Tag of HTML

HTML syntax is like human body first head then body.Head tells body to perform.We save HTML file with .HTML or .HTM extensions eg compinfotechnology.html or compinfotechnology.htm.This is all about making a Simple HTML Page.

Learn About Web Development

Web Development is a term that means making you own website on the web.You can make you own websites using web languages easily.There are two types of websites exists on the web.

1.Static (HTML,CSS)
2.Dynamic (PHP,Java,ASP.NET etc)

Static Websites are simple like a single page which does not involve any Server e.g. like a simple page which cannot involve any change from outside server.This Blog is also Example .Database is not involve in static websites.HTML (Hyper Text Markup Language) is basis for making static pages and CSS(Cascading Style Sheet) is used for styling HTML tags.

Dynamic Websites are like Google+ , Facebook which involves changes in webpages.Dynamic websites have a server and a database is working on backend of the websites.Dynamic Websites are high quality and interactive websites and most popular and mostly used websites.PHP (Hypertext Preprocessor),Java and ASP.NET Programming Languages are Use to Develop Dynamic Websites.

Pages