php - 目录中记录的文件名与数据库不同

Question

我有以下脚本为我的文件名生成一个随机时间戳。

 $newfilename = round(microtime(true)) . ".jpg";

但是上传到我的mySQL数据库的文件名和我目录下记录的文件名不一样，导致图片无法显示。

比如有一次，数据库中的图片记录为1441743610.jpg，而目录中的图片为1441743609.jpg。

这是我的代码:

session_start();

$username = $_SESSION['username'];

$file_dir = "userpictures/$username" ;

mkdir($file_dir, 0777, true);

// $_FILES["file"]["name'] is the file that is uploaded by her

$filePath = $_FILES["file"]["name"];
$image = imagecreatefrompng($filePath);
$bg = imagecreatetruecolor(imagesx($image), imagesy($image));
imagefill($bg, 0, 0, imagecolorallocate($bg, 255, 255, 255));
imagealphablending($bg, TRUE);
imagecopy($bg, $image, 0, 0, 0, 0, imagesx($image), imagesy($image));
imagedestroy($image);
$quality = 100; // 0 = worst / smaller file, 100 = better / bigger file 
imagejpeg($bg, $filePath . ".jpg", $quality);
imagedestroy($bg);

// this chunk here converts the file to jpg


$newfilename = round(microtime(true)) . ".jpg";
// round(microtime) generates a randomized number.


// check format of image before uploading
$imageFileType = pathinfo($newfilename,PATHINFO_EXTENSION);

if ($imageFileType != "jpg" && $imageFileType != "png" &&   $imageFileType != "jpeg"
&& $imageFileType != "gif" ) 

{
echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}

else

{
$uploadOk = 1;
}


// if any errors have occured (determined by $uploadOk), the critical "move_uploaded_files" php function is not activated

if ($uploadOk == 1) 

{
$filename = $newfilename;
move_uploaded_file($_FILES["file"]["tmp_name"], "user_pictures/$username/" . $filename);
}

希望就发生这种情况的原因提供建议。请注意，此行为并不一致，而且它大部分时间都有效。，但这对我来说是 Not Acceptable 。

编辑:

这是我将 $filename 上传到数据库(以及其他数据)的代码

$con = mysqli_connect("FARM.mysql.anyhost.com", "user", "password");
  if (!$con) {
  die("Something went wrong. Don't worry, just refresh the page"); }

mysqli_select_db($con, "FARM");
  if (mysqli_select_db($con, "FARM") == false) {
  die("Something went wrong. Don't worry, just refresh the page"); }

$username = $_SESSION['username'];
$post = mysqli_real_escape_string($con, $_POST['postdescription']);
$timestamp = date("jS \of F Y h:i:s A P");


$user_uploadposts = "INSERT INTO $username (PostingTime, Image, Description)  VALUES ('$timestamp','$filename', '$post')";


mysqli_query($con, $user_uploadposts);
mysqli_close($con);

Answer 1

我不知道在数据库中保存文件路径时你的查询是怎样的，但根据你在这里解释的行为:

Note that this behaviour is not consistent and it works most of the time., but thats not acceptable to me.

问题是您在保存到数据库时没有使用 $newfilename，而是使用 $newfilename = round(microtime(true)) 再次“重新创建”文件名。 ".jpg";

这导致同时 microtime 递增并且名称不再相等。它有时起作用的原因是脚本有时运行得更快。为避免这种情况，您只需使用 $newfilename 而不是再次创建变量。

嗯