PHP - Php Unix Timestamp To Date

I have a little problem with creating a timestamp and display it again with date ()
Here is a small shript:
<?php
   $day = 6;
   $month = 7;
   $year = 1985;
   $ts = mktime($month, $day, $year);
   echo date("d-m-Y",$ts);
?>

In my world would result in 6-7-1985
but instead I get 06-11-2010

Why .. what am I doing wrong?

POSTBIL.COM

Hi am trying to add date and timestamp of when a comment gets posted.Am not gr8t at php but still learning.
If any one can help me on this would be reil gr8t.
Sry for the long post.
As for now i have this Code: [Select]
$date = date("M j, y, g:i a"); and echo's out the date, time [/code]$date[/code] as in the current date and time which i dont want.


Code: [Select]
<?php
$query = yasDB_select("SELECT * FROM newsblog");
if($query->num_rows == 0) {
echo '<div id="newsblog_text">This news blog has no comments, become a member and be the first to add one!</div>';
} else {
$query = yasDB_select("SELECT * FROM newsblog WHERE userid = '$id'");
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$date = date("M j, y, g:i a");
$text = $row['comment'];
$text = str_replace(':D','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/biggrin.gif" title="biggrin" alt="biggrin" />',$text);
$text = str_replace(':?','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/confused.gif" title="confused" alt="confused" />',$text);
$text = str_replace('8)','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/cool.gif" title="cool" alt="cool" />',$text);
$text = str_replace(':cry:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/cry.gif" title="cry" alt="cry" />',$text);
$text = str_replace(':shock:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/eek.gif" title="eek" alt="eek" />',$text);
$text = str_replace(':evil:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/evil.gif" title="evil" alt="evil" />',$text);
$text = str_replace(':lol:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/lol.gif" title="lol" alt="lol" />',$text);
$text = str_replace(':x','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/mad.gif" title="mad" alt="mad" />',$text);
$text = str_replace(':P','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/razz.gif" title="razz" alt="razz" />',$text);
$text = str_replace(':oops:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/redface.gif" title="redface" alt="redface" />',$text);
$text = str_replace(':roll:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/rolleyes.gif" title="rolleyes" alt="rolleyes" />',$text);
$text = str_replace(':(','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/sad.gif" title="sad" alt="sad" />',$text);
$text = str_replace(':)','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/smile.gif" title="smile" alt="smile" />',$text);
$text = str_replace(':o','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/surprised.gif" title="surprised" alt="surprised" />',$text);
$text = str_replace(':twisted:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/twisted.gif" title="twisted" alt="twisted" />',$text);
$text = str_replace(':wink:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/wink.gif" title="wink" alt="wink" />',$text);
echo '<div class="newsblog_box1"><div class="newsblog_name">' . $row['name'] . ' '.$date.'</div></div>
<div class="newsblog_box2">' . $text . '</div>';
}
}?> 

I'm having a weird issue going on, I'm wondering if it has to do with my php.ini or server setup, anyway here is the code with the odly outcomes:

Code: [Select]
echo date('Y/m/d H:i:s', 2145000000);
// 2037/12/21 01:20:00

echo date('Y/m/d H:i:s', 2149000000);
// 1901/12/31 01:58:24

echo date('Y/m/d H:i:s', 2150000000);
// 1902/01/11 15:45:04

It seems after year 2037 it goes down to 1900+... Why would this happen? I've tried on 2 godaddy servers and local host and all same result

