Notes

Note: Not all major browsers support all the new input types. However, you can already start using them; If they are not supported, they will behave as regular text fields.

Input Type: color

The color type is used for input fields that should contain a color.

Example

Select a color from a color picker:

Select your favorite color:

Try it yourself »

Input Type: date

The date type allows the user to select a date.

Example

Define a date control:

Birthday:

Try it yourself »

Input Type: datetime

The datetime type allows the user to select a date and time (with time zone).

Example

Define a date and time control (with time zone):

Birthday (date and time):

Try it yourself »

Input Type: datetime-local

The datetime-local type allows the user to select a date and time (no time zone).

Example

Define a date and time control (no time zone):

Birthday (date and time):

Try it yourself »

Input Type: email

The email type is used for input fields that should contain an e-mail address.

Example

Define a field for an e-mail address (will be automatically validated when submitted):

E-mail:

Try it yourself »

Tip: Safari on iPhone recognizes the email type, and changes the on-screen keyboard to match it (adds @ and .com options).

Input Type: month

The month type allows the user to select a month and year.

Example

Define a month and year control (no time zone):

Birthday (month and year):

Try it yourself »

Input Type: number

The number type is used for input fields that should contain a numeric value.

You can also set restrictions on what numbers are accepted:

Example

Define a numeric field (with restrictions):

Quantity (between 1 and 5):

Try it yourself »

Use the following attributes to specify restrictions:

max - specifies the maximum value allowed
min - specifies the minimum value allowed
step - specifies the legal number intervals
value - Specifies the default value

Try an example with all the restriction attributes: Try it yourself

Input Type: range

The range type is used for input fields that should contain a value from a range of numbers.

You can also set restrictions on what numbers are accepted.

Example

Define a control for entering a number whose exact value is not important (like a slider control):

Try it yourself »

Use the following attributes to specify restrictions:

max - specifies the maximum value allowed
min - specifies the minimum value allowed
step - specifies the legal number intervals
value - Specifies the default value

Input Type: search

The search type is used for search fields (a search field behaves like a regular text field).

Example

Define a search field (like a site search, or Google search):

Search Google:

Try it yourself »

Input Type: tel

Example

Define a field for entering a telephone number:

Telephone:

Try it yourself »

Input Type: time

The time type allows the user to select a time.

Example

Define a control for entering a time (no time zone):

Select a time:

Try it yourself »

Input Type: url

The url type is used for input fields that should contain a URL address.

The value of the url field is automatically validated when the form is submitted.

Example

Define a field for entering a URL:

Add your homepage:

Try it yourself »

Tip: Safari on iPhone recognizes the url input type, and changes the on-screen keyboard to match it (adds .com option).

Input Type: week

The week type allows the user to select a week and year.

Example

Define a week and year control (no time zone):

Select a week:

Try it yourself »

Html5

1208

09/09/2023

Html5

Language

Html5

html5

<h1>The input max and min attributes</h1>

<form action="/action_page.php">
  <label for="datemax">Enter a date before 1980-01-01:</label>
  <input type="date" id="datemax" name="datemax" max="1979-12-31"><br><br>

<label for="datemin">Enter a date after 2000-01-01:</label>
  <input type="date" id="datemin" name="datemin" min="2000-01-02"><br><br>

<label for="quantity">Quantity (between 1 and 5):</label>
  <input type="number" id="quantity" name="quantity" min="1" max="5"><br><br>

