當我將文件路徑保存在數據庫中時，我會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
2 回答
縹緲止盈
TA貢獻2041條經驗 獲得超4個贊
轉義反斜杠（使用\\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();
慕哥9229398
TA貢獻1877條經驗 獲得超6個贊
在插入發生之前將數據變量聲明為字符串，然后使用準備好的語句來創建記錄。*用于文件導航的正斜杠。
<?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);
?>
- 2 回答
- 0 關注
- 252 瀏覽
添加回答
舉報
0/150
提交
取消