How to Code

HTML5 New Form Attributes
HTML5 has several new attributes for
and
.
New attributes for
:
autocomplete
novalidate
New attributes for :

autocomplete
autofocus
form
formaction
formenctype
formmethod
formnovalidate
formtarget
height and width
list
min and max
multiple
pattern (regexp)
placeholder
required
step


/
autocomplete Attribute
The autocomplete attribute specifies whether a form or input field should have autocomplete on or off.
When autocomplete is on, the browser automatically complete values based on values that the user has entered before.
Tip:
It is possible to have autocomplete "on" for the form, and "off" for specific input fields, or vice versa.
Note:
The autocomplete attribute works with
and the following
types: text, search, url, tel, email, password, datepickers, range, and color.
Example
An HTML form with autocomplete on (and off for one input field):
First name:
Last name:
E-mail:

Try it yourself �
Tip:
In some browsers you may need to activate the autocomplete function for this to work.
novalidate Attribute
The novalidate attribute is a boolean attribute.
When present, it specifies that the form-data (input) should not be validated when submitted.
Example
Indicates that the form is not to be validated on submit:
E-mail:

Try it yourself �
autofocus Attribute
The autofocus attribute is a boolean attribute.
When present, it specifies that an
element should automatically get focus when the page loads.
Example
Let the "First name" input field automatically get focus when the page loads:
First name:
Try it yourself �
form Attribute
The form attribute specifies one or more forms an
element belongs to.
Tip:
To refer to more than one form, use a space-separated list of form ids.
Example
An input field located outside the HTML form (but still a part of the form):
First name:

Last name:
Try it yourself �
formaction Attribute
The formaction attribute specifies the URL of a file that will process the input control when the form is submitted.
The formaction attribute overrides the action attribute of the
element.
Note:
The formaction attribute is used with type="submit" and type="image".
Example
An HTML form with two submit buttons, with different actions:
First name:
Last name:
value="Submit as admin">

Try it yourself �
formenctype Attribute
The formenctype attribute specifies how the form-data should be encoded when submitting it to the server (only for forms with method="post")
The formenctype attribute overrides the enctype attribute of the
element.
Note:
The formenctype attribute is used with type="submit" and type="image".
Example
Send form-data that is default encoded (the first submit button), and encoded as "multipart/form-data" (the second submit button):
First name:
value="Submit as Multipart/form-data">

Try it yourself �
formmethod Attribute
The formmethod attribute defines the HTTP method for sending form-data to the action URL.
The formmethod attribute overrides the method attribute of the
element.
Note:
The formmethod attribute can be used with type="submit" and type="image".
Example
The second submit button overrides the HTTP method of the form:
First name:
Last name:
value="Submit using POST">

Try it yourself �
formnovalidate Attribute
The novalidate attribute is a boolean attribute.
When present, it specifies that the
element should not be validated when submitted.
The formnovalidate attribute overrides the novalidate attribute of the
element.
Note:
The formnovalidate attribute can be used with type="submit".
Example
A form with two submit buttons (with and without validation):
E-mail:

Try it yourself �
formtarget Attribute
The formtarget attribute specifies a name or a keyword that indicates where to display the response that is received after submitting the form.
The formtarget attribute overrides the target attribute of the
element.
Note:
The formtarget attribute can be used with type="submit" and type="image".
Example
A form with two submit buttons, with different target windows:
First name:
Last name:
value="Submit to a new window">

Try it yourself �
height and width Attributes
The height and width attributes specify the height and width of an
element.
Note:
The height and width attributes are only used with
.
Tip:
Always specify both the height and width attributes for images. If height and width are set, the space required for the image is reserved when the page is loaded. However, without these attributes, the browser does not know the size of the image, and cannot reserve the appropriate space to it. The effect will be that the page layout will change during loading (while the images load).
Example
Define an image as the submit button, with height and width attributes:

Try it yourself �
list Attribute
The list attribute refers to a
element that contains pre-defined options for an
element.
Example
An
element with pre-defined values in a
:


Try it yourself �
min and max Attributes
The min and max attributes specify the minimum and maximum value for an
element. The
TYPE MUST BE NUMBER NOT TEXT
Note:
The min and max attributes works with the following input types: number, range, date, datetime, datetime-local, month, time and week.
Example
elements with min and max values:
Enter a date before 1980-01-01:
Enter a date after 2000-01-01:
Quantity (between 1 and 5):
Try it yourself �
multiple Attribute
The multiple attribute is a boolean attribute.
When present, it specifies that the user is allowed to enter more than one value in the
element.
Note:
The multiple attribute works with the following input types: email, and file.
Example
A file upload field that accepts multiple values:
Select images:
Try it yourself �
pattern Attribute
The pattern attribute specifies a regular expression that the
element's value is checked against.
Note:
The pattern attribute works with the following input types: text, search, url, tel, email, and password.
Tip:
Use the global
title
attribute to describe the pattern to help the user.
Tip:
Learn more about
regular expressions
in our JavaScript tutorial.
Example
An input field that can contain only three letters (no numbers or special characters):
Country code:
Try it yourself �
placeholder Attribute
The placeholder attribute specifies a short hint that describes the expected value of an input field (e.g. a sample value or a short description of the expected format).
The short hint is displayed in the input field before the user enters a value.
Note:
The placeholder attribute works with the following input types: text, search, url, tel, email, and password.
Example
An input field with a placeholder text:

