PHP :: Calculating Dates From A Date In The Database?

Calculating Future Dates
I have a variable ($today) that is simply $today = date("m/j/Y"); I want to get another variable for x months down the line, but using the php.net reference of the mktime and date command, my second date, as follows comes out in a large number. How can I make sure it is forwarding the date properly, and format it like mm/dd/yyyy?

This is the line from php.net reference page. I need this to calculate properly, and format mm/dd/yyyy - just like my variable up top. $two_months_from_today = mktime(0,0,0,date("m")+2 ,date("d"),date("Y"));

Calculating Days Between Two Dates
I need to calculate the numbers of days (only the number of days) between two days, one a variable $row['user_cp_name'] in the format MM/DD/YY, and another, the current time. I've tried a bunch of tutorials on the internet and none seem to work properly.

Calculating Span Between Earliest And Latest Dates
I'm wanting to find the span between the earliest and latest date in my database so I can calculate how many applications are filled out every day. It would be incredible if I could exclude weekends, but that's not necessary at this point.

When I'm using a "date" type field in MySQL, I can use this ugly code:

Calculating Start And Ending Dates For A Week
Given a week number, how do you derive the starting date and ending date? I am trying to get the reverse of the yearweek function of MySQL. The yearweek function returns the year and week given a date. For example, yearweek(񟭂-08-01') returns 200231.

Calculating Date Of Weekly Meeting
Just say I have a chat session on my site at the same time every week (eg - Friday 4pm EST). How can I calculate the time/date of the next meeting. Eg - if the current time is Thursday morning, it'll be the following day. If the current time is Friday afternoon, it needs to calculate the session in 7 days time (eg - that Friday's session has already ended). So is there a way I can calculate the date of the next session based on the current time/date? And how long till the next one? So my output would be "the next meeting is in 3 days, 22 hours and 12 minutes, on Friday 23 May 4pm"

Calculating A Fictional Date, Not Working In PHP 4.4.4
I'm attempting to calculate the date for an online game that's set in the future. The games time is 4 times faster then our time so to figure it out I recorded the exact date/time in the game and the exact date/time in real time. Then all I need to do is multiply the seconds by 4 to the fictional date.

Here is what I currently have:

$realTime_start = mktime(17, 44, 20, 9, 25, 2007);
$realTime_current = mktime(date("H"), date("i"), date("s"), date("n"), date("j"), date("Y"));
$fomTime_start = mktime(14, 57, 0, 12, 8, 2007);

$seconds = ($realTime_current - $realTime_start) * 4;

$fom_date_full = date("H:i jS F Y",(strtotime("14:57 8 December 2007") + ($seconds)));
$fom_year = substr($fom_date_full, (strlen($fom_date_full) - 4), strlen($fom_date_full));
$fom_year = 2404 + ($fom_year - 2007);
$fom_date = date("H:i jS F",(strtotime("14:57 8 December") + ($seconds)));

$fom_date_full = $fom_date." ".$fom_year;
This works perfect in PHP 5+ but not on a server I'm using at the moment for testing (which uses PHP 4.4.4). I've referred to the manual to check the functions haven't changed from these versions and by the look there hasn't been any major changes.

At the time of writing this the correct output is "22:18 17th January 2405" and the PHP 4 output is "02:17 10th February 2367".

Calculating Some Formulas From Database Data
I am doing a project on beetle diversity and need to calculate a few
diversity indices for a load of data i have collected. I thought that
maybe i could make a program in php to do that for, and save a bit of
time (as well as prevent calculation errors). I imagine this could be
quite a bit of programming but i have dreamweaver to help me.
Now what i have is a MySQL database full of data on beetle diversity
with the following tables:

Date - the date the sample is from
Habitat - one of 9 habitats that i am testing between (ie. grass,
stones, birch woodland, etc)
Replica - ie 'Repeats', there were two replicas for each habitat from
each date (A and B)
Trap number - from each replica there were 6 traps
Species - the species of beetle that was found in the trap (of course
there are often more than one per trap)
Number of Individuals - the number of individuals of that species
found in that trap

