mardi 29 décembre 2015

#Commandes #HTML

Document Outline

<!DOCTYPE> Version of (X)HTML
<html>….</html> HTML document
<head>….</head> Page information
<body>….</body> Page contests

Comments
<!– Comment Test –>
Page Information
<base /> Base URL
<meta /> Meta data
<title>….</title> Title
<link /> Relevant resource
<style>….</style> Style resource
<script>….</script> Script resource

Document Structure 
<h1>….</h1> to <h6>….</h6> Heading
<div>….</div> Page section
<span>….</span> Inline section
<p>….</p> Paragraph
<br> Line break
<hr> Horizontal rule

Links 
<a href=””> Page link
<a href=”mailto:”> Email link
<a name=”name”> Anchor
<a href=”#name”> Link to anchor

Text Markup
<strong>….</strong> Strong emphasis
<em>….</em> Emphasis
<blockquote>….</blockquote> Long quotation
<q>….</q> Short quotation
<abbr>….</abbr> Abbreviation
<acronym>….</acronym> Acronym
<address>….</address> Address
<pre>….</pre> Pre-formatted text
<dfn>….</dfn> Definition
<code>….</code> Code
<cite>….</cite> Citation
<del>….</del> Deleted text
<ins>….</ins> Inserted text
<sub>….</sub> Subscript
<sup>….</sup> Superscript
<bdo>….</bdo> Text direction


List
<ol>….</ol> Ordered list
<ul>….</ul> Unordered list
<li>….</li> List item
<dl>….</dl> Definition list
<dt>….</dt> Definition term
<dd>….</dd> Term description


Forms
<form>….</form> Form
<fieldset>….</fieldset> Collection of fields
<legend>….</legend> Form legend
<label>….</label> Input label
<input>….</input> Form input
<select>….</select> Drop-down box
<optgroup>….</optgroup> Group of options
<option>….</option> Drop-down options
<textarea>….</textarea> Large text input
<button>….</button> Button


Tables
<table>….</table> Table
<caption>….</caption> Caption
<thead>….</thead> Table body
<tbody>….</tbody> Table body
<tfoot>….</tfoot> Table footer
<colgroup> Column group
<col /> Column
<tr>….</tr> Table row
<th>….</th> Header cell
<td>….</td> Table cell

Images and Image Maps
<img />
Image
<map>….</map>
Image Map
<area />
Area of image map
Common Character Entities
&#34;   ”   Quotation mark
&#38;   &   Ampersand
&#60;   <   Less than
&#62;   >   Greater than
&#64;   @  “At” symbol
&#128;  €   Euro
&#149;  •   Small bullet
&#153;  ™  Trademark
&#163;  £   Pound
&#160;       Non-breaking space
&#169;  ©  Copyright symbol
Objects
<object>….</object>
Object
<param />
Parameter
Empty Elements
<area />
<base />
<br />
<col />
<hr />
<img />
<input />
<link />
<meta />
<param />
Core Attributes
Class: id      Style: title
Note: Core attributes may not be used in base, head, html, meta, param, script, style or title elements.
Language Attributes 
dir       lang
Note: Language Attributes may not be used in base, br, frame, framest, hr, iframe, param or script elements.
Keyboard Attributes
accesskey     tabindex
Window Events
onLoad    onUnload
Form Events
onBlur        onReset
onChange   onSelect
onFocus     onSubmit
Keyboard Events
onKeydown   onKeyup
onKeypress
Mouse Events
onClick    onMouseout
onDblclick    onMouseover
onMousedown   onMouseup
onMousemove

#Commandes #MySQL

MySQL Data Types

CHAR
String (0 – 255)
VARCHAR
String (0 – 255)
TINYTEXT
String (0 – 255)
TEXT
String (0 – 65535)
BLOB
String (0 – 65535)
MEDIUMTEXT
String (0 – 16777215)
MEDIUMBLOB
String (0 – 16777215)
LONGTEXT
String (0 – 429496­7295)
LONGBLOB
String (0 – 429496­7295)
TINYINT x
Integer (-128 to 127)
SMALLINT x
Integer (-32768 to 32767)
MEDIUMINT x
  Integer (-8388608 to 8388607)
INT x
 Integer (-2147­483648 to 214748­3647)
BIGINT x
Integer (-9223­372­036­854­775808 to 922337­203­685­477­5807)
FLOAT
Decimal (precise to 23 digits)
DOUBLE
Decimal (24 to 53 digits)
DECIMAL
“­DOU­BLE­” stored as string
DATE
YYYY-MM-DD
DATETIME
YYYY-MM-DD HH:MM:SS
TIMESTAMP
YYYYMM­DDH­HMMSS
TIME
HH:MM:SS
ENUM
One of preset options
SET
Selection of preset options

MySQL Mathem­atical Functions

ABS
COS
SIGN
SIN
MOD
TAN
FLOOR
ACOS
CEILING
ASIN
ROUND
ATAN, ATAN2
DIV
COT
EXP
RAND
LN
LEAST
LOG, LOG2, LOG10 
GREATEST
POW
DEGREES
POWER
RADIANS
SQRT
TRUNCATE
PI

MySQL Date and Time Functions

DAYOFWEEK
DATE_SUB
WEEKDAY
ADDDATE
DAYOFMONTH
SUBDATE
DAYOFYEAR
EXTRACT
MONTH
TO_DAYS
DAYNAME
FROM_DAYS
MONTHNAME
DATE_F­ORMAT
QUARTER
TIME_F­ORMAT
WEEK
CURREN­T_DATE
YEAR
CURREN­T_TIME
YEARWEEK
NOW
HOUR
SYSDATE
MINUTE
UNIX_T­IME­STAMP
SECOND
FROM_U­NIXTIME
PERIOD_ADD
SEC_TO­_TIME
PERIOD­_DIFF
 TIME_T­O_SEC
