PHP Batch Change database table prefix implementation method _php instance

By following this method, easy to handle, the code below, useful to the top.

Copy Code code as follows:

<?php
        $database = " DatabaseName ";        //Database name
        $ user = "root";                       //database user name
        $pwd = "pwd";                          //Database password
        $replace = ' pre_ ';                      //replacement prefix
        $seach = ' pre1_ ';                     //prefix to replace
        $db =mysql_connect ("localhost", "$user", "$pwd") or Die ("Connection Database failed:". Mysql_error () );         //Connection database

        $ tables = Mysql_list_tables ("$database");       
         while ($name = Mysql_fetch_array ($tables)) {

                 $table = Str_replace ($seach, $replace, $name [' 0 ']);

                mysql_query ( "Rename table $name [0] to $table");
       }

If you add a prefix you just need to change a little bit

Copy Code code as follows:

$table = Str_replace ($seach, $replace, $name [' 0 ']);
$table = $replace. $name [' 0 '];

is OK.