PHP - Loop Through Mulit-dimension Array And Match Dates

Hi, I am completely stuck on this. I am trying to allow the user to select a start day and end day.  then the system adds two weeks to the start day and each previous calculation (ie intervals of 0 weeks, 2 weeks, 4 weeks, etc. from the start day) until the end date is reached.  I would also like each of these dates to be inserted into my database.   I have no clue as to where to even start with this.  I know I will need some kind of loop based on days, but I am not sure how I would write this.     I suppose this would be the basic structure of the query, but not sure how to incorporate this loop that I need.

mysql_query("INSERT INTO events (title, date)
VALUES ('$title', '(current date that the loop is in)')");
mysql_error();

can anyone help me out with this?  thanks in Advance!

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

Hello everyone,

I am trying to convert dates directly from the database but still keep it within the same array so that I can conveniently access it later on. I am not sure how to explain this better, but I believe the code is pretty self explanatory:
$stmt = $this->db->query("SELECT title,slug,content,author_id,created FROM article");

$stmt->setFetchMode(PDO::FETCH_ASSOC);

$i = 0;

while($var = $stmt->fetch())
{
$this->data[] = $var;
$this->data[$i]['date'] = date("F j, Y", strtotime($var['created']));
$i++;
}

print_r($this->data);

/* produced array
Array
(
    [0] => Array
        (
            [title] => PHP Security Book
            [slug] => php-security-book
            [content] => Lorem ipsum dolor sit amet, consectetur adipisicing elit.
            [author_id] => 3
            [created] => 2012-03-13 12:34:42
            [date] => March 13, 2012
        )

    [1] => Array
        (
            [title] => Something To Do
            [slug] => somthing-to-do
            [content] => You know what a dolor sit amet, consectetur adipisicing elit.
            [author_id] => 3
            [created] => 2012-03-13 12:35:46
            [date] => March 13, 2012
        )
)
*/

I access it like so:

foreach ($_data as $var) 
{
echo '<h2>' . $var['title'] . '</h2> <br />';
echo '<b>' . $var['date'] . '</b> <br />';
echo '<p>' . $var['content'] . '</p> <br />';
}

It works perfectly but my question is:
Is there a better or more efficient way to do this? I think that my while loop could use some improvement.
I was also thinking of maybe fetching the results into a class using PDO::FETCH_CLASS, but it seems like a bit of a hassle for just one modification.

Dead simple, I know it is but I'm still a little newbie. I have this chat box, and I don't want people to be able to swear in it so I need help making a function where you call the string as an argument and it returns true if the string has any words from an array in it, Even if the word is walking and not just walk. If it's true I can replace the entire string with something else.

Can someone tell me what functions I need? I prefer you didn't do it all for me I need to learn 

Thanks in advance!

Code: [Select]
array ( 0 => array ( 'c0' => '6/111', 'c1' => '6/114', 'cnt' => '1', ), 1 => array ( 'c0' => '6/114', 'c1' => '6/111', 'cnt' => '1', ), 2 => array ( 'c0' => '6/145', 'c1' => '6/116', 'cnt' => '1', ), )
I want to "match" as on example code
0 => array ( 'c0' => '6/111', 'c1' => '6/114', 'cnt' => '1', ),
1 => array ( 'c0' => '6/114', 'c1' => '6/111', 'cnt' => '1', ),

c0 & c1, to get (and the array to be reseted)

0 => array ( 'c0' => '6/111', 'c1' => '6/114', 'cnt' => '2', ),
1 => array ( 'c0' => '6/145', 'c1' => '6/116', 'cnt' => '1', ), )

how to do it? I think that on only SQL it's impossible to do that ("switch"), furthermore I think that the code above would be useful

/*
$_c1 = @array_merge($_c1,$_c1x); if(!empty($_c0)) {
foreach($_c1 as $value) {
if(!isset($c1x[$value['id']])) {
$c1x[$value['id']] = $value;
$c1x[$value['id']]['cnt'] = 0;
} $c1x[$value['id']]['cnt']++;
} $this->tpl->assign('c1x',$c1x);
} */

please help mi, thank you very much

I can't get the COUNT of the matching results? Please help.