Try it yourself �
required Attribute
The required attribute is a boolean attribute.
When present, it specifies that an input field must be filled out before submitting the form.
Note:
The required attribute works with the following input types: text, search, url, tel, email, password, date pickers, number, checkbox, radio, and file.
Example
A required input field:
Username:
Try it yourself �
step Attribute
The step attribute specifies the legal number intervals for an
element.
Example: if step="3", legal numbers could be -3, 0, 3, 6, etc.
Tip:
The step attribute can be used together with the max and min attributes to create a range of legal values.
Note:
The step attribute works with the following input types: number, range, date, datetime, datetime-local, month, time and week.
Example
An input field with a specified legal number intervals:

Try it yourself �
HTML5
Tag
Tag
Description
Defines an HTML form for user input
Defines an input control

Sample html:




Valid date format: mm/dd/yyyy




The Script:

Back in the day, you'd often see prompts on personal webpages asking for your name. After you typed in the information, you would be greeted with a page that had a welcome message, such as, "Welcome to My Personal WebPage John Schmieger!" (If your name just so happened to be John Schmieger).

The JavaScript prompt is not very useful and many find it slightly annoying, but hey, this tutorial is here to educate you, so let's learn how to make that prompt!

Simple JavaScript Prompt
You can use a prompt for a wide variety of useless tasks, but below we use it for an exceptionally silly task. Our prompt is used to gather the user's name to be displayed in our alert dialogue box.

HTML & JavaScript Code:






Display:

Recap on JavaScript Prompt
It sure is a quick way to gather some information, but it is not as reliable an information gatherer as other options available to you. If you want to find out someone's name and information, the best way to request this information would be through the use of HTML Forms. And if you want to use the information you collected in your website, you might use some PHP to get that job done in a more sophisticated manner.

If you have a select element that looks like this:

test1
test2
test3


Running this code:
var e = document.getElementById("ddlViewBy");
var strUser = e.options[e.selectedIndex].value;

Would make strUser be 2. If what you actually want is test2, then do this:
var e = document.getElementById("ddlViewBy");
var strUser = e.options[e.selectedIndex].text;

Which would make strUser be test2

var e = document.getElementById("ddlViewBy");
var SELIndex = e.selectedIndex
if (SELIndex==0){
error_message = error_message + '*Select something from xx.\n';
error = 1;
}

if you want to see if the select has nothing selected.?


----------------
Clipboard
Customizing
Date
Files
Form
Formatting
Function
Hardware
Ini
Internet
Keyboard
Link
Network
Pdf
Plug-in
Printing
Query
Security
Server
Setup
String
Text Box
Variables
Video



javascript code:
var e = document.getElementById("comoperationid");
var SELIndex = e.selectedIndex
if (SELIndex==0){
error_message = error_message + '*Select something from operationid.\n';
error = 1;
}

Question: When I convert numbers to strings, can I guarantee exactly n decimal places in the resultant string?

Answer: The simplest way of converting a number variable to string is to concatenate the variable with an empty string. However, this conversion does not guarantee the number of decimal places in the string. If you want exactly n decimal places in the conversion result, use the toFixed method, like this:

str = x.toFixed(n);

Here x is the number to be converted, the string str is the conversion result, and n specifies how many fractional decimal places must appear in the resultant string. The method can also be used without the parameter n - you can simply write: x.toFixed(), which is equivalent to x.toFixed(0). Consider these examples:

var x = 2.31;
var s = x.toFixed() // result: '2'
var s0 = x.toFixed(0) // result: '2'
var s1 = x.toFixed(1) // result: '2.3'
var s2 = x.toFixed(2) // result: '2.31'
var s3 = x.toFixed(3) // result: '2.310'
var s4 = x.toFixed(4) // result: '2.3100'

The toFixed method might not always ensure the correct rounding of the conversion results. For example, (0.947).toFixed(0) may produce either '0' or '1', depending on the browser; in most versions of Microsoft Internet Explorer (0.947).toFixed(0) produces '0' while in Mozilla Firefox or Google Chrome the same conversion produces '1'. Below are the actual conversion results in your browser:

