如果在php中可用或不可用，我如何設定條件來檢查約會？

我想創建一個條件來確定特定醫生是否可以預約。如果不可用，則執行條件（回傳真）；
這是我的代碼，我試圖提出條件，但沒有奏效。

     if($_POST){  
   $patient_obj->docId =$_POST['selectDr'];
   $patient_obj->appStart =$_POST['appStart'];
   $patient_obj->appEnd =$_POST['appEnd'];
   $patient_obj->patientId =$_POST['patientId'];

   $startDateInput= $patient_obj->appStart;
   $startDateInput=strtotime($startDateInput);
   $startDateInput= date('Y-m-d H:i:s', $startDateInput);

   $endDateInput= $patient_obj->appEnd;
   $endDateInput=strtotime($endDateInput);
   $endDateInput= date('Y-m-d H:i:s', $endDateInput);
   

   $sql = "SELECT AppStart,AppEnd,docID FROM appointments WHERE docID=?";
   $stmt = $conn->prepare($sql);
   $stmt->bindParam(1,$patient_obj->docid);
   $stmt->execute();
   $data=$stmt->fetch();
    extract($data);
    $startDateInDb=$AppStart;
    $startDateInDb=strtotime($startDateInDb);
    $startDateInDb= date('Y-m-d H:i:s', $startDateInDb);
    $endDateInDb=$AppEnd;
    $endDateInDb=strtotime($endDateInDb);
    $endDateInDb= date('Y-m-d H:i:s', $endDateInDb);
  if(($startDateInput>=$startDateInDb && $startDateInput <=$endDateInDb) || ($endDateInput >=$startDateInDb && $endDateInput <= $endDateInDb) || ($startDateInput <= $startDateInDb && $endDateInput >=$endDateInDb)) {
       echo'
       <script>
       alert("change the appointment")
       </script>';
  } 
  else{
   $patient_obj->addAppointment();
}

uj5u.com熱心網友回復：

注意：fetch() 只回傳您查詢的第一條記錄（WHERE docID=?）。因此請在您的查詢中添加條件以確定資料庫中是否存在與新提交的約會資料重疊的任何記錄。

因此，請更改塊：

$sql = "SELECT AppStart,AppEnd,docID FROM appointments WHERE docID=?";
   $stmt = $conn->prepare($sql);
   $stmt->bindParam(1,$patient_obj->docid);
   $stmt->execute();
   $data=$stmt->fetch();
    extract($data);
    $dateStart=$AppStart;
    $dateStart=strtotime($dateStart);
    $dateStart= date('Y-m-d H:i:s', $dateStart);
    $dateEnd=$AppEnd;
    $dateEnd=strtotime($dateEnd);
    $dateEnd= date('Y-m-d H:i:s', $dateEnd);
   
   if (($startDateInput>=$dateStart && $startDateInput<=$dateEnd) && ($endtDateInput>=$dateEnd && $endtDateInput>=$dateStart)) {
      echo'<script> alert("the appointment is already taken");</script>';
    exit();
   }
   else{
     $patient_obj->addAppointment();
  }

到

   $sql = "SELECT COUNT(*) as total_rows FROM appointments WHERE docID=? and ((AppStart >= ? && AppStart <=?) || (AppEnd >= ? && AppEnd <=?) || (AppStart <= ? && AppEnd >=?))";

   $stmt = $conn->prepare($sql);
   $stmt->bindParam(1,$patient_obj->docid);
   $stmt->bindParam(2,$startDateInput);
   $stmt->bindParam(3,$endDateInput);
   $stmt->bindParam(4,$startDateInput);
   $stmt->bindParam(5,$endDateInput);
   $stmt->bindParam(6,$startDateInput);
   $stmt->bindParam(7,$endDateInput);

   $stmt->execute();

   $row = $stmt->fetch(PDO::FETCH_ASSOC);
   $total_rows = $row['total_rows'];

   if ($total_rows!=0) {
      echo'<script> alert("the appointment is already taken");</script>';
      exit();
   }
   else{
      $patient_obj->addAppointment();
  }

為了進一步演示，我做了一個測驗鏈接，代碼如下：

<?php
ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

if ($_POST) {
$servername="localhost";
$db="xxxxxx";
$username="xxxxxx";
$password="xxxxx";

try {
  $conn = new PDO("mysql:host=$servername;dbname=$db", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//  echo "Connected successfully";
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}

$docid=$_POST["docid"];
$startDateInput=$_POST["startDateInput"];
$endDateInput=$_POST["endDateInput"];



$sql = "SELECT COUNT(*) as total_rows FROM appointments WHERE docID=? and ((AppStart >= ? && AppStart <=?) || (AppEnd >= ? && AppEnd <=?) || (AppStart <= ? && AppEnd >=?))";

   $stmt = $conn->prepare($sql);
/*
   $stmt->bindParam(1,$patient_obj->docid);
   $stmt->bindParam(2,$startDateInput);
   $stmt->bindParam(3,$endtDateInput);
   $stmt->bindParam(4,$startDateInput);
   $stmt->bindParam(5,$endtDateInput);
   $stmt->bindParam(6,$startDateInput);
   $stmt->bindParam(7,$endtDateInput);
*/


   $stmt->bindParam(1,$docid);
   $stmt->bindParam(2,$startDateInput);
   $stmt->bindParam(3,$endDateInput);
   $stmt->bindParam(4,$startDateInput);
   $stmt->bindParam(5,$endDateInput);
   $stmt->bindParam(6,$startDateInput);
   $stmt->bindParam(7,$endtDateInput);



   $stmt->execute();

   $row = $stmt->fetch(PDO::FETCH_ASSOC);
   $total_rows = $row['total_rows'];

   if ($total_rows!=0) {
//      echo'<script> alert("the appointment is already taken");</script>';
//      exit();
 echo "<font color=red>Already taken</font>";
   }
   else{
    //  $patient_obj->addAppointment();
echo "<font color=blue>Allow insertion</font>";
  }
}

  ?>

Current Data in db: <br>
Doctor1 From:  <font color=red>2021-11-28 12:05:12</font> to  <font color=red>2021-11-30 12:00:00</font><br>
Doctor1 From: <font color=red>2021-11-01 00:00:00</font> to  <font color=red>2021-11-02 00:00:00</font><br>

<br><br>

<form method=POST>
<input name=docid value="Doctor1"><br>
<input name=startDateInput value=""> (e.g. 2021-11-28 1:0:0)<br>
<input name=endDateInput value=""> (e.g. 2021-11-30 12:0:0)<br>
<input type=submit>
</form>

上面的代碼可以在http://www.createchhk.com/SO/testSO28Nov2021a.php看到 LIVE

標籤：php

上一篇：Laravel檢查點擊了哪個按鈕

下一篇：如何從JSON回應中查詢特定欄位？