現在位置: 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だけが入れ替わっています。