PHP - Future Dates

Hi, I am using this function to output a list of dates for every friday over the next 12months. This is working fine.

Code: [Select]
[php]
//function
function nextWeeksDay($date_begin,$nbrweek)
{
$nextweek=array();
for($i = 1; $i <= $nbrweek; $i++)  { // 52 week in one year of course
$nextweek[$i]=date('Y-m-d', strtotime('+'.$i.' week',$date_begin));
}
return $nextweek;
}
/// end function
/// example of a select date
// var
$date_begin=strtotime('this Friday');
$nbrweek=52;
// call function
$result=nextWeeksDay($date_begin,$nbrweek);
// Insert
//$date1=date('Y-m-d', $date_begin);
for($i = 1; $i <= $nbrweek; $i++)  {
//$date=$result[$i];
echo $result[$i]."<br/>";
}

[/php]
My problem is that when I alter the code to try and get the date for every second Friday for the next year the script freezes.

Code: [Select]
[php]
//function
function nextWeeksDay($date_begin,$nbrweek)
{
$nextweek=array();
for($i = 2; $i <= $nbrweek; $i+2)  { // 52 week in one year of course
$nextweek[$i]=date('Y-m-d', strtotime('+'.$i.' week',$date_begin));
}
return $nextweek;
}
/// end function
/// example of a select date
// var
$date_begin=strtotime('this Friday');
$nbrweek=52;
// call function
$result=nextWeeksDay($date_begin,$nbrweek);
// Insert
//$date1=date('Y-m-d', $date_begin);
for($i = 2; $i <= $nbrweek; $i+2)  {
//$date=$result[$i];
echo $result[$i]."<br/>";
}

[/php]
I really don't understand why??  Does anyone know why?

Thanks

Hi,

I want to calculate the future month, i have used following code to calculate the date
$date = date('Y-m-d',strtotime(date("Y-m-d", strtotime('2010-01-31')) . " +3 month"));

It gives me 2010-03-03

But i need to get 2010-02-28

OR just month is enough like 2010-02

Thank you
Nikhil

Hello!

I've managed to solve that the content is shown AFTER 6 hours when added to the SQL. But I want to add many things on the same (current time) but I don't want everything to pop up after 6 hours. I want a 6 hour delay on EACH content I add. How do I solve this?

Here is my code:


$six_hours_ago = time() - 21600;
$sql = "SELECT * FROM Trailers WHERE Genre LIKE '%".$_GET['show']."%' AND time < '".$six_hours_ago."' ORDER BY `Trailers`.`sort` DESC";


insert.php
$sql="INSERT INTO Trailers (Poster, Title, Year, Genre, IMDB, Actors, Plot, Youtube, time)
VALUES
('".mysql_real_escape_string($_POST['Poster'])."','".mysql_real_escape_string($_POST['Title'])."','".$_POST['Year']."','".mysql_real_escape_string($_POST['Genre'])."','".$_POST['IMDB']."','".mysql_real_escape_string($_POST['Actors'])."','".mysql_real_escape_string($_POST['Plot'])."','".$_POST['Youtube']."', '".time()."')";


Thanks!