$SomeVar = myname;
$queryU =  "SELECT * FROM adxone WHERE username = '".$SomeVar."'";
$resultU = mysql_query($queryU);
while($scoreP = mysql_fetch_array($resultU))
{
$scoreP['roundzAa'];
$scoreP['roundzAb'];
$scoreP['roundzAc'];
$scoreP['roundzAd'];
$scoreP['roundzAe'];
$scoreP['roundzAf'];
$scoreP['roundzAg'];
$scoreP['roundzAh'];
}


$WinV = 'resultA';
$query =  "SELECT * FROM acs WHERE resultx = '".$WinV."'";
$result = mysql_query($query);
while($scoreUsr = mysql_fetch_array($result))
{
$scoreUsr = $scoreM1['winxa'];  
$scoreUsr = $scoreM1['winxb']; 
$scoreUsr = $scoreM1['winxc']; 
$scoreUsr = $scoreM1['winxd']; 
$scoreUsr = $scoreM1['winxe']; 
$scoreUsr = $scoreM1['winxf']; 
$scoreUsr = $scoreM1['winxg']; 
$scoreUsr = $scoreM1['winxh']; 
}

$count1 = count( array_intersect($resultU, $result) );
echo($count1);

mysql_query("UPDATE comp SET id=$count1 WHERE username = '".$SomeVar."'");
?>

I have a array of file path strings and trying to search the array for a string that would be the end of the path sting and return the index of the file path that contains the string. I've tried using something like this, but it finds the keyword in anyplace in the file path. I've also tried strripos() as well with the same results. Any suggestions?

function array_search_partial($arr, $keyword) {
    foreach ($arr as $index => $string) {
			if(strpos($string, $keyword) !== FALSE) {
				return $index;
			}
    }
}

 

Hello,

I have several job categories on a recruitment website:

$job_category[0]="accountant";
$job_category[1]="php programming";
$job_category[2]="baseball";

these job categories are contained within the urls imediately after the recruiting company's name and before the word "jobs", so we could have the following urls:

www.url.com/company_name_accountant_jobs
www.url.com/another_company_name_baseball_jobs
www.url.com/yet_another_company_name_php programming_jobs

Using the array $job_categories and the page path after the foward slash (e.g. yet_another_company_name_php programming_jobs) please could you tell me how to strip out the job category and the company name? (I'll extract the page path using a mod_rewrite)

Thanks

Stu

Is their a way to format lr.submit_time in every record that is returned in the $results array without doing like a for/foreach loop? Like array_walk() or something similar?

$query = "
				SELECT
					lr.*,
					l.make,
					l.model,
					l.part_number,
					l.description,
					pd.job_number,
					pd.line_item,
					pd.enterprise,
					pd.description,
					pd.qty AS order_qty,
					log.name AS user_full_name
				FROM
					leds_requests lr
				LEFT JOIN
					leds l
				ON
					l.id = lr.product_id
				LEFT JOIN
					production_data pd
				ON
					pd.id = lr.order_id
				LEFT JOIN
					login log
				ON
					log.user_id = lr.user_id
				WHERE
					lr.id IN(
					SELECT
						MAX(id)
					FROM
						leds_requests
					WHERE
						status_id = 0
					GROUP BY
						order_id,
						product_id
				) AND lr.id NOT IN(
					SELECT
						id
					FROM
						leds_requests
					WHERE
						lr.id = id AND status_id IN(1, 2, 3, 4)
				)
				GROUP BY
					order_id,
					product_id,
					job_number
	";
	$statement = $pdo->prepare($query);
	$statement->execute();
	$results = $statement->fetchAll();
	
	echo json_encode($results);

 

Hi,
A user selects week and a room to book. I put these into an array so I have now have an array of room numbers and dates.

I don't want them to book seperate holidays for one accommodation, I have mangaged to stop them booking a two week stay and they an extra week.  But I need a way to stop them booking two or three seperate two week holidays.  So basically I need to just give an error if the dates they have selected are not consecutive.

I have tried many variations of adding and subtracting 7 days  and comparing that in the array using a loop based on the room ids being the same.

I know the code below doesn't work but it gives an idea of how I been trying.
Also assume that the array has aan accomID and date seperated by a comma.

 function search_break_in_consec_weeks($accomCountValidCheck, $accomID, $date){

$allConsec = false;

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

$varArray =  explode(', ', $value);

$varDate =  $varArray[1];

$varAccomID =  $varArray[0];

if($accomID == $varAccomID && date("Y-m-d", strtotime($date)) == date("Y-m-d", strtotime($varDate ."+7 days")) || date("Y-m-d", strtotime($date)) == date("Y-m-d", strtotime($varDate ."-7 days"))){

   $allConsec = true;

   break;

}else{

   $allConsec = false;

}

}

return $countStray;

}