==================================
accept 	audio/*
video/*
image/*
MIME_type 	Specifies the types of files that the server accepts (only for type="file")
align 	left
right
top
middle
bottom 	Not supported in HTML5. Deprecated in HTML 4.01. Specifies the alignment of an image input (only for type="image")
alt 	text 	Specifies an alternate text for images (only for type="image")
autocompleteNew 	on
off 	Specifies whether an <input> element should have autocomplete enabled
autofocusNew 	autofocus 	Specifies that an <input> element should automatically get focus when the page loads
checked 	checked 	Specifies that an <input> element should be pre-selected when the page loads (for type="checkbox" or type="radio")
disabled 	disabled 	Specifies that an <input> element should be disabled
formNew 	form_id 	Specifies one or more forms the <input> element belongs to
formactionNew 	URL 	Specifies the URL of the file that will process the input control when the form is submitted (for type="submit" and type="image")
formenctypeNew 	application/x-www-form-urlencoded
multipart/form-data
text/plain 	Specifies how the form-data should be encoded when submitting it to the server (for type="submit" and type="image")
formmethodNew 	get
post 	Defines the HTTP method for sending data to the action URL (for type="submit" and type="image")
formnovalidateNew 	formnovalidate 	Defines that form elements should not be validated when submitted
formtargetNew 	_blank
_self
_parent
_top
framename 	Specifies where to display the response that is received after submitting the form (for type="submit" and type="image")
heightNew 	pixels 	Specifies the height of an <input> element (only for type="image")
listNew 	datalist_id 	Refers to a <datalist> element that contains pre-defined options for an <input> element
max        New 	number
date 	Specifies the maximum value for an <input> element
maxlength 	number 	Specifies the maximum number of characters allowed in an <input> element
min New 	number
date 	Specifies a minimum value for an <input> element
multiple      New 	multiple 	Specifies that a user can enter more than one value in an <input> element
name 	text 	Specifies the name of an <input> element
patternNew 	regexp 	Specifies a regular expression that an <input> element's value is checked against
placeholder New 	text 	Specifies a short hint that describes the expected value of an <input> element
readonly 	readonly 	Specifies that an input field is read-only
required    New 	required 	Specifies that an input field must be filled out before submitting the form
size 	number 	Specifies the width, in characters, of an <input> element
src 	URL 	Specifies the URL of the image to use as a submit button (only for type="image")
stepNew 	number 	Specifies the legal number intervals for an input field

HTML5 Input Types
checkbox
color
date
datetime
datetime-local
email
file
hidden
image
month
number
password
radio
range
reset
search
submit
tel
text
time
url
week 	Specifies the type <input> element to display
value 	text 	Specifies the value of an <input> element
 
width      New 	pixels 	Specifies the width of an <input> element (only for type="image")

Html5

09/27/2023

Javascript

Archive

Gps Google Map Copy

gps

Google Map Calculations Backup

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>Latitude and Longitude of a Point</title>
<meta name="description" content="Find the latitude and longitude of a point using Google Maps.">
<meta name="keywords" content="latitude, longitude, google maps, get latitude and longitude">
<script async defer src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBpHlB8OlaTfaCE6aS9ZZSRvxcdb0n1MIs&callback=initMap"
  type="text/javascript"></script>

<script type="text/javascript">
//<![CDATA[
// Latitude and Longitude math routines are from: http://www.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html

var map = null;
var latsgn = 1;
var lgsgn = 1;
var marker = null;
var posset = 0;
var ls='';
var lm='';
var ld='';
var lgs='';
var lgm='';
var lgd='';
var mrks = {mvcMarkers: new google.maps.MVCArray()};
var iw;
var drag=false;

google.maps.event.addListener(marker, 'click', function(mll) {
gC(mll.latLng);
var html= "<div style='color:#000;background-color:#fff;padding:5px;width:150px;'><p>Latitude - Longitude:<br />" + String(mll.latLng.toUrlValue()) + "<br /><br />Lat: " + ls +  "° " + lm +  "' "  + ld + ""<br />Long: " + lgs +  "° " + lgm +  "' " + lgd + ""</p></div>";
iw = new google.maps.InfoWindow({content:html});
iw.open(map,marker);
});
google.maps.event.addListener(marker, 'dragstart', function() {if (iw){iw.close();}});

google.maps.event.addListener(marker, 'dragend', function(event) {
posset = 1;
if (map.getZoom() < 10){map.setZoom(10);}
map.setCenter(event.latLng);
computepos(event.latLng);
drag=true;
setTimeout(function(){drag=false;},250);
});

google.maps.event.addListener(map, 'click', function(event) {
if (drag){return;}
posset = 1;
fc(event.latLng) ;
if (map.getZoom() < 10){map.setZoom(10);}
map.panTo(event.latLng);
computepos(event.latLng);
});

}

function showLatLong(latitude, longitude) {
if (isNaN(latitude)) {alert(' Latitude must be a number. e.g. Use +/- instead of N/S'); return false;}
if (isNaN(longitude)) {alert(' Longitude must be a number.  e.g. Use +/- instead of E/W'); return false;}

latitude1 = Math.abs( Math.round(latitude * 1000000.));
if(latitude1 > (90 * 1000000)) { alert(' Latitude must be between -90 to 90. ');  document.getElementById("latbox1").value=''; return;}
longitude1 = Math.abs( Math.round(longitude * 1000000.));
if(longitude1 > (180 * 1000000)) { alert(' Longitude must be between -180 to 180. ');  document.getElementById("lonbox1").value='';  return;}

var point = new google.maps.LatLng(latitude,longitude);
posset = 1;
if (map.getZoom() < 7){map.setZoom(7);}else{}
map.setMapTypeId(google.maps.MapTypeId.HYBRID);
map.setCenter(point);
fc(point);
computepos(point);
}

if (latitude.indexOf('-') < 0){latsgn = 1;}else{latsgn = -1;}
alat = Math.abs( Math.round(latitude * 1000000.));
if(alat > (90 * 1000000)) { alert(' Degrees Latitude must be between -90 to 90. ');  document.getElementById("latbox1m").value=''; document.getElementById("latbox1md").value=''; document.getElementById("latbox1ms").value=''; return; }
latitudem = Math.abs(Math.round(latitudem * 1000000.)/1000000);  //integer
absmlat = Math.abs(Math.round(latitudem * 1000000.));  //integer
if(absmlat >= (60 * 1000000)) {  alert(' Minutes Latitude must be between 0 to 59. ');  document.getElementById("latbox1md").value=''; document.getElementById("latbox1ms").value=''; return;}
latitudes = Math.abs(Math.round(latitudes * 1000000.)/1000000);
absslat = Math.abs(Math.round(latitudes * 1000000.));
if(absslat > (59.99999999 * 1000000)) {  alert(' Seconds Latitude must be between 0 and 59.99. '); document.getElementById("latbox1ms").value=''; return; }

if (longitude.indexOf('-') < 0){lgsgn = 1;}else{lgsgn = -1;}
alon = Math.abs( Math.round(longitude * 1000000.));
if(alon > (180 * 1000000)) {  alert(' Degrees Longitude must be between -180 to 180. '); document.getElementById("lonbox1m").value=''; document.getElementById("lonbox1md").value=''; document.getElementById("lonbox1ms").value=''; return;}
longitudem = Math.abs(Math.round(longitudem * 1000000.)/1000000);
absmlon = Math.abs(Math.round(longitudem * 1000000));
if(absmlon >= (60 * 1000000))   {  alert(' Minutes Longitude must be between 0 to 59. '); document.getElementById("lonbox1md").value=''; document.getElementById("lonbox1ms").value='';   return;}
longitudes = Math.abs(Math.round(longitudes * 1000000.)/1000000);
absslon = Math.abs(Math.round(longitudes * 1000000.));
if(absslon > (59.99999999 * 1000000)) {  alert(' Seconds Longitude must be between 0 and 59.99. '); document.getElementById("lonbox1ms").value=''; return;}

latitude = Math.round(alat + (absmlat/60.) + (absslat/3600.) ) * latsgn/1000000;
longitude = Math.round(alon + (absmlon/60) + (absslon/3600) ) * lgsgn/1000000;
var point = new google.maps.LatLng(latitude,longitude);
posset = 1;
if (map.getZoom() < 7){map.setZoom(7);}else{}
map.setMapTypeId(google.maps.MapTypeId.HYBRID);
map.setCenter(point);
fc(point);
computepos(point);
}

function streetview()
{
if (posset == 0)
{
	alert("Position Not Set.  Please click on the spot on the map to set the street view point.");
	return;
}

var point = map.getCenter();
var t1 = String(point);
t1 = t1.replace(/[() ]+/g,"");
var str = "http://www.satelliteview.co/?e=" + t1 + ":0:Latitude-Longitude Point:sv:0";
var popup = window.open(str, "llwindow");
popup.focus();
}

function googleearth()
{
if (posset == 0)
{
	alert("Position Not Set.  Please click on the spot on the map to set the Google Earth map point.");
	return;
}
var point = map.getCenter();
var gearth_str = "/?r=googleearth&mt=Latitude-Longitude Point&ml=" + point.lat() + "&mg=" + point.lng();
var popup = window.open(gearth_str, "llwindow");
popup.focus();
}

function pictures()
{
if (posset == 0)
{
	alert("Position Not Set.  Please click on the spot on the map to set the photograph point.");
	return;
}
var point = map.getCenter();
var pictures_str = "http://www.picturepastime.com?r=pictures&mt=Latitude-Longitude Point&ml=" + point.lat() + "&mg=" + point.lng();
var popup = window.open(pictures_str, "llwindow");
popup.focus();
}

function lotsize()
{
if (posset == 0)
{
	alert("Position Not Set.  Please click on the spot on the map to set the lot size map point.");
	return;
}
var point = map.getCenter();
var t1 = String(point);
t1 = t1.replace(/[() ]+/g,"");
var lotsize_str = "http://www.satelliteview.co/?e=" + t1 + ":0:Latitude-Longitude Point:measure:0";
var popup = window.open(lotsize_str, "llwindow");
popup.focus();
}

function getaddress()
{
if (posset == 0)
{
	alert("Position Not Set.  Please click on the spot on the map to set the get address map point.");
	return;
}
var point = map.getCenter();
var t1 = String(point);
t1 = t1.replace(/[() ]+/g,"");
var getaddr_str = "http://www.satelliteview.co/?e=" + t1 + ":0:Latitude-Longitude Point:map:0";
var popup = window.open(getaddr_str, "llwindow");
popup.focus();
}

function rL()
{
var marker = mrks.mvcMarkers.pop();
if (marker)
{
marker.setMap(null);
document.getElementById("latbox").value='';
document.getElementById("latboxm").value='';
document.getElementById("latboxmd").value='';
document.getElementById("latboxms").value='';
document.getElementById("lonbox").value='';
document.getElementById("lonboxm").value='';
document.getElementById("lonboxmd").value='';
document.getElementById("lonboxms").value='';
}
}

function gC(ll){
var latA = Math.abs(Math.round(ll.lat() * 1000000.));
var lonA = Math.abs(Math.round(ll.lng() * 1000000.));
if(ll.lat() < 0)
{
	var tls = '-' + Math.floor((latA / 1000000)).toString();
}
else
{
	var tls = Math.floor((latA / 1000000)).toString();
}
var tlm = Math.floor(((latA/1000000) - Math.floor(latA/1000000)) * 60).toString();
var tld = ( Math.floor(((((latA/1000000) - Math.floor(latA/1000000)) * 60) - Math.floor(((latA/1000000) - Math.floor(latA/1000000)) * 60)) * 100000) *60/100000 ).toString();
ls = tls.toString();
lm = tlm.toString();
ld = tld.toString();

if(ll.lng() < 0)
{
  var tlgs = '-' + Math.floor((lonA / 1000000)).toString();
}
else
{
	var tlgs = Math.floor((lonA / 1000000)).toString();
}
var tlgm = Math.floor(((lonA/1000000) - Math.floor(lonA/1000000)) * 60).toString();
var tlgd = ( Math.floor(((((lonA/1000000) - Math.floor(lonA/1000000)) * 60) - Math.floor(((lonA/1000000) - Math.floor(lonA/1000000)) * 60)) * 100000) *60/100000 ).toString();
lgs = tlgs.toString();
lgm = tlgm.toString();
lgd = tlgd.toString();
}

function reset() {
mrks.mvcMarkers.forEach(function(elem, index) {elem.setMap(null);});
mrks.mvcMarkers.clear();
document.getElementById("latbox").value='';
document.getElementById("latboxm").value='';
document.getElementById("latboxmd").value='';
document.getElementById("latboxms").value='';
document.getElementById("lonbox").value='';
document.getElementById("lonboxm").value='';
document.getElementById("lonboxmd").value='';
document.getElementById("lonboxms").value='';
marker.setPosition(map.getCenter());
}

var R = 6371; // Radius of the earth in km
  var dLat = deg2rad(lat2-lat1);  // deg2rad below
  var dLon = deg2rad(lon2-lon1);
  var a = 
    Math.sin(dLat/2) * Math.sin(dLat/2) +
    Math.cos(deg2rad(lat1)) * Math.cos(deg2rad(lat2)) * 
    Math.sin(dLon/2) * Math.sin(dLon/2)
    ;
  var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
  var d = R * c; // Distance in km
  var d = R * c*3280.839895; //Distance feet
  if(d>10000){
    d=d/5280;
    var unit="miles";
  }else{
      var unit="feet";
  }
  return d+" "+unit;
}

function deg2rad(deg) {
  return deg * (Math.PI/180)
}
function storePile(){
   alert(document.getElementById("lonbox").value+","+document.getElementById("latbox").value);
   document.getElementById("x2").value=document.getElementById("x1").value;
   document.getElementById("x5").value=document.getElementById("x4").value;
   document.getElementById("y2").value=document.getElementById("y1").value;
   document.getElementById("y5").value=document.getElementById("y4").value;
   document.getElementById("x1").value=document.getElementById("lonbox").value;
   document.getElementById("y1").value=document.getElementById("latbox").value;
   document.getElementById("x4").value=document.getElementById("x1").value;
   document.getElementById("y4").value=document.getElementById("y1").value;
}
//END ORIGINAL JAVASCRIPT. NEW CODE NEXT
// Converts from degrees to radians.

function toRadians(degrees) {
  return degrees * Math.PI / 180;
}
 
// Converts from radians to degrees.
function toDegrees(radians) {
  return radians * 180 / Math.PI;
}

function bearing(startLat, startLng, destLat, destLng){
  startLat = toRadians(startLat);
  startLng = toRadians(startLng);
  destLat = toRadians(destLat);
  destLng = toRadians(destLng);

y = Math.sin(destLng - startLng) * Math.cos(destLat);
  x = Math.cos(startLat) * Math.sin(destLat) -
        Math.sin(startLat) * Math.cos(destLat) * Math.cos(destLng - startLng);
  brng = Math.atan2(y, x);
  brng = toDegrees(brng);
  return (brng + 360) % 360;
}
function distanceHeading(lat1,lon1,lat2,lon2){
      var distance=getDistanceFromLatLonInKm(lat1,lon1,lat2,lon2);
      var heading=bearing(lat1,lon1,lat2,lon2);
      document.getElementById("lat9").value=lat2;
      document.getElementById("long9").value=lon2;
      document.getElementById("bearing9").value=heading;
      document.getElementById("pile").value=document.getElementById("pile").value+"["+lon1+","+lat1+"]"+"["+lon2+","+lat2+"]";
      document.getElementById("length").value=document.getElementById("length").value+" "+distance;
      document.getElementById("heading").value=document.getElementById("heading").value+" "+heading+"n";
     alert(distance+" -> "+heading+" degrees");
     var complete=lat1+","+lon1+"; "+distance+" -> "+heading+" degrees; "+lat2+", "+lon2+"nn";
     document.getElementById("piled").value=document.getElementById("piled").value+complete;
}
function distanceToGPSpoint(){
      var lat1=document.getElementById("lat9").value;
      var lon1=document.getElementById("long9").value;
      var bearing=document.getElementById("bearing9").value;
      var distance=document.getElementById("dist9").value;
      document.getElementById("gps9").value=getPointAtDistance(lat1, lon1, distance, bearing);
}
function circleDistance(lat1,lon1,lat2,lon2){
      var distance=getDistanceFromLatLonInKm(lat1,lon1,lat2,lon2);
      var distance100=2*3.141596*parseFloat(distance);
      var area=3.141596*(parseFloat(distance)*parseFloat(distance));
      var width=document.getElementById("equipmentWidth").value/43560;
      var distance50=distance100/2;
      var distance25=distance100/4;
     alert("full circle="+parseInt(distance100)+" ft ==== half circle="+parseInt(distance50)+" ft ====== quarter circle="+parseInt(distance25)+" ft");
     alert("full circle area="+distance100*width+" acre ==== half circle area="+distance50*width+" acre ====== quarter circle area="+distance25*width+" acre");
}
function getPointAtDistance(lat1, lon1, distance, bearing) {
    const R = 6371e3; // Earth's radius in meters
    const d = distance/3.280839895013123; // Distance in meters

const lat1Rad = toRadians(lat1);
    const lon1Rad = toRadians(lon1);
    const brngRad = toRadians(bearing);

const lat2Rad = Math.asin(
        Math.sin(lat1Rad) * Math.cos(d / R) +
        Math.cos(lat1Rad) * Math.sin(d / R) * Math.cos(brngRad)
    );

const lon2Rad = lon1Rad + Math.atan2(
        Math.sin(brngRad) * Math.sin(d / R) * Math.cos(lat1Rad),
        Math.cos(d / R) - Math.sin(lat1Rad) * Math.sin(lat2Rad)
    );
    var point="["+toDegrees(lat2Rad)+", "+toDegrees(lon2Rad)+"]";
    return point;
}

function toRadians(deg) {
    return deg * (Math.PI / 180);
}

function toDegrees(rad) {
    return rad * (180 / Math.PI);
}

</script>

<h1>Steves Farms - <label id="fld">Pick Field</label></h1>
<div id="wrapper" style="margin:5px"><div id="map" style="width:<?php echo $width; ?>px; height:<?php echo $height; ?>px;float:left;margin-left:50px;">
</div>

<div style="float:left;">
<center><p>    <input type="button" value="Clear / Reset" id="reset" onclick="reset()">  <input type="button" name="storepile" value="Store gps points" onclick="storePile();"><input type="button" name=" " value="Distance Calc" onclick="distanceHeading(distance.y4.value,distance.x4.value,distance.y5.value,distance.x5.value);"> <input type="button" value="Center Red Marker" id="reset1" onclick="reset1()"><input type="button" name=" " value="Circular Distance Calc" onclick="circleDistance(distance.y4.value,distance.x4.value,distance.y5.value,distance.x5.value);"><input type="text" id="equipmentWidth" name="width" value="30" size="4"></center></p>
<hr>
<h3>Get the Latitude and Longitude of a Point</h3>
<p>When you click on the map, move the marker or enter an address the latitude and longitude coordinates of the point are inserted in the boxes below.</p>
onclick="showLatLong(<label id="lat"></label>, <label id="lon"></label>);"</td></tr>

<div style="float:left;">
<form name="distance">
<table><tr><td>Longitude<td>Latitude</td></tr>
<tr><td><input size="15" type="text" id="lonbox" name="lon" value="" ><td><input size="15" type="text" id="latbox" name="lat" value="" >
<tr><td><input type="text" id="x1" name="x1" value="-104.8"><td><input type="text" id="y1" name="y1" value="40.5">
<tr><td><input type="text" id="x2" name="x2" value="-104.8"><td><input type="text" id="y2" name="y2" value="40.5">
<tr><td><input type="text" id="x3" name="x3" value="-104.8"><td><input type="text" id="y3" name="y3" value="40.5">
<tr><td><input type="text" id="x4" name="x4" value="-104.8"><td><input type="text" id="y4" name="y4" value="40.5">
<tr><td><input type="text" id="x5" name="x5" value="-104.8"><td><input type="text" id="y5" name="y5" value="40.5">
</td></tr></table>
</div><div style="float:left;">
<input type="button" name=" " value="Slope Calc" onclick="slopeCalc();">
Slope:<input type="text" id="slope1" name="slope1"> Intercept=<input type="text" id="intercept1" name="intercept1">
<table><tr><td><td>Latitude<td>Longitude<td>Bearing<td>Distance<td>GPS Points</tr>
<tr><td><input type="button" name=" " value="Point At Distance" onclick="distanceToGPSpoint();"><td><input type="text" id="lat9" name="1at9"><td><input type="text" id="long9" name="1ong9"><td><input type="text" id="bearing9" name="bearing9"><td><input type="text" id="dist9" name="dist9"><td><input type="text" id="gps9" name="gps9" style="width:250px;"></td></tr>
</table>
</div>
<div style="float:left;">

</form>
   <textarea1 name="pile" id="pile" cols="50" rows="10"> </textarea1>
   <textarea1 name="length" id="length" cols="25" rows="10"> </textarea1>
   <textarea1 name="heading" id="heading" cols="20" rows="10"> </textarea1>
   <textarea1 name="piled" id="piled" cols="50" rows="10"> </textarea1>
   <hr></div>

<div id="home" style="float:left;">
<a href="#" onclick="showLatLong(40.550475, -104.916644);showField('hpHeckman');";>hpHeckman</a><br>
<a href="#" onclick="showLatLong(40.552008, -104.908361);showField('hpHill');">hpHill</a><br>
<a href="#" onclick="showLatLong(40.551894, -104.911001);showField('HpLake');">HpLake</a><br>
<a href="#" onclick="showLatLong(40.551274, -104.913640);showField('hpNorth');">hpNorth</a><br>
<a href="#"  onclick="showLatLong(40.546269, -104.910636);showField('hpSheep');">hpSheep</a><br>
<a href="#"  onclick="showLatLong(40.546220, -104.915636);showField('hpSwest');" >hpSwest</a><br>
<a href="#"  onclick="showLatLong(40.548519, -104.915485);showField('hpTopMid');">hpTopMid</a>    <br>
<p><a href="#"  onclick="showLatLong(40.491420, -104.906505);showField('sparky');">sparky</a></p>
<p><a href="#"  onclick="showLatLong(39.741600, -104.812409);showField('ghetto');">ghetto</a></p>
<a href="#"  onclick="showRoads('hp')">Access points</a><br>
<p><input type="button" value="Mark Field" id="reset2" onclick="reset1()"></p>
</div>
<div id="severance" style="float:left;"><p><label id="fld2">None</label></p>
<a href="#"  onclick="showLatLong(40.543595, -104.867098);showField('sev05A');" >sev05A</a><br>
<a href="#"  onclick="showLatLong(40.543366, -104.863665);showField('sev05B');">sev05B</a><br>
<a href="#"  onclick="showLatLong(40.540187, -104.862592);showField('sev06A');">sev06A</a>    <br>
<a href="#" onclick="showLatLong(40.540252, -104.860039);showField('sev06B');" >sev06B</a>        <br>
<a href="#"  onclick="showLatLong(40.535620, -104.859438);showField('sev07');">sev07</a>             <br>
<a href="#"  onclick="showLatLong(40.532000, -104.858580);showField('sev08');">sev08</a>                 <br>
<a href="#" onclick="showLatLong(40.538654, -104.866669);showField('sev09');">sev09</a>                      <br>
<a href="#"  onclick="showLatLong(40.540937, -104.867764);showField('sev10');">sev10</a><br>
<a href="#"  onclick="showRoads('sev')">Access points</a><br>
</div>
<table><tr><td> </td><td><strong>Degrees</strong></td><td><strong>Minutes</strong></td><td><strong>Seconds</strong></td></tr>
<tr><td>Latitude:</td><td><input size="5" type="text" id="latboxm" name="latm" value="" ></td><td><input size="6" type="text" id="latboxmd" name="latmd" value="" ></td><td><input size="8" type="text" id="latboxms" name="latms" value="" ></td></tr>
<tr><td >Longitude:</td><td><input size="5" type="text" id="lonboxm" name="lonm" value="" ></td><td><input size="6" type="text" id="lonboxmd" name="lonmd" value="" ></td><td><input size="8" type="text" id="lonboxms" name="lonms" value="" ></td></tr>
</table>
<div id="fields" style="float:left;float:top;padding: 0 100px 0 0px;">

</div>

<div style="float:left;">
<h3>Show Point from Latitude and Longitude</h3>
<p>Use this if you know the latitude and longitude coordinates of a point and want to see where on the map the point is.
<br><strong>Use:</strong> <strong><font size="5">+</font></strong> for <em>N</em> Lat or <em>E</em> Long     <strong><font size="5">-</font></strong> for <em>S</em> Lat or <em>W</em> Long.<br><strong>Example:</strong> +40.689060  -74.044636<br><strong>Note:</strong> Your entry should not have any embedded spaces.</p>
<table width="100%">
<form onsubmit="showLatLong(this.latitude.value, this.longitude.value); return false;">
<tr><td colspan="2">Decimal Deg. Latitude:</td><td colspan="2"><input type="text" size="13" id="latbox1" name="latitude" value=""></td></tr>
<tr><td colspan="2">Decimal Deg. Longitude:</td><td colspan="2"><input type="text" size="13" id="lonbox1" name="longitude" value=""></td></tr>
<tr><td colspan="4" align="center"><input type="submit" value="Show Point"></td></tr>
</form>
<tr><td colspan="4"><hr>Example: <strong>+34   40   50.12</strong>   for <em>34N 40' 50.12"</em></td></tr>
<form onsubmit="showLatLong1(this.latm.value, this.latmd.value, this.latms. value, this.lonm.value, this.lonmd.value, this.lonms.value); return false;">
<tr><td> </td><td><strong>Degrees</strong></td><td><strong>Minutes</strong></td><td><strong>Seconds</strong></td></tr>
<tr><td>Latitude:</td><td><input size="5" type="text" id="latbox1m" name="latm" value="" ></td><td><input size="6" type="text" id="latbox1md" name="latmd" value="" ></td><td><input size="8" type="text" id="latbox1ms" name="latms" value="" ></td></tr>
<tr><td >Longitude:</td><td><input size="5" type="text" id="lonbox1m" name="lonm" value="" ></td><td><input size="6" type="text" id="lonbox1md" name="lonmd" value="" ></td><td><input size="8" type="text" id="lonbox1ms" name="lonms" value="" ></td></tr>
<tr><td colspan="4" align="center"><input type="submit" value="Show Point"></td></tr>

</form>
</table>
<input type="button" onclick="rL();" value="Remove Last Blue Marker"/>
</div>

</div>
</div>
</center>

Javascript

02/20/2026

Javascript

Controls

List Box Controls Another Listbox And Fills In A Text Box

list box text box onchange header dropdown

Search & PHPScript 2025/12

Javascript

09/09/2023

Javascript

Customizing

How To Setup TinyMCE Text Editor

text editor

Scripture View

To use this editor you need to download some important files from the TinyMCE editor official sites.

How to setup TinyMCE text editor
Follow the below steps to add TinyMCE editor in PHP or HTML file.

1. Add TinyMCE editor’s JS library : 
<script type="text/javascript" src="tinymce/tinymce.min.js"></script>

2. Add HTML textarea to display Editor box :
<stextarea name="editor" id="editor"></stextarea>

3. Call the TinyMCE editor function :
<script>
 tinymce.init({
   selector: 'textarea#editor',  //Change this value according to your HTML
   auto_focus: 'element1',
   width: "700",
   height: "200"
 });  
 </script>

<hr>
 lets see the complete example, which helps to you display formatted HTML code.
index.php

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Add tinymce editor in PHP or HTML </title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript" src="tinymce/tinymce.min.js"></script>
<style>
.texteditor-container { 
 width:700px;
 height:365px;
}
textarea#editor1 {
 width:500px !important;
 border:1px solid red;
 
}
</style>
<script>
 tinymce.init({
   selector: 'textarea#editor',  //Change this value according to your HTML
   auto_focus: 'element1',
   width: "700",
   height: "200"
 });
 
 $( document ).ready(function() {
 
  $('#buttonpost').on("click", function(){
   tinyMCE.triggerSave();
   var value = $("textarea#editor").val();  
   $("#display-post").html(value);
   $(".texteditor-container").hide();
   return false;
  });
 
 });   
 
</script>

</head>
<body>
 
 <div class="texteditor-container">
     <h1> Add tinymce editor in PHP or HTML </h1>
  <stextarea name="editor" id="editor"></stextarea>
  <input type="button" id="buttonpost" value="Publish Post"  />
 </div>
 
 <div id="display-post" style="width:700px;" ></div>
 
 
</body>
</html

<hr><hr>
To implement an HTML editor for multiple text areas using PHP, the process primarily involves client-side JavaScript libraries to create the rich text editing interface and then using PHP to handle the data submitted from these editors.
1. Client-Side Implementation (HTML & JavaScript):

Include HTML Textareas: Create multiple <textarea1> elements in your HTML form. Each textarea intended to be an HTML editor should have a unique ID or a shared class.

Code

<form method="post" action="process.php">
        <label for="editor1">Content Area 1:</label>
        <stextarea id="editor1" name="content1"></stextarea>

<label for="editor2">Content Area 2:</label>
        <stextarea id="editor2" name="content2"></stextarea>

<label for="editor3">Content Area 3:</label>
        <stextarea class="html-editor" name="content3"></stextarea>

<button type="submit">Submit</button>
    </form>

Integrate a WYSIWYG HTML Editor Library: Use a JavaScript library like TinyMCE, CKEditor, or Quill.js to transform the plain textareas into rich HTML editors.
        TinyMCE Example (using IDs):

JavaScript

Javascript

10/27/2025

Javascript

Date

Check For Valid Date

valid date

Sample html:

Valid date format: mm/dd/yyyy

The Script:

Javascript

1548

09/09/2023

Javascript

Date

Preload Current Date Into Text Box

form current date

Javascript

09/09/2023

Javascript

Form

Input - First Caps

capital first onblur

<!-- TWO STEPS TO INSTALL INITIAL CAPS:

1.  Copy the coding into the HEAD of your HTML document
  2.  Add the last code into the BODY of your HTML document  -->

<HEAD>

</script>
</HEAD>

<BODY>

Javascript

1596

09/09/2023

Javascript

Form

Form Fields - Events

form events onchange

Onsubmit and Onchange 
The onchange() event handler is triggered whenever the content of a form field is changed. The form field where this is most useful is for drop down selection lists since by using onchange instead of onblur the field can be tested immediately rather than waiting for a different field to be selected.

The onsubmit() event handler is attached to the form tag itself. Whenever a submit button is selected (or the submit method for the form is called from within your Javascript code) this event will be triggered.

Here is a sample form to demonstrate how these events are triggered: 
<form name="ex" method="POST"
onsubmit="alert('onsubmit');return false;">
<div align="center">
<select name="sel" size="1"
onchange="alert('onchange')">
<option value="1" selected="selected">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<input type="submit" value="submit" />
</div></form> 
Onreset 
The onreset() event handler (like onsubmit) is attached to the form itself. This event is triggered if the form contains a reset button and that button is pressed. 
Onmouseover and Onmouseout 
The mouseover and mouseout events are triggered when your visitor moves the mouse on or off of a particular object on your page.

See how these event handler works for yourself, the following links will execute alerts when the appropriate event handlers are triggered: onmouseover onmouseout

Onclick 
The onclick event is triggered when your visitors click their mouse on an object on your web page. Unlike the other mouse events the onclick event can also be triggered from the keyboard when your visitor selects the object by pressing the enter key when that object has the focus.

See how this event handler works for yourself: onclick

Onmousedown and Onmouseup 
A mouse button click consists of two movements. First your visitor depresses the mouse button and then they release it. If you need to trigger different events for these two actions then you can use onmousedown and onmouseup instead of onclick. These event handlers don't get triggered by selecting the object from the keyboard though.

See how these event handler works for yourself: onmousedown onmouseup

Onmousemove 
The final mouse event handler that is common to all browsers (there are some extras that are browser specific) is the onmousemove event handler which (as its name suggests) is triggered by moving the mouse cursor over the selected object.

Keyboard:
Onfocus and Onblur 
The focus and blur events are triggered when a particular object on your page gains or loses the focus. Just as you can have multiple windows open on your screen and the one you are working in has the focus, each level of objects within your web page will similarly have one that has the focus. The browser provides a means of moving the focus from one object in the page to another using either the keyboard or (in some cases) the mouse. When the focus is moved from one object to another the onblur event will be triggered for the object losing the focus and the onfocus event will be triggered for the object gaining the focus.

These two events can also often be used in place of onmousedown and onmouseup to allow the processing to be triggered from the keyboard as well as from a mouse click.

See how these event handler works for yourself, the following links will execute alerts when the appropriate event handlers are triggered: onfocus onblur

Note that the standards actually say that these two events only apply to form fields however most browsers have implemented onfocus for most web page objects. Support for onblur is somewhat more limited but still extends beyond just form fields in most browsers.

Onkeydown and Onkeyup 
The onkeydown and onkeyup events are triggered when your visitors presses a key on their keyboard and they acts on the object on your web page that currently has the focus. As their name sugges the onkey down is triggered when a key is depressed and onkeyup is triggered when it is released.
<hr>
Focus Events
Event	Occurs When
onblur	An element loses focus
onfocus	An element gets focus
onfocusin	An element is about to get focus
onfocusout	An element is about to lose focus
=================

<hr>
Keyboard Events
Event	Occurs When
onkeydown	A user presses a key
onkeypress	A user presses a key
onkeyup	A user releases a key
=================
KeyboardEvent Properties
Property	Returns
altKey	If the ALT key was pressed
charCode	Deprecated (Avoid using it)
code	The code of the key that triggered the event
ctrlKey	If the CTRL key was pressed
isComposing	If the state of the event is composing or not
key	The value of the key that triggered the event
keyCode	Deprecated (Avoid using it)
location	The location of a key on the keyboard or device
metaKey	If the META key was pressed
repeat	If a key is being hold down repeatedly, or not
shiftKey	If the SHIFT key was pressed
which	Deprecated (Avoid using it)

<hr>
Mouse Events
Event	Occurs When
onclick	A user clicks on an element
oncontextmenu	A user right-clicks on an element
ondblclick	A user double-clicks on an element
onmousedown	A mouse button is pressed over an element
onmouseenter	The mouse pointer moves into an element
onmouseleave	The mouse pointer moves out of an element
onmousemove	The mouse pointer moves over an element
onmouseout	The mouse pointer moves out of an element

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

MouseEvent Properties
Property	Returns
altKey	If the ALT key is pressed
button	Which mouse button is pressed
buttons	Which mouse buttons were pressed
clientX	The X coordinate of the mouse pointer (window relative)
clientY	The Y coordinate of the mouse pointer (window relative)
ctrlKey	If the CTRL key is pressed
detail	The details about an event
metaKey	If the META key is pressed
offsetX	The X coordinate of the mouse pointer (target relative)
offsetY	The Y coordinate of the mouse pointer (target relative)
pageX	The X coordinate of the mouse pointer (document relative)
pageY	The Y coordinate of the mouse pointer (document relative)
relatedTarget	The element that triggered the mouse event
screenX	The X coordinate of the mouse pointer (screen relative)
screenY	The Y coordinate of the mouse pointer (screen relative)
shiftKey	If the SHIFT key is pressed
which	Deprecated (Avoid using it)
Use the button property instead
onmouseover	The mouse pointer moves onto an element
onmouseup	A mouse button is released over an element

Javascript

2027

01/03/2026

Javascript

Form

Prompt For

prompt input

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.

Javascript

1477

09/09/2023

Javascript

Form

Select- Combo Box

index combo

Javascript

1752

10/05/2024

Javascript

Form

Select - Check To See If Your Select Has Been Used

select form javascript getelementbyid

If you have a select element that looks like this:

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.?

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;
}

Javascript

763

12/27/2025

Javascript

Formatting

Div - Hide A Layer

hide div layer class getElementById getElementsByClassName

Usage
Want to try it out? Here's how.

Step 1
Place this code between the tags in your webpage.

Step2
This is example html you can use, this goes inside your html body.

Try these: show a1
show a2
show a3
show 'thiscanbeanything'

Sample text:

Jean-Paul Sartre, (1905-1980) born in Paris in 1905, studied at the ï¿½cole
Normale Supï¿½rieure from 1924 to 1929 and became Professor of Philosophy at Le Havre
in 1931. With the help of a stipend from the Institut Franï¿½ais he studied in Berlin
(1932) the philosophies of Edmund Husserl and Martin Heidegger. After further teaching
at Le Havre, and then in Laon, he taught at the Lycï¿½e Pasteur in Paris from 1937 to 1939.
Since the end of the Second World War, Sartre has been living as an independent writer.

Classes

if it is a class.

compared to if it is an id.

Javascript

1874

11/21/2025

Javascript

Formatting

Converting Numbers To Strings Using ToFixed()

fixed decimal places number format

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'

Javascript

1552

09/09/2023

Javascript

Function

List Of Functions

javascript functions

[url location]
parent.frame_name.location= url   "send url into a frame"

[Integer]
var pop=parseInt(1000*Math.random());

[decimal only]
var fracPart = 123456 % 1000;

anchor() Creates an HTML anchor 1 3 
big() Displays a string in a big font 1 3 
blink() Displays a blinking string 1   
bold() Displays a string in bold 1 3 
charAt() Returns the character at a specified position 1 3 
charCodeAt() Returns the Unicode of the character at a specified position 1 4 
concat() Joins two or more strings 1 4 
fixed() Displays a string as teletype text 1 3 
fontcolor() Displays a string in a specified color 1 3 
fontsize() Displays a string in a specified size 1 3 
fromCharCode() Takes the specified Unicode values and returns a string 1 4 
indexOf() Returns the position of the first occurrence of a specified string value in a string 1 3 
italics() Displays a string in italic 1 3 
lastIndexOf() Returns the position of the last occurrence of a specified string value, searching backwards from the specified position in a string 1 3 
link() Displays a string as a hyperlink 1 3 
match() Searches for a specified value in a string 1 4 
replace() Replaces some characters with some other characters in a string 1 4 
search() Searches a string for a specified value 1 4 
slice() Extracts a part of a string and returns the extracted part in a new string 1 4 
small() Displays a string in a small font 1 3 
split() Splits a string into an array of strings 1 4 
strike() Displays a string with a strikethrough 1 3 
sub() Displays a string as subscript 1 3 
substr() Extracts a specified number of characters in a string, from a start index 1 4 
substring() Extracts the characters in a string between two specified indices 1 3 
sup() Displays a string as superscript 1 3 
toLowerCase() Displays a string in lowercase letters 1 3 
toUpperCase() Displays a string in uppercase letters 1 3 
toSource() Represents the source code of an object 1 - 
valueOf() Returns the primitive value of a String object

Definition and Usage

The substr() method extracts a specified number of characters in a string, from a start index.
Syntax   stringObject.substr(start,length)

Parameter 	Description
start 	Required. Where to start the extraction. Must be a numeric value
length 	Optional. How many characters to extract. Must be a numeric value.

Tips and Notes

Note: To extract characters from the end of the string, use a negative start number (This does not work in IE).

Note: The start index starts at 0.

Note: If the length parameter is omitted, this method extracts to the end of the string.
Example 1

In this example we will use substr() to extract some characters from a string:
<script type="text/javascript">

var str="Hello world!";
document.write(str.substr(3));

</script>

The output of the code above will be:
lo world!

Javascript

2025

09/09/2023

Javascript

Function

Insert Commas In Your Number As You Type

insert comma

Javascript

1345

09/09/2023

Javascript

Function

Load Popup Window

open window popup

Javascript

1758

09/09/2023

Javascript

Function

GetElementById

getelementbyid get element by id

Javascript

1251

09/09/2023

Javascript

Function

Confirm()

yes no cancel message box

JavaScript Confirm Example
Below is an example of how you would use a confirm dialogue box to warn users about something, giving them the option to either continue on or stay put.

HTML & JavaScript Code:
<html>
<head>
<script type="text/javascript">

</script>
</head>
<body>
<form>
<input type="button" onclick="confirmation()" value="Leave Tizag.com">
</form>
</body>
</html>
Display:

Note the part in red. This is where all the magic happens. We call the confirm function with the message, "Leave Tizag?". JavaScript then makes a popup window with two choices and will return a value to our script code depending on which button the user clicks.

If the user clicks OK, a value of 1 is returned. If a user clicks cancel, a value of 0 is returned.. We store this value in answer by setting it equal to the confirm function call.

After answer has stored the value, we then use answer as a conditional statement. If answer is anything but zero, then we will send the user away from Tizag.com. If answer is equal to zero, we will keep the user at Tizag.com because they clicked the Cancel button.

In either case, we have a JavaScript alert box that appears to inform the user on what is going to happen. It will say, "Bye bye!" if they choose to leave and, "Thanks for sticking around!" if they choose to stay.

Javascript

2000

09/09/2023

Javascript

Function

Is Javascript Enabled

enable javascript

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

Javascript

1211

09/09/2023

Javascript

Function

While Loop

while loop

JavaScript While Loop Explained
There are two key parts to a JavaScript while loop:

1.The conditional statement which must be True for the while loop's code to be executed.
2.The while loop's code that is contained in curly braces "{ and }" will be executed if the condition is True.
When a while loop begins, the JavaScript interpreter checks if the condition statement is true. If it is, the code between the curly braces is executed. At the end of the code segment "}", the while loop loops back to the condition statement and begins again.

If the condition statement is always True, then you will never exit the while loop, so be very careful when using while loops!

Creating a Simple While Loop
This example shows how to create a basic while loop that will execute a document.write 10 times and then exit the loop statement.

JavaScript Code:
<script type="text/javascript">
<!--
var myCounter = 0;
var linebreak = "<br />";
document.write("While loop is beginning");
document.write(linebreak);

while(myCounter < 10){
	document.write("myCounter = " + myCounter);
	document.write(linebreak);
	myCounter++;
}

document.write("While loop is finished!");
</script>

Display:
While loop is beginning
myCounter = 0
myCounter = 1
myCounter = 2
myCounter = 3
myCounter = 4
myCounter = 5
myCounter = 6
myCounter = 7
myCounter = 8
myCounter = 9
While loop is finished! 
Our variable myCounter started off at 0, which is less than 10, so our while loop executed its code. The value 0 was printed to the browser and then myCounter was incremented by 1 and the while loop started over again.

1 was less than 10 so the while loop's code was executed... and the process repeats itself a few more times until...

myCounter was 10 which was not less than 10 so the while loop's code did not execute. You can see this in the Display: because the last value to be printed out was 9.

Note: Advanced programmers may recognize that a for loop would be a better solution for this example, but we hope you can ignore this for our needs to create an easy example!

Javascript

1170

09/09/2023

Javascript

Function

Comment Out Lines

comment rem

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!

Javascript

1507

09/09/2023

Javascript

Function

Date And Time

date time

JavaScript Date and Time Object
The Date object is useful when you want to display a date or use a timestamp in some sort of calculation. In Java, you can either make a Date object by supplying the date of your choice, or you can let JavaScript create a Date object based on your visitor's system clock. It is usually best to let JavaScript simply use the system clock.

Advertise on Tizag.com 
When creating a Date object based on the computer's (not web server's!) internal clock, it is important to note that if someone's clock is off by a few hours or they are in a different time zone, then the Date object will create a different times from the one created on your own computer.

JavaScript Date Today (Current)
To warm up our JavaScript Date object skills, let's do something easy. If you do not supply any arguments to the Date constructor (this makes the Date object) then it will create a Date object based on the visitor's internal clock.

HTML & JavaScript Code:
<h4>It is now  
<script type="text/javascript">

</script>
</h4>
Display:
It is now
Nothing shows up! That's because we still don't know the methods of the Date object that let us get the information we need (i.e. Day, Month, Hour, etc).

Get the JavaScript Time
The Date object has been created, and now we have a variable that holds the current date! To get the information we need to print out, we have to utilize some or all of the following functions:

•getTime() - Number of milliseconds since 1/1/1970 @ 12:00 AM
•getSeconds() - Number of seconds (0-59)
•getMinutes() - Number of minutes (0-59)
•getHours() - Number of hours (0-23)
•getDay() - Day of the week(0-6). 0 = Sunday, ... , 6 = Saturday
•getDate() - Day of the month (0-31)
•getMonth() - Number of month (0-11)
•getFullYear() - The four digit year (1970-9999)
Now we can print out the date information. We will be using the getDate, getMonth, and getFullYear methods in this example.

HTML & JavaScript Code:
<h4>It is now  
<script type="text/javascript">

</script>
</h4>

Display:
It is now 1/8/2011 !
Notice that we added 1 to the month variable to correct the problem with January being 0 and December being 11. After adding 1, January will be 1, and December will be 12.

JavaScript Current Time Clock
Now, instead of displaying the date we, will display the format you might see on a typical digital clock -- HH:MM AM/PM (H = Hour, M = Minute).

HTML & JavaScript Code:
<h4>It is now  
<script type="text/javascript">

</script>
</h4>

Display:
It is now 23:09 PM 
Above, we check to see if either the hours or minutes variable is less than 10. If it is, then we need to add a zero to the beginning of minutes. This is not necessary, but if it is 1:01 AM, our clock would output "1:1 AM", which doesn't look very nice at all!

Javascript

1569

09/09/2023

Javascript

Function

Determine If An Array Checkbox Or Radiobutton Has Been Checked

checkbox array radio button checked

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

Javascript

1648

09/09/2023

Javascript

Function

Label - Changing A Label On A Web Page

update label update caption innerHTML

Javascript

1365

09/09/2023

Javascript

Function

SELECT - Using To Update Page

combo redirect url location href wordpress getelementbyid window open

Javascript

1650

10/05/2024

Javascript

Function

GetElementById

javascript form tags id= SWD

J = InStr(CODE2, "## " + "##") : CODE2 = Left(CODE2, J - 1)
For J = 0 To TMPA.Count - 1
If InStr(CODE2, "##" + TMPA(J) + "##") = 0 Then NotFound = True : CODE2 = CODE2 + "##" + TMPA(J) + "##" + vbCR
Next
CODE2 = CODE2 + "## " + "##" + vbCR
If NotFound = True Then My.Computer.FileSystem.WriteAllText(Tree2 + Filename + "Code.txx", CODE2, append:=False)

Javascript

1010

09/09/2023

Javascript

Function

Bearing

Bearing heading latitude longitude

GPS

Javascript

09/09/2023

Javascript

Language

For Statement

for

Loops

Javascript

09/09/2023

Javascript

Link

Using A Button As A Hyperlink

button hyperlink

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`

Javascript

1624

09/09/2023

Javascript

Object

.select(); Clipboard

Clipboard object of document.getElementById().select;

<!DOCTYPE html>
<html>
<body>

<p>Click on the button to copy the text from the text field. Try to paste the text (e.g. ctrl+v) afterwards in a different window, to see the effect.</p>

/* Select the text field */
  copyText.select();
  copyText.setSelectionRange(0, 99999); /* For mobile devices */

