Contact Form 7 Ticketing Plugin

The CF7 Ticketing Plugin is an incomplete plugin made for a client that needs a ticketing system for building maintenance. It utilizes the Contact Form 7 plugin for form validation and stores the input as a custom post type that can be searched and organized. CF7-Support-Ticket Plugin The plugin includes a custom backend menu, “Tickets”, … Read more

Simple Regex Reference

A simple regex reference sheet for all your regex needs. [abc]     A single character: a, b or c[^abc]     Any single character but a, b, or c[a-z]     Any single character in the range a-z[a-zA-Z]     Any single character in the range a-z or A-Z^     Start of line$     End of line\A     … Read more

Using Prepared Placeholders with Wildcards in PDO

When using SQL wildcards with PDO placeholders, include the wildcard in the variable and not the query. Use this: $search = ‘%’ . $search_term . ‘%’; $sql = “SELECT * FROM posts WHERE content LIKE :search”; $stmt = $pdo->prepare($sql); $stmt->bindParam(‘:search’, $search, PDO::PARAM_STR); $stmt->execute();

SQL Cheat Sheet

This is a handy cheat sheet for simple SQL reporting. Ordering Columns Ordering by a single column criteria: SELECT * FROM <table name> ORDER BY <column> [ASC|DESC]; ASC is used to order results in ascending order. DESC is used to order results in descending order. Examples: SELECT * FROM books ORDER BY title ASC;SELECT * … Read more

Converting a Bootstrap Template into a WordPress Theme

To put my new knowledge of WP theme creation to good use, I decided converted a Bootstrap template Clean Blog into a WordPress theme. This project gave me the confidence in my new skill and my ability to learn as I go. The conversion process felt straightforward. I learned that the Bootstrap theme didn’t easily translate into … Read more

Learning Progress Part II

The Progress So it’s been almost two and a half months since I started learning how to code. During that time I’ve finished the Beginning PHP and Development for WordPress tracks on Team Treehouse. Before starting another track I wanted to make sure I had integrated what I learned. So I made projects for myself … Read more

WordPress $wpdb Object Overview

This is a really helpful overview from BenBaltar on how to run a query on the $wpdb. I personally used this when I created a function within a plugin to check if a post was a child of an array of posts. One question I have is if it is the most efficient use of … Read more

Better WordPress Email Management with MailGun

I’ve always had a lot of trouble with the WordPress email system. Whether it’s dropping emails, not receiving emails, emails ending in spam, not authenticating with Gmail, DNS records being incorrect, a lot can and has gone wrong. Most guides out there give you a generic SMTP plugin to install and say that should solve it. Sometimes … Read more

Update WordPress links with SQL

It’s not easy changing your WordPress site links. You might have to change http to https or correct a spelling error. If changing settings or using plugins don’t help, here’s how to change it manually with SQL. Most of us will have to use phpmyadmin. Find your database manager.  In your database command line execute the … Read more

Hello, World!

This is my first blog post. I’m going to write down my experience as I learn web development so that I can look back and see the progress (or regress) I’ve made and if I find success as a developer, to show others that it’s possible for them too. Some Background I never intended to … Read more