You can use a combination of terminal commands like awk, sort, uniq, and cut to analyze an Apache log file and find out which files are called the most and the bandwidth they are using.
Coding
Pinakin Patel
PHP Web Developer
Function to create a slug in MySQL
Use this to create a slug from a string field.
using curl to fetch a file using sftp with password in command
If you need to download a file using SFTP from the command line, you should use the sftp or scp commands.
updating custom field values in mailwizz using direct SQL
In mailwizz you can create custom fields which get assigned a field_id in the database table. So in my case the customer field is called rank and the field_id = 24.
Format Telephone numbers into US format in MySQL
if you have a telephone field in a table where numbers have been entered in the format 1234567890 then use this to format it as 123-456-7890
Adding a product level field which is language dependent
Use this guide to add a new field to the xcart_products_lng_en table.
Driving School Price Comparison using wpDataTables
How to create a searchable and sortable data...
Reading a CSV and calling ChatGPT and outputting to a New CSV file
In this example I am going to use python to read...
jQuery to check the first charater of a link started with hash #
I came across an issue with an old wordpress site where the mobile menu did not close when a menu item link to internal page content because the url started with # hash.
Guide to Changing Directory Permissions to 755 and File Permissions to 644
Tutorial on how to change the permissions of all files and directories within a directory tree on Linux
Adding a HTML Sitemap to a Shopify Store
I have found that themes generally use links to prodct pages that are not the canonicalised url to the product on the store page. So this is to allow the breadcrumb to be dynamic and show based on the route they took to the product page.
How to get the sending IP addresses from the references in your SPF record
If you use SMTP services like Mailjet or Amazon...