如何在 MySQL 中保存文件路径

Question

当我将文件路径保存在数据库中时，我会

INSERT INTO `cars`(`carID`, `carType`, `carModel`, `carYear`, `carBrand`, `carImage`, `carPrice`) VALUES (1, 'electric', 'LEAF', '2019', 'Nissan', '\img\Hybrids\Leaf\White\Side.jpg', '29,990')

然后，当我从数据库中检索数据时，它返回文件路径为 imgHybridsLeafWhiteSide.jpg 如何修复文件路径以返回 \img\Hybrids\Leaf\White\Side.jpg

Answer 1

转义反斜杠（使用\\or /）：INSERT INTO `cars`(`carID`, `carType`, `carModel`, `carYear`, `carBrand`, `carImage`, `carPrice`) VALUES (1, 'electric', 'LEAF', '2019', 'Nissan', '\\img\\Hybrids\\Leaf\\White\\Side.jpg', '29,990')您可以使用 PDO 将值安全地插入数据库。$db   = new PDO( $dsn, $username, $password );$carImage = "\img\Hybrids\Leaf\White\Side.jpg";$sql  = $db->prepare("INSERT INTO cars (carImage) VALUES(:carImage)");$sql->bindParam(:carImage, $carImage, PDO::PARAM_STR);$sql->execute();

Answer 2

在插入发生之前将数据变量声明为字符串，然后使用准备好的语句来创建记录。*用于文件导航的正斜杠。<?php// Data variables$carID = "1";$carType = "electric";$carModel = "LEAF";$carYear = "2019"; // this column should be set to int as the year is a whole number$carBrand = "Nissan";$carImage = "/img/Hybrids/Leaf/White/Side.jpg"; // This column should be set to text so the slashes can be stored$carPrice = "29990"; // This column should be set to float(7,2) which allows a max of 9999999.99//Insert$insert = mysqli_prepare($con, "insert into cars (carID,carType,carModel,carYear,carBrand,carImage,carPrice) values (?,?,?,?,?,?,?)");mysqli_stmt_bind_param($insert, "sssssss", $carID,$carType,$carModel,$carYear,$carBrand,$carImage,$carPrice);mysqli_stmt_execute($insert);?>