Calculate A Firefighters Schedule In PHP
I need to calculate the following schedule in php. What I need out of the script is what shift is working “today” E.G. $shift = d;. There are 4 shifts working 24hr days starting at 7 am. The days rotate on 28 day cycles. E.G. ‘C shift’ is working on July 1 (Sunday) the next Sunday they work is the 29th. I found some code that works with 3 shifts on a different cycle but I have 4 shifts. Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Schedule
Currently, I have a database that stores a course schedule. For example: Course Title, Start Time (datetime), End Time (datetime), Mon (T/F), Tues (T/F), Wed (T/F) Thurs (T/F), Fri (T/F) I want to take this data and graph it as a visual calendar using tables. For example: Time Monday Tuesday Wednes ... 10:00AM WS1093 10:30AM WS1093 11:00AM WS1093 11:30AM 12:00PM EH2312 12:30PM EH2312 1:00PM EH2312 Something like that. What's the best way to do this? Clearly, I could make a an html calendar and load it up with a bunch of if statements but is there a more elegant way to fill in the calendar? Are there any classes available to easily do this? Code examples are very much welcomed!
View Replies !
TV Schedule?
I've seen this on a number of TV sites, where on the front page they tell you what's playing at the time you're browsing, what's coming up next, etc. I want to do this for a site I'm working on, but I have no idea where to start.
View Replies !
Schedule And Php.exe
i am making an installer for a shoutcast control panel i have designed http://sourceforge.net/projects/cast-control it runs on both windows and linux I have made a bitrate controller that runs a batch file or cron job (depending on the operating system) which will run a php file with php. In the batch file i have c:/php/php.exe "D:/pathto/shoutcast_cpanel/bitrate/bitrate.php" The problem is that i cannot include the database.php file which is in the same directory as bitrate.php. I was wondering how to make this possible or at least include the database settings from the file somehow. The reason im not just running http://serverurl/bitrate/bitrate.php is because under windows it opens up a new windows in explorer for every time.
View Replies !
Schedule Job
i need to schule a php script to run once a month in apache/windows environment. what would be the easiest best way to accomplish this task?
View Replies !
Creating A Schedule
I am building a diet/weight loss website where a customer would subscribe for 1,3,6 or 12 months. I am using Paypal IPN to handle the subscription payments. I would like to create a schedule when the customer first logs on, from the date they signed up to the date when the subscription ends and every 7 days is highlighted as the weigh in day. Basically I would like to generate a list of dates from one date to another with every 7th day highlighted.
View Replies !
Schedule Emails
Has anybody every attempting scheduling emails or trigering any event from a php site? for example, everyday at 10:00am call function x(); ?
View Replies !
Schedule Script Run
I need to schedule a php script to be run daily at 12.30am. What command can I place in my crontab to do this? I'm confused because a web browser is required to run a typical php script. I thought about lynx, but I'm not sure how to run it, and then exit after it runs.
View Replies !
Schedule My Classes
if it`s a good idea try to do a class scheduler in php HorarioEX.htm this is the visual part of what i want to do. the idea is the user insert the code of the class it`s called CRN, then appears on the table with some color and thats all. So do u think its a good idea to try with php ? or i should try javascript or another source?
View Replies !
Schedule Script
Is there a way to get my script to run on regularly scheduled intervals without using cron? My hosting provider sucks. cannot use cron. I was thinking perhaps I could create a file every hour in a certain directory and then fire the script when the file count reaches a certain number, and then clear out the directory or something like that.
View Replies !
Simple Calendar/schedule
I'm looking to develop a simple php calendar/schedule - similar to outlook calendar - that does not rely on a database but rather writes to a file. I need to be able to add to/delete from the schedule. As I am only starting out with php I am a little confused by the codes which links to databases and how to adapt them to only write to a flat file.
View Replies !
Wrong Dates In A Schedule
I am using the following code (many thanks for the code folks BTW) to generate 3 schedules in three tables one is a schedule with 7 day intervals and two are daily schedules. The two daily schedules seem to have out of sync dates at the start of each schedule. The dates look as if they may be dates from the preceding loop. I am presuming that I need to reset something after the completion of each loop but I am not sure what. $now = time(); $day = $now + 7*24*60*60; $cutoff = strtotime("+$months months"); while ($day <= $cutoff) { $date = date('Y-m-d', $day); $insert = "INSERT INTO daily_data SET subscr_id='$subscr_id', date='$date'"; mysql_query($insert); $day = $day + 7*24*60*60; } //then create a daily schedule in the excercise table for($i=0;$i<=($sched);$i++) mysql_query("INSERT INTO exercise_data SET subscr_id='$subscr_id', date=date_add(now(),INTERVAL LAST_INSERT_ID() DAY)"); //then create a daily schedule in the food and diet table for($i=0;$i<=($sched);$i++) mysql_query("INSERT INTO food_data SET subscr_id='$subscr_id', date=date_add(now(),INTERVAL LAST_INSERT_ID() DAY)");
View Replies !
Calender Script/Schedule
Does anyone have any recommendations or tips on where I can go to find a good scheduling script or a tutorial to make one? I'd perfer to make my own for security reasons so I know the code and for later addons. Basically I need to re-create something like http://radio.virtualdj.com/schedule/schedule.php where djs can login to book a time on the online radio and then it blocks the slot off.
View Replies !
Allow A User To Schedule A Stay
I am trying to code a program in PHP that would allow a user to schedule a stay at this place, it would save that to a database. If a particular day has 5 people booking it, it is no longer able to be scheduled. I can't get the scheduler page to check how many people have booked or my calendar to display a day in red if it is booked.
View Replies !
How To Schedule Tasks On Website.
I am trying to figure out how to schedule tasks on my website. For example, PAGE1 should perform a different task in the morning than in the afternoon. And at the end of the day, I have to extract some data from the database and put them into a file. This should be done automatically.
View Replies !
Schedule Mail Sending
I need to send an newsletter as an email that is scheduled. The user will prepare the newsletter and save it in database. He will also input the scheduling option i.e date and time the newsletter has to be sent. I have a table Newsletter_T where newsletter contents are being saved and Contacts_T where the email address resides. I am using PHP 5.2.3, Apache and MySQL.
View Replies !
Send Email With Schedule
I want to create an option to the user to suscribe to a service that sends an automatic mails everyday with information taken from a database created in MySQL. I have the form and the access with PHP to the database and I can send an automatic mail at the moment that the users press a button to activate the action, but I do not know how to do it everyday (or the period of time chosen by the user).
View Replies !
Creating A Schedule Script
I have a league based web site and I'm looking to make a script that can make a schedule of matches. Last year I did alot of hard coding with a ton of if statements (not very fun). There are 2 vars. how many weeks you play number of teams.
View Replies !
How To Set Up Multiple Dates For Schedule?
I have a question about how to set up dates in my mysql database. I am setting up a show schedule database for a friend at a local college tv station. This would normally be pretty straight forward and easy. The problem lies in the fact that their show lineup is not huge, therefore they air most of their shows that the students produce up to 5 times a day and also some of these shows -not all- come on all week long (Sunday thru Saturday) and some only come on one or two days out of the week. My database (so far) contains the following tables: ...
View Replies !
Schedule A Cron Job With Php Script
Is it at all possible to schedule a cron job from a php script? Perhaps cron isn't my best option. I need to have a script run automatically at one specific time and not repeat. The way I was thinking of doing this is to schedule a cron job, then when it runs remove it from crontab. Is this possible, or even the right solution?
View Replies !
How To Schedule Jobs On A Host?
I'm using a php hosting company for my website. It seems most php pages are user-event triggered, so it is difficult to schedule something to run regularly. For example, user puts something in discussion board, and I need to update my search index to include it. Since building index is pretty IO intensive and takes long time, I hope to do it once a day when traffic is very low or zero so it doesn't impact server performance. I can't really rely on user events to trigger such things. For example, user won't expect his click would trigger a 20 minute delay so I can piggy bag an index-build at the page handler, and there might not even be user clicking my site at the time I desire. Is scheduling for jobs (or something similar) achievable using regular PHP? (I don't have shell login, etc. for the typical PHP hosting service).
View Replies !
Setting Up A Time Schedule?
I have a php script that needs to run 6 times a day, the documents that came with it suggest that it should be setup as a cron job, but where my site is hosted, I'm unable to do this. so I thought that maybe I could setup a php time schedule, so that the script will run inbetween these times when a users hits the site: 12am-1am 4am-5am 8am-9am 12pm-1pm 4pm-5pm 8pm-9pm but also I'm wondering how the script could keep track if the script has already been ran for a particular time period.
View Replies !
Table With Weekly Schedule From A Database?
I'm designing a site for a community radio station and the schedule needs to be generated from the list of programs that are in the database the shows table has the following colums show_id, show_name, day, start_time, end_time (i didn't list the non-relevant ones for this portion of the site) because a table has to be built left to right instead of top to bottom (cell for monday 8am then tuesday 8am instead of all the monday then tuesday etc) and not all the programs are the same length (i think i can use row span="x" depending on the length of the show) I'm quite lost. should i have other colums? how do i query the database to pull the data out in the proper order and build the table?
View Replies !
How Would Watchers Know, Without A Cyclic Check On MySQL Schedule Table About Task Validity?
I have developed a PHP-based website where a "planner" user can make up schedules of activities to be performed, storing them into MySQL tables. Afterwards, other "watcher" users can connect to the website and retrieve closest task due time, and keep retrieving next task after each one has been performed. The problem arises if the planner asynchronously changes the schedule, e.g. deleting the task "watcher" users consider to be the next one, or inserting a closer one. How would watchers know, without a cyclic check on MySQL schedule table about task validity? I would need a sort of asynchronous server-pushing tecnhique towards watcher's browser when any schedule modification occurs. Would you say this could be done with PHP alone?
View Replies !
Calculate A Value That Is In The Db
i want it to calculate a value that is in the db if the db has the value 6 pound(s) (i have a submit button) and the users enters in the input box a value for more pounds then how do i make it calculate in fractions or even divisions.. cause see this is what i have. PHP Code:
View Replies !
Age Calculate
I need to run a query if a user age is within specified age range. User age is store in a table in 0000-00-00 format the age limits are passed by two vars: PHP Code: $ageMin = 25; $ageMax = 35; I can do it in a php function but I'd like to perform this validation in a query string. Is it possible?
View Replies !
Calculate Date
I have a date 11-07-2007 22:06 and i want to know how to calculate 4 hours ahead and create a count down system $date_now $date_4hours $countdown = $date_now - $date_4hours;
View Replies !
Calculate Rank
I need to display the rank of my players. The rank is based on this row: c_strength What would I use to count their rank, ie: Rank: 54 of 5,231
View Replies !
Calculate The Percentage Of 250 Between 150 And 450
Say I have two numbers, for example 150 and 450....and a third number between them, say 250. I want to calculate the percentage of 250 between 150 and 450, where 150 is the 0%, and 450 is the 100%. I know there is a certain formula, but seeing math was never my favorite course, I can't just figure it out.
View Replies !
Calculate Months
I would like to make the login form so that you can only have so many failed login attempts. For example, I would like to make it so that if you fail to login correctly after 5 attempts, you won't be able to for 10 minutes.
View Replies !
Best Way To Calculate A Rating?
ive got some code which ive written which takes 5 values from a database and calculates the average then displays the average as a certain number of stars. the code works perfectly so there is nothing wrong.. its just a bit long and i was wondering if theres a qicker easy way to do the same thing? or if i should just stick to what ive got. Code:
View Replies !
Calculate Many Downloads
I want to know how many successful downloads from website, is there some PHP script can do this? Let's say I have file "abc.zip" people can download, The system is Apache+linux+php+mysql, how I can know exact how many successfully downloads and the download time. I know it can be done by weblog statistic, but I want to know is there some way in php can do it so I can save in database and view real time result.
View Replies !
Calculate Cost
I have an equipment table. In this table there is an onhand, receivedqty, and totalcost fields. How can I query to get an average cost and extended cost. The math would be totalcost/receivedqty=averagecost and the extended cost would averagecost*onhand. Is it possible to do the equations within the mysql statement. I tried the below but it won't let me use average to get the extended cost.
View Replies !
Calculate Days Worked
I have a set date in my MySQL database that records when a Sales Lead is established and I echo that date as $row_rsLead['lead_date']; I need to be able to calculate how many days that lead has existed. $row_rsLead['lead_date']; outputs as 2007-06-14. I have made numerous attempts to create a function that will calculate the days between the lead_date and today's date, but have made absolutely no headway. I am either stuck working between differing date formats or really strange numerical outputs. If there is a script someone is willing to share or point me in a direction that is good for a relative newcomer to PHP,
View Replies !
Calculate Volume Discount
I'm trying to create a calculation that will look at the qty ordered and compare that to the quantity discounts. An example is as follows. Product = Bronco wild horses 1,000(horses) = $300.00/m 2,000 = $150.00/m 3,000+ = $100.00/m etc. /m=per thousand So if I order 2500 horses the php page will look at the value entered, select the proper price and calculate the final total. 2500/1000=2.5X$150.00=$375.00 for 2500 Bronco's. As you can see below, I've got the formating for the final total, But I don't know how to have it find the right price. Code:
View Replies !
How To Calculate The Day Of The Week By A Given Date.
I'm currently working on a (simple) calendar system which allows registered users to add an event to the calendar. The table EVENT stores info about the author, date and description of the event. I then managed to output a list in which only events of this year are showed and are grouped together by months. And now I only need one more thing to complete the script. I want to output for every event on which day of the week it occurs (monday - sunday). I've looked around for tutorials but haven't found a basic one.
View Replies !
Calculate Crc32 Of File In Php
I am having a problem calculating a crc32 hash of a file in php. I have uploaded a file, calculated an md5 hash and it is correct, both using md5_file() and hash_file("md5",filename) and they are both correct (tested with md5 command on osx and MD5 in Java). I am using hash_file("crc32",filename) and this gives a different result to crc32 in Java and crc32 command on osx.
View Replies !
Calculate Totals In A Loop
I am trying to calculate the totals of all the fields pulled up in a loop... i.e. I have a database called "checkout" that has bidder numbers, lot numbers, and amount for each lot number. When a person wins an auction (this is a live auction not an online auction) we enter a new row in the database that has the bidder number, the lot number, and the amount. After the auction is complete and they are checking out we have the script pull all the rows where the bidder number equals the bidder who is paying, it displays their bidder number, and lists each lot number and amount for that lot on separate lines in a loop statement. I would like to have a final line at the end of the page that displays the total of all the amounts listed. I.e. if they have lot number 12 at $50 and lot number 10 @ $27 and lot number 55 @ $63 the script displays as follows... bidder number: 101 lot number 12: $50 lot number 10: $27 lot number 55: $63 And I would like the end to say total: $140 How can I do this? I appreciate any help... Here is a copy of what I am working with now. Code:
View Replies !
Calculate Percentage Discount
I have a field which holds a numerical value lets say 29.99 Based on whatever the value of this number is I then want to calculate 5% of the value Do I just do $discountPrice = $totalPrice * 5% Im not sure what syntax to use to achieve this
View Replies !
Calculate Dates Given Beg And End Date
I am trying to figure out how to generate a listing of dates using the following known values: begDate = 2007-07-03 endDate = 2007-08-30 recurDates = Tue|Thu Question is how do I generate the YYYY-MM-DD for each of the dates between begDate and endDate for each of the recurDates?
View Replies !
Calculate Difference Between Dates
I've to build a function that tells me the resultant date from adding a number of days to a date. Example: function adddate(date, days) { return date + days; } For example if I call with this...adddate(2007-05-05, 5) it should give back a 2007-05-10. I've tried but is hard! It should work with any number of days.
View Replies !
|