- <?php
- include_once('./config/config_global.php');
- $servername = $_config['db']['1']['dbhost'];
- $username = $_config['db']['1']['dbuser'];
- $password = $_config['db']['1']['dbpw'];
- $dbname = $_config['db']['1']['dbname'];
- $mysqli = mysqli_connect($servername, $username, $password, $dbname) ;
- $dbname = '\''.$dbname.'\'';
- $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE Engine='MyISAM' AND TABLE_SCHEMA=$dbname";
- //执行查询
- $result = $mysqli->query($sql);
- if($result === false){ //执行失败
- echo $mysqli->error;
- echo $mysqli->errno;
- }
- //输出结果
- while($row = $result->fetch_assoc()) {
- echo 'ALTER TABLE '.$row['TABLE_NAME'].' ENGINE=InnoDB;' .'<br>';
- }
- // 销毁变量
- $servername = '';
- $username = '';
- $password = '';
- $dbname = '';
- ?>