PHP - Auto Calculate The Difference

I have date stored in database in any of the given forms 2020-06-01, 2020-05-01 or 2019-04-01

I want to compare the old date with current date 2020-06-14

And the result should be in days.

Any help please?

PS: I want to do it on php side. but if its possible to do on database side (I am using myslq) please share both ways🙂

//php code
<?php
include_once('con.php');
if(!empty($_GET['search'])) {
$search = $connect->prepare('SELECT * FROM posts WHERE title LIKE :search');
$search->bindValue(':search', '%'.$_GET['search'].'%', PDO::PARAM_STR);
$search->execute();
?>
<?php
while($row = $search->fetch()) {?>
<li class="result" onClick="searchValue('<?php echo $row['title'];?>')"><?php echo $row['title'];?></li>    
<?php } ?>
<?php } ?>

//ajax

$('#inputsch').keyup(function(){
	$.ajax({
	type: 'GET',
	url: 'fetch.php',
	data:'search='+$(this).val(),
	success: function(data){
		$('#box').show();
		$('#box').html(data);
	}
	});
}); 
});
function searchValue(val) {
$('#inputsch').val(val);
$('#box').hide();
}


//search box

 <form action="search.php">
 <input id="inputsch" type="text" name="search" placeholder="search..." autocomplete="off" autofocus>
 <button type="submit" value="search" >search</button> 
 </form>
 <div id="box"></div>


//the problem here is when i click the result is only added to input, but i want it to autosubmit

is it possible to calculate sum of the element in the array_pop . i have to get sum of 3 maximum subject with grade from student .

 else if (($sub == 'BI') || ($sub == 'TSI') || ($sub == 'PAP') || ($sub == 'PAK'))  { 

                      
                      
if ($res == 0) {
                        $merit = 18;
                      }
                      if ($res == 1) {
                        $merit = 16;
                      }
                      if ($res == 2) {
                        $merit = 14;
                      }
                      if ($res == 3) {
                        $merit = 12;
                      }
                      if ($res == 4) {
                        $merit = 10;
                      }
                      if ($res == 5) {
                        $merit = 8;
                      }
                      if ($res == 6) {
                        $merit = 6;
                      }
                      if ($res == 7) {
                        $merit = 4;
                      }
                      if ($res == 8) {
                        $merit = 2;
                      }
                      if ($res == 9) {
                        $merit = 0;
                      }


                 

                      $main_add_merit1 = $merit;
                    
                          $main_add_merit1;

                          $y[$i] = $main_add_merit1;
                       //echo '<br>';
                       rsort($y);


  $first = array_pop($y);
  

                    }