fieldoffice

// UPDATE POST CONTENT
UPDATE wp_posts SET `post_content`
= REPLACE (`post_content`,
'OriginalText',
'ReplacedText');

// CHANGE POSTS TO PAGES
UPDATE wp_posts SET post_type = 'page' WHERE post_type = 'post'

// CHANGE PAGES TO POSTS

fieldoffice

//HEADER
<meta name="msapplication-config" content="browserconfig.xml" />

//ROOT - browserconfig.xml
<?xml version="1.0" encoding="utf-8"?>
<browserconfig>
  <msapplication>
    <tile>
      <square70x70logo src="images/smalltile.png"/>
      <square150x150logo src="images/mediumtile.png"/>

fieldoffice

// Browser Prefixes
@mixin transform($transforms) {
	-webkit-transform: $transforms;
	-moz-transform: $transforms;
	-ms-transform: $transforms;
	transform: $transforms;
}

// Rotate
@mixin rotate ($deg) { 

fieldoffice

$('#searchform').submit(function(e) {
	var s = $( this ).find("#s");
        if (!s.val()) {
		e.preventDefault();
		alert("Your search is empty!");
		$('#s').focus();
	}
});

fieldoffice

@mixin vertical-align {
  position: relative;
  top: 50%;
  -webkit-transform: translateY(-50%);
  -ms-transform: translateY(-50%);
  transform: translateY(-50%);
}

.item p {
  @include vertical-align;

fieldoffice

<script type="text/javascript">
    var select = $('.card-expiry-year'),
    year = new Date().getFullYear();
 
    for (var i = 0; i < 12; i++) {
    select.append($("<option value='"+(i + year)+"' "+(i === 0 ? "selected" : "")+">"+(i + year)+"</option>"))
  }
</script> 

<select class="card-expiry-year"></select>

fieldoffice

/* TOP - 100 IS THE VERTICAL OFFSET IN PIXELS */

$('#link').click(function() {
    $('html, body').animate({
        scrollTop: $('#anchor').offset().top - 100
    }, 600);
});

fieldoffice

<script type="text/javascript">
  WebFontConfig = {
    google: { families: [ 'Source+Code+Pro::latin' ] }
  };
(function() {
  var wf = document.createElement('script');
  wf.src = ('https:' == document.location.protocol ? 'https' : 'http') +
  '://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
wf.type = 'text/javascript';
wf.async = 'true';

fieldoffice

/* EXTEND SUBNAV
******************************************/

class submenu_wrap extends Walker_Nav_Menu {
    function start_lvl( &$output, $depth = 0, $args = array() ) {
        $indent = str_repeat("\t", $depth);
        $output .= "\n$indent<div class='sub-menu-wrap'><ul class='sub-menu'>\n";
    }
    function end_lvl( &$output, $depth = 0, $args = array() ) {
        $indent = str_repeat("\t", $depth);

fieldoffice

<?php
	$conn = mysqli_connect('localhost','user','pw') or die(mysqli_error());
	$db=mysqli_select_db($conn,'database') or die(mysqli_error());

	$filename = 'filename-' . date("d-m-Y") . '.csv';

	header( 'Cache-Control: must-revalidate, post-check=0, pre-check=0' );
	header( 'Content-Description: File Transfer' );
	header( 'Content-type: text/csv' );
	header( "Content-Disposition: attachment; filename={$filename}" );