PHP Script to alter and convert all tables in a MySQL database to use a different character set and collation

collation.php

<?php

// enter your database name
$database_name = 'name';
// enter your database user name
$database_username = 'user';
// enter your database user password
$database_password = 'password';

$connection = mysql_connect( 'localhost', $database_username, $database_password );

if ( !$connection ) {
  
	echo 'ERROR - Cannot establish connection to database!';
	
} else {
  
	mysql_select_db( $database_name );
	$result = mysql_query( 'show tables' );

	while( $tables = mysql_fetch_array( $result ) ) :

		foreach ( $tables as $key => $value ) :
		  
		  	// you can change character set and collation here by replacing lowercase values with the ones you want
			mysql_query("ALTER TABLE ".$value." CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
			
		endforeach;
		
	endwhile;
	
	echo 'Done!';
	
}