PHP - Use A Loop And Compare With Database For Unique Name

Hi All,

I'm hoping someone can help as I've got myself in a muddle on some code.

Basically, the form has a date field (date moved in).

If the date entered is over 3 years old, all's ok

However, if the date entered is less than 3 years old, the user needs to complete a list field. The list field is essentially a repeater field with a date and address field.

If the user adds a date and address and this (plus the original date) is more than 3 years combined history - happy days!

If the user adds a date and address and they've still not hit 3 years history, then I need to increase the number of rows (this is handled by another function which works by incrementing a field on the form.

As it stands, it works until I need another field to appear i.e. they've entered the first date, then entered a date within the list/repeater field but still not got 3 years worth.

I think it's more or less there but seem to have muddled some of the logic (I think/hope!). A fresh pair of eyes would be great:

Here's my code:

function dateDiffInDays($date1, $date2) { 
    # Calulating the difference in timestamps 
    $diff = strtotime($date2) - strtotime($date1); 
      
    # 1 day = 24 hours 
    # 24 * 60 * 60 = 86400 seconds 
    return abs(round($diff / 86400)); 
} 

add_filter( 'gform_pre_render_2', 'applicant_2_previous_address_history' );
add_filter( 'gform_pre_validation_2', 'applicant_2_previous_address_history' );
function applicant_2_previous_address_history( $form ) {

	#get the value from the form date input d/m/Y so need to change
	$get_moved_in_date = rgpost( 'input_1' );
	if ( $get_moved_in_date ) {
		#convert the date format
		$moved_in_date = date_format(date_create_from_format('d/m/Y', $get_moved_in_date), 'd-m-Y'); 	
		#echo "New date format is: ".$moved_in_date. "<br/>"; 
	}
	
	#get todays date
	$today = date("d-m-Y");
	#echo "<h3>Today: ".$today."</h3>";
	
	#calculate the difference in days
	$dateDiff = dateDiffInDays($today, $moved_in_date); 	
	#printf("<p>Difference between two dates: " . $dateDiff . " Days</p>"); 	

	#check if we moved in less than 3 years ago
	if ( $dateDiff < 1095 ) {
		
		#less than 3 years, so need to loop through the list fields, compare dates and tally totals days
		if ( $days_sum < 1095 ) {
			
			# get the input from the list
			$list_values = rgpost( 'input_2' );
			$i = 0; #use this to get even rows only due to the way data is stored :(
			$sum = 0; #use this to increment the no. of rows in the list
			$previous = null; #use this to calc date difference between rows
			$days_sum = $dateDiff; #set the total number of days. Don't start at 0, start from current date - time at current residence
			if ( $list_values ) {
				foreach ( $list_values as $key => $value ){
					#get even rows only
					if($i%2 == 0){
						
						#$sum = $sum + 1; #increment our rows
						
						if ( $value ) {
							#convert the date format
							$additional_date = date_format(date_create_from_format('d/m/Y', $value), 'd-m-Y');
							#echo "<h3>Date: ".$additional_date."</h3>";
						}			
								
						if ( $previous !== null ){ # if it's null, we're in the first loop
						
							#convert the date format
							$previous_date = date_format(date_create_from_format('d/m/Y', $previous), 'd-m-Y');
							
							$dateDiff2 = dateDiffInDays($additional_date, $previous_date); 	
							printf("<p>Next Iteration Difference between " . $additional_date . " and " . $previous_date . " is: " . $dateDiff2 . " Days</p>"); 	
							
							$days_sum = $days_sum + $dateDiff2;
							
						} else {
							
							#convert the date format
							$dateDiff1 = dateDiffInDays($additional_date, $moved_in_date); 	
							printf("<p>1st Iteration Difference between " . $additional_date . " and " . $moved_in_date . " is: " . $dateDiff1 . " Days</p>"); 	
							
							$days_sum = $days_sum + $dateDiff1;
							
						}
						
						$previous = $value; # set the current value, so it will be saved for the next iteration
			
					}
					$i++;
				} #end foreach $list_values
			} #endif $list_values
			$sum = $sum + 1; #increment our rows
			echo "<p>Total no of days = " .$days_sum.'</p>';
			
		} #endif $days_sum < 1095	
	
		echo '<p>Not enough days so loop through list</p>';
		$flag = 'true';
		
	} else {
		
		echo '<p>Were ok!</p>';
		$flag = 'false';	
		
	} #endif $dateDiff < 1095



	/*
	if ( $dateDiff < 1095 ) {
		$value = 'yes';
	} else {
		$value = 'no';	
	}	
	*/

	#we moved in less than 3 years ago, so get history
	if ( $flag == 'false' ) {		
        return $form;
    } 

    foreach ( $form['fields'] as &$field ) {
        if ( $field->id == 2 ) {
            $field->isRequired = true;
        }
		echo "<p>The sum of array element is = " .$sum.'</p>';
		if ( $field->id == 3 ) {
			$_POST['input_3'] = $sum;
		}
		
    }

    return $form;
	
}

Thanks

  <?php  $testid=$_GET['testid'];
include_once("header.php");
?>
<html>
<head>
<body>
<?php
include_once('connect.php');
$sqltest="select testname from test where testid='$testid'";
$sqltestresult=mysql_query($sqltest) or die(mysql_error());
while($result=mysql_fetch_array($sqltestresult))
{
 $testname=$result['testname'];


}




