Current Creative currentcreative

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

This blog post has helped me clean up my postgres development environment on Mac. So making a copy!

How completely uninstall PostgreSQL 9.X on Mac OSX

This article is referenced from stackoverflow:

If installed PostgreSQL with homebrew , enter brew uninstall postgresql

If you used the EnterpriseDB installer , follow the following step.

	<?php
	/**
	* CSDev - Bootstrap 5 wp_nav_menu walker
	* Supports WP MultiLevel menus
	* Based on https://github.com/AlexWebLab/bootstrap-5-wordpress-navbar-walker
	* Requires additional CSS fixes
	* CSS at https://gist.github.com/cdsaenz/d401330ba9705cfe7c18b19634c83004
	* CHANGE: removed custom display_element. Just call the menu with a $depth of 3 or more.
	*/
	class bs5_Walker extends Walker_Nav_menu

	// load all dependencies. gulp-* dependencies are
	// all loaded at once by gulp-load-plugins
	var gulp = require("gulp");
	var del = require("del");
	var plugins = require("gulp-load-plugins")();
	var autoprefixer = require("autoprefixer");
	var cssnano = require("cssnano");
	var cssmqpacker = require("css-mqpacker");
	var uncss = require("postcss-uncss");
	var pngquant = require("imagemin-pngquant");

	//stop all vimeo videos when close
	//jquery require
	$(function(){
	$('.modal, .close').click(function(){
	$("iframe").each(function() {
	var src= $(this).attr('src');
	$(this).attr('src',src);
	});
	});
	});

	<?php
	$args = [
	// Location pickable in Customizer
	'theme_location' => 'main-menu',
	// Assigns a default menu to location
	'menu' => 'Main Menu',
	// Main wrapper around the ul of posts
	'container' => 'div',
	'container_class' => 'container-class',
	'container_id' => 'container-id',

	<?php
	/*
	Plugin Name: Sample Plugin
	Plugin URI: https://brianhogg.com/
	Description: Showing is_new
	Version: 1.0
	Author: Brian Hogg
	Author URI: https://brianhogg.com
	License: GPLv2 or later
	*/

	<?php
	// Use an ACF image field
	// Set the 'return value' option to "array" (this is the default)
	// This example uses three image sizes, called medium, medium_large, thumbnail
	$imageobject = get_field('image');
	if( !empty($imageobject) ):
	echo '<img alt="' . $imageobject['title'] . '" src="' . $imageobject['sizes']['medium'] . '" srcset="' . $imageobject['sizes']['medium_large'] .' '. $imageobject['sizes']['medium_large-width'] .'w, '. $imageobject['sizes']['medium'] .' '. $imageobject['sizes']['medium-width'] .'w, '. $imageobject['sizes']['thumbnail'] .' '. $imageobject['sizes']['thumbnail-width'] .'w">';
	endif;
	?>

	$my_query = new WP_Query($freereads_args);
	$post_count = $my_query->found_posts;

	<?php

	$image = get_field('image'); // assigns the image field to the variable of $image

	if( !empty($image) ){ ?> <!-- if the $image variable isn't empty, display the following: -->

	<img src="<?php echo $image['url']; ?>" alt="<?php echo $image['alt']; ?>" /> <!--displays the URL for the image variable and also the alt tag which is entered in the WordPress media library-->

	<?php }; ?> <!--ends the if statement -->