What are your feelings regarding Linux desktop distros, and their ability to break through to mainstream usage? I started using Ubuntu about 6 or 7 years ago, and have fooled around with some other distros, but at least for me Ubuntu always seemed the best. I've got my 65 year old mom using it, and my 11 year old son playing with Kubuntu (and learning python!). I don't really consider us normal though; normal being almost too dumb to do more than check email and get on the internet.   I've managed to fully switch over to Ubuntu on all of my computers, with the exception of running Windows in a VM for Photoshop and Illustrator. Since I don't use those programs every day, there are a lot of days where I don't see Windows. I never really had a problem with Windows, except for Windows 3.1 was kind of a drag. Getting on the internet on a 56K modem on Windows 95 wasn't any fun either, but that wasn't Windows' fault. I never had the crashes and bad experiences people like to claim makes Windows suck. My main reason for abandoning Windows is just to be more involved with Linux, and hopefully reach Linux guru status someday.   I really never liked Macs. I bought one 3 or 4 years ago, and it just felt like I was paying a lot of money for a glorified (and over-hyped) linux distro. I really never liked the feel of the Finder. At the time there was no awesome text editor, and I bought a couple just to test out what I could find. Unlike Windows and Linux, it seemed like nothing is free in the Mac world. I eventually gave the Mac away. We couldn't be friends.   I'd really like to see Linux become the dominant OS. It's exciting to see how far Ubuntu has come in the years that I've used it, and I evangelize for Linux/Ubuntu quite a bit. Even still, it can sometimes seem that I am a stranger in a strange world. Do you think we can count on Linux being a bigger part of mainstream computing? One of the problems I see is that there are so many distros that a person investigating Linux may be a little overwhelmed. What do you think is keeping the masses from using Linux desktops?

Hello,

I am having trouble setting a cookie with a future expiration. I am using PHP Version 5.1.6.

Here is my code:

$expire = time() + 60*60*24*30; // 30 days
setcookie("TestCookie",$value, $expire);

The cookie gets set, however, the cookie is not persistent and expires when I close my browser. This should not be the case but should expire in 30 days.

The time() is correct on the server.

Here is the raw http headers:

Status: HTTP/1.1 200 OK
Date:   Sat, 26 Mar 2011 15:12:27 GMT   
Server:   Apache/2.2.3 (CentOS)   
X-Powered-By:   PHP/5.1.6   
Set-Cookie:   TestCookie=my+cookie+value; expires=Mon, 25-Apr-2011 15:12:27 GMT   
Content-Length:   126   
Connection:   close   
Content-Type:   text/html; charset=UTF-8

However, when I open Firefox or Chrome they both say that the cookie will expire when I close the browser. I know that my browser is accepting cookies properly because I see other cookies from other websites in the cookie list that expire with future dates.

I've tried setting a cookie in the future with javascript and it works fine, like the following:

$jsExpire = date("D, j M Y H:i:s e", $expire);
echo "
<script>
<!--//
document.cookie =
'jscookie=testcookie; expires=$jsExpire; path=/'
//--></script>
";

However, when still trying to set the cookie (before headers are sent which is how php operates), php fails to set the cookie properly.

Is there any kind of setting in php ini that could effect cookie expiration dates?

Obviously it's not a browser problem since I can set cookies correctly with javascript but not php.

I even tried sending cookie with header() like this and it doesn't set in the futu

header("Set-Cookie: TestCookie=my+cookie+value; expires=Mon, 25-Apr-2011 17:26:45 GMT; path=/; domain=.mydomain.com");

Any help appreciated.

Hi,

 

I have made a database linked with php that I use a html form for.

The HTML form requests a particular date to retrieve, and the php form it is linked to then retrieves data from the MySQL database from that date.

 

My question is: I want there to be a restriction so that the retrieval can only be for dates before the present date (and certainly not any date in the future).

 

e.g. if it is 6th July 2020, then the database can only retrieve from the 5th July 2020 and before. (7th July 2020 onwards also is not allowed.)

Is there a way I can do it? Anyone who can guide me to a particular code function or something of that sort - I would be deeply grateful as my searches have not come up fruitful.

Edited July 10, 2020 by samanj
clarity

