Method I :
SELECT count('id') as cnt,order_status,order_date FROM `product_order`
group by MONTH(order_date)
Method II :
SELECT count('id') as cnt,order_status,order_date FROM `product_order`
group by DATE_FORMAT(order_date, '%m')
Method III:
SELECT SQL_NO_CACHE YEAR(record_date), MONTH(record_date), COUNT(*) FROM stats
GROUP BY YEAR(record_date)*100 + MONTH(record_date)
SELECT YEAR(date_column), MONTH(date_column), COUNT(*)
FROM date_table
GROUP BY DATE_FORMAT(date_column, '%Y%m')
Static Maps API <img src="http://maps.google.com/staticmap?size=500x400&markers=11,78&zoom=12"><img src="http://maps.googleapis.com/maps/api/streetview?size=200x200&location=40.720032,-73.988354&heading=235">
function generate_password( $length = 8 ) {
$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
$password = substr( str_shuffle( $chars ), 0, $length );
return $password;
}
function generate_number_code( $length = 8 ) {
$chars = "0123456789";
$password = substr( str_shuffle( $chars ), 0, $length );
return $password;
}
function getRandom(length) {
var rand = Math.floor(Math.pow(10, length-1) + Math.random() * 9 * Math.pow(10, length-1));
return rand;
}
Between two years SELECT * FROM `dt_tb` WHERE year( dt2 ) between 2004 and 2005 Between two month ranges. SELECT * FROM `dt_tb` WHERE month(dt) between '02' and '08' SELECT * FROM `dt_tb` WHERE month(dt) between '02' and '08' and year(dt) between 2004 and 2005 Between two date ranges SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31'
Method I
<?php ob_start(); if(isset($_GET['elimina_id'])){ if (in_array($_GET['elimina_id'], $_SESSION['cart']) ) { $index = (array_keys($_SESSION['cart'], $_GET['elimina_id'])); $i = $index[0]; unset($_SESSION['cart'][$i]); header('location: cart.php'); } } ob_end_flush(); ?>
Method II
HTML: <meta http-equiv="refresh" content="0;url=http://www.site.com/cart.php"> JavaScript #1: <script>window.location = "http://www.site.com/cart.php";</script> JavaScript #2: <script>window.navigate("http://www.site.com/cart.php");</script>
@media screen and (min-width: 768px) {
.modal-dialog {
left: 50%;
right: auto;
width: 624px;
}
}
.modal-dialog{
position: absolute;
left: 50%;
//now you must set a margin left under zero - value is a half width your window
margin-left: -312px;
// this same situation is with height - example
height: 500px;
top: 50%;
margin-top: -250px;
}
Enter text filed only to allow alphabit & Numbers
function alpha_numeric_validation(arg){
var valReg = /^[A-Za-z0-9]+$/;
if(valReg.test( arg ) ) {
return false;
} else {
return true;
}
}
Enter text file allow allphabi & space only
function alpha_space_validation(arg){
var valReg = /^[A-Za-z ]+$/;
if(valReg.test( arg ) ) {
return false;
} else {
return true;
}
}
alert(email_validation("asasas"))
function email_validation(arg){
var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
if( !emailReg.test( arg ) ) {
return false;
} else {
return true;
}
}
function get_enum($table,$clname){
$Query="SHOW COLUMNS FROM `$table` LIKE '$clname'";
$result = $this->db->query($Query) or die("Get Enum value Query");
if($result){
$row = mysql_fetch_array( $result , MYSQL_NUM );
$regex = "/'(.*?)'/";
preg_match_all( $regex , $row[1], $enum_array );
$enum_fields = $enum_array[1];
return $enum_fields;
}
return false;
}
Removes the datepicker functionality completely. This will return the element back to its pre-init state. Code : $( "#start_date" ).datepicker( "destroy" ); $( "#end_date" ).datepicker( "destroy" );
var resp ="" //Json Value
var objJSON = eval("(function(){return " + resp + ";})()");
objJSON.name // Value
| To do this... | Type this... | Or this... | Description |
| ‘ | ‘ | left single quote | |
| ’ | ’ | right single quote | |
| ‚ | ‚ | single low-9 quote | |
| “ | “ | left double quote | |
| ” | ” | right double quote | |
| „ | „ | double low-9 quote | |
| † | † | dagger | |
| ‡ | ‡ | double dagger | |
| ‰ | ‰ | per mill sign | |
| ‹ | ‹ | single left-pointing angle quote | |
| › | › | single right-pointing angle quote | |
| ♠ | ♠ | black spade suit | |
| ♣ | ♣ | black club suit | |
| ♥ | ♥ | black heart suit | |
| ♦ | ♦ | black diamond suit | |
| ★ | ★ | black star | |
| ☆ | ☆ | white star | |
| ‾ | ‾ | overline, = spacing overscore | |
| ← | ← | leftward arrow | |
| ↑ | ↑ | upward arrow | |
| → | → | rightward arrow | |
| ↓ | ↓ | downward arrow | |
| © | © | © | copyright sign |
| ™ | ™ | trademark sign | |
| �-  |
unused | ||
| 	 | horizontal tab | ||
| | line feed | ||
| |   | Non-breaking space | |
|   | space | ||
| ! | ! | exclamation mark | |
| " | " | " | double quotation mark |
| # | # | number sign | |
| $ | $ | dollar sign | |
| % | % | percent sign | |
| & | & | & | ampersand |
| ' | ' | apostrophe | |
| ( | ( | left parenthesis | |
| ) | ) | right parenthesis | |
| * | * | asterisk | |
| + | + | plus sign | |
| , | , | comma | |
| - | - | hyphen | |
| . | . | period | |
| · | · | · | middle dot |
| • | • | bullet | |
| / | ⁄ | / | slash |
| 0 - 9 | 0- 9 |
digits 0-9 | |
| : | : | colon | |
| ; | ; | semicolon | |
| < | < | < | less-than sign |
| = | = | equals sign | |
| > | > | > | greater-than sign |
| ? | ? | question mark | |
| @ | @ | at sign | |
| A - Z | A- Z |
uppercase letters A-Z | |
| [ | [ | left square bracket | |
| \ | \ | backslash | |
| ] | ] | right square bracket | |
| ^ | ^ | caret | |
| _ | _ | horizontal bar (underscore) | |
| ` | ` | grave accent | |
| a - z | a- z |
lowercase letters a-z | |
| { | { | left curly brace | |
| | | | | vertical bar | |
| / | ⁄ | / | slash |
| ° | ° | ° | degree sign |
| ± | ± | ± | plus or minus |
| ² | ² | ² | superscript two |
| ³ | ³ | ³ | superscript three |
| ´ | ´ | ´ | acute accent |
| µ | µ | µ | micro sign |
| ¶ | ¶ | ¶ | paragraph sign |
| ¸ | ¸ | ¸ | cedilla |
| ¹ | ¹ | ¹ | superscript one |
| º | º | º | masculine ordinal |
| » | » | right angle quote | |
| ¼ | ¼ | ¼ | one-fourth |
| ½ | ½ | ½ | one-half |
| ¾ | ¾ | ¾ | three-fourths |
| ¿ | ¿ | ¿ | inverted question mark |
| À | À | À | uppercase A, grave accent |
| Á | Á | Á | uppercase A, acute accent |
| Â | Â | Â | uppercase A, circumflex accent |
| Ã | Ã | Ã | uppercase A, tilde |
| Ä | Ä | Ä | uppercase A, umlaut |
| Å | Å | Å | uppercase A, ring |
| Æ | Æ | Æ | uppercase AE |
| Ç | Ç | Ç | uppercase C, cedilla |
| È | È | È | uppercase E, grave accent |
| É | É | É | uppercase E, acute accent |
| Ê | Ê | Ê | uppercase E, circumflex accent |
| Ë | Ë | Ë | uppercase E, umlaut |
| Ì | Ì | Ì | uppercase I, grave accent |
| Í | Í | Í | uppercase I, acute accent |
| Î | Î | Î | uppercase I, circumflex accent |
| Ï | Ï | Ï | uppercase I, umlaut |
| Ð | Ð | Ð | uppercase Eth, Icelandic |
| Ñ | Ñ | Ñ | uppercase N, tilde |
| Ò | Ò | Ò | uppercase O, grave accent |
| Ó | Ó | Ó | uppercase O, acute accent |
| Ô | Ô | Ô | uppercase O, circumflex accent |
| Õ | Õ | Õ | uppercase O, tilde |
| Ö | Ö | Ö | uppercase O, umlaut |
| × | × | × | multiplication sign |
| Ø | Ø | Ø | uppercase O, slash |
| Ù | Ù | Ù | uppercase U, grave accent |
| Ú | Ú | Ú | uppercase U, acute accent |
| Û | Û | Û | uppercase U, circumflex accent |
| Ü | Ü | Ü | uppercase U, umlaut |
| Ý | Ý | Ý | uppercase Y, acute accent |
| Þ | Þ | Þ | uppercase THORN, Icelandic |
| ß | ß | ß | lowercase sharps, German |
| à | à | à | lowercase a, grave accent |
| á | á | á | lowercase a, acute accent |
| â | â | â | lowercase a, circumflex accent |
| ã | ã | ã | lowercase a, tilde |
| ä | ä | ä | lowercase a, umlaut |
| å | å | å | lowercase a, ring |
| æ | æ | æ | lowercase ae |
| ç | ç | ç | lowercase c, cedilla |
| è | è | è | lowercase e, grave accent |
| é | é | é | lowercase e, acute accent |
| ê | ê | ê | lowercase e, circumflex accent |
| ë | ë | ë | lowercase e, umlaut |
| ì | ì | ì | lowercase i, grave accent |
| í | í | í | lowercase i, acute accent |
| î | î | î | lowercase i, circumflex accent |
| ï | ï | ï | lowercase i, umlaut |
| ð | ð | ð | lowercase eth, Icelandic |
| ñ | ñ | ñ | lowercase n, tilde |
| ò | ò | ò | lowercase o, grave accent |
| ó | ó | ó | lowercase o, acute accent |
| ô | ô | ô | lowercase o, circumflex accent |
| õ | õ | õ | lowercase o, tilde |
| ö | ö | ö | lowercase o, umlaut |
| ÷ | ÷ | ÷ | division sign |
| ø | ø | ø | lowercase o, slash |
| ù | ù | ù | lowercase u, grave accent |
| ú | ú | ú | lowercase u, acute accent |
| û | û | û | lowercase u, circumflex accent |
| ü | ü | ü | lowercase u, umlaut |
| ý | ý | ý | lowercase y, acute accent |
| þ | þ | þ | lowercase thorn, Icelandic |
| ÿ | ÿ | ÿ | lowercase y, umlaut |
$( "#start_date" ).datepicker({
minDate: new Datenew Date(1999, 10 - 1, 25),
maxDate: new Datenew Date(1999, 10 - 1, 30),
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 2,
onClose: function( selectedDate ) {
$( "#end_date" ).datepicker( "option", "minDate", selectedDate );
}
});
$( "#end_date" ).datepicker({
minDate: new Datenew Date(1999, 10 - 1, 25),
maxDate: new Datenew Date(1999, 10 - 1, 30),
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 2,
onClose: function( selectedDate ) {
$( "#start_date" ).datepicker( "option", "maxDate", selectedDate );
}
});