帝国cms电影批量插入评论

本文链接：https://blog.csdn.net/helloworld_dream/article/details/103143073

本文介绍了一段使用PHP编写的自动化脚本，该脚本能够连接到MySQL数据库，执行SQL查询，并自动插入评论数据。通过随机数生成不同数量的评论，确保了数据的多样性和随机性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php
$dbhost = 'localhost:3306';  // mysql服务器主机地址
$dbuser = '51ady';            // mysql用户名
$dbpass = '51ady';          // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
    die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
mysqli_select_db( $conn, '5ady' );


$sql = "SELECT id  FROM phome_ecms_news   " ;
$retval = mysqli_query( $conn, $sql );

$newsRow = mysqli_fetch_assoc($retval);

while($row = mysqli_fetch_assoc($retval))
{
	for ($i = 0; $i < rand(5,20); $i++) {
		$articleId = $row['id'];
		$articleNum = $articleId;
		$len = strlen($articleId);
		$cha = 10-$len;
		if($cha <10){
			$f = '';
			for ($i = 0; $i < $cha; $i++) {
				$f.='0';
			}
			$articleNum = $f.$articleId;
			// echo($articleNum);die;
		}
    	$comm_sql = "INSERT INTO `phome_enewspl_1` (plid,pubid,username,sayip,saytime,id,checked,classid,zcnum,fdnum,userid,isgood,saytext,eipport) VALUES (NULL, '100001".$articleNum."',   '匿名', '113.116.70.94', FLOOR(1358540000 + RAND() * (1574074061 - 1358540000)), ".$articleId.",     '0', '0', FLOOR(0 + RAND() * 200), FLOOR(0 + RAND() * 10), '0', '0', (SELECT content as saytext FROM comment ORDER BY rand() LIMIT 1 ), '13293');" ;
		$comm_retval = mysqli_query( $conn, $comm_sql );
		// var_dump($articleId);
		
	}
 echo($row['id']." 完成\r\n");

} 
}