如何利用PHP源码高效构建一个网址导航平台？

网址导航PHP源码是用于创建和管理一个网址导航网站的程序，通常包括网站链接的添加、编辑、删除等功能。

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn>connect_error) {
    die("连接失败： " . $conn>connect_error);
}
// 添加新的网址
if (isset($_POST['add'])) {
    $url = $_POST['url'];
    $title = $_POST['title'];
    $sql = "INSERT INTO urls (url, title) VALUES ('$url', '$title')";
    if ($conn>query($sql) === TRUE) {
        echo "新网址已成功添加";
    } else {
        echo "Error: " . $sql . "<br>" . $conn>error;
    }
}
// 编辑网址
if (isset($_POST['edit'])) {
    $id = $_POST['id'];
    $url = $_POST['url'];
    $title = $_POST['title'];
    $sql = "UPDATE urls SET url='$url', title='$title' WHERE id=$id";
    if ($conn>query($sql) === TRUE) {
        echo "网址已成功更新";
    } else {
        echo "Error: " . $sql . "<br>" . $conn>error;
    }
}
// 删除网址
if (isset($_POST['delete'])) {
    $id = $_POST['id'];
    $sql = "DELETE FROM urls WHERE id=$id";
    if ($conn>query($sql) === TRUE) {
        echo "网址已成功删除";
    } else {
        echo "Error: " . $sql . "<br>" . $conn>error;
    }
}
// 显示网址列表
$sql = "SELECT * FROM urls";
$result = $conn>query($sql);
echo "<h2>网址列表</h2>";
echo "<table border='1'>";
echo "<tr><th>ID</th><th>标题</th><th>网址</th></tr>";
while ($row = $result>fetch_assoc()) {
    echo "<tr>";
    echo "<td>" . $row["id"] . "</td>";
    echo "<td>" . $row["title"] . "</td>";
    echo "<td><a href='" . $row["url"] . "'>" . $row["url"] . "</a></td>";
    echo "</tr>";
}
echo "</table>";
$conn>close();
?>

这个示例中，我们首先连接到数据库，然后根据用户提交的表单数据执行相应的操作（添加、编辑或删除网址），我们从数据库中获取所有网址并显示在一个表格中。