File: /home/imensosw/www/imenso.co/demo/zuruuna/find_n_replace_in_db.php
<?php
// Connect to your MySQL database.
$hostname = "localhost";
$username = "root";
$password = "";
$database = "wedding_web";
$conn = new mysqli($hostname, $username, $password,$database);
// The find and replace strings.
$find = "http://localhost/";
$replace = "http://10.0.0.7/";
$loop = mysqli_query($conn,"
SELECT
concat('UPDATE ',table_schema,'.',table_name, ' SET ',column_name, '=replace(',column_name,', ''{$find}'', ''{$replace}'');') AS s
FROM
information_schema.columns
WHERE
table_schema = '{$database}'")
or die ('Cant loop through dbfields: ' . mysqli_error());
while ($query = mysqli_fetch_array($loop))
{
mysqli_query($conn,$query['s']);
}
?>