$host = 'localhost';
$username = 'root';
$password = '123456';
$database = 'test_db';
<p>// 创建连接
$mysqli = new mysqli($host, $username, $password, $database);</p><p>// 检查连接是否成功
if ($mysqli->connect_error) {
die('连接失败：' . $mysqli->connect_error);
}</p><p>// 设置字符集，避免中文乱码
$mysqli->set_charset('utf8mb4');</p>

$sql = "SELECT id, name, email FROM users WHERE status = ?";
$stmt = $mysqli->prepare($sql); // 预处理，防 SQL 注入
<p>$status = 1;
$stmt->bind_param('i', $status); // 'i' 表示整型参数
$stmt->execute();</p><p>$result = $stmt->get_result(); // 获取结果集</p>
                    <div class="aritcle_card">
                        <a class=&quot;aritcle_card_img" href="/ai/839">
                            <img src="https://img.php.cn/upload/ai_manual/000/000/000/175680126275698.png" alt="QoQo">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/ai/839">QoQo</a>
                            <p>QoQo是一款专注于UX设计的AI工具，可以帮助UX设计师生成用户角色卡片、用户旅程图、用户访谈问卷等。</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="QoQo">
                                <span>172</span>
                            </div>
                        </div>
                        <a href="/ai/839" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="QoQo">
                        </a>
                    </div>
                <p>while ($row = $result->fetch_assoc()) {
echo "ID: {$row['id']}, 姓名: {$row['name']}, 邮箱: {$row['email']}<br>";
}</p><p>$stmt->close(); // 记得关闭语句</p>

$sql = "INSERT INTO users (name, email, status) VALUES (?, ?, ?)";
$stmt = $mysqli->prepare($sql);
<p>$name = '张三';
$email = 'zhangsan@example.com';
$status = 1;</p><p>$stmt->bind_param('ssi', $name, $email, $status);
$stmt->execute();</p><p>if ($stmt->affected_rows > 0) {
echo "新增成功，ID：" . $mysqli->insert_id;
} else {
echo "执行失败：" . $stmt->error;
}</p><p>$stmt->close();</p>

$result = $mysqli->query("SELECT * FROM config");
if ($result && $result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo $row['key'] . ' = ' . $row['value'] . '<br>';
    }
}
$result->free(); // 释放结果集