<script>$(“#button_id”).click(function() { if($(this).data(‘dont’)==1) return; $(this).data(‘dont’,1); // Do Process ….. $(this).data(‘dont’,0);} ///////// OR ///////// $(“#button_id”).click(function() { if($(“#button_id”).data(‘dont’)==1) return; $(“#button_id”).data(‘dont’,1); // Do Process ….. […]
How to get Last Month’s record data from MySQL Database?
SELECT * from product_order WHERE YEAR(order_date) = YEAR(CURRENT_DATE – INTERVAL 1 MONTH) and MONTH(order_date) = MONTH(CURRENT_DATE – INTERVAL 1 MONTH)
How to get This Month’s record data from MySQL Database?
SELECT * from product_order WHERE MONTH(order_date) = MONTH(NOW()) and YEAR(order_date) = YEAR(NOW())
How to get Last Week’s (Monday to Sunday) record data from MySQL Database?
SELECT * from product_order WHERE yearweek((order_date), 1) = yearweek(curdate(), 0)
How to get Yesterday’s record data from MySQL Database?
SELECT * from product_order WHERE DATE(order_date) = DATE(NOW() – INTERVAL 1 DAY)
How to get Today’s record data from MySQL Database?
SELECT * from product_order WHERE DATE(order_date) = DATE(NOW())
How To Create Shortcode In WordPress with parameters?
<?php### the shortcode code add in theme’s functions.php file ###// “do_shortcode” but without the wrapping <p> of Shortcodesfunction do_shortcode_boc($content) { $array = array ( […]
Set only first letter capital other in lowercase in PHP SQL
$sql = “SELECT concat(left(emp_name,1),substring(lower(emp_name),2)) as emp_name FROM employee”; Input : “Raj Kumar”Output : “Raj kumar”
WAMP: Missing http://localhost/ in urls , wrong WAMP projects url
1. Open wamp/www/index.php in Change $suppress_localhost = ($wampConf[‘urlAddLocalhost’] == ‘off’ ? true : false);To$suppress_localhost = ($wampConf[‘urlAddLocalhost’] == ‘on’ ? true : false); OR 2. From […]