/* Copy the text inside the text field */
  navigator.clipboard.writeText(copyText.value);
  
  /* Alert the copied text */
  alert("Copied the text: " + copyText.value);
}
</script>

</body>
</html>

<li>Dim dbs As Database
Dim rs As Recordset
Dim strSQL As String
Set dbs = CurrentDb

strSQL = 'your query here

Set rs = dbs.OpenRecordset(strSQL)

If Not (rs.EOF And rs.BOF) Then
  rs.MoveFirst
  'get results using rs.Fields()
Else

'Use results
<li>rs.MoveFirst
Do While Not rs.EOF
   'do something like rs("SomeFieldName") 
   rs.MoveNext
Loop
<li>DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM NameOfTable"
DoCmd.SetWarnings True
<li>Sub InsertIntoX2() 
     
        Dim dbs As Database 
     
        ' Modify this line to include the path to Northwind 
        ' on your computer. 
        Set dbs = OpenDatabase("Northwind.mdb") 
         
        ' Create a new record in the Employees table. The  
        ' first name is Harry, the last name is Washington,  
        ' and the job title is Trainee. 
        dbs.Execute " INSERT INTO Employees " _ 
            & "(FirstName,LastName, Title) VALUES " _ 
            & "('Harry', 'Washington', 'Trainee');" 
             
        dbs.Close 
     
    End Sub

