这是我的postaddata.php代码：
require('includes/database.php');
$db = new Database();
if(isset($_POST['btnPostad']))
{
$allowedextensions = array("jpg", "jpeg", "gif", "png");
$extensions = end(explode ("." , $_FILES['file']['name']));
if((($_FILES['file']['type'] == 'image/gif')
|| ($_FILES["file"]['type'] == 'image/jpg')
|| ($_FILES["file"]['type'] == 'image/png')
|| ($_FILES["file"]['type'] == 'image/jpeg'))
&& ($_FILES["file"]['size'] > 20000)
&& (in_array($extensions, $allowedextensions)))
{
if($_FILES['file']['error']> 0)
{
$msg = "Error: " . $_FILES['file']['error'] . "<br>";
header('Location:postad.php?msg='.$msg);
}
else
{
$msg2 = "Upload " . $_FILES['file']['name'] . "<br>";
$msg2 .= "Type " . $_FILES['file']['type'] . "<br>";
$msg2 .= "Size " . ($_FILES['file']['size'] / 1024 ). "KB" . "<br>";
$msg2 .= "Stored In " . $_FILES['file']['tmp_name'] . "<br>";
if (file_exists("uploads/". $_FILES['file']['name']))
{
$msg = $_FILES['file']['name']. "already exists";
header('Location:postad.php?msg='.$msg);
}
else
{
move_uploaded_file($_FILES['file']['tmp_name'], "uploads/" . $_FILES['file']['name']);
//$msg1 = "Stored in uploads/: " . $_FILES['file']['name'];
}
}
}
else
{
$msg = '<b> <font face="Verdana, Geneva, sans-serif" color="red">File type is not Supported, Please try uploading recommended formats (JPG, JPEG, GIF, PNG)</font></b>';
header('Location:postad.php?msg='.$msg);
}
//header('Location:postad.php?msg='.$msg1);
$pic = ($_FILES['file']['name']);
$data = array
(
'Ad_Status' => $_POST['adstatus'],
'Model_Year' => $_POST['model_year'],
'Car_Make' => $_POST['car_make'],
'Car_Model' => $_POST['car_model'],
'City' => $_POST['city'],
'Price' => $_POST['price'],
'Mileage' => $_POST['mileage'],
'Mileage_Unit' => $_POST['mileage_unit'],
'Transmission' => $_POST['transmission'],
'Engine_Type' => $_POST['engine_type'],
'Engine_Capacity' => $_POST['engine_capacity'],
'Exterior_Color' => $_POST['exterior_color'],
'Air_Bags' => $_POST['air_bags'],
'Air_Conditioner' => $_POST['air_conditioner'],
'Power_Steering' => $_POST['power_steering'],
'Power_Locks' => $_POST['power_locks'],
'Power_Mirror' => $_POST['power_mirror'],
'Keyless_Entry' => $_POST['keyless_entry'],
'Cruise_Control' => $_POST['cruise_control'],
'Navigation_System' => $_POST['navigation_system'],
'FM_Radio' => $_POST['fm_radio'],
'Cassette_Player' => $_POST['cassette_player'],
'CD_Player' => $_POST['cd_player'],
'Sun_Roof' => $_POST['sun_roof'],
'Alloy_Rims' => $_POST['alloy_rims'],
'HID' => $_POST['hid'],
'Comments' => $_POST['comments'],
'Car_Image' => $pic,
'Display_Name' => $_POST['display_name'],
'Email' => $_POST['email'],
'Mobile_Number' => $_POST['mobile_number'],
'Secondary_Number' => $_POST['secondary_number'],
'Featured' => $_POST['featured']
);
$result_insert_data = $db->insert('car_information',$data);
$msg = '<b> <font face="Verdana, Geneva, sans-serif" color="green">Your Ad has been posted and will be reviewed and displayed within 24hrs</font></b>';
header('Location:Index.php?msg='.$msg);
}
else
{
$msg = '<b> <font face="Verdana, Geneva, sans-serif" color="red">Your Ad has not been posted! Please, try again later</font></b>';
header('Location:postad.php?msg='.$msg);
}
当使用PHP在mysql数据库中插入记录时，文件（已存在/类型）的验证不起作用。正如您所看到的，在将数据发布到数据库之前，文件函数/验证就已经存在。我想限制重复图像插入/文件类型限制等。虽然我已经写了代码，但我认为我的if/else也有一些问题。你能帮忙吗？
看看file_exists()的文档，看看它可能失败的一些原因。
file_exists不适用于指向不存在文件的符号链接。这可能不是你的问题- 对于由于安全模式限制而无法访问的文件，将返回
FALSE。可能也不是这样 - 但接下来，请阅读底部的注释：
file_exists的结果被缓存这可能会导致意外行为
您需要尝试clearstatcache()函数。从文件来看：
您还应该注意，PHP不会缓存关于不存在的文件的信息。因此，如果对不存在的文件调用
file_exists()，则在创建该文件之前，它将返回FALSE。如果您创建了文件，即使您删除了文件，它也会返回TRUE。
您可以尝试在if语句之前调用以下函数：
clearstatcache(true, "uploads/". $_FILES['file']['name']);
if(file_exists("uploads/". $_FILES['file']['name']))
{
// And so on...