The PHP json_decode function will return a strict null if the string passed into it is invalid json or it can’t parse it successfully. The
Read moreUsing Create/Select to Create a New MySQL Table From Another
In a single statement you can copy the structure and data from one table and populate the results of a query into the new table.
Read more
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
Read morePHP 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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | function clearAllCookies(){ $cookies = explode(';', $_SERVER['HTTP_COOKIE']); foreach($cookies as $cookie) { $parts = explode('=', $cookie); $name = trim($parts[0]); /* this removes any invalid cookie names preventing this warning: PHP Warning: Cookie names cannot contain any of the following '=,; \\t\\r\\n\\013\\014' */ $name = str_replace(array("=", ",", ";", " ", "\t","\r","\n",chr(013),chr(014)), "", $name); if($name <> ''){ setcookie($name, '', time()-1000); setcookie($name, '', time()-1000, '/'); } } } |
String Concatenation in MySQL
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
Read moreHow to do Email Validation in PHP
Using the PHP filter_var function we can test email addresses for valid format and only unicode characters. Example usage below.
1 2 3 4 | function isValidEmailSimple($emailAddress) { if (filter_var($emailAddress, FILTER_VALIDATE_EMAIL)) return true; return false; } |
MySQL 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
Read moreReplace 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
Read moreFix 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.
Read moreListing 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
Read more