(0.947).toFixed(0) // '0' ('0' in MSIE, but '1' in Firefox)
(0.0947).toFixed(1) // '0.0' ('0.0' in MSIE, but '0.1' in Firefox)
(0.00947).toFixed(2) // '0.00' ('0.00' in MSIE, but '0.01' in Firefox)
(0.000947).toFixed(3) // '0.000' ('0.000' in MSIE, but '0.001' in Firefox)

For correct rounding, use the Math.round method or Math.round in combination with toFixed like this:
x=0.947; s0=(Math.round(x)).toFixed(0) // '1'
x=0.0947; s1=(Math.round(10*x)/10).toFixed(1) // '0.1'
x=0.00947; s2=(Math.round(100*x)/100).toFixed(2) // '0.01'
x=0.000947; s3=(Math.round(1000*x)/1000).toFixed(3) // '0.001'

function addCommas(nStr)
{
nStr += '';
x = nStr.split('.');
x1 = x[0];
x2 = x.length > 1 ? '.' + x[1] : '';
var rgx = /(\d+)(\d{3})/;
while (rgx.test(x1)) {
x1 = x1.replace(rgx, '$1' + ',' + '$2');
}
return x1 + x2;
}
_________________________________
[As you type]
example IWS-order_productsSub.php

function checkit(id1){
var key1= window.event.keyCode
if (key1>57 || key1<48){
return;
}
document.getElementById('li'+id1).checked=true;
nStr=document.getElementById(id1).value;
var start1=1000;
while(start1!=-1){
start1= nStr.indexOf(",");
nStr=nStr.replace(",","");
}
nStr += '';
x = nStr.split('.');
x1 = x[0];
x2 = x.length > 1 ? '.' + x[1] : '';
var rgx = /(\d+)(\d{3})/;
while (rgx.test(x1)) {
x1 = x1.replace(rgx, '$1' + ',' + '$2');
}
document.getElementById(id1).value=x1+x2;
}

JavaScript - Is it Enabled?
This lesson will first teach you how to enable JavaScript in Internet Explorer, Firefox, and Opera, then show you how you can write a very simple script to separate website visitors who don't have JavaScript enabled from those who do.

Advertise on Tizag.com
Enable JavaScript - Internet Explorer
In Internet Explorer 6/7 (download Internet Explorer), you can check to see if JavaScript is enabled by navigating to the custom security settings that are somewhat buried (don't worry; we'll help you find it).

1.Click on the Tools menu
2.Choose Internet Options... from the menu
3.Click the Security tab on the Internet Options pop up
4.Click the Custom Level... button to access your security settings
5.Scroll almost all the way down to the Scripting section
6.Select the Enable button for Active scripting
7.Click OK to finish the process
8.Click Yes when asked to confirm

Enable JavaScript - Firefox
In Firefox 2 (download Firefox) you can check to see if JavaScript is enabled by navigating to the Content settings under Options.

1.Click on the Tools menu
2.Choose Options... from the menu
3.Click the Content tab in the Options pop up
4.Make sure that Enable JavaScript is checked
5.Click OK to finish the process

Enable JavaScript - Opera
In Opera (download Opera) you can check to see if JavaScript is enabled by navigating to the Content settings under Preferences.

1.Click on the Tools menu
2.Choose Preferences... from the menu
3.Click the Advanced tab in the Preferences pop up
4.Select Content from the list of items on the left
5.Make sure that Enable JavaScript is checked
6.Click OK to finish the process
JavaScript Detection
These days, it's basically impossible to navigate the web without a JavaScript-enabled browser, so checking whether or not a user has JavaScript enabled is not all that important. Chances are, the only way it be disabled is if the company's IT staff has decided to disable JavaScript for some reason. However, if you still want to be sure your users are JavaScript enabled, this script will get it done.

The only sure fire way to separate users who don't have JavaScript from those who do is to use a simple redirect script that will only work for those with JavaScript enabled. If a person's browser does not have JavaScript enabled, the script will not run, and they will remain on the same page.

JavaScript Code:

Replace the example URL with the webpage of your choice

Creating Single Line Comments
To create a single line comment in JavaScript, you place two slashes "//" in front of the code or text you wish to have the JavaScript interpreter ignore. When you place these two slashes, all text to the right of them will be ignored, until the next line.

These types of comments are great for commenting out single lines of code and writing small notes.

JavaScript Code:


Display:
I have comments in my JavaScript code!
Each line of code that is colored red is commented out and will not be interpreted by the JavaScript engine.

Creating Multi-line Comments
Although a single line comment is quite useful, it can sometimes be burdensome to use when disabling long segments of code or inserting long-winded comments. For this large comments you can use JavaScript's multi-line comment that begins with /* and ends with */.

JavaScript Code:


Display:
I have multi-line comments!
Quite often text editors have the ability to comment out many lines of code with a simple key stroke or option in the menu. If you are using a specialized text editor for programming, be sure that you check and see if it has an option to easily comment out many lines of code!

