<?php
// header("Content-Type: text/html;charset=utf-8");
try {
$redis = new Redis();
$redisConn = $redis->connect('127.0.0.1', 6379);
} catch (Exception $e) {
$text = $e->getMessage();
// 解决PHP输出显示小黑色钻石带有问号
die(iconv("GB2312", "UTF-8", $text));
}
// 连接数据库
$host = '127.0.0.1';
$username = 'root';
$pass = '';
$dbname = 'mmw';
$conn = new mysqli($host, $username, $pass, $dbname);
if (!$conn) {
die('数据库连接失败'. $conn->connect_error);
}
// rpush由列表尾部添加字符串值
// for ($i = 0; $i < 2; $i++) {
// $redis->rpush('test', $i);
// }
// llen返回列表的长度
$length = $redis->llen('test');
var_dump($length);
if ($length <= 0) {
die('没有值');
}
for ($i = 0; $i < $length; $i++) {
// lpop返回和移除列表的第一个元素
$value = $redis->Lpop('test');
try {
$sql = 'insert into mmw_user (name) values (' . $value . ')';
$result = mysqli_query($conn, $sql);
if ($result && mysqli_affected_rows($conn) > 0) {
echo '插入成功';
} else {
die('插入失败');
}
} catch (Exception $e) {
die('插入失败' . $e->getMessage());
}
// 延迟1秒执行
sleep(1);
}
12-21
884
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)