foreach($accomCountValidCheck as $accomVal){

$varArray =  explode(', ', $accomVal);

$varAccomID  =  $varArray[0];

$varDate=  $varArray[1];

 $valReturnConsec = search_break_in_consec_weeks($accomCountValidCheck, $varAccomID, $varDate);

if($valReturnConsec){echo '<b>'.$varAccomID.'</b>'. ' consec<br />';}

if($valReturnConsec == false){echo $varAccomID .'not consec<br />';}

}

Hi I am trying to search an array that comes from a power shell script, the array of strings that returns is ever changing as it receives variables from the script. Therefore I need to use preg_grep to search for the word "not" I am also using another array which inverts this I then need to compare these new two arrays to the original and separate the results $working and not working into a table. I would be most grateful for any advice/solutions. The preg_grep aren't displaying anything.  <?php //phpinfo(); ini_set('display_errors', 'On'); error_reporting(0);//E_ALL echo '<html> <style> body { font-family:Calibri,Helvetica,sans-serif; font-size:100%; } </style>   <head> <link rel="stylesheet" type="text/css" href="style.css">   <script type="text/javascript"> function uploadJS(){ String.prototype.trim = function() { return this.replace(/^\s+|\s+$/g, ""); }; var textAreaValue=document.getElementById(\'ServerList\').value; var trimmedTextAreaValue=textAreaValue.trim(); if(trimmedTextAreaValue!="") { document.myForm.submit(); } else{ alert("Server List Text Area is Empty"); } }; var input=document.getElementById(\'fileSelect\').value; if(input!="") { document.myForm.submit(); } else{ alert("You have not selected a file, please select one to proceed."); }       var handleFileSelect = function(e) {         var files = e.target.files;         if(files.length === 1) {         document.forms.myForm.filecsv.value = files[0].name;         }     }                 };                 </script> </head>';   #Upload Code $target = "D:\Web\Upload/";   $target = $target . basename( $_FILES['uploaded']['name']) ;   $ok=1;   if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target))   {   echo "The file ". basename( $_FILES['uploadedfile']['name']). "   has been uploaded";   }   else {     }     if ($uploaded_size > 150000)   { echo "Your file is too large.<br>";   $ok=0;   }     if ($uploaded_type =="text/php")   {   echo "No PHP files<br>";   $ok=0;   } if (!($uploaded_type=="text/csv")) { echo "<br>";  $ok=0; }    $target = "upload/";  $target = $target . basename( $_FILES['uploaded']['name']) ;  $ok=1;   //This is our size condition if ($uploaded_size > 350000) { echo "Your file is too large.<br>"; $ok=0; }  //This is our limit file type condition if ($uploaded_type =="text/php")  {  echo "No PHP files<br>"; $ok=0; }  //Here we check that $ok was not set to 0 by an error if ($ok==0) {  } //If everything is ok we try to upload it  else  {  if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) {  echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; }  else {   }  }   #Start of scripts to check Servers in textbox   if(isset($_POST['ServerList']))                 {                                 //$arry=explode( "\r\n", $_POST['ServerList'] );                 $txttrim = trim($_POST['ServerList']);                 //$textAr = explode("\n", $text);                 //$textAr1 = array_filter($text, 'trim'); // remove any extra \r characters left behind                 $txtarea = explode("\n",$txttrim);                 $txtarea = array_filter($txtarea,'trim');                                                 foreach ($txtarea as $line => $servername)                 {                                              //$line => $servername;                                 ##check if querying itself....                 }                                      echo '<pre>';     $target="D:/Web/Upload/"; $target= $target . basename( $_FILES['uploaded']['name']) ;     $csv = $target;                 //$filename= $_FILES['uploaded']['name'];                 $output=shell_exec("powershell -Command D:/Web/scripts/PHPfwrules.ps1 $csv < NUL");                 echo '<h6>';                 print_r($output);                 $nomatch=preg_grep('/^not/i',$output);                 echo $nomatch;                 $match=preg_grep("/not/",$output,PREG_GREP_INVERT);                 echo $match;                 if ($working1= array_intersect($output,$match))                                 {                 echo"<link rel=stylesheet type=text/css href=style.css>                 <table class=results>                                 <tr>                                 <th>Server Name</th>                                 <th>Working</th>                                 </tr>                                 <tr>                                 <td>".$servername."</td>                                 <td>".$working1."</td>                                 </tr></table>                                 "; } else if ($notworking1= array_intersect($output,$nomatch)) {                 echo"<link rel=stylesheet type=text/css href=style.css>                 <table class=results>                                 <tr>                                 <th>Server Name</th>                                 <th>Not Working</th>                                 </tr>                                 <tr>                                 <td>".$servername."</td>                                 <td>".$notworking1."</td>                                 </tr></table> "; } }                                                                 echo' <link rel=stylesheet href=dhtmlwindow.css type=text/css />                                                 <link rel=stylesheet type=text/css href=style.css>                                                 <script src=js/dhtmlwindow.js></script>                                                 <hr />                                                 <table class=results>                                                 <tr>                                                 <th>Server Name</th>                                                 <th>Working</th>                                                 <th>  Not Working</th>                                                 </tr>                                                 <tr>                                                 <td>'.$servername.'</td>                                                 <td>'.$working1.'</td>             <td>'.$notworking1.'</td>                                                                                                   <td></td>                                                 ';                echo '</pre>';   echo ' <h3>Firewall Implementation </h3> <h4>Please enter the server below, you can only select one server at a time. </h4> <!--The form--> <form action="fw2.php" method="post" name="myForm" id="myForm" enctype="multipart/form-data"> <textarea name=ServerList id=ServerList> </textarea> <h5>Please select a CSV file.</h5>     <input name="uploaded" type="file" /><br />                 <input type="submit" value="Submit" /> <br> </html> ' ; ?>    

Hi All,

I need to subtract dates and display the number of days left.  I have a 'Start' date and an 'End' date in DATETIME format in the DB.  Not quite sure where to start.  A simply start - end doesn't work  .

Start = 2011-11-01-00:00:00
End = 2011-11-30-23:59:59

Since it is now 2011-11-27, my output should equal 3.  Any help is appreciated.

Hi guys,

I am trying to do a multidates events availability calender. The script below indicates todays date by highlighting an orange colour and also indicates the start and end date of the event highlighting grey colour on the two dates (The colour are link via css classes as shown).
Code: [Select]
//Today's date
$todaysDate = date("d/m/Y");
            $dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
echo "<td align='center' ";
if($todaysDate == $dateToCompare){
echo "class='today'";
}else{
//Compare's the event dates
$sqlcount = "select event_start,event_end from b_calender where event_start ='".$dateToCompare."' AND event_end='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlcount));
if($noOfEvent >= 1){
echo "class='event'";
}
}
It works ok i.e. if start date = 01/01/2012 and end date = 04/01/2012 both date will be highlighted with grey colour. However I want it to also highlight grey on the dates between the 1st and 4th to show that then anydates between the 1st and 4th are not available and this is when I'm stuck.

Please guys I need help.

Thanks

Code: [Select]
$new_array2=array_diff($my_array,$itemIds);

$updatedb = mysql_query("UPDATE content_type_ads SET field_expire_value = '666' WHERE $new_array2 = field_item_id_value");
"$new_array2" has only 12 digit numbers for each item in the array, and I want to match them to the "field_item_id_value" field in the table, updating the "field_expire_value" field for the record where they match.  I know I am close because the UPDATE code works before I add the WHERE statement (it of course adds '666' to EVERY field, but for a noobie it's a start!).