如何将SQL查询与PHP脚本相结合

Question

I have this query to count the number of forms that are submitted by a certain user

$sql="SELECT `ID` FROM `kform` WHERE `ID`='$ID'";                               
$result = $conn->query($sql);
$k=0;
if ($result->num_rows > 0) {
   while($row = $result->fetch_assoc()) {                                                                                                 
      $k++;
   }
}

plus I have this php script that is basically check a certain date (which is included in each form) and prints valid if it is within this fiscal year

$endYear = 2017;
while($endYear <= 2025) {
    $end = $endYear.'/06/30';
    $endDate = DateTime::createFromFormat('Y/m/d', $end);
    $initDate = DateTime::createFromFormat('Y/m/d', $end);
    $initDate = $initDate->sub(new DateInterval('P1Y')) -> add(new DateInterval('P1D'));
    $ddb =  $row2['Date'];
    $dateFromDB = DateTime::createFromFormat('Y-m-d', $ddb);
    if ($dateFromDB >= $initDate && $dateFromDB <= $endDate) { 
        echo "valid
";
        echo "\tStartDate->\"".$initDate->format("Y-m-d")."\"
";
        echo "\tEndDate->\"".$endDate->format("Y-m-d")."\"
";
        echo "\tDateFromDatabase->\"".$dateFromDB->format("Y-m-d")."\"
";
    }

    $endYear++;
}

Now what I was trying to do is to combine these two functions together, the idea behind that is to count only the forms that are in this fiscal year, any older forms should not be counted. I tried different ways to combine them but it gave me different errors every time, So is it even possible to do so?

Answer 1

Go on from that:

 function isValidYear($dategiven){
   $endYear=2017;
   while($endYear<=2025) {
     $end = $endYear.'/06/30';
     $endDate = DateTime::createFromFormat('Y/m/d', $end);
     $initDate = DateTime::createFromFormat('Y/m/d', $end);
     $initDate = $initDate->sub(new DateInterval('P1Y'))->add(new DateInterval('P1D'));
     $ddb =  $dategiven;
     $dateFromDB = DateTime::createFromFormat('Y-m-d', $ddb);
     if ($dateFromDB>=$initDate && $dateFromDB<=$endDate) { 
       return true;
     }
     $endYear++;
    }
    return false;
 }

And

$sql="SELECT `ID` FROM `kform` WHERE `ID`='$ID'";                               
$result = $conn->query($sql);
$k=0;
if ($result->num_rows > 0) {
 while($row = $result->fetch_assoc()) {
   if(isValidYear($row['datefield'])){
      $k++;
   }
}

Note: Your $sql selects only the ID field. You have to at Date

$sql="SELECT * FROM `kform` WHERE `ID`='$ID'";