the current week number of the year

[jefargrafx]

Hi yall...

I got a record set that retreives a cafeteria menu from a database. In the database I have a column that iindicates the records assigned week 1-52 for 52 weeks in the year.

I've got very thing working okay by sorting on the week number column 1-52 and I have record set navigation set so the user can page throguh the records (differnet menus)

However, I need to automaticlly move to the current week based on the sytem clock.

so when the user opens the page he see this weeks menu. (what ever this week might be)

I'm sure php can do this? any ideas on where I might look.

thanks

jef

 

[sleipnir214]

If you're running PHP 4.1.0 or newer, the date() function (

http://us2.php.net/manual/en/function.date.php)

will accept an input for the date format of "W", which will give you the ISO-8601 week of the year (weeks starting on Monday).

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

The PEAR class Date_Calc also has a method weekOfYear(), which will return the week of a year. That class will also allow you to arbitrarily set the day of the week on which a week begins.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[jefargrafx]

very god, I got this to work and set it as a variable

$weeknumber = date("W"

and
echo $weeknumber;

print 35 to the screen, but how to I get my recordset to move to menu_week 35?

right now it get's all the records and displays them 1-52, starting at 1, week week I'd like to start at 35?

any ideas

thanks I new to PHP, but I got ta say I'm lovin it.

let me know

jef

 

[DRJ478]

You should take care of that in your SQL statement.

# 1. ascertain the current week
$currentWeek = date("W");
# construct SQL
$SQL = "SELECT * FROM menutable WHERE menuWeek = $currentWeek";

That's all. The WHERE clause limits the records to the specified condition.

 

[jefargrafx]

okay guys I almost got it

this is the url I'm passing

cafeteria_startpage_00.php?pageNum_rs_getCafeteriaMenus=33

where 33 is the date("w"

however if I pass

cafeteria_startpage_00.php?pageNum_rs_getCafeteriaMenus=weeknumber

I just get weeknumber in the url
why

In my test page where I set the link I have

$weeknumber = date("W"
echo $weeknumber;

and then the link to the startpage

what am I missing?

jef

 

[DRJ478]

When you pass something as a GET parameter then that's what's in the variable - that's why.

You need to create your link within the PHP application and set the correct parameter there:

$weeknumber = date("W");
# print the link now
print(&quot;<a href=&quot;cafeteria_startpage_00.php?pageNum_rs_getCafeteriaMenus=&quot;.

$weeknumber

;
# etc.

It is your code that has to create the correct link. Hence these pages are called 'dynamic'.

 

[sleipnir214]

Insufficient data for a meaningful answer. You're the only one of us that has seen your code.

As a general piece of advice, you need to build your URL string by concatenating "afeteria_startpage_00.php?pageNum_rs_getCafeteriaMenus=" with the value in $weeknumber. You're not doing that correctly in your PHP code.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[jefargrafx]

DRJ478

thnaks for setting me straight!

I get it now, I was trying to pass a variable of a variable on a href..... no wonder

you the best and big cookie and a thanks a lot.

I'll get there


jef