PHP - What Will Be The Best Way To Store Date?

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks

(continuing from topic title)
So if I set a date of July 7 2011 into my script, hard coded in, I would like the current date to be checked against the hard coded date, and return true if the current date is within a week leading up to the hard coded date.

How could I go about doing this easily?

I've been researching dates in php but I can't seem to work out the best way to achieve what I'm after.

Cheers
Denno

Hi guys, I'm putting together a small event system where I want the user to add his own date and time into a textfield (I'll probably make this a series of drop-downs/a date picker later).
This is then stored as a timestamp - "0000-00-00 00:00:00" which displays fine until I try to echo it out as a UK date in this format - jS F Y, which just gives today's date but not the inputted date.



Here's the code I have right now:

Code: [Select]
$result = mysql_query("SELECT * FROM stuff.events ORDER BY eventdate ASC");

echo "<br />";
echo mysql_result($result, $i, 'eventvenue');
echo ", ";

$dt = new DateTime($eventdate);

echo $dt->format("jS F Y");


In my mysql table eventdate is set up as follows:
 
field - eventdate
type - timestamp
length/values - blank
default - current_timestamp
collation - blank
attributes - on update CURRENT_TIMESTAMP
null - blank
auto_increment - blank


Any help as to why this could be happening would be much appreciated, thanks.

I'm getting this Time Zone error.
Perhaps it's a compatibility issue with PHP 5.3. Looked all over for an answer without finding one.
Here is the error message


Warning: date() [function.date]: It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone_set() function.
In case you used any of those methods and you are still getting this warning,
you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST'
instead in /blocked.php on line 41
12/02/12

