BitBook

Moving Your Git Project to GitHub

December 15, 2018 mike Dev

From the root of your current project run this command. That’s it!

git push --mirror git@github.com:username/project.git

1	git push --mirror git@github.com:username/project.git

Loop Through All Properties of a PHP Object

December 13, 2018 mike PHP

Looping through all of a PHP objects properties is just as easy as an array. Output:

Validating JSON in PHP

December 11, 2018 mike PHP

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

Using Create/Select to Create a New MySQL Table From Another

December 8, 2018 mike MySQL

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.

How to use emoji’s on your website

December 7, 2018 mike HTML & UI

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

PHP Function To Remove All Cookies For The Domain

December 6, 2018 mike PHP

This PHP function will delete all valid cookies for a domain. We’re also sanitizing the cookie variable names from invalid characters.

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, '/');
            }
       }
}

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

December 5, 2018 mike 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

How to do Email Validation in PHP

December 4, 2018 mike PHP

Using the PHP filter_var function we can test email addresses for valid format and only unicode characters. Example usage below.

function isValidEmailSimple($emailAddress) {
	if (filter_var($emailAddress, FILTER_VALIDATE_EMAIL)) return true;
	return false;
}

function isValidEmailSimple($emailAddress) {

if (filter_var($emailAddress, FILTER_VALIDATE_EMAIL)) return true;

return false;

}

MySQL Query using Avg Ignoring Certain Values

December 3, 2018 mike MySQL

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 In PHP

November 30, 2018 mike PHP

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