PHP - Date Not Posting...

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

Alright, I have a Datetime field in my database which I'm trying to store information in. Here is my code to get my Datetime, however it's returning to me the wrong date. It's returning:
1969-12-31 19:00:00

$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
$phpdate = strtotime( $mysqldate );
echo $mysqldate;


Is there something wrong with it?

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, 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]";
}
?>

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]

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 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,

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

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.

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 doing a form that posts values to XML, and i don't know how.

can someone help me with a quick lesson in passing variables/XML data? i don't even know what question to ask, actually -

the XML format i've been given is:
Code: [Select]

<?xml version="1.0" encoding="UTF-8"?>
<lead>
    <innerNode></innerNode>
    <last_name>Smith</last_name>
    <first_name>John</first_name>
</lead>


and what i've come up with so far is this, but i don't even know if i'm on the right track:

Code: [Select]


$last_name = $_REQUEST['l_name'];
$first_name = $_REQUEST['f_name'];


$url = "http://url.com/leads";

$post_string = '<?xml version="1.0" encoding="UTF-8"?>
<lead>
    <innerNode></innerNode>
    <last_name>'.$last_name.'</last_name>
    <first_name>'.$first_name.'</first_name>
</lead>';


$header  = "POST HTTP/1.0 \r\n";
$header .= "Content-type: text/xml \r\n";
$header .= "Content-length: ".strlen($post_string)." \r\n";
$header .= "Content-transfer-encoding: text \r\n";
$header .= "Connection: close \r\n\r\n";
$header = $post_string;

$ch = curl_init();
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, 4);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, $header);

$data = curl_exec($ch);

if(curl_errno($ch)) {
    print curl_error($ch);
} else {
echo "yay";
    curl_close($ch);
}

i'm being told "should return a response.xml with either a success or failure post status." which is confusing me

can someone help a bit?

thanks very much...

GN

hello, i have a while loop that displays multiple tables of data depending on how many are in the database... i have a link if you click it will redirect to another page that prompts you to save an xls file with the table data... this was all working for me before when i had the while loop display rows of data in one table...well i decided that i would like the while loop to display a separate table each time... when i changed it... the xls file only shows one table of data... how can i set up so it will export all tables of data... is there some kind of loop i can set up for it to append the tables??

i have the table data all in a variable $table which i put into a hidden form field that redirects to the xls export page.... any help is appreciated...   

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Admin</title>



</head>

<body>

<?php





$sql= mysql_query("SELECT * FROM programs")
           or die (mysql_error());

while($row = mysql_fetch_array($sql)){

$table =

"<table border='1' width='600' style='border-collapse:collapse;'>" .
"<th colspan='4'>Programs</th>" .
"<tr>" .
"<td>ID</td>" . 
"<td>Views</td>" .
"<td>Enabled</td>" .

"</tr>";




$prog_titles = $row['titles'];


$prog_titles = explode(',' , $prog_titles);








$table .=

 "<tr>" .
 "<td>".$row['id']. "</td>" .
 "<td>".$row['views']. "</td>" .
 "<td>".$row['enabled']. "</td>" .  
 "<td></td>" .
 "</tr>" .







 "<tr>" .
 "<td>Title ID</td>" .
 "<td>Name</td>" .
 "<td>Description</td>" .
 "<td>Image</td>" .
 "</tr>" ;
 






foreach ( $prog_titles as $title ) {

$sql2= mysql_query("SELECT * FROM titles WHERE title = '$title' ");
$row2 = mysql_fetch_array($sql2);


$table .=

 "<tr>" .
 "<td>" . $row2['id'] . "</td>" .
 "<td>" . $row2['title'] . "</td>" .
 "<td>" . $row2['description'] . "</td>" .
 "<td>". "<img width='50px' src='images/" . $row2['img'] . "'/></td>" .
 "</tr>" ;



} // close foreach

$table .=
 "</table>";
 
 
 
 echo $table;
 echo "<br /><br /><br />";
 
  
 
 
} // close while


 
?>

<br />
<br />

<FORM action="export.php">
<INPUT type="submit" value="Export to XLS"> 
<INPUT type="hidden" value="<?php print $table;?>" name="export">
</FORM>


</body>
</html>

the code is in a form whose method = "post".
i have failed to echo $r_in. i eed help on this.

$lowest_time = 30 - 14;
$adder = 2*5*9;

echo   '<table width="526" border="0"><tr>
      <td width="169">
      <input type="text" name="$r_in" value="'.$lowest_time.'"  style="width:169px" readonly="readonly" class="text_non_color"/></td>
      <td width="169">
      <input type="text" name="$r_out" value="'.$adder.'"  style="width:169px" readonly="readonly" class="text_non_color"/></td>
      </tr></table>';