Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $database_name=’dbname’;
- $database_username=’dbusername’;
- $database_password=’dbpassword’;
- $connection = mysql_connect(‘localhost’,$database_username,$database_password);
- if(!$connection) {
- echo “Cannot connect to the database – incorrect details”;
- }else{
- mysql_select_db($database_name);
- $result=mysql_query(‘show tables’);
- while($tables = mysql_fetch_array($result)) {
- foreach ($tables as $key => $value) {
- mysql_query(“ALTER TABLE “.$value.” COLLATE utf8_general_ci”);
- }
- }
- echo “Successfull collation change!”;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement