If we want to get rows by filtering given month and year, We can use 2 popular ways.
EXTRACT()
BETWEEN
1. EXTRACT( ):
The EXTRACT() function is used to return a single part of a date/time, such as year, month, day, hour, minute, etc.
SYNTAX:
EXTRACT(unit FROM date)
This function have a following units to use.
MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR, SECOND_MICROSECOND, MINUTE_MICROSECOND, MINUTE_SECOND, HOUR_MICROSECOND, HOUR_SECOND, HOUR_MINUTE,...
Sunday, 24 August 2014
Monday, 18 August 2014
In general we don't like to see our images stretched in view. In this case, If we want to reduce size diagonally, what should we do?
We can do it by changing width property of image.
First We need to get original width of image using javascript's naturalWidth property.
Then Multiply it with 0.5 to get 50% reduced image.
If you want 2x larger image, then multiply it with 2. like this below code,
domElement.width = doemElement.naturalWidth * 0.5;
Then assign resultant...
The Javascript's naturalWidth and naturalHeight properties will return original width and height of an image.
For an example, If we are using an image with 350px original width and 225px original height, It will return the same height and width even we made changes in DOM's height and width property.
The following DEMO will make you understand more what I'm saying.
In this DEMO the original image size of image is 350 x 225 px. We are also changed image width...
Saturday, 9 August 2014
$_GET and $_POST
Both GET and POST create an array.
e.g. array(key=>value, key2=>value2, key3=>value3, ...).
This array holds key/value pairs, where keys are the names of the form controls and values are the input data from the user.
Both GET and POST are treated as $_GET and $_POST. These are superglobals, which means that they are always accessible, regardless of scope - and you can access them from any function, class or file without having...
Thursday, 7 August 2014
This reloadAfterSubmit attribute always confusing with data type. I have seen so many post related to reloadAfterSubmit not working like that in jqGrid forum and stackoverflow posts. Here I gave explanation about reload process in jqGrid.
jqGrid using AJAX to post data to Server Side (add, edit, delete). So, our page will not get refresh.
jqGrid reloadAfterSubmit...
Subscribe to:
Posts (Atom)
Posts