What i need to do is calculate Shannon-Weiner, Shannon Equitability
and Margalefs Diversity indices for each replica from each date for
each habitat (the data for the individual traps will be merged
together).
I have an idea of how to do it but what i am stumbling at is how to
create a recordset which will calculate the total number of
individuals for that species from that replica, date & habitat (I) and
calculate the number of different species for that replica, date &
habitat (S). Once i have S and I i should be able to write the formula
in php to create the indices.
Ideally this could be done in a way to allow for each repeating areas
to be assigned so that all of the indices for that habitat (for each
date and replica) could be shown on one page (to save a lot of
clicking).

Calculating Against SQL Database, Returing Values
I was interested in trying to calculate against an SQL Table and return values that matched within the calculation. What i am trying to put together is a Zip Code Locator. I have a table "AREA" of Lat, Long and Zip Code numbers for the area im interested in. I also have a table "LOCATIONS" of Lat, Long and Zip code numbers for 25 different locations with data about Store Name, Address, etc.

What i would like to do is have a user input thier Zip code and that would launch one query, which would pull down the Lat & Long from the table "AREA". I would like to then Query the database "LOCATIONS" and calculate the distance between them using a formula. So it would do this.

User submit--->$_POST['zip'];---->Query and bring down LAT, LON from "AREA" table--->Query the LOCATIONS table, bring down all values---->calculate LAT, LON, from AREA table minus LAT, LON from the LOCATIONS table and populate to Variables the values that were LESS THAN 5 or something.

WHERE Date = Specific Dates
What is the sql query to have the dates be specific to a specific time frame? Such as all records = August. I have tried 2003-08-% but that didn't work.

Seeing If A Date Is Between Two Dates In A Table...
I have 2 fields in my table, (date1 and date2) with date1 = 2007-08-01 and date2 = 2007-09-30

I'm trying to run this sql statement:

SELECT * FROM discounts WHERE discType = 'Date Range' AND date1 >= '2007-09-15' AND date2 <= '2007-09-15'

and it won't return any rows...

is there a way to see if a date is between 2 days in a table? (btw.. 'Date Range' is valid.. so thats not it)

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?

Integer Date To Readable Dates
I currently work in ASP and am in the process of moving some
application across to PHP. At present I store dates in a database in
numerical format 38694, which is 08/12/2005. In ASP its very easy to
convert this value back into a date, but I cannot find a way to do this
in PHP.

Dates And European Date Format
ATM my database is using an American style date format with the year coming first, then the month then the day, is there a way to set it so it goes day, month, year?

Basically how it works is I got 3 drop down boxes with days, months and years in it. The user choose the desired date clicks a button and it updates the db. My problem is its has that American format and if I put it as text then I won't be able to do calculations or sorts on the date so I need it as a date.

Also do I need to actually change anything in my mysql data base in regards to the date field atm I got it set as a date is there any additional things I gotta change?

Converting Dates To Mysql Date Field
Is there a way to convert a date in this format:

8-7-2002 to fit into a MySQL date field format 2002-08-07.

the 8-7-2002 is a field in which users pick a date from a pop-up calendar in javascript. When I enter that date into the database, i want to convert it to the MySQL date format.....is there a way to convert it?

Formatting Dates Taken From Database
<?php echo $_SESSION['MY_date'] ?> This is line of code that gets a date from a session variable. The session variable, MY_date, comes from a database DATE field.
The output is like this: 2007-01-01. What I want the output to look like is this: January 1, 2007. How do I do that? or what changes are needed in the above code?

Format Dates In A Database...
what is the best or easiest format for storing dates in a mysql database? I'm wanting to store a lot of things with a date value and want it to be as easy as possible to read the date from it... I've had problems with getting dates in the past because of how I stupidly stored them.

I was thinking of simply having
day/month/year

e.g:
22/05/1988or should I use a unix timestamp?

Dates In Database + Retrieving
What is the best way to store dates into database so the data can be retrieved later on.

For example: I use this to get the date and i store it.

<?php
$date = date('d/m/y');
?>

However, if i wanted it to say '20 March 2007' would this be easy or is there a better way to store them.

