HTML5 Template
This is the basic HTML5 template. Use it as the starting place for all your of HTML5 documents. Some editors allow you to add a template file for quickly creating a file. If your editor does not already have an HTML5 template, you can use this one. You can also keep it someplace convenient to copy and paste from if you wish.
<!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <title></title> </head> <body> </body> </html>
Selected MySQL commands
MySQL is very helpful when building a database. The following table contains the minimal commands needed to create, populate, and query a database using MySQL.
Command | Discussion |
---|---|
USE databaseName; | Set the databaseName as the default database |
DROP TABLE IF EXISTS tableName; | Delete the entire table |
CREATE TABLE tableName (
fieldName type modifiers, ); |
Create a table called tableName with the fields defined by the field lines.Modifiers: PRIMARY KEY, AUTO_INCREMENT |
INSERT INTO tableName VALUES ( …) ; | Insert a new record into tableName. Values must be correct type in correct order. |
SELECT * FROM tableName WHERE condition ORDER BY field | Select all fields from tableName which meet the condition. Sort according to the given field. |
UPDATE tableName SET field = value WHERE condition; | Modify an existing record. Use condition to specify which record is modified, and set given value(s) to specified field(s) |
DELETE FROM tableName WHERE condition | Delete any records from the tableName table that satisfy the condition |
CREATE VIEW viewName AS query | Create a virtual table containing the results of a complex query (often an inner join or link table join) |
Selected JavaScript syntax
JavaScript is still one of the most used programming languages, especially for client-side programming, and the following table offers a summary of the most useful functions and what they do.
![image0.jpg](https://www.dummies.com/wp-content/uploads/221808.image0.jpg)
Selected CSS attributes
This table highlights the most commonly used CSS attributes. Each of these attributes can be applied to any container element in a page. The container can be a single element denoted by the ID attribute, a member of a class, or all the elements in a page of a certain type.
Attribute | Discussion |
---|---|
margin | Defines space between element border and parent (left, right, top, bottom variations) |
padding | Defines space between contents and border (with variants) |
border: size color style | Defines a border. Styles: none, dotted, dashed, solid, double, groove, ridge, inset, and outset. |
color | Foreground color: color name or hex value |
background-color | Background color: color name or hex value |
background-image: url(filename) | Sets image indicated by filename as background image |
background-repeat | Indicates how background will repeat: repeat, repeat-x, repeat-y, and no-repeat |
font-family | Font name: sans-serif, serif, monospace, cursive, and fantasy |
font-size | Font size (best specified in ems or percent) |
font-style | Set italics: none, italic, and oblique |
font-weight | Set boldness: lighter, normal, bold, and bolder (100-900) |
text-align | Alignment: left, right, center, and justify. Works on content, not a block |
text-decoration | Adds decoration to text: none, underline, overline, line-through, and blink |
display | Defines how element is displayed: none, block, and inline |
position | Describes positioning scheme: absolute and relative |
left, top, right, bottom | Indicates position of element (must set position absolute or relative first) |
float | Removes element from normal layout and floats it in a direction: left and right |
height, width | Specifies the height and width of an element. Important for floated elements. |
clear | Force this floated element to position: left, right, and both |
Selected HTML syntax
Despite all the new programming languages and technology, HTML remains the basic building block for a lot of websites. This table contains the most commonly-used HTML tags.
Tag | Comments |
---|---|
<html></html> | Required for all pages. |
<head></head> | Required for all pages — must be inside HTML tags. |
<title></title> | Must be in head. |
<body></body> | Required for all pages — must be inside HTML tags. |
<link rel = “stylesheet” type = “text/css” href = “address” /> |
Link to external style sheet. Replace address with URL of style sheet. |
<style type = “text/css”></style> |
Page-level style sheet declaration. |
<h1></h1> .. <h6>..</h6> |
Defines headline from most prominent (h1) to least prominent (h6). |
<p></p> | Paragraph. |
<div></div> | Generic block-level component. |
<span></span> | Generic inline component. |
<em></em> | Emphasis (default: italics). |
<strong></strong> | Strong emphasis (default: bold). |
<br /> | Line break. |
<ol></ol> | Defines an ordered list. |
<ul></ul> | Defines an unordered list. |
<li></li> | List item — must be inside ol or ul pair. |
<dl></dl> | Definition list — a list of terms and definitions. |
<dt></dt> | Definition term — found in dl groups. |
<dd></dd> | Definition data — usually paired with a dt set inside a dl. |
<a href = “address”>content</a> |
Displays content as a link, and sends browser to address when activated. |
<img src = “filename” alt = “alternative text” /> |
Displays image referenced by filename. Alternative text is required for non-visual browsers. |
<table></table> | Define an HTML table. |
<tr></tr> | Table row. |
<th></th> | Table header — must be inside tr. |
<td></td> | Table data — must be inside tr. |
<script></script> | Internal JavaScript code. |
<script src = “filename”></script> |
Load external JavaScript code. |
<!–[if IE]><![endif]→ |
Conditional comment. Code inside these tags will only be executed by Internet Explorer. It’s possible to indicate specific versions as well (<!—[if IE < 7]>). |