?>
<!--pass test name and time left -->
<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td width="50%" valign="middle">
                           <h1 style="margin-left:0;"><?php 
  if(isset($testname))
  {
  
  echo $testname ;
  }
  ?></h1>
                         </td>
                         <td width="50%" align="right" valign="middle">
 <ul class="tabs" id="tabs">
                <li id="showtime" style="font-weight:bold; color:#FF0000; bottom:5px; font-size:16px; float:right"></li>
</ul>


                         </td>
                        </tr></table>
<div class="div-tabs-container" class="div-tabs-container" style="width:79%;margin-left:3%" > 
        <table cellpadding="0" cellspacing="0" border="0" id="questiontable" >
        <tr>
<?php
include_once('connect.php');
$sql="select * from testquestions where testid='$testid'";
$result=mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result)>0)
{
  $data = array(); // create a variable to hold the information
while (($row = mysql_fetch_array($result, MYSQL_ASSOC)) !== false)


{
$data[] = $row; // add the row in to the results (data) array
}
//shift off the first value
array_shift($data[0]);


$merge = call_user_func_array('array_merge', $data);


$size=sizeof($merge);
$newdata=array();
$num=1;
$correctanswerarray=array();
$selctedanswers=array();
/* echo "<form action='fetchquestion.php' method='post' id='formsubmit' onsubmit='return out()' name='test'>"; */


foreach ($merge as $key => $value ) 
{


$sql2="select qid, question,option1,option2,option3,option4,correct_answer from question where qid='$value'  ";


$result2=mysql_query($sql2) or die(mysql_error());




  while($row2=mysql_fetch_assoc($result2))
{
                  $questionid=$row2['qid'];
    $question=$row2['question'];
$option1=$row2['option1'];
$option2=$row2['option2'];
$option3=$row2['option3'];
$option4=$row2['option4'];
        $correctanswer=$row2['correct_answer'];
#array to store the correct answer.
$correctanswerarray[] = $questionid.$correctanswer; 
   #$newdata[]=$row2;






echo "


 <table class='bix-tbl-container' cellspacing='0' cellpadding='0' border='0' width='100%' id='questiontable'><tr>
                <td class='bix-td-qno jq-qno-2413'  rowspan='2' valign='top' align='left'>$num</td>
                <td class='bix-td-qtxt' valign='top'><p>$question</p></td>
            </tr>
            <tr>
                <td class='bix-td-miscell' valign='top'><table class='bix-tbl-options' id='tblOption_2413' border='0' cellpadding='0' cellspacing='0' width='100%'><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_A_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid' value='1'  id='disable'/>
</td><td class='bix-td-option' width='1%'>A.</td>
                         <td class='bix-td-option' width='48%' id='tdOptionDt_A_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option1</td>                                                         
        <td id='tdAnswerIMG_A_2413' class='jq-img-answer'  valign='middle'style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/accept.png' alt='' />  
        </td>                                                         
        </tr>                                                         
        </table></td></tr><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_B_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid'  value='2' id='disabble'/>
</td><td class='bix-td-option' width='1%'>B.</td>
                         <td class='bix-td-option' width='48%'id='tdOptionDt_B_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option2</td>                                                         
        <td id='tdAnswerIMG_B_2413' class='jq-img-answer'  valign='middle' style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/wrong.gif' alt=''/>  
        </td>                                                         
        </tr>                                                         
        </table></td></tr><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_C_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid'  value='3' id='disable'/>
</td><td class='bix-td-option' width='1%'>C.</td>
                         <td class='bix-td-option' width='48%' id='tdOptionDt_C_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option3</td>                                                         
        <td id='tdAnswerIMG_C_2413' class='jq-img-answer'  valign='middle' style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/wrong.gif' alt='' />  
        </td>                                                         
        </tr>                                                         
        </table></td></tr><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_D_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid' value='4' id='disable'/>
</td><td class='bix-td-option' width='1%'>D.</td>
                         <td class='bix-td-option' width='48%' id='tdOptionDt_D_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option4</td>                                                         
        <td id='tdAnswerIMG_D_2413' class='jq-img-answer'  valign='middle' style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/wrong.gif' alt='' />  
        </td>                                                         
        </tr>                                                         
        </table></td></tr></table>
 \n 


<input type='hidden' name='count' value='$num' id='count'>
<input type='hidden' name='queId[]' value='$questionid' id='queId'> 
                  
    
    


                </td>
            </tr>
            </table>
";










$num++;


}


} 
  
 echo " 
      </tr>
        </table>  
   "; 
#array of correct answrer 
#echo "array of correct answer<br/>";
#print_r($correctanswerarray);
#echo "size of the coreect answer array";
   $size1=sizeof($correctanswerarray);
echo "<br/>";




}
else
{
echo " no questions available for selected test";
}
?>
 </div>
 <!-- add div right side -->
 <div style="height:500px;width:150px;float:right;margin-top:-500px;border:1px solid #99CCFF">
</div>


<div style="height:30px">
</div>
<!--  add div bottom -->
<div style="height:125px;border:1px solid #99CCFF">
</div>


<?php
 include('footer.html'); 
?>


</body>
</html>