使用PHP脚本更新数据

<?php
    $dbhost='127.0.0.1';//mysql服务器主机地址
    $dbuser = 'root'; // mysql用户名
    $dbpass='root';//mysql用户名密码
    $conn = mysqli_connect($dbhost,$dbuser,$dbpass);
    if(!$conn){
        die('连接失败: ' . mysqli_error($conn));
    }

    $m = $_GET['m'];//起始位置
    $n = $_GET['n'];//每次执行条数
    if ($m<0){
        echo '请输入起点';
        die;
    }
    if (!$n || $n>1000){
        //每次执行条数，未填写则默认1000条
        $n = 1000;
    }
    //起点
    $m = $m*$n;
    $sql = "SELECT id,content FROM database.table1 LIMIT ". $m . "," . $n;
    $memberInfo = mysqli_query($conn, $sql);//获取数据
    $row = mysqli_fetch_all($memberInfo);
    $num = 0;
    foreach ($memberInfo as $key => $value) {
        if(strpos($value['content'],'Unknown') == false){
            $temp = explode('|',$value['content']);
            $temp[0] = 'Unknown';
            $content = implode('|',$temp);
            $sql_up = "UPDATE database.table1 SET content= '$content' WHERE id=".$value['id'];
            $result = mysqli_query($conn, $sql_up);//更新数据
            $num++;
            echo $value['id'].'</br>';
        }
    }

    echo $num.'条数据更新成功！';
    mysqli_close($conn);
?>