Create, register and use shortcodes in WordPress
18/03/2023Learn how to create and register your own WordPress shortcodes to add dynamic content to your posts and pages.
Importing and Exporting MySql databases using command line
Every office has those useful commands which, inexplicably, nobody can remember when actually needed. In my last office, for some reason, it was MySql database imports and dumps. For nostalgic reasons I’m going to leave this here:
Import
mysql -u username -p [database_name] < [path_to_file.sql]Export/Dump
mysqldump -u [username] -p [database_name] > [name_of_file.sql]An easy trick for remembering this is to notice the direction of the less than and greater than signs. Greater than points away from the database (exporting) whereas less than points towards the database (importing).
You might like:
How to/why use guard clauses in JavaScript
16/03/2023Learn how to improve code readability and performance by using guard clauses in JavaScript. Discover their benefits and best practices.
Implements and Extends, Object Oriented TypeScript
15/03/2023Learn the difference between implements and extends in TypeScript. Use Implements to implement interfaces and types, and extends to inherit from classes.
Reading/Parsing and Writing YAML files, PHP Symfony
14/03/2023In this tutorial we will look at using YAML in PHP. Learn about Parsing and Writing YAML files using Symfony's YAML component.
Measuring code execution performance in JavaScript
13/03/2023Measuring code execution performance is an important way to identify bottlenecks. Use these methods in JavaScript to help optimise your code.
Measuring script/code execution time in PHP, microtime
06/03/2023Find bottlenecks, optimise and clean your code, and speed up your apps by measuring the execution time of your PHP scripts using microtime.
Regenerate WordPress media image sizes, programmatically
25/02/2021Learn how to regenerate and update WordPress media and image sizes both programmatically (without plugin), and also with a handy plugin.
Magic Constants in PHP. What they are and how to use them
15/02/2021Ever seen constants like __DIR__ and __FILE__ being used in PHP? These are 'Magic Constants', and this is how we can use them.
Detect single and multiple keypress events: JavaScript
16/10/2019Learn how to use event listeners to detect and handle single and multiple keypress events in JavaScript. Add modifier keys to your application!