我正在嘗試將圖片與路徑文件一起保存到我的數據庫中。但它現在的做法是不正確的。它僅將圖像保存到數據庫中，而不是整個圖像路徑。怎么了？我在另一個項目中使用此代碼做了完全相同的事情，但無法解決這里的問題。$userPic = '';$date_time = date('Y-m-d_H-i-s');if(!empty($userLoggedIn)) { if (isset($_FILES['fileToUpload'])) { $errors = array(); $file_name = $_FILES['fileToUpload']['name']; $file_size = $_FILES['fileToUpload']['size']; $width = 1500; $height = 1500; $file_tmp = $_FILES['fileToUpload']['tmp_name']; $file_type = $_FILES['fileToUpload']['type']; $tmp = explode('.', $_FILES['fileToUpload']['name']); $file_ext = strtolower (end ($tmp)); $extensions = array("jpeg", "jpg", "png", "gif"); if(in_array($file_ext, $extensions) === false) { $errors[] = "extension not allowed. Please choose a JPEG or PNG file."; } if ($file_size > 8097152) { $errors[] = 'File size must be 2 MB'; } if ($width > 1500 || $height > 1500) { echo"File is to large"; } if(!$errors) { $userPic = md5($_FILES["fileToUpload"]["name"]) . $date_time . " " . $file_name; move_uploaded_file($file_tmp, "assets/images/profile_pics/" . $userPic); $stmt = $con->prepare("UPDATE users SET profile_pic = ? WHERE username = ?"); $stmt->bind_param('ss', $userPic, $username); $stmt->execute(); $stmt->close(); } }}else { echo "Invalid Username";}
2 回答
撒科打諢
TA貢獻1934條經驗 獲得超2個贊
您可以分配另一個包含所使用圖像的路徑和變量的變量，然后在查詢中使用該變量：
$file_path = "assets/images/profile_pics/".$userPic;
catspeake
TA貢獻1111條經驗 獲得超0個贊
你的代碼：
if(!$errors) {
$userPic = md5($_FILES["fileToUpload"]["name"]) . $date_time . " " . $file_name;
move_uploaded_file($file_tmp,"assets/images/profile_pics/" . $userPic);
$imag_path = "assets/images/profile_pics/" . $userPic;
$stmt = $con->prepare("UPDATE users SET profile_pic = ? WHERE username = ?");
$stmt->bind_param('ss', $imag_path, $username);
$stmt->execute();
$stmt->close();
}
嘗試這個：
您僅保存新圖像名稱，而不保存路徑。
- 2 回答
- 0 關注
- 142 瀏覽
添加回答
舉報
0/150
提交
取消