Warning: Date(): Windows Does Not Support Dates Prior To Midnight
I tried to use the date() function with the mktime(). It keeps giving warning:

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970

I could use the @ to surpress the warning but I would like to know why it's happening. Take a look at this. There doesn't seem to be anything wrong with it. PHP Code:

[function.date]: Windows Does Not Support Dates Prior To Midnight (00:00:00)
I'm working with PHP in a Windows environment and ended up with the following message:

Warning: date() [function.date]: Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in c:Inetpubincludecommonereken.inc.php on line 29
Whether I'm working in Windows or Linux is all the same, because I'm dealing with dates prior to the year 1700 as well.

I've found the following library:
http://phplens.com/phpeverywhere/adodb_date_library

It replaces a number of standard php functions such as date(), but for strtotime() there's no replacement. Anybody got an efficient code solution for this?

How Do I Display All Database Entries Between Two Dates
I have two dates in a form " startdate" and enddate"

when i display the results i would like to show all results between, and including the two dates. how do i do this... this is my current query:

My Variables:

$userid = $_GET['idr'];
$fromdate = $_GET['fromdate'];
$todate = $_GET['todate'];

The query:

$result = mysql_query("SELECT date, status, time, notes FROM timeclock WHERE userid='".$userid."' ORDER BY time");

Date Is Not Being Pulled From MYSQL Database, Instead Current Date Is Displayed!
I am having trouble pulling a date from a database using PHP at the <a
href="http://www.mytuneslive.com/ameshkin69/"> following page.</a>

Here is the code. As you can see, it is just making the date the
current time. The values in the database are UNIX timestamp, and the
DATE() function is used to convert from UNIX to readable date. Can

<td width="55%" align="left" valign="top"><?php
$row_comment['timestamp'] = date("n d Y g:i A");.....

Dates - Mysql Database Older Than 7 Days
I would like to delete all the records in mysql database that is older than 7 days.
How do i go about selecting it in the database ( currentdate - 7).

DATE Doesn't Get Into Database
I have a HTML-form with a 10width field in which you can enter a date. But whatever I enter. In the database I always find 0000-00-00. The variable comes through. I checked that. Does anybody know what I do wrong ?

Date Database?
The admin assistants can enter the number of hours that each employee has worked on a particular date in a particular month (hours are variable depending upon customer demand) and at the end of the month need to run off a pay slip for each employee containing the following data:

I know how to add, delete and modify the data, the only thing im not sure of is the databse structure for the dates.

Inserting Date Into Database
I have a pretty simple news code that inserts the data, and then is retreaved, with a pretty simple scheme. I have a date column set at timestamp(14), and I'm trying to insert NOW() as the date. I browse with phpmyadmin and all it has is 14 zero's. PHP Code:

Displaying Date From A Database
All I need to do is change the date so it reads, for example, May 1999 when it's displayed on the page. Code:

Inserting Date In Database
I have form which allows a user to select a date as part of the form.
On submitting i am getting no update to the database and no error message.
To try and test it i created a shorter version which sets up the variables except the date.This gives the same result.ie no update. Code:

Filtering Results By DATE Value In Database
I have this code in my page for displaying some data from a database, sorted by date. i had posted a messed up version of this a while ago but I couldnt get it working even after a few suggestions. PHP Code:

What Is The Proper Date Format For A Txt Database?
I would like to know what format should be used when writing to a txt file. I am trying to search between a start date and a ending date and list any variables For example.

if (($sDate <= $jdate && $eDate >= $jdate))

then I have it list the variables it will work if searching between months and days but it does not work if I have different years. I will get all years printed out.

my date format is m/d/Y 6/13/2001

If I search for example start date = 6/01/2001 and the ending date = 6/09/2001

I will get the correct month and day dates but I also get anything from the year before and including year in the future.

Date & Time Format In Database.
I'm using MySQL database, the problem is I've setup that user input the Date format in dd/mm/yyyy (example: 14may2007) and Time (example: 12:00pm). How do I convert it to Date & Time format in database format before insert into database? Sorry, noob here.

