<?php include "connect.php"; $date = date("Y/n/d"); if(isset($_POST["send"])) { $fname = $_POST['fname']; $lname = $_POST["lname"]; $start_date =$date; $end_date = $_POST["end_date"]; $sql = "INSERT INTO `tbl_user`(`fname`, `lname`, `start_date`, `end_date`)VALUES (:fname , :lname , :start_date , :end_date) "; $result = $connect->prepare($sql); $result->bindParam(":fname",$fname); $result->bindParam(":lname",$lname); $result->bindParam(":start_date",$start_date); $result->bindParam(":end_date",$end_date); $result->execute(); if($result) echo "OK"; else echo "NO"; } ?><!DOCTYPE html><html><head><meta charset="utf-8" /><title>NAHID...</title></head><body> <form action="" method="post"> <table> <tr> <td>fname:</td> <td><input type="text" name="fname" /></td> </tr> <tr> <td>lname:</td> <td><input type="text" name="lname" /></td> </tr> <tr> <td>EndDate:</td> <td><input type="text" name="end_date" /></td> </tr> <tr> <td> </td> <td><input type="submit" name="send" value="ارسال" /></td> </tr> </table> </form> <hr /> <?php $s = "SELECT * FROM `tbl_user`"; $res = $connect->query($s); WHILE($row = $res->fetch(PDO::FETCH_ASSOC)) { $startdate = $row["start_date"]; $enddate = $row["end_date"]; $ndate = date("Y/n/d"); ?> <table> <tr> <td>fname:</td> <td> <?php if($ndate<=$enddate && $ndate>=$startdate) { echo$row["fname"]; } /*else { echo "کاربر منقضی شده است"; }*/ ?> </td> </tr> <tr> <td>lname:</td> <td> <?php if($ndate<=$enddate && $ndate>=$startdate) { echo$row["lname"]; } /*else { echo "کاربر منقضی شده است"; }*/ ?> </tr> </table><?php } ?></body></html>
