怎样把路径存入mysql数据库

CREATE TABLE paths (
  id INT PRIMARY KEY AUTO_INCREMENT,
  path VARCHAR(255)
);

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
  die("连接失败: " . $conn->connect_error);
}

// 在此处执行插入路径的代码

// 关闭连接
$conn->close();
?>

// 待插入的路径
$path = "/path/to/file";

// 构建插入路径的SQL语句
$sql = "INSERT INTO paths (path) VALUES ('$path')";

// 执行插入操作
if ($conn->query($sql) === TRUE) {
  echo "路径插入成功";
} else {
  echo "插入失败: " . $conn->error;
}

// 构建查询路径的SQL语句
$sql = "SELECT * FROM paths";

// 执行查询操作
$result = $conn->query($sql);

// 处理查询结果
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    echo "ID: " . $row["id"]. " - 路径: " . $row["path"]. "<br>";
  }
} else {
  echo "没有找到路径";
}