Following on from my problem with another Google Chart which jay0316 kindly helped with, I have another issue which I am hoping that someone might be able to help me with.   I am trying to put together a site for my wife to manage her diabetes and insulin intake. We want to monitor her blood/sugar glucose over periods of time (but with notes that she includes that can help monitor reasons for outlying results such as illness), so I am trying to include a Google Annotation Chart to do this, drawing on blood/glucose readings stored in a Database.   Where I am struggling at the moment is converting timestamps into information that I can include in the chart.   What I currently have at the moment (which obviously isn't working) is:

<script type="text/javascript" src="https://www.google.com/jsapi?autoload={'modules':[{'name':'visualization','version':'1','packages':['annotationchart']}]}"></script>
      <script type='text/javascript'>
      google.load('visualization', '1', {'packages':['annotationchart']});
      google.setOnLoadCallback(drawChart);
      function drawChart() {
        var data = new google.visualization.DataTable();
        data.addColumn('datetime', 'Date');
        data.addColumn('number', 'Readings');
        data.addColumn('string', 'Notes');
        data.addRows([
		<?php

$annotate=DB::getInstance()->query("SELECT * FROM tabbyhealth WHERE reading!=0");

I have a simple mysql database holding information about an image upload including its 'name' and 'date uploaded' [current_timestamp()] to a folder 'image'

I then display it into a table using the php ‘foreach’ facility.

I want the date to be displayed in the ‘dd/mm/yyyy’ format.  not the default yyyy/mm/dd.

Here is the relevant code

<?php

 $conn = mysqli_connect("localhost", "root", "", "dbname");

  $results = mysqli_query($conn, "SELECT * FROM tablename");

  $image = mysqli_fetch_all($results, MYSQLI_ASSOC);

?>

<?php foreach ($image as $user): ?>

<td><p>NAME</p><?php echo $user['name']; ?></td>

<td><p>COMMENT</p><?php echo $user['comment']; ?></td>

<td><p>DATE</p><?php echo $user['date']; ?></td>

What do I need to do?

THANKS- Warren

OK So I've got a datepicker that sends a date in d/m/y format. My DB stores the data in Unix Timestamp Which I can convert the date to with strtotime however this does the exact date & time.

All I want is the actual day. I've spent hours trying to convert this with just the day with mixed results...

Thanks.

How do you execute commands on Unix box using a PHP script?

Hi,
I am in the process of switching over to a  unix server,
and I found the dir program I use in development now sorts the unix way by date
 !
MySQL client version 5.1.52
PHP  latest

Below in my script how do I change the output to sort by name please

<html>
<head>
<title>DIR</title>
</head>
<link rel="stylesheet" type="text/css" href="../../css/tableLL.css">
<body>
<?php

function humansize($size) {

    $kb = 1024;         // Kilobyte

    $mb = 1024 * $kb;   // Megabyte

    $gb = 1024 * $mb;   // Gigabyte

    $tb = 1024 * $gb;   // Terabyte

        if($size < $kb) return $size."B";

    else if($size < $mb) return round($size/$kb,0)."KB";

    else if($size < $gb) return round($size/$mb,0)."MB";

    else if($size < $tb) return round($size/$gb,0)."GB";

    else return round($size/$tb,2)."TB";

}

// get local directory path

$path= dirname($_SERVER['SCRIPT_FILENAME']);

?>

<h3>Files in <?php print $path; ?>:</h3>

<ul>

  <?php

$d = dir($path);

$icon = '';

while (false !== ($entry = $d->read())) {

    if ( substr($entry, 0, 1)=='.' ) continue;

    // get size

    $size = filesize($path.'/'.$entry);

    $humansize = humansize($size);

    // find filename extension

    $dotpos = strrpos($entry, '.');

    if ($dotpos) {

        $ext = substr($entry, $dotpos+1);

        if ($ext === 'jpeg' || $ext === 'gif' || $ext === 'png') {

            $icon = "<img src='$entry' style='width: 48px; height: auto; vertical-align: text-top;' alt='icon' title='$entry' />";

        }

    }

    print "<li><a href='$entry'>$entry</a> ($humansize) $icon</li>\n";

    $icon= '';
}

$d->close();

?>

</ul>

<hr width="100%">


I do hope someone can help

Regards
Topshed

Why doesn't this code work...

echo '<p>time() = ' . time() . ' seconds</p>';
echo '<p>$lastActivity = ' . $lastActivity . '</p>';
echo '<p>Seconds Active: ' . time() - $lastActivity . ' seconds</p>';

...where $lastActivity comes from my database.


When I run my script I see...
Quote

time() = 1331187131 seconds

$lastActivity = 1331186745
-1331186745 seconds


The last line is dropping the label and there is now Date Math?!


Debbie

After doing some reading im trying to make sure I understand how all this time stuff works with using sql

I have a Session created for users that uses

$_SESSION['login_time'] = time();

when I echo that it comes up as
1324245123. so the reason it looks like that is because that is what UNIX looks like?

So thats why this code doesnt work

if ($get1['date'] > strtotime('-1 minutes')) {

because the date im getting from $get1 is a sql time stamp and the strtotime is UNIX and they dont match
do I understand this right?

Hi,
I have switched to a unix server from a windows one and my  dir.php now displays in date order which makes things very hard to find

Below is the code I use, can anyone tell me what to put, and where ? to make it sort by file name, or point me to a freeware script that has already invented the wheel so to speak.


<?php
function humansize($size) {
    $kb = 1024;         // Kilobyte
    $mb = 1024 * $kb;   // Megabyte
    $gb = 1024 * $mb;   // Gigabyte
    $tb = 1024 * $gb;   // Terabyte
    if($size < $kb) return $size."B";
    else if($size < $mb) return round($size/$kb,0)."KB";
    else if($size < $gb) return round($size/$mb,0)."MB";
    else if($size < $tb) return round($size/$gb,0)."GB";
    else return round($size/$tb,2)."TB";
}
$path= dirname($_SERVER['SCRIPT_FILENAME']);
?>
<h3>Files in <?php print $path; ?>:</h3>
<ul>
  <?php
$d = dir($path);
$icon = '';
while (false !== ($entry = $d->read())) {
    if ( substr($entry, 0, 1)=='.' ) continue;
    $size = filesize($path.'/'.$entry);
    $humansize = humansize($size);
    $dotpos = strrpos($entry, '.');
    if ($dotpos) {
        $ext = substr($entry, $dotpos+1);
        if ($ext === 'jpeg' || $ext === 'gif' || $ext === 'png') {
            $icon = "<img src='$entry' style='width: 48px; height: auto; vertical-align: text-top;' alt='icon' title='$entry' />";
        }
    }
    print "<li><a href='$entry'>$entry</a> ($humansize) $icon</li>\n";
    $icon= '';
}
$d->close();
?>


Please help an old fellow who should know better
Regards
Topshed

What needs to be changed to make this work...
Code: [Select]
// Build query.
$q2 = "UPDATE member
SET logged_in=?,
last_activity=time(),
updated_on=NOW()
WHERE id=?
LIMIT 1";

Apparently PHP doesn't like time()   


Debbie

Hi

I have been googling really hard and haven't found any satysfying solution except http://www.phpfreaks.com/forums/php-coding-help/open-and-get-contents-of-a-word-document-with-php/

Do you know any PHP class to play with *.doc (up to 2003) files on Linux server? COM is nice but only on w1ndows

Thanks in advance
Tom

Code: [Select]
for ($z=1;$z<=30*365; $z++)
{
$bal[date('Y-m-d', strtotime("+ ". $z ." days"))] = $balance;//the balance of loan here.;
}

As you can see Im working on loading the daily balance of a 30 year loan in an array.

The code goes to hell in the year 2038.  I have scoured the internet for help.  I have gone to the wikipedia link and have looked at other posts but there isn't quite something that can help me.  How can I load dates beyond 01-18-2038 into my array?

I have heard of ways to do it with MySQL and the DATETIME() function, but that doesn't seem to make sense for what I am trying to accomplish.

Please point me in the right direction.

Thanks.

Hello. I have a mysql database with an 'entrytime' field which contains the unix timestamp the record was added.

How do I create a mysql query to select all records for a given month/year?

For example, if I wanted to create a query to display all records for October 2010 how do I go about it?

I am at a loss and can't find my answer via google. Thanks in advance for any help!