如何从mysql表中的title列生成带有连字符的url？

// 连接到MySQL数据库
$servername = "your_servername";
$username = "your_username";
$password = "your_password";
$dbname = "your_dbname";
$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接数据库失败：" . $conn->connect_error);
}

// 查询title列的值
$sql = "SELECT title FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 遍历每个title值并生成URL
    while($row = $result->fetch_assoc()) {
        $title = $row["title"];
        
        // 处理title值
        $title = preg_replace("/[^a-zA-Z0-9\s]/", "", $title); // 去除特殊字符和空格
        $title = strtolower($title); // 转换为小写字母
        
        // 生成URL
        $url = str_replace(" ", "-", $title); // 连字符替换
        $url = urlencode($url); // URL编码

        // 更新URL列
        $update_sql = "UPDATE your_table SET url = '".$url."' WHERE title = '".$row["title"]."'";
        $conn->query($update_sql);
    }
} else {
    echo "没有查询到结果";
}

$conn->close();