Javascript

07/29/2022

Javascript

Printing

Print Web Page

print button

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:

Javascript

1423

09/09/2023

Javascript

String

String Manipulations

replace indexof substring length

indexOf:
var ss = "a string index of test ";
var result = ss.indexOf("ri");

length:

Replace Function: Global Regular Expression
By enabling the global property of our regular expression, we can go from replacing one match at a time to replacing all matches at once. To enable the global property, just put a "g" at the end of the regular expression.

replace:

Display:
Old string = Hello username! I hope you enjoy your stay username.
New string = Hello Chuck! I hope you enjoy your stay Chuck.

substring:

The output of the code above will be: lo w

Question: How do I convert numbers to strings in JavaScript?

Answer: The simplest way to convert any variable to a string is to add an empty string to that variable (i.e. concatenate it with an empty string ''), for example:

a = a+'' // This converts a to string
b += '' // This converts b to string

5.41 + '' // Result: the string '5.41'
Math.PI + '' // Result: the string '3.141592653589793'

Javascript

1246

09/09/2023

Javascript

String

Array Information

length array size count

<h2>Array Object Properties</h2>
<table>
  <tr>
    <td>Property</td>
    <td>Description</td>
  </tr>
  <tr>
    <td>constructor</td>
    <td>Returns the function that created the Array object's prototype</td>
  </tr>
  <tr>
    <td>length</td>
    <td>Sets or returns the number of elements in an array</td>
  </tr>
  <tr>
    <td>prototype</td>
    <td>Allows you to add properties and methods to an Array object</td>
  </tr>
  </table>
  