Here is the code. Line 41 is near the bottom, the one with the d,m,y.  Perhaps the echo date (d/m/y") needs to be changed. Appreciate any help!

Code: [Select]
   <table border="3" width="16%" align="center" cellspacing="0" bgcolor="#FF6600" bordercolor="red" bordercolordark="red" bordercolorlight="red">
                            <tr>
                                    <td width="176">

                                            <p align="center"><?php // shows IP Number on Page
            echo $ip; ?> </p>

                                    </td>
                            </tr>
                    </table>
                    <p align="center"><?php // Show the user agent
        echo 'Your user agent is: <b>'.$_SERVER['HTTP_USER_AGENT'].'</b><br />';?></p>
                    [b]<h1 align="center"><?php echo date("d/m/y");?></h1>[/b]
            </td>
    </tr>
</table
[,code]

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.
Any one know how to write this code?
Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>

Hi Guys..

How can I change a date on the fly ?
Everything is UTC on my server.

How can I change a date to something else on the fly?

Ie:

$timezone = "cet";
$datetime = "2011-09-04 19:53:00";

echo $datetime($timezone);

So I can give it a datetime and have it echo the datetime as if it were in the other timezone?

Thanks
Graham

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.

i have a table that shows payments made but  want to the payments only showing from a set date(06/12/14) and before this date i dont want to show   this is my sql that doesnt seem to work and is showing dates before the specified date. .

"SELECT * FROM payments2014, signup2014, editprop2014 WHERE signup2014.userid = payments2014.payment_userid AND editprop2014.prop_id = signup2014.prop_id AND signup2014.userid !='page1' AND signup2014.userid !='page6' AND signup2014.userid !='page4' AND payments2014.payment_transaction_status !='none' AND payments2014.payment_transaction_status !='CANCELLEDa' AND payments2014.payment_type !='deposit' AND payments2014.payment_paid_timestamp NOT LIKE '%2012%' AND payments2014.payment_paid_timestamp NOT LIKE '%2011%' AND payments2014.payment_paid_timestamp >= '06/12/14' ORDER BY payments2014.payment_id DESC"

i have some other parts in the statment but this one that should be filtering is 

host_payments2014.payment_paid_timestamp >= '06/12/14' 

thanks in advance

Hi,

I am trying to convert a String date into numeric date using PHP function's, but haven't found such function.
Had a look at date(), strtotime(), getdate();

e.g. Apr 1 2011  ->    04-01-2011

Could someone please shed some light on this?

Regards,
Abhishek

Well, I am storing some of images on my server, but I have to type in the name myself which gets a bit boring and I may overwrite an old image by accident, so, I was thinking of having mysql auto increment the image names. But will this be suitable for images, or should it be text.

Hi, I want to maintain users who log in a webpage and each time they leave, I want to record the current time, so this sounds silly but do I just set in my db table in a field that tracks a user's last log in with DEFAULT: CURRENT_TIMESTAMP?

db structu
user_id   lastActivity  lastSession (stores TIMESTAMP of last time user logged in)

Any help much appreciated

It seems that in the following script I am not able to make $page contain some values as it always acts as it contains 0.
The script will give you more idea about what I wanna do with it.
Code: [Select]
<?php
include('dbinfo.inc');
session_start();
$connect= mysql_connect($host,$dbuser,$password) or die("connect to database fails");
mysql_select_db($dbname, $connect);
//This will set the number of messages we want to display on each page
$rows_per_page = 5;
function show_msg()
{
echo "<tr align='center'>
<td>$row[message]</td>
</tr>
<tr><td><strong>Sent By: $_SESSION[username] ON Date: $row[date]</strong></td></tr>
<tr><td></td></tr>";
}
//This will set the necessay variables required to set the page layout
function page_vars()
{
$sql = "select * from msgs";
$result = mysql_query($sql, $connect);
$numrows = mysql_num_rows($result);
$total_pages = ceil($numrows/$rows_per_page);
//Check whether page is given or not
if(isset($_GET["page"]))
{
$page = $_GET["page"];
}
else
{
$page = 1;
}
if($page < 1):
{
$page = 1;
}
elseif($page > $total_pages):
{
$page = $total_pages;
}
endif;
}
if($_SESSION[loggedin] == TRUE && $_SESSION[actype] == lecturer)
{
echo "<form action='postmsg.php' method='POST'>";
echo "<table width='80%' border='1'><tr align='center'><td><strong>To send a new message type it in the below box and press SUBMIT</strong>
</td></tr>";
echo "<tr align='center'>
<td><textarea name='msgarea' cols='40' row='5'></textarea></td>
</tr>
<tr align='center'>
<td><input type='submit' value='Send Message' /></td>
</tr>
</table>";
$limit .= 'LIMIT '.($page - 1)*$rows_per_page.', '.$rows_per_page;
echo $limit;
$sql = "select * from 'msgs' $limit";
$result = mysql_query($sql);
echo "<table width='80%' border='1'>";
$row = mysql_fetch_assoc($result);
while($row)
{
show_msg();
}
}
else
{
page_vars();
$limit .= 'LIMIT '.($page - 1)*$rows_per_page.', '.$rows_per_page;
$sql = "select * from msgs $limit";
$result = mysql_query($sql,$connect);
echo "<table width='80%' border='1'>";
while($row = mysql_fetch_assoc($result))
{
show_msg();
}
echo "<tr align='center'>
<td>
<a href='$_SERVER[php_self]?page=1'>First Page</a>
<a href='$_SERVER[php_self]?page=($page - 1)'>$page</a>
<a href='$_SERVER[php_self]?page=$page'>$page</a>
<a href='$_SERVER[php_self]?page=($page + 1)'>$page</a>
<a href='$_SERVER[php_self]?page=($total_pages)'>>>>Last Page</a>
</td>
</tr>";
echo "</table>";
}
?>
now when i echo $limit it always shows "-5, 5" , that's not what i want from this script.
Instead I want limit to store "0, 1" with the same concept not direct because it will change according to what $_GET[page] holds.

Hope I will get the solution here....

how do i get a drop down value and store it in a another table
as of now i am getting the value from one table showing it on drop down now once that is selected i need to insert it into another table.

<html>
<?php

mysql_connect('localhost','root','') or die('Could not connect to mysql ' . mysql_error());
        mysql_select_db("dbtest") or die(mysql_error());

if(isset($_POST['submit'])) { //$name=$_POST['val'];
$id = $_POST['select'];
          $id=$row['name'];
?>
<input type="text" name="name2" value="<?php echo $row['name'] ?>"><br />
       <?php
      $query = "INSERT INTO sub (`sub`) values('" . $id . "')";
            $result = mysql_query($query);
                 
if($query) {                       
echo "query executed";         
}

    
    } 
    ?>

<form id="name" action="<?php $_POST['SERVER_SELF'] ?>" method="POST" >
<input type="text" name="name1"><br />
<select name="select" id="select">
<?php
$query = "SELECT name,id FROM main"; 
            $result = mysql_query($query);
            
if($query) {  
                while($row = mysql_fetch_array($result)) {
$options .= '<option value="' . $row['name'] . '">' . $row['name'] . '</option>';
        //  $out .= "<option value=\" . $row['name'] . \" >' . $row['name'] . '</option>";    
}
}

echo $options;
?>

</select>

<input type="submit" name="submit1">
</form>

</html>

Thanks the above seem to work.

Hi,    I am building a website that will contain listings, there will be a categories page which will bring the user to the subcategories for that category then the user can see all listings linked to that subcategory. At the minute I am just linking each page using basic href tags to go to the page name.php and all my pages end up being homepage.com/clickedlink.php.    How do I change my URL's so that if i click on a certain category the url changes to page name.php?category=chosen category?   Thanks