1. [PHP]代码
$setting = array(
'databaseHost' => '127.0.0.1',
'databaseUser' => 'root',
'databasePass' => '',
'oldDatabaseName' => 'old_database_name',
'newDatabaseName' => 'new_database_name',
'execute' => false,
);
$db = new PDO("mysql:host={$setting['databaseHost']};dbname={$setting['oldDatabaseName']}", $setting['databaseUser'], $setting['databasePass']);
$result = $db->query("show tables");
$tables = $result->fetchAll();
foreach ($tables as $tableCtr) {
$tablename = $tableCtr['Tables_in_' . $setting['newDatabaseName']];
$sql = "ALTER TABLE $tablename RENAME TO " . str_replace('mymps', 'mk_', $tablename);
$sql = "RENAME TABLE {$setting['oldDatabaseName']}.{$tablename} TO {$setting['newDatabaseName']}.{$tablename};";
if ($setting['execute']) {
if ($db->query($sql)) {
continue;
} else {
exit($db->errorInfo());
}
} else {
echo $sql . PHP_EOL;
}
}
ecshop
本版本全面兼容php5.6+，并且修复了许多官方程序的低级代码bug。在apache 2.4.17+php5.6.15环境下测试通过，人格保证无毒无木马，仅仅是一名ecshop热爱者心血来潮之作。ecshop编译更新日志：1、加入最新官方补丁。2、修改数据库连接底层为mysqli, 现在完美无缺了。3、再次对所有代码进行细节修复。4、adminers更新至1.1.2, 在线管理数据库的神器。5、测
下载
