WordPress Database Switcher

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

1

2

3

4

5

6

7

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(

Posted in Wordpress No comments November 16, 2016

AJAX Username Verification

Download

Posted in Jquery No comments September 3, 2016

Php Captcha

Download

Posted in Php No comments August 31, 2016

Multiple Select Box plugin

Download

Posted in CSS, Jquery No comments August 8, 2016

1. Download the theme.
2. Extact the compress file.
3. Goto extact theme folder-> app-> design-> frontend-> default and copy theme name folder.
4. Goto magento folder-> app-> design-> frontend-> default and past here.
5. Goto extact theme folder-> skin-> frontend-> default and copy theme name folder.
6. Goto magento folder-> skin-> frontend-> default and past here.
7. Goto admin panel and login.
8. Goto System-> Configuration-> Design-> teme fill all field with your theme name.
9. Goto System-> Design and Add Design Change and select Custom Design “your theme” if design is already created then update it to select new theme name.
10. Check your homepage.

Posted in Magento No comments August 3, 2016

Add Style and Script in WordPress Plugin

// Plugin Folder URL
if ( !defined( 'PLUGIN_URL' ) ) {
	define( 'PLUGIN_URL', plugin_dir_url( __FILE__ ) );
}

// Plugin Version
if ( !defined( 'SCRIPT_VERSION' ) ) {
	define( 'SCRIPT_VERSION', '1.0.6' );
}


function load_scripts() {
	wp_register_style( 'main-style',  PLUGIN_URL . 'includes/css/style.css', array(  ), SCRIPT_VERSION );

	wp_register_script( 'custom',  PLUGIN_URL .  'includes/js/custom.js', array( 'jquery' ), SCRIPT_VERSION, false );
	wp_register_script( 'fitvids',  PLUGIN_URL . 'includes/js/jquery.fitvids.js', array( 'jquery' ), SCRIPT_VERSION, false );
	
	wp_enqueue_script( 'jquery' );
	wp_enqueue_script( 'custom' );

		
	wp_enqueue_style( 'main-style' );	
}
add_action( 'wp_enqueue_scripts', 'load_scripts' );

...

Posted in Wordpress No comments July 15, 2016

Add Remember me functionality

user.php

<?php
class User
{
    //private variabel for session data
    private $user;
    //function for check username and password
    function check_login($username, $password) {
        //get username value and save to private variabel
        $this->user = $username;
        //checked username and password
        if($username == "admin" && $password == "password") {
            //if username and password true, then create session...

Posted in Php 6 comments July 2, 2016

Download files without displaying URL

<?php 
set_time_limit(0);

if(isset($_GET['id']) && !empty($_GET['id'])){


$fakeFileName= $_GET['id']; // change the file name
$realFileName = $_GET['id'];

$file = "".$realFileName; // file url.
$fp = fopen($file, 'rb');

header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=$fakeFileName");
header("Content-Length: " . filesize($file));
fpassthru($fp);

}

?>
[/cc]
<strong>If above code is not working so try this</strong>
[cc]
<?php
if(isset($_GET['id']) && !empty($_GET['id'])){


$fakeFileName = $_GET['id']; // change the file name
$realFileName = $_GET['id'];

$file = "".$realFileName; // file url...

Posted in Php No comments July 2, 2016

Media Query for different Device or Screen

/* (320x480) iPhone (Original, 3G, 3GS) */
@media
only screen and (min-width: 320px) and (max-width: 480px) {
    /* insert styles here */
}
 
/* (320x480) Smartphone, Landscape */
@media screen and (min-width: 320px) and (max-width:568px) {
    /* insert styles here */
}

/* small tab */
@media
only screen and (min-width: 600px) and (max-width: 800px) {
    /* insert styles here */
}
 
/* tab */
@media screen and (max-width: 979px) {
    /* insert styles here */
}

/* big tab */
@media (min-width: 768px) and (max-width: 1024px) {
    /* insert styles here */
}

/* (480x800) Android */
@media only screen and (min-device-width: 480px) and (max-device-width: 800px) {
    /* insert styles here */
}
 
/* (640x960) iPhone 4 & 4S */
@...

Posted in CSS No comments June 30, 2016

Display all content of object

 alert(object.toSource());

1	alert(object.toSource());

Posted in Jquery No comments June 16, 2016

Recent Posts