Simple Snippet to find instance of a text string in all tables of WordPress

In looking for this script I assembled a simple snippet to do the work for me suspecting I will need to do this again.  This could make a good plugiin for admins and web people – hmm…

The script – reasonably well commented, Intended to be used on the site root assuming that the WP install is also on the site root. If  this is not the case, change the require on the top of the script. Not tested on multi-site WP yet.

<?php
// datamafia.com the wordpress ninja
// This script rolls through the WP DB and finds all fo the tables
// For each table found every column is extracted
// then in each column we perform 3 MYSQL like searches in the style of :
// "%target word or phrase%"
// "%target word or phrase"
// "target word or phrase%"
// The output is then printed to screen with a noticeable text flag and in bold

// ### THE ONE USER FONGIURATION ###
$target_text = 'and'; // set this to the string you want to find
// ### END USER CONFIGURATION ###

define('WP_USE_THEMES', false); // no theme-o-la
require_once($_SERVER['DOCUMENT_ROOT'].'/wp-load.php'); // get the WP coex in the scroipt
global $wpdb; // for use in function / etc

$sql = "SHOW TABLES FROM ".DB_NAME.";"; //tables
$result  = $wpdb->get_results($sql);
echo '<p>Results for text `'.$target_text.'` in '.DB_NAME.'</p>'; // WTF you are doing
foreach($result as $row){
 $obj1 = 'Tables_in_'.DB_NAME;
 $sql2 = "show columns from `".$row->$obj1."`;";
 $result2 = $wpdb->get_results($sql2);
 foreach($result2 as $row2){
 $sql3 = "select count(*) as dacount from `".DB_NAME."`.`".$row->$obj1."` where ".$row2->Field." like '%$target_text%' or ".$row2->Field." like '$target_text%' or ".$row2->Field." like '%$target_text'; ";
 $result3 = $wpdb->get_results($sql3);
 $strong = $strong2 = null;
 if($result3[0]->dacount/*)>0*/){ // triggered for results
 $strong = '<br /><br /><strong>BOOM!----------------------------------------------<br />';
 $strong2 = '</strong><br /><br />';
 }
 echo $strong.
 "Table: ".$row->$obj1."<br />"
 . "&nbsp;&nbsp;COL: ".$row2->Field
 . '<br />&nbsp;&nbsp;&nbsp;&nbsp; count : ('.$result3[0]->dacount.')'.$strong2.'<br />';
 }
}
?>

Enjoy!

Release : Finally Listed on WordPress.org

My Dash Note plugin (a little Saturday afternoon scripting) is finally live on WordPress.org here. The biggest hurdle was getting in line with the dev and marketplace guidelines for WordPress. With that done migration for more work to the WP site is in line.

My local supprt page for this plug-in is here.  Thanks for your support and drop mad stars on my script

Demistifying Search Engine Experts

With each passing year I fear Search Engine “Experts” more and more. I rank them as modern snake oil sales*, at best. Typically a project brings in an “Expert” who has the personality of gum stuck to my shoe and siphons money from my employers riding on the results of others and contributing little.

* Large enterprise SEO not withstanding. I am talking about the various fly-by-night SEO companies who come in using destructive methods to get fast results at the expense of the small business.

In this post I want to discuss how search engines work and why I advocate against using SEO “experts” until a site is live for 6-12 months minimum with a rich collection of valid content.

Assumption : You have a web programmer and coder like me who will write solid code, coach the staff, and encourage good work.

Meta Tags & Description :

Truth : Not too valuable. Estimated at 5% of overall ranking calculation
(more…)

Apple OSX

I use a Mac.

The OS(X) is just a nightmare with only a few exceptions.

This is not one of the exceptions.

The Problem: In learning C++ (C Plus Plus) and want to compile and execute some simple programs – math and text manipulation mostly.
(more…)