Today's Date In Database Insertion
How do I insert today's date in a certain database row without using the date() function for a string? For example, when you use PHPMyAdmin to insert a new table row and there's a column with the type "date", it gives you options such as CURDATE, NOW, etc. How would I use that in a database query?

Convert Date From A Database Query
I have a simple database for events. I have a column named "date" that I would like to display as "March 8, 2007" on the webpage. What do I need to add to change the date format? Here is my php code:

Reading And Displaying A Date From A MySql Database
I've just started using php, and although I am very impressed by it,
there are some things with which I am confounded!

What I'm trying to do is read in a Date from a mySql database and then
display it on screen (the Date is in the usual yyyy-mm-dd format).

If I use SQL on phpadmin
SELECT Date
FROM details
WHERE details.Name = "Paul Lee"
LIMIT 0 , 30

The result comes up 2005-01-01, so this seems to work.
But if I use the following:

$db = mysqli_connect("localhost","root","");
@mysqli_select_db($db, "personnel") or die ( "Unable to select
database" );
$query = 'SELECT Date FROM details WHERE details.Name = "Paul Lee"
LIMIT 0, 30'

$result=mysqli_query($db, $query);

echo "<br>";

echo $result;

mysqli_close($db);

I get "Object id #2" displayed on screen.
I have tried to use the explode function to separate the months, year
and day using the "-" as a delimeter, but this doesn't work, and I
can't seem to get the other php date/time functions to work either.

Inserting A Date Into A Microsoft Access 97 Database
I was wondering if anyone could help me insert a short date into microsoft access 97 using php? i can insert text no problem but i can't seem to be able to insert a date properly. i have been using

//$date = "#" . "$sqlmonth" . "1" . "$cboyear" . "#";

$strSQL = "INSERT INTO tblSupport (tDate) VALUES ($date)";
$result = odbc_exec($connect, $strSQL);

Note: i can insert a date if i hard code it like putting in #01

How To Find The Last Accessed Date Of A MySql Database
How to find out the last accessed date of a MySql Database. I have around 200 databases in my server some are used and some are not in Use, I want to remove the database that are not in Use. SHOW TABLE STATUAS gives me last updated Date. In my case there are some database which are not updated at all, but...

Insert Server Date / Time Into Database
I currently have the following to insert a variable into a database:

$zip = $db->escape($_POST['zip']);
$db->query("INSERT INTO zip SET zips = '$zip'");

I would like to also add the date & time the submission was made.

Pulling Data From A MySQL Database With PHP Date Code??
I am trying to find ways to retrieve data by date from a mysql database.
What I would like to do is to have the option for people to retrieve a file
that was entered in the week before the current day (something like click
here for all drinks added in the last week) I have tried to make this code
work, the only way I can is to manually change the date every day, I would
like it to do it automatically.

Taking Date Of Birth From User And Sending It To A Mysql Database
i have created a form that takes a users date of birth as 3 seperate values $day $month and $year i do not know how to combine these values into a single value called $dob.
I tries using just a singal value to take the date however it did not work, even after I had formated my database.

How To Compare 2 Dates In Mysql As Mysql Treats Dates As String ?
I'm trying to compare two dates in MYSQL. But its not treating the dates as numbers, but as strings. I try using strtotime but that did not work.

Convert User Entered Date And Time To Unix Timestamp Before Inserting To Database
How do you convert a user inputted date to a unix timestamp before
insterting it into your database? I have a form, with a textfield for
a date that the user inputs in the format mm-dd-yyyy and three dropdow
boxes for hours, minutes, and AM/PM. All of these need to be considered
together and converted to one Unix Timestamp and then inserted to the
MYSQL date field. The type of field is INT (11) so that I can instead
of the standard 0000-00-00 format of MYSQL so that I can do better
calculations and queries.

Sort Results By Date/time, Limit 5 Database Entries Of Today &/or Upcoming Days
I'm designing a website for my fraternity and in the database I have entries which contain past events, todays events, and upcoming events. My problem is that I can not figure out how to sort the query results to display:

1) only past events based on the CURRENT DATE
2) only the events which fall on the CURRENT DATE or after, limiting the results to 5 entries
3) all events that fall on CURRENT DATE or afterwards

