SQL
WordPress SQL Syntax Example
I have a couple of tables I'm joining and only want to return users that a field missing in the joined table. Users id fname lname userMeta id metaKey metaValue I'm trying to find users that don't have a record in…
Blog · Page 24 of 25
Notes from the build.
Practical guides on AI automation, web development, WordPress, Laravel and the tools we use every day.
PHP
PHP Date Formatting
A simple example of how to take a date and change it's format using PHP. August, 3 2015 to YYYY-MM-DD Easily done with the below code: $olddate = 'August 3, 2015'; $newdate = date('Y-m-d', strtotime($olddate)…
PHP
Parsing RSS Feed For Images
I'm trying to parse out an RSS feed for images. My original code grabbed the title, description, link, and pubDate just fine. I read a tutorial online on how to get the images out as well, but now that I've updated my…
node.js
How to Monitor Node.js Instances
How do you monitor node.js instances on your server? I used to use the Forever package, but it has since been deprecated. PM2 is a great replacement and seems to be more robust than Forever. I'd recommend it over…
MySQL
Delete Duplicates from a MySQL Database Table
I was trying to figure out a query to count the IP addresses I had in a table, tell me how many are the same, then delete duplicates only leaving a single record for each. Data example: id, ip 1 72.135.77.1 2 …
HTML
Changing Date Format Before Insert
When passing dates from a form to be saved in your database you sometimes need to change their format. For example a with a datetimepicker you want the format to look like 07-31-2017 12:30pm for the end user. But in…
Linux
Ubuntu Command to List All Installed Packages
To list all packages installed in CentOS you run: yum -qa Just had someone ask what's the equivalent to this command in Ubuntu, well here you go: apt list…
CSS
Replace Select Drop Down Arrow with FontAwesome
I've seen this question a lot so here's an example of how to replace a select drop down arrow with a fontawesome icon. <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"…
WordPress
WordPress Shortcode for the Current URL
Had a request last week to create a shortcode that would output the current page URL within a post or page in WordPress. Here you go, edit your /wp-content/themes/themeName/functions.php file and add this to the…
JavaScript
JavaScript: Reload Page on Click Without Query String
Here is an example of how to reload a page on button click with JavaScript and removing the query string. I have a URL like this: domain.com/experts-exchange/29046174.php?id=1&query=nathan&orgID=2442 I want to be able…
Rather have us build it?
We help Kansas City businesses automate the busywork and ship reliable software. Tell us what you're working on.