PHP how to stop for statement after value is hit

Posted on 2013-01-09
Last Modified: 2013-01-10
I have a calendar controls that correctly assigns a week (1-52) number to the date that is picked in a start date and end date control.

And in my database I have 52 price fields (one for each week).

I am trying to display the pricing for the weeks that are picked.
For example if the start week is 40 and the end week is 45 it displays the pricing for weeks 40, 41, 42, 43, 44 and 45.

I have that all working accurately through the code:
 echo "<td>Week ", $i, ": $<b>", $row["price$i"], "</b></td>";

Open in new window

The problem is when the start date is larger then the end date.
For example if the start week is 52 (last week of the year) and the end week is 1 (first week of the next year).

I have the code:
 echo "<td>Week ", $i, ": $<b>", $row["price$i"], "</b></td>";

Open in new window

It will bring back the correct information for week 52 but then goes into a loop adding week 53, 54, 55, etc... with no values.

How do I get it to stop at week 52 and also bring back the values for weeks lower then 52 (ie week #1 in the example).

I hope this makes sense.

Thank you in advance for your help.
Question by:Razzmataz73
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 150 total points
ID: 38761517
There is an ISO standard for week numbers.  You can use a combination of date() and strtotime() to get the week number.  These functions are documented in the web site, and also written about in this article.

Try printing out the week number according to the PHP date() function.  You will find that a "homegrown" week number is not a useful way of dealing with this information.  If you still have trouble with this, please post back with some test data and I'll be glad to show you a solution.  It may take a day or two because I am teaching full time right now, but there is a good solution and I will be happy to show you how we would do it.

Best regards, ~Ray

Author Comment

ID: 38761538
The week number comes back with no problem.

My issue is how do I write a query if the start week number is less then the end date number.

For example 49 and 1.
LVL 110

Expert Comment

by:Ray Paseur
ID: 38761546
You do not write a query that way.  You use the week number and the year to produce a lower DATETIME value and an upper DATETIME value. Then you write a query using the BETWEEN subclause of the WHERE clause.  The article either tells it explicitly or give strong suggestions about it.  You want to convert the year + week number to an ISO-8601 DATETIME string, and your query will use the resulting DATETIME strings to look into the data base table.
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation


Author Comment

ID: 38761557
Duh!  Don't know why that didn't occur to me.
That sounds perfect!
I will try it out first thing tomorrow and let you know how it goes.
LVL 34

Accepted Solution

Slick812 earned 350 total points
ID: 38761742
Not sure if you can apply this, but the Math of having a higher number first, is that you roll (for loop) the High to the Highest first and then roll from the lowest to the Lower number as this code which I ran , and it does what you describe-

$array52 = range(0, 53);
$startweek = 50;
$endingweek = 2;

if ($startweek == $endingweek)
	echo "Week ", $startweek, ': $<b>price', $array52[$startweek], "</b><br />";
} elseif ($startweek < $endingweek)
	for($i=$startweek; $i<=$endingweek; $i++) echo "Week ", $i, ': $<b>price', $array52[$i], "</b><br />";
} else
	for($i=$startweek; $i<=52; $i++) echo "Week ", $i, ': $<b>price', $array52[$i], "</b><br />";
	for($i=1; $i<=$endingweek; $i++) echo "Week ", $i, ': $<b>price', $array52[$i], "</b><br />";

Open in new window

LVL 12

Expert Comment

by:sivagnanam chandrakanth
ID: 38761804

if($i==52) exit;

Expert Comment

ID: 38762301
Firstly you should not allow  to select next week which is less then start week if you are taking into consideration weeks for your query and it is assumed that you need data for a
particular year only.
In case you intend to extend the query range spread over multiple and i assume consecutive
years then you should set a variable for currYear which should be year for the start week.
And if start week is more then end week it would be assumed that those weeks belong to
next year.
In such eventualities it would be advisable to do it in multiple steps. One each for each year.
Like one starting form 50th week and going upto 52nd week and then another query which starts at 1st week of the next year and going up to end week.
Naturally you would need to involve year in your query to get correct results.
LVL 110

Expert Comment

by:Ray Paseur
ID: 38762523
Please see (and give yourself some time to read the code and output carefully -- it's subtle).

This program shows how to use the week number.  You can use it in combination with strtotime() and date() to come up with the appropriate DATETIME values to use in the query.

<?php // RAY_week_number.php
echo "<pre>";


echo "WE ARE NOW IN WEEK " . date('W');
echo PHP_EOL;

$now = date('c', strtotime( date('Y-01-01') . ' + ' . date('W') . ' WEEKS' ));

$years = array
( 2006
, 2007
, 2008
, 2009
, 2010
, 2011
, 2012
, 2013
, 2014
, 2015

foreach ($years as $y)
    $c = date('c', strtotime("$y-01-01"));
    $w = date('W', strtotime("$y-01-01"));
    echo PHP_EOL . "ON $c IT IS WEEK NUMBER $w";
    if ($w > '01')
        $str = "$c NEXT MONDAY";
        $tsp = strtotime($str);
        $nur = date('c', $tsp);
        $nuw = date('W', $tsp);
        echo " AND ON $nur IT IS WEEK NUMBER $nuw";

foreach ($years as $y)
    $str = "$y" . '-01-01' . ' NEXT MONDAY';
    $tsp = strtotime($str);
    $nur = date('r', $tsp);
    echo PHP_EOL . "$str = $nur";

foreach ($years as $y)
    $str = "$y" . '-01-01' . ' FIRST MONDAY';
    $tsp = strtotime($str);
    $nur = date('r', $tsp);
    echo PHP_EOL . "$str = $nur";

Open in new window

Best regards, ~Ray

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question