In a single statement you can copy the structure and data from one table in MySQL and populate the results of a query into the
How to use emoji’s on your website
The proper way to use emojis on you’re site is to use the HTML unicode characters. Just copy and paste them into your html. You’ll
Function To Remove All Cookies For The Domain
This PHP function will delete all valid cookies for a domain. We’re also sanitizing the cookie variable names from invalid characters.
String Concatenation Using concat Function
Unlike SQL Server, String concatenation works using a function. It’s a simple function that you pass comma separated values into in the order you want
How to do Email Validation
Using the PHP filter_var function we can test email addresses for valid format and only unicode characters. Example usage below.
Query using Avg Ignoring Certain Values
In this case we want to get the average of values but we also want to ignore certain values, say if when the deviceType column
Replace All Characters In a String that Aren’t Alphanumeric
Using the preg_replace function you can easily replace all characters in a string that are not alphanumeric. This can be useful for sanitizing a string
Fix SSH Key Permissions (Permissions are too open private key will be ignored)
Sometimes you’ll get an error on your ssh client when you’re working with a new ssh key and you’re trying to ssh into the server.
Listing Files Only With Grep Command
To only show the file names and not a preview of data add the command line param -l to grep. The below example searches in
Using Ghostscript CLI to Shrink a PDF
Shrinking a PDF with Ghostscript is easy in Linux. Below are 3 ghostscript commands to shrink PDFs to a few different levels. screen – lowest