如何利用PHP和UniApp实现用户个人设置功能

define('DB_HOST', 'localhost');
define('DB_USERNAME', 'your_username');
define('DB_PASSWORD', 'your_password');
define('DB_NAME', 'users');

require_once 'config.php';

// 连接数据库
$conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取用户个人设置
$user_id = $_POST['user_id'];
$name = $_POST['name'];

$sql = "SELECT * FROM settings WHERE user_id = '$user_id' AND name = '$name'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 更新用户个人设置
    $value = $_POST['value'];
    $sql = "UPDATE settings SET value = '$value' WHERE user_id = '$user_id' AND name = '$name'";
    $result = $conn->query($sql);
    if ($result) {
        echo json_encode(array("status" => "success"));
    } else {
        echo json_encode(array("status" => "error", "message" => "更新失败"));
    }
} else {
    // 添加用户个人设置
    $value = $_POST['value'];
    $sql = "INSERT INTO settings (user_id, name, value) VALUES ('$user_id', '$name', '$value')";
    $result = $conn->query($sql);
    if ($result) {
        echo json_encode(array("status" => "success"));
    } else {
        echo json_encode(array("status" => "error", "message" => "添加失败"));
    }
}

$conn->close();

<view>
    <input v-model="name" placeholder="请输入设置名称" />
    <input v-model="value" placeholder="请输入设置值" />
    <button @click="saveSettings">保存设置</button>
</view>

export default {
    data() {
        return {
            name: '',
            value: ''
        }
    },
    methods: {
        saveSettings() {
            uni.request({
                url: 'http://localhost/settings.php',
                method: 'POST',
                data: {
                    user_id: '1',  // 当前用户ID
                    name: this.name,
                    value: this.value
                },
                success: (res) => {
                    console.log(res.data);
                    if (res.data.status === 'success') {
                        uni.showToast({
                            title: '保存成功',
                            icon: 'success'
                        });
                    } else {
                        uni.showToast({
                            title: '保存失败',
                            icon: 'none'
                        });
                    }
                },
                fail: () => {
                    uni.showToast({
                        title: '请求失败',
                        icon: 'none'
                    });
                }
            });
        }
    }
}