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
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();
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
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
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
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
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
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
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