<h2>Array Object Methods</h2>
<table>
  <tr>
    <td>Method</td>
    <td>Description</td>
  </tr>
  <tr>
    <td>concat()</td>
    <td>Joins two or more arrays, and returns a copy of the joined arrays</td>
  </tr>
  <tr>
    <td>indexOf()</td>
    <td>Search the array for an element and returns it's position</td>
    </tr>
  <tr>
    <td>join()</td>
    <td>Joins all elements of an array into a string</td>
    </tr>
  <tr>
    <td>lastIndexOf()</td>
    <td>Search the array for an element, starting at the end, and returns it's position</td>
    </tr>
  <tr>
    <td>pop()</td>
    <td>Removes the last element of an array, and returns that element</td>
    </tr>
  <tr>
    <td>push()</td>
    <td>Adds new elements to the end of an array, and returns the new length</td>
    </tr>
  <tr>
    <td>reverse()</td>
    <td>Reverses the order of the elements in an array</td>
    </tr>
  <tr>
    <td>shift()</td>
    <td>Removes the first element of an array, and returns that element</td>
    </tr>
  <tr>
    <td>slice()</td>
    <td>Selects a part of an array, and returns the new array</td>
    </tr>
  <tr>
    <td>sort()</td>
    <td>Sorts the elements of an array</td>
    </tr>
  <tr>
    <td>splice()</td>
    <td>Adds/Removes elements from an array</td>
    </tr>
  <tr>
    <td>toString()</td>
    <td>Converts an array to a string, and returns the result</td>
    </tr>
  <tr>
    <td>unshift()</td>
    <td>Adds new elements to the beginning of an array, and returns the new length</td>
    </tr>
  <tr>
    <td>valueOf()</td>
    <td>Returns the primitive value of an array</td>
    </tr>
