Awards

[Xtremer360]

So inside my custom CMS i'm developing I have a module that controls various things like adding/editing awards, adding/editing award shows, and viewing voteCounts for the awardshows and for the individual nominees. Now the question I have is if there is a way without having to have the user make input to close the voting to have it actually close it by itself.

[xyph]

Use timestamps!

 

If you want the vote to close in 30 days, simply have a close date stored in an sql database, or as a unix timestamp in a flat file.

 

Before someone can vote, check the current date, if it's AFTER the close date, don't allow it!

[Xtremer360]

Okay is it possible to have something like

 

$year = date('Y');

 

then do on the insert statement :

 

$Y-12-31

[xyph]

I'm assuming you mean

 

$year-12-31

 

And yes, you can.

[Xtremer360]

Unless there's a date function I'm unaware of that will find the last day of the current year.

[Xtremer360]

Well I tried this and no matter what it puts the value into that dateExpires as 0000-00-00

 

$year = date('Y');       
        $query = "INSERT INTO `awardsShows` 
                (awardsDate, statusID, creatorID, dateCreated, dateExpires) 
            VALUES 
                ('".$date."','".$statusID."','".$userID."', NOW(), '".$year."'-12-31)";
        mysqli_query($dbc, $query);
        $result = "good";

[incubi1]

Try putting your date together before the query.

 

 

$year = date('Y');     

$year .= "-12-31";

 

        $query = "INSERT INTO `awardsShows`

                (awardsDate, statusID, creatorID, dateCreated, dateExpires)

            VALUES

                ('".$date."','".$statusID."','".$userID."', NOW(), '".$year."')";

        mysqli_query($dbc, $query);

        $result = "good";

[xyph]

'".$year."'-12-31

 

should have been

 

'".$year."-12-31'

 

And I'm assuming that 12-31 will ALWAYS be the last day of any given year