MOON
Server: Apache
System: Linux e2e-78-16.ssdcloudindia.net 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64
User: imensosw (1005)
PHP: 7.4.33
Disabled: exec,passthru,shell_exec,system
Upload Files
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']);
}
?>