php - 如何使用 PHP/MySQL 限制用户在一个月内仅上传三张图片
问题描述
我正在研究 PHP。我的问题是如何限制用户在一个月内只能上传三张图片。
我的Mysql数据库表——
CREATE TABLE `images` (
`id` int(40) NOT NULL,
`user_name` varchar(40) NOT NULL,
`mobile` varchar(30) NOT NULL,
`email` varchar(50) NOT NULL,
`name` longblob NOT NULL,
`position` int(40) NOT NULL,
`date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
我希望用户在一个月内只能上传三张图片。
请帮助我使用 PHP 脚本。我是 PHP 的初学者。分享最佳解决方案..
我用这个——
<?php
include("admin/config.php");
if(isset($_POST["insert"]))
{
$mobile = $_POST['mobile'];
$email = $_POST['email'];
$user_name = $_POST['user_name'];
$fileinfo = @getimagesize($_FILES["image"]["tmp_name"]);
$width = $fileinfo[0];
$height = $fileinfo[1];
$allowed_image_extension = array(
"png",
"jpg",
"jpeg"
);
$file_extension = pathinfo($_FILES["image"]["name"], PATHINFO_EXTENSION);
$sql="select * from images where (name='$name');";
$count=mysqli_query($mysqli,$sql);
$count=count($_FILES['name']);
if($count>3)
{
echo "<font color='red'>3 image upload </font>";
} else{
$file_extension = pathinfo($_FILES["image"]["name"], PATHINFO_EXTENSION);
if (! file_exists($_FILES["image"]["tmp_name"])) {
$response = array(
"type" => "error",
"message" => "Choose image file to upload."
);
}
else if (! in_array($file_extension, $allowed_image_extension)) {
$response = array(
"type" => "error",
"message" => "<font color='red'>Upload valiid images. Only PNG and JPEG are allowed.</font>"
);
echo $result;
} // Validate image file size
else if (($_FILES["image"]["size"] > 2000000)) {
$response = array(
"type" => "error",
"message" => "Image size exceeds 2MB"
);
} // Validate image file dimension
else if ($width > "1250" || $height > "720") {
$response = array(
"type" => "error",
"message" => "<font color='red'>Image dimension should be within 1250X720</font>"
);
} else {
$target = '/image';
$target = "image/" . basename($_FILES["image"]["name"]);
$file = addslashes(file_get_contents($_FILES["image"]["tmp_name"]));
$query = mysqli_query($mysqli,"INSERT INTO images VALUES ('','$user_name','$mobile','$email','$file','',NOW())");
if (move_uploaded_file($_FILES["image"]["tmp_name"], $target)) {
$response = array(
"type" => "success",
"message" => '<font color="green">Image uploaded successfully </font>'
);
} else {
$response = array(
"type" => "error",
"message" => "<font color='red'>Problem in uploading image files.</font>"
);
}
}
// if(mysqli_query($connect, $query))
// {
// echo '<script>alert("Image Inserted into Database")</script>';
// }
}
}
?>
还有我的 HTML 表单 -
<form method="post" id="frm-image-upload" action="my-account.php#parentHorizontalTab3" name='img'
method="post" enctype="multipart/form-data">
<div class="agileits_w3layouts_contact_left"style="margin-left:20%;">
<input type="hidden" name="user_name" value="<?php $space = " ";
echo $row["fname"].$space.$row["lname"]; ?>" id="user_name" Placeholder="Your Name" required />
<input type="hidden" name="mobile" value="<?php echo $row["mobile"]; ?>" id="mobile"Placeholder="Mobile" required />
<input type="hidden" name="email" value="<?php echo $row["email"]; ?>" id="email" Placeholder="Email" required/>
</div>
<center>
<input type="file" name="image" id="image" />
</center>
<br />
<center><input type="submit" name="insert" id="insert" value="Upload" class="btn btn-info" /> </center>
</form>
请帮我分享最佳解决方案 - 用户可以在一个月内上传三张图片。
解决方案
基本思想是计算给定用户在给定月份上传的所有图像,例如:
SELECT COUNT(*) FROM `images` WHERE `user_name` = ? GROUP BY MONTH(`date`);
如果上面的查询返回3
,您可以阻止上传。
推荐阅读
- android - Android Accessibility 服务同时与多个开关交互
- azure - 如何自动将数据从 CSV 文件加载到 Azure SQL
- javascript - 在本地使用 bootstrapValidator 发送静态数据
- javascript - 在 html 页面中自定义计数器
- flutter - 如何更改 CupertinoAlertDialog 的背景颜色?
- python-3.x - 如何指定叶热图中的颜色?
- javascript - 新手如何使用 d3.csv?它不起作用,我做错了什么?
- java - Java 中的 XSLT 转换能否在无效标签上输出警告
- python - 在数据框中插入缺失的行(可变索引范围)
- kubernetes - Kubernetes 上的 WSO2 APIM 模式 2 部署