For example we have 2 columns ‘state_id’ and ‘district_id’ in a table called ‘state_and_district’, So while inserting data into this table by mistake state id inserted into district_id and District id inserted into state_id, So instead of changing each row values we can do this by using a simple query of mysql.

We cant use a query like assign state_id = district_id and district_id = state_id because it will just set both value to district_id. Instead of this we will use temporary variable to swap column values. So below is query which can be used to swap values of 2 columns in table and will work for “IS NOT NULL”

UPDATE swap_test SET state_id=district_id, district_id=@temp WHERE (@temp:=state_id) IS NOT NULL;

Above query is using temporary variable to swap values of column values and It is working properly. Although there is second query also available which is perfect way to do this and will work for NOT NULL and NULL both values.

UPDATE swap_test SET state_id=(@temp:=state_id), state_id = district_id, district_id = @temp;

Above query is perfect query to swap two column values with each other in Db table. I am sure there will be lots of other ways to do this and if you know any other better way then let us know in comments.

I hope this article help someone for sure. I am PHP Freelancer India and I am having more than 6 years of experience. So contact me if you have any work.

We are going to use wordpress action hooks, WordPress providing many hooks by which we can change or add wordpress functionality without changing core files of wordpress.So here we are going to use ‘admin_head’ action hook by which you can change admin head logo and other things. So below are code to change admin head logo at top left of screen :

function change_admin_head_logo() {
echo '
<style type="text/css">
#header-logo{
background:url(images/my-logo.png) left center no-repeat;
width:100px;
height:32px;
}
</style>';
}
add_action('admin_head', 'change_admin_head_logo', 11);

So in above code you can see we use ‘admin_head’ action hook and one CSS block to override current admin logo image. Upload your login logo image in wp-content/themes/[current_theme]/images/ and then replace image name ‘my-logo.png’ with your logo image name. Now put this above code in functions.php file of your theme and then check your admin logo at top left.

I am PHP Freelancer, Freelance PHP Developer having more than 5 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).

$().ready(function() {
	// validate signup form on keyup and submit
	$("#signupForm").validate({
		rules: {
			firstname: "required",
		},
		messages: {
			firstname: "Please enter your firstname",
		}
	});
});

You can see in above code “signupForm” is form id, But you can also see that to make First Name required we use “firstname”(which is the name of text box element of First Name). If I was using custom PHP language then I was not having any issues if this validation use name of element for validation instead of id or class, But in cakePHP when we create any element then it created it name like this :

data['ModelName']['firstname']

So we can’t use this name in this validation, otherwise it will not work. So I stuck into one big problem that I want to use this library but can’t use it with name and I can’t change name of cakePHP otherwise it will increase my code time while working on other functionality related to this form.

So I googling on internet to find solution for it because i knew that I am not only one developer who is using cakephp and want to use this library and having same issue like me. I got some clues but didn’t find perfect solution for it. But based upon on that solution I tried many things and finally I made jQuery validation library working with id of element.

So let me explain how we can do it.Lets take one example.We have one form which is taking information “First Name” and “Last Name” and we want to validate it with jQuery validation library. So form id is “testingform” and id of First name is “first_name” and Last Name id is “last_name”.So js code to validate this field would be like this :

$().ready(function() {
    // validate the form when it is submitted
   	 $("#testingform").validate();
   	 $("#first_name").rules("add", {
   		 required:true,
   		 messages: {
   				required: "Please Enter Title of Project."
   		 }
   	  });
   	 $("#last_name").rules("add", {
   		 required:true,
   		 messages: {
   				required: "Please Enter Description of Project."
   		 }
   	  });
	 /*  You Can add oter fields like above
	 	 Here with messages. But remember you have to mention
		 $("#testingform").validate(); first and then write
		 all other code
	 */
});

You Can add other more fields like above,but remember you have to mention $(“#testingform”).validate(); first and then write all other code for more fields to validate.

So this is way to use id of input box or element while validation form by jQuery Validation Library. You can post you problems, thoughts in comments.

I am PHP Freelancer, Freelance PHP Developer having more than 5 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).

Anyway when we use $ as jquery object then the $ function in jQuery will never return null. So it is likely it is a different non-jQuery $ in use may be prototype.js or other library being used.We all know that $ is itself not null because the exception would be different, like : “$ is not a function” but In this case the browser is saying that the result of the expression $(…)) is null, which is main cause of this error is $ which is different non-jquery object used by another library.So to solve this error you should use try this :

