現在位置: Top/データベースの文字置換

MovableTypeで画像のURLだけ置換する。

<?
$DBHost = 'localhost';
$Database = '';
$DBUser = '';
$DBPassword = '';

$blogid='1'; 
$url1 = 'http://xxx/img/';
$url2 = 'http://yyy/img/';

if (!($mysql = mysql_connect($DBHost,$DBUser,$DBPassword)))
  {echo "Can't Connect DBHost $DBHost(1)";}

if (!(mysql_select_db($Database)))
  {echo "Can't Connect Database $Database(2)";}

$query = "SELECT entry_id, entry_title, entry_text, entry_text_more
  FROM mt_entry WHERE entry_blog_id = $blogid";

$res = mysql_query($query);
while($row = mysql_fetch_object($res)) {
  $itemid = $row->entry_id;
  $title = $row->entry_title;
  $text = $row->entry_text;
  $text_more = $row->entry_text_more;
  $text = str_replace($url1,$url2,$text);
  $text_more = str_replace($url1,$url2,$text_more);
  echo '['.$itemid.'] '.$title.'<br>';

  $query2 = "UPDATE mt_entry
    SET entry_text='$text', entry_text_more='$text_more'
    WHERE entry_id=$itemid";
  $res2 = mysql_query($query2); 
}

?>

このあと再構築をすれば、画像のURLだけが入れ替わっています。