<?php

$longopts = array(
  "db_name:",
  "db_user:",
  "db_pw:",
  "find_string:",
  "replace_string:",
  "replace_guid_field"
);

$options = getopt("", $longopts);
print "Found arguments:\n";
print_r($options);

$database = $options["db_name"];
$database_user = $options["db_user"];
$database_pw = $options["db_pw"];
$find_string = $options["find_string"];
$replace_string = $options["replace_string"];
$replace_guid = array_key_exists("replace_guid_field", $options);

$link = mysql_connect("localhost", $database_user, $database_pw);
mysql_select_db($database);

$query = "SHOW TABLES FROM $database";
$result = mysql_query($query);

while ($arr = mysql_fetch_array($result, MYSQL_NUM)) {
  foreach ($arr as $table) {
    process_table($table, $find_string, $replace_string, $replace_guid);
  }
}
mysql_close($link);

print "done";

function process_table($table, $find_string, $replace_string, $replace_guid) {
  print "\nprocessing $table....";

  $field_arr = array();
  $query = "SELECT * FROM $table";
  $result = mysql_query($query);
  while ($row_arr = mysql_fetch_array($result, MYSQL_ASSOC)) {
    foreach ($row_arr as $key => $value) {
      if (strpos($value, $find_string) !== false) {
        // Create a list of fields which contain the found string.
        $field_arr[$key] = true;
        //print_r($row_arr);
      }
    }
  }

  if (count($field_arr) == 0) {
    print " string not found.";
  } else {
    print " string found in field(s): " . implode(', ', array_keys($field_arr)) . "\n";
    foreach (array_keys($field_arr) as $field) {
      if ($field != "guid") {
        $query = "UPDATE $table SET $field = replace($field, '$find_string', '$replace_string') WHERE $field LIKE '%$find_string%'";
        update_table($query);
      } else {
        if ($replace_guid) {
          $query = "UPDATE $table SET $field = replace($field, '$find_string', '$replace_string') WHERE $field LIKE '%$find_string%'";
          update_table($query);
        } else {
          print "\nString found in guid field but not replacing. Override this by using the --replace_guid_field flag.\n";
        }
      }
    }
  }
}

function update_table($query) {
  print "\n$query\n";
  $result = mysql_query($query);
  $num_updated = mysql_affected_rows();
  print "... updated $num_updated records\n";
}
?>