Checkboxes can be used as arrays and the value can be collected using JavaScript. We will be discussing client side JavaScript and the collection of checkbox value. You can visit the php section for checkbox array handling using PHP server side scripting. We can create a group of checkbox by giving them the same name and that will create an array and from it we can collect the names of the check boxes for which it is checked.

Here are some commands we will be using to get the details of the events or actions we perform.

document.form1.scripts.length

This gives us the length of the array or the number of elements present in the array. If we know we are using 5 checkboxes then we can directly use the number 5 but it is a good to use this as this picks up all the checkboxes of the group without missing any checkbox. Note that the word scripts in the document.form1.scripts.length is the name of the array and same as the checkboxes name.
document.form1.scripts[i].checked

The above command will return true if the checkbox is checked so we will use one if condition to know it is checked or not. The value of i is the index of the array and as we will be using one for loop so the value of i will be changing upto the maximum value. Here is the demo of the script. SexMale Female
Scripts You knowJavaScript PHP HTML

The JavaScript code is kept within the head tag of the page.



To display the period button and checkboxes see the code below. BODY

SexMale Female

Scripts You knowJavaScript PHP HTML

With an ordinary HTML link using the tag you can target the page that the link refers to so that it will display in another window or frame. Of course the same can also be done from within Javascript.

To target the top of the current page and break out of any frameset currently in use you would use in HTML. In Javascript you use:

top.location.href = 'page.htm';
To target the current page or frame you can use in HTML. In Javascript you use:

self.location.href = 'page.htm';
To target the parent frame you can use in HTML. In Javascript you use:

parent.location.href = 'page.htm';
To target a specific frame within a frameset you can use in HTML. In Javascript you use:

top.frames['thatframe'].location.href = 'page.htm';
To target a specific iframe within the current page you can use in HTML. In Javascript you use:

self.frames['thatframe'].location.href = 'page.htm';
or
parent.right.location.href= `Loads file into window or frame right`

The JavaScript print function window.print() will print the current webpage when executed. In this example script, we will be placing the function on a JavaScript button that will perform the print operation when the onClick event occurs.

HTML & JavaScript Code:

function moveOn(field,nextFieldID,e){
var unicode=e.keyCode? e.keyCode : e.charCode
if(unicode!=39 && unicode!=37){
if(field.value.length >= field.maxLength){
document.getElementById(nextFieldID).focus();
}
}
}


-
-
";

Adding a color to alternate rows or columns (often called color banding) can make the data in your worksheet easier to scan. To format alternate rows or columns, you can quickly apply a preset table format. By using this method, alternate row or column shading is automatically applied when you add rows and columns.

Table with color applied to alternate rows

Here's how:

Select the range of cells that you want to format.

Go to Home > Format as Table.

office 365 asks for cell range. Remove "I have headers" checkmark. You can uncheck the headers box and it will remove the headers it creates. Delete the cells and move the cells up

Pick a table style that has alternate row shading.

To change the shading from rows to columns, select the table, under Table Design, and then uncheck the Banded Rows box and check the Banded Columns box.

ALTER TABLE prices
ADD COLUMN inventory smallint AFTER invoice;

ALTER TABLE eqMaintenance ADD COLUMN filter2id smallint AFTER filterid

ALTER TABLE filters ADD COLUMN model varchar(75) AFTER description
ALTER TABLE filters ADD COLUMN code varchar(10) AFTER model

ALTER TABLE filters ADD COLUMN cost decimal (10,2) AFTER type_of
ALTER TABLE fertilizer_applied ADD COLUMN crop_year smallint AFTER acres

=================================


increase size:
ALTER TABLE table_name MODIFY COLUMN column_name SMALLINT;
ALTER TABLE `bible` MODIFY COLUMN `chapter` SMALLINT;
ALTER TABLE `transactions` MODIFY `description` varchar (400);
ALTER TABLE `lastbackup` MODIFY `source` varchar (500);
ALTER TABLE `fertilizer_applied` MODIFY `comments` varchar (400);

ALTER TABLE `purchases` MODIFY `description` varchar (400);
ALTER TABLE `equipment_photo` MODIFY `caption` varchar (100);


MySQL ALTER TABLE Statement
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

ALTER TABLE - ADD Column
To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype;
The following SQL adds an "Email" column to the "Customers" table:

ExampleGet your own SQL Server
ALTER TABLE Customers
ADD Email varchar(255);
ALTER TABLE - DROP COLUMN
To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):

ALTER TABLE table_name
DROP COLUMN column_name;
The following SQL deletes the "Email" column from the "Customers" table:

Example
ALTER TABLE Customers
DROP COLUMN Email;
ALTER TABLE - MODIFY COLUMN
To change the data type of a column in a table, use the following syntax:

ALTER TABLE table_name
MODIFY COLUMN column_name datatype;