Skip to main content


Showing posts from September, 2018

How to create jQuery fadeIn fadeOut Animation

How to create jQuery fadeIn fadeOut Animation Html: <ul> <li class="client-testimonial"><img src="demo1.png"></li> <li class="client-testimonial"><img src="demo2.png"></li> <li class="client-testimonial"><img src="demo3.png"></li> <li class="client-testimonial"><img src="demo4.png"></li> </ul> jQuery: jQuery(document).ready(function(){ if(jQuery('.client-testimonial').length > 0){ var showImg = jQuery(".client-testimonial-img"); var quoteIndex = -1; function showFadeInFadeOut() { ++quoteIndex; showImg.eq(quoteIndex % showImg.length) .fadeIn(2000) .delay(2000) .fadeOut(2000, showFadeInFadeOut); } showFadeInFadeOut(); } });

How to get custom image size url in Wordpress

Here are simple way to get custom image from URL $imgUrl = 'http://localhost/wptest/wp-content/themes/sydney/images/header.jpg';   global $wpdb; $attachment = $wpdb->get_col($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid='%s';", $imgUrl )); $image_id = $attachment[0]; $thumbnail_url = wp_get_attachment_image_src($image_id, array('615','440'), true );

How to set varchar primary key field in Mysql

How to set varchar primary key field in Mysql Table structure of Users table CREATE TABLE `users` (    `id` varchar(36) NOT NULL DEFAULT 'InitiallyEmpty',    `first_name` varchar(100) NOT NULL,    `last_name` varchar(100) NULL,    `email` varchar(100) NOT NULL,    `password` varchar(100) NOT NULL,    PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Want to fill id an automatically filled. You need to create trigger Trigger structure for automatically update DROP trigger if exists before_insert_users; delimiter $$ CREATE TRIGGER before_insert_users BEFORE INSERT ON users FOR EACH ROW BEGIN     SET = uuid(); END $$ delimiter ; Now create insert query insert into users (first_name,last_name,email,password) values ('Sudhir','Pandey','','123465');