01.<?php
02.require('connect.php');
03.
04.if(isset($_POST["name"]) && isset($_POST["shortname"]) && isset($_POST["date"])){
05.
06. $time = new DateTime($_POST['date']);
07. $lastyear = $time->modify('-1 year')->format('Y-m-d');
08.
09. $sql_date = "SELECT * FROM project WHERE shortname='" . $_POST['shortname'] . "'";
10. $sql_date .= " AND (`date` BETWEEN '" . $_POST['date'] . "' AND '" . $lastyear . "')";
11. $result_date=mysqli_query($con,$sql_date);
12. $rows_date =mysqli_num_rows($result_date);
13. $i=0;
14.
15. if($rows_date>$i){
16. echo "<script>";
17. echo "alert(' ชื่อย่อโครงการ/เกียรติบัตรซ้ำในรอบ 1 ปี กรุณาเพิ่มใหม่อีกครั้ง !');";
18. echo "window.history.back();";
19. echo "</script>";
20. }
21.
22. else{
23. $name = mysqli_real_escape_string($con,$_POST["name"]);
24. $shortname = mysqli_real_escape_string($con,$_POST["shortname"]);
25. $date = mysqli_real_escape_string($con,$_POST["date"]);
26.
27. $sql = "UPDATE project SET name = '$name', shortname = '$shortname', date = '$date' WHERE id = ".$_POST["id"];
28.
29. mysqli_query($con,$sql);
30. mysqli_close($con);
31. }
32.}
33.
34.else{
35. echo 'error';
36.}
37.
38.?>