</table>

Javascript

1296

09/09/2023

Javascript

Text Box

Auto Clear Text Box

Input text - auto clear

FIND A STORE

Javascript

1460

09/09/2023

Javascript

Text Box

Move To Next Field Automatically When Textbox Is Full

auto move text box event keycode focus

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();
}
}
}

-
-
";

Javascript

1542

09/09/2023

Javascript

Variables

Using Math In Functions

float integer math parse gps distance heading bearing

Javascript Math

Javascript

02/20/2026

Microsoft Excel

Clipboard

Text Import Wizard

csv delimited special formatting

You can use Microsoft Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data is imported in the way that you want.

Note    To start the Text Import Wizard, on the Data tab, in the Get External Data group, click From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import.

Excel Ribbon Image

Step 1 of 3

Original data type    If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. If all of the items in each column are the same length, select Fixed width.

Start import at row    Type or select a row number to specify the first row of the data that you want to import.

File origin    Select the character set that is used in the text file. In most cases, you can leave this setting at its default. If you know that the text file was created by using a different character set than the character set that you are using on your computer, you should change this setting to match that character set. For example, if your computer is set to use character set 1251 (Cyrillic, Windows), but you know that the file was produced by using character set 1252 (Western European, Windows), you should set File Origin to 1252.

Preview of file    This box displays the text as it will appear when it is separated into columns on the worksheet.

