批量获取或更新数据库中的业务数据脚本

mysql_bat.php 用于获取线上数据库中的数据或批量更新数据库中的数据。

    <?php
    
    //演示脚本 用于查询线上系统数据库问题
    $dbs = ['x001', 'x002', 'x003'];
    
    file_put_contents('mysql_bat.txt', '');
    
    foreach ($dbs as $v) {
        $mysql_conf = array('host' => 'localhost', 'db' => $v, 'db_user' => 'xxx', 'db_pwd'  => 'xxx');
        
        $mysqli = new mysqli($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);
        $mysqli->query("set names 'utf8';");//编码转化
        $select_db = mysqli_select_db($mysqli, $mysql_conf['db']);
        if ($select_db) {
            //查询律所部门名称
            $deptName = $configName = '';
            $sql1 = "select name from {$v}.lawfirm_dept where id=1;";
            $res1 = $mysqli->query($sql1);
        
            while ($row = $res1->fetch_assoc()) {
                $deptName = $row['name'];
            }
        
            file_put_contents('mysql_bat.txt', '[new] '.$deptName.PHP_EOL, FILE_APPEND);
        
            $res1->free();
            $mysqli->close();
        }else{
            file_put_contents('mysql_bat.txt', '[connect error] '.$v.PHP_EOL, FILE_APPEND);
            continue;
        }
        
        // sleep(1);
    }