Example:
Today is September 15, 2007

Problem 1) Displaying all events that happened before September 15, 2007
Problem 2) Displaying only 5 results that fall on September 15, 2007 or after
Problem 3) Displaying all events that are happening on or after September 15, 2007

And obviously I would like the CURRENT DATE to change depending on what date it is, currently.

Ok so now I've been very redundant in my explanation of my problem here is the code and a link to what that particular page looks like. Code:

Calculating
how can I solve this:
I have filled variable total (total oredr)
This variable I must recalculate before sending, ie (look at HERE word)

total = 100

Example
---------------------
function process_button() {
global $order;

$process_button_string = web_draw_hidden_field('x_login', blah blah
....) .

HERE web_draw_hidden_field('x_amount',
number_format($order->info['total'], 2)) .

Here must total be not 100, but divided with 5.85

How can I do that?

I have tryed
web_draw_hidden_field('x_amount', number_format($order->info['total/5.85'],
2)) .
but did not work

Calculating Age
Im trying to pull a date of birth from my database (mysql) and use this to calculate a users age for display on the page. At the moment i'm storing the date of birth of each user in three different INT fields in my table:

Year - INT - 4
Day - INT - 2
Month - INT - 2

here is the code im trying to use to calculate the age: Code:

Calculating
when calculating i am trying to add to variables together like this but it not work why.

$total = ($a+$b);

Calculating
<?php

$ok = "60";
if ($ok>30) || ($ok<=50){
print "30-50";
}
else
{
print "60-over";
}
?>

what is wrong ?

Get Dates Between Two Dates, Then Add To Table
I've got a form that inserts data into a database. Basically what it sends is a sets of dates. What I'm wanting is another set of inputs that also sends some dates. But before it adds them to the database I want to query the dates and find all of the dates between the two given ones and add them to the database as well. Code:

Calculating Colors
wondering if anyone has built or knows of a script out there that will calculate and output all of the websafe colors as hex values.

Calculating Duration
I'm trying to figure out how to calculate the duration when given 2 times.

What I have is a script shown below in which you select a start time and end time from a drop down box, but would like some assistance on how to calculate the duration.

An example:

Start Time: 8:30
End Time: 9:30

Result: 1 Hour (60 mins)

<tr>
<td><b>Select Operation Start Time</b></td>
<td><select name="start_time">
<option value="null">Select One</option>
<?
$start=mktime(8,30,0,date('m'),date('d'),date('Y'));
for($i=$start;$i<=$start+32400;$i+=900)
{
$time=date("H:i",$i);
echo "<option value=$time>$time</option>";
}
?>
</select></td>
</tr>
<tr>
<td><b>Select Operation End Time</b></td>
<td><select name="end_time">
<option value="null">Select One</option>
<?
$start=mktime(8,30,0,date('m'),date('d'),date('Y'));
for($i=$start;$i<=$start+32400;$i+=900)
{
$time=date("H:i",$i);
echo "<option value=$time>$time</option>";
}
?>
</select></td>
</tr>

Calculating Tim - Easy For You! =)
I found out that i can calculate the dates e.g

$today = strftime('%Y%m%d',mktime(0, 0, 0, date("m"), date("d"),
date("Y")));
$yesterday = strftime('%Y%m%d',mktime(0, 0, 0, date("m"), date("d") - 1,
date("Y")));
$dayBeforeYesterday = strftime('%Y%m%d',mktime(0, 0, 0, date("m"),
date("d") - 2, date("Y")));
$dayBeforeTheDayBeforeYesterday = strftime('%Y%m%d',mktime(0, 0, 0,
date("m"), date("d") - 2, date("Y")));

and so on........

This works even if we have the 1st of August $yesterday gives me the 31st
july.

Can I do this with times also?

e.g. Iit it now 17:06 an i want to make minus 20 min (like abopve minus 1
day) and I want the result to be 16:46.
I tried the above example, wit %H%M but it does not work?