جایگزین کردن یک متن در کل جدول‌های دیتابیس با PHP

<?php
// Database connection credentials
$host = 'localhost';
$dbname = 'your_database_name'; // Change this to your database name
$user = 'your_username'; // Change this to your username
$password = 'your_password'; // Change this to your password

try {
    // Create a new PDO connection
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Get all table names in the database
    $tables = $pdo->query("SHOW TABLES")->fetchAll(PDO::FETCH_COLUMN);

    // Iterate through each table
    foreach ($tables as $table) {
        // Get columns of the table
        $columns = $pdo->query("SHOW COLUMNS FROM $table")->fetchAll(PDO::FETCH_COLUMN);

        // Iterate through each column to update the values
        foreach ($columns as $column) {
            $updateQuery = "UPDATE `$table` SET `$column` = REPLACE(`$column`, 'متنی که میخواهید جایگزین شود', 'متنی که باید جایگزین شود') WHERE `$column` LIKE '%متنی که میخواهید جایگزین شود%'";
            try {
                $pdo->exec($updateQuery);
                echo "Updated $table.$column successfully.\n";
            } catch (PDOException $e) {
                // Catch any errors (e.g., if the column data type is not suitable for REPLACE)
                echo "Failed to update $table.$column: " . $e->getMessage() . "\n";
            }
        }
    }

    echo "Database update complete.\n";

} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

<?php
// Database connection credentials
$host = 'localhost';
$dbname = 'your_database_name'; // Change this to your database name
$user = 'your_username'; // Change this to your username
$password = 'your_password'; // Change this to your password

// Create a new mysqli connection
$mysqli = new mysqli($host, $user, $password, $dbname);

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Get all table names in the database
$tablesResult = $mysqli->query("SHOW TABLES");

if ($tablesResult) {
    // Iterate through each table
    while ($tableRow = $tablesResult->fetch_array()) {
        $table = $tableRow[0];

        // Get columns of the table
        $columnsResult = $mysqli->query("SHOW COLUMNS FROM `$table`");

        if ($columnsResult) {
            // Iterate through each column to update the values
            while ($columnRow = $columnsResult->fetch_assoc()) {
                $column = $columnRow['Field'];

                $updateQuery = "UPDATE `$table` SET `$column` = REPLACE(`$column`, 'متنی که میخواهید جایگزین شود', 'متن جایگزین') WHERE `$column` LIKE '%متنی که میخواهید جایگزین شود%'";
                if ($mysqli->query($updateQuery) === TRUE) {
                    echo "Updated $table.$column successfully.\n";
                } else {
                    echo "Failed to update $table.$column: " . $mysqli->error . "\n";
                }
            }
        } else {
            echo "Failed to get columns for table $table: " . $mysqli->error . "\n";
        }
    }
} else {
    echo "Failed to get tables: " . $mysqli->error . "\n";
}

// Close the connection
$mysqli->close();

echo "Database update complete.\n";
?>