PHP function to loop business days between two posted dates

Question

Possible Duplicate:
Print Y-m-d list of business dates between two dates from MySQL using PHP

I'm new to these kind of PHP programming so bear with me.

I want users to be able to post two dates, a startdate and a enddate and from these dates calculate the business dates (exclude Saturday and Sunday) and insert these to MySQL

For example if I have this form...

<form action='update.php' method='post'>
  <input type='text' name='start_date'>
  <input type='text' name='end_date'>
  <input type='submit' name='submit'>
</form>

update.php

if(isset($_POST['submit'])) {

   $start_date = $_POST['start_date']; //Let's say this is 2012-10-01
   $send_date = $_POST['end_date']; //Let's say this is 2012-10-10

}

Now I would like to loop through the dates and create a MySQL query that would run like this:

INSERT INTO tbl_dates (date_value) VALUES ('2012-10-01');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-02');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-03');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-04');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-05');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-08');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-09');
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-10');

I know this is probably not a good solution but it's how I need it.

How do I create the loop?

I don't recommend doing so , it's not a standard database design. It will provide lots of data duplication — Aliweb, Oct 31 '12 at 08:16

score 1 · Accepted Answer · edited May 23 '17 at 12:27

1

$startDate = $start_date;
$endDate = $send_date;

// Convert to UNIX timestamps
$currentTime = strtotime($startDate);
$endTime = strtotime($endDate);

// Loop until we reach the last day
$result = array();
while ($currentTime <= $endTime) {
  if (date('N', $currentTime) < 6) {
    $result[] = date('Y-m-d', $currentTime);
  }
  $currentTime = strtotime('+1 day', $currentTime);
}

// start insertion
foreach($result as $value)
{
  mysql_query("INSERT INTO tbl_dates (date_value) VALUES '".$value."'");
}

Source : Print Y-m-d list of business dates between two dates from MySQL using PHP

Omg! I just realized that it's a thread started by you. You already have your answer

edited May 23 '17 at 12:27

Community

1
1

answered Oct 31 '12 at 08:19

asprin

9,579
12
66
119

1

do not copy code from other questions on StackOverflow please. If an answer exists you can copy code from, it means the question you want to paste it to is a duplicate. – Gordon Oct 31 '12 at 09:10
The section I copied was a part of the solution. I also included the next part to complete the solution. And that is the reason why I also mentioned the source in my post. – asprin Oct 31 '12 at 11:41

score 0 · Answer 2 · answered Oct 31 '12 at 08:15

0

Use date('N', $timestamp) to get the number of the day of the week. You can then check if this day matches Your requirements.

P.S. date('N') was introduced in PHP 5.1.0

answered Oct 31 '12 at 08:15

undefined

2,051
3
26
47

1

You can use `w` if you are worried about PHP version. – Salman A Oct 31 '12 at 08:24
@SalmanA: Thanks for noticing. Didn't see that in the list of formats. – undefined Oct 31 '12 at 08:31

score 0 · Answer 3 · answered Oct 31 '12 at 08:24

Code in your flavor on the basis of your PHP tag only ->

<?php

$_POST['start_date'] = '2012-10-01';
$_POST['end_date'] = '2012-10-10';

$start = explode('-',$_POST['start_date']);
$end   = explode('-',$_POST['end_date']);
$i = (int)$start[2];
for($i; $i<$end[2]; $i++)
{
$i = sprintf('%02d', $i);
echo "INSERT INTO tbl_dates (date_value) VALUES ('2012-10-$i')";
echo "<br />";
}

?>

Output

INSERT INTO tbl_dates (date_value) VALUES ('2012-10-01')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-02')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-03')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-04')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-05')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-06')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-07')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-08')
INSERT INTO tbl_dates (date_value) VALUES ('2012-10-09')

This code does not exclude saturday and sunday but thank's anyway. — David, Oct 31 '12 at 09:21
@David aah my bad i just mised that point & thought it to be a loop only problem — swapnesh, Oct 31 '12 at 09:24

PHP function to loop business days between two posted dates

3 Answers3

Linked