迅睿CMS导入别站数据库

<?php
if (isset($_GET['go'])) {
	$host = 'localhost';
	// 数据库服务器
	$username = 'uname';
	// 数据库用户名
	$password = 'pwd';
	// 数据库密码
	$database = 'database';
	// 数据库名
	$cmscid = $_GET['cmscid'];
	$mtabcid = $_GET['mtabcid'];
	if ($_GET['go'] == 'step1') {
		//第一步：先获取CMS电影栏目所有内容ID
		// 连接数据库
		$conn = new mysqli($host, $username, $password, $database, '3306');
		// 检查连接
		if (!$conn) {
			die("Connection failed: " . mysqli_connect_error());
		}
		// 确认数据总量
		$query = 'SELECT count(id) AS rows FROM dr_1_news WHERE catid = '.$cmscid.' AND simi <= 500000';
		// 查询语句
		$result = mysqli_query($conn, $query);
		// 执行查询
		// 检查结果
		if ($result) {
			//有数据存在，获取总数
			$count = mysqli_fetch_assoc($result);
			$rows = $count['rows'];
			//            $k = 0;
			//            while ($row = $result->fetch_assoc()) {
			//                $k = $k + 1;
			//                // 处理每一行数据
			//                echo $k.'-名称：' . $row['title'] . ' / 网址：' . $row['wangzhi'] . ' / LOGO：con/con.png / 简介：' . $row['description'] . '<br />';
			//            };
			?>
			            <script language="javascript" type="text/javascript">
			                window.location.href = "copycms.php?cmscid=<?=$cmscid?>&mtabcid=<?=$mtabcid?>&go=step2&rows=<?=$rows?>&page=1";
			</script>
			            <?php
			            exit();
		} else {
			echo "查询错误: " . $query . "<br>" . mysqli_error($conn);
		}
		// 关闭连接
		mysqli_close($conn);
		exit();
	} elseif ($_GET['go'] == 'step2') {
		// 第二步：数据入库
		$page = $_GET['page'];
		$rows = $_GET['rows'];
		//第一步：先获取CMS电影栏目所有内容ID
		// 连接数据库
		$conn = new mysqli($host, $username, $password, $database, '3306');
		// 检查连接
		if (!$conn) {
			die("Connection failed: " . mysqli_connect_error());
		}
		$limit = $page - 1;
		//limit的始初值为0
		$query = 'SELECT * FROM dr_1_news WHERE catid = '.$cmscid.' AND id < 500000 ORDER BY paixu DESC, similarweb ASC LIMIT ' . $limit . ',1';
		// 查询语句
		$result = mysqli_query($conn, $query);
		// 执行查询
		// 检查结果
		if ($result) {
			//有数据存在
			// mysqli fetch_assoc 第一条数据不显示，不要使用While循环操作
			$row = mysqli_fetch_assoc($result);
			// 输出数据
			$name = $row['title'];
			$url = $row['wangzhi'];
			$tips = $row['description'];
			$src = '/con/con.png';
			$area = $mtabcid;
			// 格式化域名
			$domain = str_ireplace('http://', '', $url);
			$domain = str_ireplace('https://', '', $domain);
			$domain = explode('/', $domain);
			$domain = $domain[0];
			//判断是否有二级域名
			echo '名称：' . $name . ' / 网址：' . $url . ' / 域名：' . $domain . ' / 简介：' . $tips . '<br /><br />';
			//mTab字段：name，url，src，area, domain, tips
			//CMS字段： title, wangzhi,
			// 连接mTab数据库
			$mtabconn = new mysqli('localhost', 'uname', 'pwd', 'database', '3306');
			if (!$mtabconn) {
				die("Connection failed: " . mysqli_connect_error());
			}
			// 通过Title判断数据是否存在
			$query = "SELECT count(*) AS count FROM linkstore WHERE name = '" . $name . "'";
			// 查询语句
			$result = mysqli_query($mtabconn, $query);
			// 执行查询
			$row = mysqli_fetch_assoc($result);
			// 获取统计数
			if ($row['count'] > 0) {
				// 数据存在，更新
				echo $query = 'UPDATE linkstore SET url = "' . $url . '", tips = "' . $tips . '", domain = "' . $domain . '" where name = "' . $name . '"';
			} else {
				// 数据不存在，插入
				echo $query = 'INSERT INTO linkstore(name,url,src,area,domain,tips,create_time) VALUES("' . $name . '","' . $url . '","' . $src . '","' . $area . '","' . $domain . '","' . $tips . '","' . date("Y-m-d H:i:s") . '")';
			}
			if ($mtabconn->query($query) === TRUE) {
				// 数据操作成功
				mysqli_close($mtabconn);
				if ($page < $rows) {
					// 还有数据，进入到下一页
					$page = $page + 1;
				} else {
					// 采集结束，回到首页
?>

<script language="javascript" type="text/javascript">
	window.location.href = "copycms.php";
</script>

<?php
					exit();
				}
				;
?>

<script language="javascript" type="text/javascript">
	window.location.href = "copycms.php?cmscid=<?=$cmscid?>&mtabcid=<?=$mtabcid?>&go=step2&rows=<?=$rows?>&page=<?=$page?>";
</script>

<?php
				exit();
			} else {
				echo "数据库出错: " . $mtabconn->error;
			}
		} else {
			echo "查询错误: " . $query . "<br>" . mysqli_error($conn);
		}
		// 关闭连接
		mysqli_close($conn);
		exit();
	}
}
?>

<form method='get' action="copycms.php">
    <label for='db_host'>CMS分类ID</label>
    <input placeholder="CMS分类ID" type='text' name='cmscid' required><br>
    <label for='db_host'>mTab分类ID</label>
    <input placeholder="CMS分类ID" type='text' name='mtabcid' required><br>
    <input type="hidden" name="go" value="step1">
    <input type="submit" value="提交">
</form>