Step 2 of 3 (Delimited data)

Delimiters    Select the character that separates values in your text file. If the character is not listed, select the Other check box, and then type the character in the box that contains the cursor. These options are not available if your data type is Fixed width.

Treat consecutive delimiters as one    Select this check box if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters.

Text qualifier    Select the character that encloses values in your text file. When Excel encounters the text qualifier character, all of the text that follows that character and precedes the next occurrence of that character is imported as one value, even if the text contains a delimiter character. For example, if the delimiter is a comma (,) and the text qualifier is a quotation mark ("), "Dallas, Texas" is imported into one cell as Dallas, Texas. If no character or the apostrophe (') is specified as the text qualifier, "Dallas, Texas" is imported into two adjacent cells as "Dallas and Texas".

If the delimiter character occurs between text qualifiers, Excel omits the qualifiers in the imported value. If no delimiter character occurs between text qualifiers, Excel includes the qualifier character in the imported value. Hence, "Dallas Texas" (using the quotation mark text qualifier) is imported into one cell as "Dallas Texas".

Data preview    Review the text in this box to verify that the text will be separated into columns on the worksheet as you want it.

Step 2 of 3 (Fixed width data)

Data preview    Set field widths in this section. Click the preview window to set a column break, which is represented by a vertical line. Double-click a column break to remove it, or drag a column break to move it.

Step 3 of 3

Click the Advanced button to do one or more of the following:

##Specify the type of decimal and thousands separators that are used in the text file. When the data is imported into Excel, the separators will match those that are specified for your location in Regional and Language Options or Regional Settings (Windows Control Panel).

##Specify that one or more numeric values may contain a trailing minus sign.

Column data format    Click the data format of the column that is selected in the Data preview section. If you do not want to import the selected column, click Do not import column (skip).

After you select a data format option for the selected column, the column heading under Data preview displays the format. If you select Date, select a date format in the Date box.

Choose the data format that closely matches the preview data so that Excel can convert the imported data correctly. For example:

##To convert a column of all currency number characters to the Excel Currency format, select General.

##To convert a column of all number characters to the Excel Text format, select Text.

##To convert a column of all date characters, each date in the order of year, month, and day, to the Excel Date format, select Date, and then select the date type of YMD in the Date box.

Excel will import the column as General if the conversion could yield unintended results. For example:

##If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General.

##If, in a column of dates, each date is in the order of year, month, and date, and you select Date along with a date type of MDY, Excel converts the column to General format. A column that contains date characters must closely match an Excel built-in date or custom date formats.

If Excel does not convert a column to the format that you want, you can convert the data after you import it.

Microsoft Excel

1089

09/09/2023

Microsoft Excel

Customizing

Lock The Top Row / Header When Scrolling In Excel & Google Sheets

freeze lock

Headers

excel freeze panes example
Freeze Top Row
In a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it.
In the Ribbon, select View > Freeze Panes.
excel freeze panes ribbon
Select Freeze Top Row.
As you scroll down in your worksheet, the top row remains visible regardless of how far you scroll.
excel freeze panes row68
To remove the freeze, select Unfreeze Panes from the Freeze Panes menu.
excel freeze panes unfreeze
Freeze Panes
You can also freeze more than one row at a time.
Position your cursor in the row you wish to freeze.
In the Ribbon, select View > Freeze Panes > Freeze Panes.
excel freeze rows multiple rows
The worksheet freezes Rows 1 to 3. If you scroll down, these rows remain in view.
excel freeze panes multiple rows example
To remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu.
Try our AI Formula Generator
Ex. Sum all values in Column B where Column A equal Q1
Generate
Freeze Top Row in Google Sheets
The process is similar in Google Sheets
In the Menu, click View > Freeze > 1 row.
excel freeze panes google sheets menu
As you scroll down, the top row remains in place.

Microsoft Excel

01/05/2024

Microsoft Excel

Customizing

Adding A Color To Alternate Rows

color alternate rows

Filter List

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.

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.

Microsoft Excel

12/08/2025

Microsoft Excel

Form

Button To Go To A Certain Sheet

button sheet

Microsoft Excel

09/09/2023

Microsoft Excel

Formatting

Show Developer Tab In Ribbon In Excel 2010 And Later Versions

Developer macro button

Microsoft Excel

09/09/2023

Microsoft Excel

Function

Updating Multiple Cells

Multiple sheets range

Microsoft Excel

09/09/2023

Microsoft Excel

Language

IF Usage In Excel

if(

Microsoft Excel

09/09/2023

Microsoft Excel

Pdf

Printing Group Of Sheets

create pdf worksheet groups excel

When you print a Microsoft Excel workbook to the Adobe PDF printer or the Acrobat Distiller printer, and the Print Entire Workbook option is selected in the Print dialog box, more than one PDF file is created (for example, Workbook 1, Workbook 2, and Workbook 3).

Solutions

Do one or more of the following:

Make sure that the print quality setting is the same for all of the worksheets in the workbook.

1. In Excel, hold down the Ctrl key (Windows) or the Shift key (Mac OS), and select all of the sheets in the Excel workbook.

2. Choose File > Page Setup > Page > Print Quality, and select a print quality setting. Adobe Technical Support recommends that you select 600 dpi, which is the default setting for the Adobe PDF and Acrobat Distiller printers.

I selected active sheets and pdf worked. Right click a tab to Ungroup the sheets.

Print the workbook to a PostScript file, and then use Acrobat Distiller to convert the PostScript file to a PDF file.

Print the workbook to a PostScript file using the Adobe PostScript printer driver (AdobePS), then use Acrobat Distiller to convert the PostScript file to a PDF file. Adobe Technical Support has achieved more consistent results using Acrobat Distiller when converting an Excel workbook to PDF.

Select Print Entire Workbook in the Print dialog box in Excel.

Select all of the sheets in the Excel workbook, then select the Print Entire Workbook option in the Print dialog box. To select multiple sheets, hold down the Control key (Windows) or the Shift key (Mac OS).

Microsoft Excel

1527

09/09/2023

Mysql

Database

Alter Table

change table alter table

Mysql

09/09/2023

Mysql

Database

Does Field Exit In Table

field exists

Developer

Mysql

12/02/2023

Mysql

Database

MySQL ALTER TABLE Statement

alter table drop add modify

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;

Mysql

12/02/2023

Mysql

Database

Query Language

num show

Developer

1. Using the SHOW TABLES Command:

You can use the SHOW TABLES command to list all tables in a specific database and then check if your table is among them.

SHOW TABLES LIKE 'your_table_name';

Mysql

03/14/2025

Mysql

Database

Truncate A Table

empty truncate delete

Empty Tables

TRUNCATE TABLE parts

When you truncate a table, the AUTO_INCREMENT counters on the table will be reset.
MySQL truncates the table by dropping and creating the table. Thus, the DELETE triggers for the table do not fire during the truncation.
Starting in MySQL 5.5, you can not truncate an InnoDB table that is referenced by a foreign key in another table.
Starting in MySQL 5.6, you can not truncate a NDB table that is referenced by a foreign key in another table.

Example

In MySQL, truncating a table is a fast way to clear out records from a table if you don't need to worry about rolling back. In most cases, MySQL handles the process of table truncation a bit differently than other databases such as Oracle or SQL Server.

Let's look at an example of how to use the TRUNCATE TABLE statement in MySQL.

For example:

TRUNCATE TABLE customers;

This example would truncate the table called customers and remove all records from that table.

It would be equivalent to the following DELETE statement in MySQL:

DELETE FROM customers;

Both of these statements would result in all data from the customers table being deleted. The main difference between the two is that you can roll back the DELETE statement if you choose, but you can't roll back the TRUNCATE TABLE statement.

Let's look at one more example where we prefix the table name with the database name.

For example:

Mysql

03/31/2025

Notes

Input Type: color

Example

Input Type: date

Example

Input Type: datetime

Example

Input Type: datetime-local

Example

Input Type: email

Example

Input Type: month

Example

Input Type: number

Example

Input Type: range

Example

Input Type: search

Example

Input Type: tel

Example

Input Type: time

Example

Input Type: url

Example

Input Type: week

Example

Sample text:

More on JPS

This content is in a div with id "thicanbeanything"

Classes

FIND A STORE