Hello guys,   I require a suggestion about how shall I proceed as when I am about to set a goal for my future in programming world, Just so that you could suggest me better, I urge you to please read about a little background history of mine.  And please stay neutral in regards of language, dont say PHP because you are a PHP developer and dont say Java because you are a Java developer.   Thanks.   I stepped into programming when I was in school (below A-levels at 14, now I am 29) and I started to bunk school and went to internet cafe and would sit there reading sources of HTML pages in year 2000. I would observe their programming styles, I would learn about the tags they used and then search internet (it was IE6 then and Yahoo searching at its peak) so I could learn about it.   Years passed, and having my family related to medical professions, I took admission in Pharmacy in University and quit after 2 years and entered working class.  My development slowed down but passion always stayed the same.   Now I am in Spain and working as a technician of mobile repairing with a company, but I still have this passion of programming and when I learn that etc etc friend of mine now is working with CISCO in Germany, now is working as a game developer in America, I become really sad. I could have been one of those. But the fact is that I am not. So I restarted again with development and started learning PHP on my work desk using online resources and tutorials and asking silly questions.   Nothing I could become but an obsolete language programmer with a mess.   Now when I havent been able to become someone, till now, I still have passion and I want to be somewhere.   ----------------------------- I am confused for some days now, shall I continue with PHP (apart from the fact that i am a MYSQL learner, haven't learned PDO or MYSQLi till now) or shall I step into Java learning, using the online resources ofCourse, but if I step into Java, It will be a fresh start and I will be able to organize it better on my way with guidance of professionals like you.   The Things confusing me: (as I am imagining in my mind)   PHP: A great web development language being used on billions of website, have an extraodinary support, well documented, World is moving online, so future is e-commerce in these terms.   JAVA: Feels a giant to me, and impresses me at times, a myth to me, I am speaking illogical I know, and after android, I see a great potential in this language.
Edited by Digitizer, 28 August 2014 - 06:03 PM.

Hi, I am trying to get the number of days between the current date and a date in the future specified by column 'end_date'. The code I have seems to be working but it displays the number of days as a negative number, how do I change this to be a positive number? I have tried simply changing $days = $now - $end_date; to $days = $end_date - $now; but that doesn't work as I thought it would! Thanks in advance..

Code: [Select]
$now = time();
      $end_date = strtotime($row['end_date']);
      $days = $now - $end_date;
      echo floor($days/(60*60*24));

I was wondering if there was a way to have the MAX function NOT return a Date that is more than 2 days into the future (from the current day)?  If there is a Date that is more than 2 days into the future I would like to return the one closest to the current day.  Here is the code I have:

Code: [Select]
<?php

mysql_connect("local", "xxx", "xxx") or die(mysql_error());
mysql_select_db("pricelink") or die(mysql_error());



// Get a specific result from the "ft9_fuel_tax_price_lines" table
$query ="SELECT ItemNumber,TableCode,Cost, MAX(`Date`) as `max_date`, MAX(`Time`) as 'max_time' FROM `ft9_fuel_tax_price_lines`
         GROUP BY `ItemNumber`,`TableCode`";

$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>ItemNumber</th> <th>TableCode</th> <th>Date</th> <th>Time</th> <th>Cost</th> </tr>";


// keeps getting the next row until there are no more to get
while($row=mysql_fetch_array($result))
{

// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['ItemNumber'];
        echo "</td><td>";
        echo $row['TableCode'];
        echo "</td><td>";
        echo $row['max_date'];
        echo "</td><td>";
        echo $row['max_time'];
        echo "</td><td>";
        echo $row['Cost'];
echo "</td></tr>"; 


} 

echo "</table>";
?>

Any help would be appreciated.
Thanks!

I want to set a never expire date, so I figured I would set the date 99 years into the future.  No dice.  After trial and error, it appears you can only make it 25 years into futu

date("Y-m-d",strtotime("+25 years"));

I wonder if it is the absolute date, or the number 25.  If it is the maximum date (i.e. nothing after 2035) then I will have a problem with this code next year!

I was trying to prevent bottlenecks when sending emails, and the below post was the solution.

Similar predicament now, but I also need to generate some images first so they may be attached to the emails and the images are generated by a fairly slow command line program that emulates a browser.  Multiple emails might or might need the same image so I plan on creating all the images before queuing the emails.

I believe the futureTick approach executes each tick in series as blocking, but doesn't attempt to execute all of them at once so it doesn't impact the rest of the application.  Promises, however, appear to be more about a structured process for managing callback functions.  As such, the futureTick approach would likely be best for tasks requiring much PHP processing, and promises are more suitable for tasks which PHP is just waiting for a response from some other service.  True?

Would one ever want to attempt to use both approaches?  Seems like it might make sense if the code within a promise was PHP intensive to break it down into multiple futureTick tasks, but not not feed promises into the futureTick as promises are "kind of" non-blocking, true?

To execute the CLI image program, considering https://github.com/clue/reactphp-shell.  Or do you think plan old exec() would be applicable?

For using promises, would it just look something like the following?

$deferred = new React\Promise\Deferred();

$deferred->promise()
->then(function ($rs) {
    // create the first image
})->then(function ($rs) {
    // create the second image
})->then(function ($rs) {
    // create the last image
})->then(function ($rs) {
    // send the first email
})->then(function ($rs) {
    // send the second email
})->then(function ($rs) {
    // send the last email
});

$deferred->resolve($nothing?); 

Or maybe something like the following?  I would be amazed if it works as is, but hopefully is on the right track.

$deferred = new React\Promise\Deferred();
$deferred->promise()
->then(function ($rs) {
    // Create images
    // See https://github.com/clue/reactphp-shell
    $launcher = new ProcessLauncher($loop);
    $shell = $launcher->createDeferredShell('bash');

    $shell
    ->execute('create the first image')
    ->execute('create the second image')
    ->execute('create the lst image')
    
    ->then(function ($rs) use($loop) {
        // Send emails
        // Just showing this way but will actually use kicken's EmailQueue solution
        $loop->futureTick(function () {
            // send the first email
        });
        $loop->futureTick(function () {
            // send the second email
        });
        $loop->futureTick(function () {
            // send the last email
        });
    });
});

$deferred->resolve($someQueueOfImages?); 

 

My query is a fixtures list for my local sports team- There seems little point including fixtures from the past as they are in a results query anyway.
I'm ordering by date (see below) but how can I remove the ones already past?

$query = "SELECT * FROM fix10 ORDER BY Date";

TIA Nick

Hi,
So I only want my users to be able to perform certain tasks each 12 hours.
This is the code I use:
Code: [Select]
function canVote($ip, $vote_id, $updateTimer = true){
$time = date("Y-m-d H:i:s");

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->from('votes_voters');
$count =  $this->CI->db->count_all_results();
/*$count = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->from('votes_voters')
-count_all_results();*/

$row = $this->CI->db
->where('vote_id =', $vote_id)
->where('user_ip =', $ip)
->get('votes_voters')
->row();

if($count == 0){
$data = array(
   'vote_id' => $vote_id,
   'user_ip' => $ip,
   'last_vote' => $time
);

$this->CI->db->insert('votes_voters', $data);
return true;
}
else{
$last_vote = $row->last_vote;
if($last_vote + strtotime("12 hours") < $time){
return false;
}
else{
if($updateTimer = true){
$data = array(
               'last_vote' => $time,
            );

$this->CI->db->where('vote_id', $vote_id);
$this->CI->db->where('user_ip', $ip);
$this->CI->db->update('votes_voters', $data);
}
return true;
}
}
}
Apparently the failing bit is this:
Code: [Select]
if($last_vote + strtotime("12 hours") < $time){
return false;
}
I believe you can guess what I'm trying to do here, if variable 1 + 12 hours is smaller than variable 2, then return false.
Any help is much appreciated.

Hey guys,

What I'm trying to do is set 2 dates.  Today's date and then a date 14 days from now.  However, I want it to increase the month if by adding 14 days will bring me to the next month, same with the year.

I have this, but it doesn't increment the month or year.

$week = mktime(11, 59, 59, date("m"), date("d")+14, date("y"));
$date =  date("Y-m-d H:i:s", $week);