$(document).ready(function($) {
// your code goes here ...
});

Or you can try this also :

jQuery(function($) {
// your code goes here ...
});

Or you can replace “$” with “jQuery” (without quotes) in your code(which is not a good idea, but works.) Now you can try any of this method and let us know in comment that it is working or not or you can suggest any other solution in comments too.

I am PHP Freelancer, Freelance PHP Developer having more than 5 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).

So to make this I thought first that I need to change some html part of colorbox script but finally I found one easiest way to do it by CSS. So to make close button at top right corner, You need to add one CSS block to colorbox CSS. Below is CSS block which you need to add in colorbox CSS :

/* To change position of close button to Top Right Corner */
#colorbox #cboxClose
{
top: 0;
right: 0;
}
#cboxLoadedContent{
margin-top:28px;
margin-bottom:0;
}

Add this to your CSS file or Colorbox CSS file and then you can see close button will automatically show on top right corner of Colorbox.

Also I am PHP Freelancer, Freelance PHP Developer having more than 5 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).

We can do this by using the_content filter but for example if we are showing that video after title and before content using the_content filter then if we using any plugin which use the_content filter to add social sharing buttons or related posts then it will show twice because the_content called 2 times, first call to parse video link and second to show content.So to overcome this problem I found one wordpress functions who return Embed HTML of Video using oEmbed by passing link of video.

wp_oembed_get takes a URL and Attempts to fetch the embed HTML for it using oEmbed. Here is list of sites  which you can embed from. So this method will work only for sites exists in lists, So if you are using any other website video link then it will not work. But as we can see it support mostly all famous video sites, So this is not a big issue.

We can use wp_oembed_get like this :

<?php $embed_code = wp_oembed_get('http://www.youtube.com/watch?v=8h85FZL5Khk'); ?>

Get embed html code by link by passing width argument :

<?php $embed_code = wp_oembed_get('http://www.youtube.com/watch?v=8h85FZL5Khk', array('width'=&gt;400)); ?>

So wp_oembed_get is function by which you can get embed HTML using oEmbed by passing link of video.

Hostgator established in 2002, HostGator has been a world-leading provider of web hosting service. Although its office is in Houston, Texas, It provide top-notch service to clients from over 200 countries internationally with staff of over 600 employees. Hostgator offer Shared, Reseller, VPS, and Dedicated server packages for both beginners and professionals alike. Each of shared Web Hosting plans includes 24/7/365 support, a 99.9% uptime guarantee, and a 45-day money-back guarantee. If you would like to learn more, please visit hostgator company page.

So to get 25% discount on hostgator total price you just need to enter coupon code “1CENTHECOUPON” (without quotes) in coupon code box and you will get $9.94 off from your first month amount. So in this way you can get hosting for first month in 1 cent.

Let me Know if you have any problem in this coupon code.

So if you want to enable this functionality just open wp-config.php file exists in root of wordpress site and then simply added below line anywhere :

define('WP_ALLOW_REPAIR', true);

The script can be found at {$your_site}/wp-admin/maint/repair.php, So If you want to run it manually you can run it by go to http://www.yoursite.com/wp-admin/maint/repair.php.

Also Please Note: That this define enables the functionality, The user does not need to be logged in to access this functionality when this define is set. This is because its main intent is to repair a corrupted database, Users can often not login when the database is corrupt.

I hope this post helpful for someone. If you have any question then you can ask me anytime or post it in comment.

Also I am PHP Freelancer, Freelance PHP Developer having more than 4 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).

Here is code to get particular category products :

$cObj = Mage::getModel(‘catalog/category’)->load($categoryId);
$productObj = $cObj->getProductCollection()->getData();

In above code in first line $categoryId is category id for which you want to fetch products. So just pass category id in this code and you will get products object in $productObj.

I hope this post helpful for someone. If you have any question then you can ask me anytime or post it in comment.

Also I am PHP Freelancer, Freelance PHP Developer having more than 4 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).

Below is URL of PHP Formatter :

PHP Formatter - PHP Beautifier – PHP Pretty Printer

This PHP Formatter having so many options like :

I hope this post helpful for someone. If you have any question then you can ask me anytime or post it in comment.

Also I am PHP Freelancer, Freelance PHP Developer having more than 4 years of experience, So if you want to do any projects then you can contact me.

Hostgator Hosting in 1 Cent Coupon Code – “1CENTHECOUPON” (Without Quotes).