Now I am describing how to add a specific datetime unit in date. TIMESTAMPADD function of mysql is very important when we are working on datetime part in mysql query.This function takes integer INTERVAL argument and return result datetime with given unit interval.
The unit and interval both are must be same unit type().which should be one of the following values: MICROSECOND(microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR.

The Syntax is:

TIMESTAMPADD(unit,interval,datetime_expr)

Unit: Its unit type of interval, which you want add.
Interval : the integer value of ‘unit’ type
Exp: target datetime value

Example:

SELECT TIMESTAMPADD(WEEK,1,Now())
Result: 2012-05-21 17:27:25

Posted: Monday, May 14th, 2012

Author: Parvez

TIMEDIFF() function in MySql

TIMEDIFF is another useful function in mysql to get datetime difference, Where this function returns time difference of both value like exp1- exp2.

The syntax of TIMEDIFF is:

TIMEDIFF(expr1,expr2)

Exp1: from date of datetime type
Exp2: to date of datetime type

Note: both value must be same datetime type. The result returned by TIMEDIFF() is limited to the range allowed for TIME values. Alternatively, you can use either of the functions TIMESTAMPDIFF() and UNIX_TIMESTAMP(), both of which return integers.

Example:

SELECT TIMEDIFF(’2011-12-31 23:59:59.000001′, ’2011-12-30 01:01:01.000002′)
Result: 46:58:57.999999

Posted: Monday, May 14th, 2012

Author: Parvez

DateTime Difference in MYSQL

Now we are discussing how to get time difference in mysql.
There are a lot of mysql function for datetime calculation, one of them are TIMESTAMPDIFF.

Syntax is:

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

Here one expression may be date type but other must be datatime type,the date type expression treated as date time with ’00:00:00’.

Where terms are following:

Unit: is return unit from result.
Exp1: from date
Exp2: to date

Example:

SELECT TIMESTAMPDIFF(MONTH,’2012-02-11′,’2012-07-01′)
Result: 4;
SELECT TIMESTAMPDIFF(MONTH,’2012-07-11′,’2012-01-01′)
Result: -6
SELECT TIMESTAMPDIFF(MINUTE,’2012-01-11′,’2012-05-01′)
Result: 159840

Posted: Saturday, May 12th, 2012

Author: Parvez

How to find all element of any div in Jquery

Hi,
below code is used for get all element listing with label and textbox.
for example if a div has image and when the user click the image then user will be able to edit the property of image in edit dialog box.

view plain copy to clipboard print ?

<link href=“http://twitter.github.com/bootstrap/assets/css/bootstrap.css” rel=“stylesheet”>
<link href=“http://twitter.github.com/bootstrap/assets/css/bootstrap-responsive.css” rel=“stylesheet”>
<link href=“http://twitter.github.com/bootstrap/assets/css/docs.css” rel=“stylesheet”>
<link href=“http://twitter.github.com/bootstrap/assets/js/google-code-prettify/prettify.css” rel=“stylesheet”>
<script type=“text/javascript” src=“http://platform.twitter.com/widgets.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/jquery.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/google-code-prettify/prettify.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-transition.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-alert.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-modal.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-dropdown.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-scrollspy.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-tab.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-tooltip.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-popover.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-button.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-collapse.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-carousel.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/bootstrap-typeahead.js”></script>
<script src=“http://twitter.github.com/bootstrap/assets/js/application.js”></script>
<div class=“clearfix content-preview”>
<div id=“view-content” class=“input”><div class=“marketing1″>
<a title=“”>
<img src=“http://www.google.com/images/flower-pictures-blue.jpg”>
</a>
</div>
<div class=“marketing2″>
<a title=“Adventure Designed Boots” href=“”>
<img title=“Adventure Designed Boots.” alt=“Adventure Designed Boots” src=“http://www.google.com/a.jpg”>
</a>
</div>
</div>
</div>
<div class=“modal” id=“preview-static-block”>
<div class=“modal-header”>
<button class=“close” data-dismiss=“modal”>×</button>
</div>
</div>
<script>
$(‘.input div’).hover(
function() {
var that = $(this);
$(this).css({
“position”:“relative”
});
var imageObj = $(this).find(“img”);
$(this).append(
$(“<span style=’top: ” + $(this).height()/2 + “px; left:” + (imageObj.width() - 10 ) + “px; color:red; position:absolute; z-index:1111′ id=’imgEdit’ class=’btn’><a>Edit</a></span>”)
.bind(‘click’, function(){
var nodes={};
$(this).parent().find(‘*’).not($(this)).each(function(i, el){
for (var attr, i=0, attrs=el.attributes, l=attrs.length; i<l; i++){
attr = attrs.item(i)
nodes[attr.nodeName] = attr.nodeValue;
}
});
var html = ‘<div class=”static-block-preview-header”><form>’;
$.each(nodes, function(key, value) {
html += ‘<div class=”clearfix”>’;
html += ‘<label> ’ + key + ‘ </label>’ + ‘<div class=”input”><input type=”text” value=”‘ + value + ‘” /> </div>’;
html += ‘</div>’;
});
html += ‘</form></div>’;
$(‘#preview-static-block’).html(html);
previewStaticBlock.show();
})
);
},
function(){
$(this).find(“span:last”).remove();
});
previewStaticBlock = new Boxy(‘#preview-static-block’, {
title: ‘ ’,
modal: true,
fixed: true,
show: false,
center: true,
cache: false,
closeText: ”
});
</script>

Posted: Friday, May 11th, 2012

Author: Parvez

Abstract class are a feature of PHP (OOPs)

Abstract classes are a feature of PHP object-oriented programming (OOP) and the source of confusion when considered versus an Interface.
Main difference between interface and abstract class is:
• Child class can implement multiple interfaces but extend only a single abstract class.
• If multiple inheritance is not required then people often go with abstract classes.
• Abstract Class provide the option of later adding base functionality within the abstract class.
Importance of abstract class:
A abstract class provide the functionality to concrete base class function as well as abstract function which is must be implemented by child class.
Abstract Method

An abstract method would be written like any other method except it contains ‘abstract’ at the beginning. When an abstract method is declared in the parent class, the child classes must their own function under the same name and signature as declared in the parent class.

view plain copy to clipboard print ?

Example:
abstract class TestAbstract
{
abstract function getHello();
}
Class driveCl extends TestAbstract {
protected function getHello() {
echo ‘hello’;
}
}
$obj= new driveCl();
$obj-> getHello();
Result ‘hello’;

Example:<br /> abstract class TestAbstract<br /> {</p> <p> abstract function getHello();<br /> }<br /> Class driveCl extends TestAbstract {<br /> protected function getHello() {<br /> echo ‘hello’;<br /> }<br /> }<br /> $obj= new driveCl();<br /> $obj-> getHello();<br /> Result ‘hello’;<br />

Featured of Abstract class:
1. Single inheritance. Child classes can extend only one class at a time.
2. Abstract classes cannot be instantiated — no new TestAbstract ();
3. Abstract classes can define class variables of type const only.
4. Abstract class A can be extended by another abstract class B. Abstract class B can implement none or any of the abstract functions in A.
5. In the previous case, a child class C which extends abstract class B must implement all abstract functions in B as well as the abstract functions in A which have not already been implemented in B.
6. The signature of the concrete functions and abstract functions must be the same.
7. The visibility of functions in the child classes must be the same or less restrictivethan the parent class.

Posted: Friday, May 11th, 2012

Author: Parvez

How to create another controller under controller folder in Magento

Like we want to create a new group of controller class under a module controller folder.
mymudle/controllers/indexControler.php
We want to create another folder iunder controller ‘render’ and create new controller class under newly created folder.
mymudle/controllers/rednder/carusalController.php
then url would be
mywebsite/module_name/controller_render/action

Step 1: First we will create a controller file under controllers folder.

mymudle/controllers/renderContrioller.php

view plain copy to clipboard print ?

<?php
class NS_MN_RenderController extends Mage_Core_Controller_Front_Action
{
}
?>

<?php<br /> class NS_MN_RenderController extends Mage_Core_Controller_Front_Action<br /> {</p> <p>}<br /> ?>

Step 2: We will create folder same name as above controller file crearted.

mymudle/controllers/rednder

Step 3: We will create Carousel controller under render folder.

view plain copy to clipboard print ?

<?php
class NS_MN _Render_CarouselController extends Mage_Core_Controller_Front_Action
{
/**
* Get test of particular static block
*/
public function indexAction()
{
$this->loadLayout();
$this->renderLayout();
}
}

<?php<br /> class NS_MN _Render_CarouselController extends Mage_Core_Controller_Front_Action<br /> {<br /> /**<br /> * Get test of particular static block<br /> */<br /> public function indexAction()<br /> {<br /> $this->loadLayout();<br /> $this->renderLayout();<br /> }<br /> }<br />

Posted: Friday, May 11th, 2012

Author: Parvez

jquery difference between parent and parents

Hello friend s, Now I am discussing a topic here clarify the difference between parent() and parents().
JQuery provide two wonderful method to get parents element information of selected element.

Given the following HTML:

view plain copy to clipboard print ?

<html>
<body>
<div class=”one”>
<div class=”two”>
<p><span>Some text</span></p>
</div>
</div>
</body>
</html>

If you want find the span parent element then you write simple code like:

$(‘span’).parent()
It will return [p] tag object.

Whereas if you call parents () method :

$(‘span’).parents()
Then you will get all above element from current selected element such as jQuery object is [p, div.two, div.one, body, html]
So main difference between parent() and parents is parent element while parents() will select all elements straight up the DOM tree.

jQuery also provide some filter method for filter search.

Like if you want find only div element then you will write code:

$(‘span’).parents().filter(‘div’)
OR
$(‘span’).parents(‘div’)
This would result in [div.two, div.one].

if you want only first div in the parent DOM then you will write:

$(‘span’).parents(‘div:eq(0)’)
Result would be ‘div.two’.

Posted: Wednesday, May 9th, 2012

Author: Parvez

How to add dynamic id of all image in a template

view plain copy to clipboard print ?

jQuery(document).ready(function() {
var i = 1;
jQuery(‘.list img’).each(function () {
jQuery(this).attr(‘id’, ‘image-’ + i);
i = i + 1;
});
});

jQuery(document).ready(function() {<br /> var i = 1;<br /> jQuery(‘.list img’).each(function () {<br /> jQuery(this).attr(‘id’, ‘image-’ + i);<br /> i = i + 1;<br /> });<br /> });

Page 22 of 37
Prev
1
...
20
21
22
23
24
...
37
Next

How add Integer in Datetime with help of MySql

Php,Mysql,Jquery Tutorial And Interview Question

The Syntax is:

Example:

TIMEDIFF() function in MySql

The syntax of TIMEDIFF is:

Example:

DateTime Difference in MYSQL

Syntax is:

Where terms are following:

Example:

How to find all element of any div in Jquery

Abstract class are a feature of PHP (OOPs)

How to create another controller under controller folder in Magento

Step 1: First we will create a controller file under controllers folder.

Step 2: We will create folder same name as above controller file crearted.

Step 3: We will create Carousel controller under render folder.

jquery difference between parent and parents

If you want find the span parent element then you write simple code like:

Whereas if you call parents () method :

Like if you want find only div element then you will write code:

if you want only first div in the parent DOM then you will write:

How to add dynamic id of all image in a template