Shaz3e

instructions

• Go to PHPMyAdmin
• Select Database
• Click Query Tab

Insert the following commands one by one make sure to change table_name with actual table name and column name with actual column name

First you need to remove foreign key from table.column

Shaz3e

#### Update the following commands in wp-config.php

```
define( 'WP_HOME', 'http://www.yoursitename.com' );
define( 'WP_SITEURL', 'http://www.yoursitename.com' );
```

#### PHPMyAdmin SQL Query
```

Shaz3e

Change default Mac OS X PHP to MAMP's PHP Installation and Install Composer Package Management

---

Instructions to Change PHP Installation

---

First, Lets find out what version of PHP we're running (To find out if it's the default version).

To do that, Within the terminal, Fire this command:

which php

Shaz3e

Use the following command to initialize the repository

> git init

Use the following command to index repository

> git add .

Shaz3e

	#overlay{
	  position:fixed;
	  z-index:99999;
	  top:0;
	  left:0;
	  bottom:0;
	  right:0;
	  background:rgba(255,255,255,1);
	  transition: 1s 0.4s;
	}

Shaz3e

```
	$(window).scroll(function(){
		if($(window).scrollTop() + $(window).height() > $(document).height() - <?php echo( s3_option('s3cc_fixed_trigger') == '' ? 100 : s3_option('s3cc_fixed_trigger') );?>) {
			$('.s3cc-fixed').css('position','static');
		}else{
			$('.s3cc-fixed').css('position','fixed');
		}
	});
```

Shaz3e

If you have a Facebook page for your website or blog, you might want to display how many fans you have. This snippet will help you to get your Facebook fan count, in full text. Don’t forget to add your page ID on line 2.

Shaz3e

If your website is multilingual, it can be useful to detect the browser language to use this language as the default. The code below will return the language used by the client’s browser.

Shaz3e

When used, Microsoft Word creates lots of tags: font, span, style, class… These tags are useful inside Word itself, but when you paste a text from Word into a webpage, you’ll end up with lots of useless tags. Here’s a very handy function to remove all Word HTML tags.

Shaz3e

Downloading an image on a remote server and saving it on your own server is useful when building websites, and it’s also very easy to do. The two lines of code below will do it for you.