Web Development

Regex for Alphanumeric Only – No Spaces, dashes or Underlines

Regex for A-Z, 0-9 and limited to 0-32 characters




if (preg_match('/^[a-zA-Z0-9]{0,32}$/', $mystring))
    return true;


Web Development

Redirect all Traffic to HTTPS

In the .htaccess file add:

RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]


Web Development

Import large database files to MySQL using Terminal with MAMP

/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot DBNAME < /Users/robertannett/Downloads/DBFILENAME.sql


Web Development

PayPal WooCommerce return URL

Under Website Selling Preferences turn on Auto Return and the url for WooCommerce should be:


Web Development

Replace the Blank Line in Contact form 7 Select List

function my_wpcf7_dropdown_form($html) {
    $text = 'Your Replacement text here';
    $html = str_replace('---', '' . $text . '', $html);
    return $html;
add_filter('wpcf7_form_elements', 'my_wpcf7_dropdown_form');


Web Development

Custom WordPress Excerpt

<?php echo wp_trim_words( get_the_excerpt(), 50, ‘…’ ); ?>

OSX Web Development

Simpler way of adding for CakePHP3 on OSX with Mamp

In a Nutshell we just need to do get the full binary package of PHP and install it on OSX, this version comes with, and we will copy it out of its install directory and drop it into our PHP version.

Get & Install the Binary Package

This website provides the packages so we just pick the version we want to use and run their install script:

curl -s | bash -s 5.6

This would install php 5.6 and we we can copy the file out of the install directory and drop it in our PHP folder.

PHP 5.6.31:

cp /usr/local/php5-5.6.31-20170817-164511/lib/php/extensions/no-debug-non-zts-20131226/ /Applications/MAMP/bin/php/php5.6.31/lib/php/extensions/no-debug-non-zts-20131226

In this example I am using Mamp so I should drop it into the extensions/no-debug-non-zts-20131226 folder of my PHP version.  These are the same version of PHP so the path should be the same, its just that Mamp holds its PHP binary files in the MAMP app.

PHP 7.3.8:

cp /usr/local/php5-7.3.8-20190811-205217/lib/php/extensions/no-debug-non-zts-20180731/ /Applications/MAMP/bin/php/php7.3.8/lib/php/extensions/no-debug-non-zts-20180731/


Enable the extension

Find the php.ini file for the version of php you want to use in my case I was using php5.6.31 (you can tell from copy/paste terminal line), and under “Extensions” add the line:

And restart Mamp, and your extension should now be installed!

Set PHP version for Terminal – Required for CakePHP / Composer based installs

Frustratingly, terminal often runs a different version of PHP when installing with composer, so for example, CakePHP refuses to install because its running a version of PHP that doesn’t have installed.  Check your version of PHP in terminal by typing:

php -v

if it is a different version that the one you want, set the correct one by using an alias in your .bashrc file.

sudo nano ~/.bashrc

Add the line (Replace php path with your path):

alias php="/Applications/MAMP/bin/php/php5.6.31/bin/php"

Then finally reload your bashrc file with:

source ~/.bashrc

You also may need to use this guide to include the php version to terminal if the above doesn’t work:


Web Development

WordPress: Additional Admin Columns with ACF

In functions.php, add the following and change [post_type] for the post type of the table you want to alter.

If you have used ACF,  you can find the post type in the ur e.g.

  • /wp-admin/edit.php?post_type=jobs
// Add the custom columns to the [post_type] post type:
add_filter( 'manage_[post_type]_posts_columns', 'set_custom_edit_[post_type]_columns' );
function set_custom_edit_[post_type]_columns($columns) {
    unset( $columns['author'] );
    $columns['yourFieldKey'] = __( 'yourFieldName', 'your_text_domain' );

    return $columns;

// Add the data to the custom columns for the [post_type] post type:
add_action( 'manage_[post_type]_posts_custom_column' , 'custom_[post_type]_column', 10, 2 );
function custom_[post_type]_column( $column, $post_id ) {
    switch ( $column ) {

        case 'yourFieldKey' :
            // Job Store
            if ( 'yourFieldKey' === $column ) {
                $data = get_field('yourFieldKey', $post_id);

                if ( ! $data ) {
                    _e( 'N/A' );
                } else {
                    echo $data->post_title;


// Make Title Clickable
add_filter( 'manage_edit-[post_type]_sortable_columns', '[post_type]_sortable_columns');
function [post_type]_sortable_columns( $columns ) {
    $columns['yourFieldKey'] = 'yourFieldKey';
    return $columns;

// Make data sortable
add_action( 'pre_get_posts', 'posts_orderby' );
function posts_orderby( $query ) {
    if( ! is_admin() || ! $query->is_main_query() ) {

    if ( 'yourFieldKey' === $query->get( 'orderby') ) {
        $query->set( 'orderby', 'meta_value' );
        $query->set( 'meta_key', 'yourFieldKey' );


Web Development

Custom posts per page on Archive and Search in WordPress

Add the following to Functions.php in your theme or child-theme amd alter the posts_per_page argument value.

 * Control the number of search results
function custom_posts_per_page( $query ) {
    if ( $query->is_archive() || $query->is_search() ) {
        set_query_var('posts_per_page', 12);
add_action( 'pre_get_posts', 'custom_posts_per_page' );


Web Development

List all ports in use

netstat -lp

List all services using a specific port

netstat -lp | grep 3306