DATE_ADD

MySQL Miscel­laneous Functions

BIT_COUNT
DES_EN­CRYPT
DATABASE
DES_DE­CRYPT
USER
LAST_I­NSE­RT_ID
SYSTEM­_USER
FORMAT
SESSIO­N_USER
VERSION
CURREN­T_USER 
CONNEC­TION_ID
PASSWORD
GET_LOCK
OLD_PA­SSWORD
RELEAS­E_LOCK
ENCRYPT
IS_FRE­E_LOCK
DECODE
BENCHMARK
MD5
INET_NTOA
SHA1
INET_ATON
AES_EN­CRYPT
FOUND_ROWS
AES_DE­CRYPT
STRCMP

MySQL String Functions

ASCII
SUBSTRING
ORD
MID
CONV
SUBSTRING_INDEX
BIN
LTRIM
OCT
RTRIM
HEX
TRIM
CHAR
SOUNDEX
CONCAT
SPACE
CONCAT_WS
REPLACE
LENGTH
REPEAT
CHAR_LENGTH
 REVERSE
BIT_LENGTH
INSERT
LOCATE
ELT
INSTR
FIELD
LPAD
LCASE
RPAD
UCASE
LEFT
LOAD_FILE
RIGHT
QUOTE

MySQL Grouping Functions

AVG
MAX
BIT_AND
STD
BIT_OR
STDDEV
COUNT
SUM
GROUP_­CONCAT
 VARIANCE
MIN

#Commandes #Javascript

Regular Expres­sions Syntax

^
Start of string
$
End of string
.
Any single character
(a|b)
a or b
(…)
Group section
[abc]
In range (a, b or c)
[^abc]
Not in range
\s
White space
a?
Zero or one of a
a*
Zero or more of a
a*?
Zero or more, ungreedy
a+
One or more of a
a+?
One or more, ungreedy
a{3}
Exactly 3 of a
a{3,}
3 or more of a
a{,6}
Up to 6 of a
a{3,6}
3 to 6 of a
a{3,6}?
3 to 6 of a, ungreedy
\
Escape character
[:punct:] 
Any punctu­ation symbol
[:space:]
Any space character
[:blank:]
Space or tab

JavaScript Event Handlers

onabort
onmous­edown
onblur
onmous­emove
onchange
onmouseout
onclick
onmous­eover
ondblclick
onmouseup
ondragdrop
onmove
onerror
onreset
onfocus
onresize
onkeydown
onselect
onkeypress 
onsubmit
onkeyup
onunload
onload

JavaScript Dates

Date()
setMonth()
getDate()
setFul­lYear()
getDay()
setHours()
getMonth
setMin­utes()
getFul­lYear
setSec­onds()
getYear
setMil­lis­eco­nds()
getHours
setTime()
getMinutes
setUTC­Date()
getSeconds
setUTC­Day()
getMil­lis­econds
setUTC­Month()
getTime
setUTC­Ful­lYear()
getTim­ezo­neO­ffset()
setUTC­Hours()
getUTC­Date()
setUTC­Min­utes()
getUTC­Day()
setUTC­Sec­onds()
getUTC­Month()
setUTC­Mil­lis­eco­nds()
getUTC­Ful­lYear()
toSource()
getUTC­Hours()
toString()
getUTC­Min­utes()
toGMTS­tring()
getUTC­Sec­onds()
toUTCS­tring()
getUTC­Mil­lis­eco­nds() 
toLoca­leS­tring()
parse()
UTC()
setDate()
valueOf()

Pattern Modifiers

g
Global match
i *
Case-i­nse­nsitive
m *
Multiple lines
s *
Treat string as single line
x *
Allow comments and whitespace in pattern
e *
Evaluate replac­ement
U *
Ungreedy pattern

JavaScript Arrays

concat()
slice()
join()
sort()
length
splice()
pop()
toSource()
push()
toString()
reverse()
unshift()
shift()
valueOf()

JavaScript Strings

charAt()
slice()
charCo­deAt()
split() x
concat()
substr()
fromCh­arC­ode()
substr­ing()
indexOf()
toLowe­rCase()
lastIn­dexOf()
toUppe­rCase()
length
toLoca­leL­owe­rCase()
locale­Com­pare() 
toLoca­leU­ppe­rCase()
match() x
toSource()
replace() x
valueOf()
search() x

JavaScript RegExp Object

compile()
lastParen
exec()
leftCO­ntext
global
multiline
ignoreCase 
rightC­ontext
input
source
lastIndex
test()
lastMatch

JavaScript Numbers and Maths

abs()
min()
acos()
NEGATI­VE_­INF­INITY
asin()
PI
atan()
POSITI­VE_­INF­INITY
atan2()
pow()
ceil()
random()
cos()
round()
E
sin()
exp()
sqrt()
floor()
SQRT1_2
LN10
SQRT2
LN2
tan()
log()
toSource()
LOG10E
toExpo­nen­tial()
LOG2E
toFixed()
max()
toPrec­ision()
MAX_VALUE 
toString()
MIN_VALUE
valueOf()
NaN

JavaScript Booleans

toSource()
valueOf()
toString()

JavaScript Functions

decode­URI()
 isNaN()
decode­URI­Com­pon­ent()
 Number()
encode­URI()
 parseF­loat()
encode­URI­Com­pon­ent()
 parseInt()
escape()
 String()
eval()
 unescape()
isFinite()

openbase.io

Archives du blog