PHP - Time - Show Days Left To A Timestamp

Hi all.
I have an issue and don't know how to go about it. I have a table that contains user orders. I want to move only orders that will be due in 10 days time to another table. How can I achieve that?

thanks

hey guys im wondering how you would add or takeaway a hour from a timestamp in a database when trying to select it please?   thank you

I have a string in php:
Quote

Sat, 28 Apr 2012 05:09:45 GMT

I want to convert it to timestamp
Example: 1335594473

I have to two variables $cronlast and $cronnow in my php code.
I need to have the time 7am of previous day in $cronlast variable and  7am today in $cronnow variable.
I need the time in UNIX timestamp format.
So everyday when I print the variable I should have:

$cronlast=7am Yesterday(in Unix Timestamp)
$cronnow=7am Today(in Unix Timestamp)

I would appreciate any help.

How to output a MySQL timestamp field to correct local time with daylight saving with PHP?   Local time is set in php.ini with: date.timezone = "Europe/London"   Confirmed set with:   <?php echo date_default_timezone_get(); ?>   But when I echo the timestamp field it does not display correct UK time for the record (an hour behind correct UK time).   <?php echo date('jS F Y - g:ia', strtotime($row['Date'])); ?>  

I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith.

The cookie doesn't show if I go to that url page. But it does show up once I reload the page.  So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page?

Here is my code.

// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);

if(!empty($url_ref_name)) {

  $number_of_days = 365;
  $date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
  setcookie( "ref", $url_ref_name, $date_of_expiry,"/");

} else if(empty($url_ref_name)) {
  if(isset($_COOKIE['ref'])) {
    $user_cookie = $_COOKIE['ref'];
  }
} else {}

// This is for the sign up form
if(isset($_COOKIE['ref'])) {
  $user_cookie = $_COOKIE['ref'];
  ?>
  <fieldset>
    <label>Referred By</label>
    <div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
    <input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
  </fieldset>
  <?php
}

 

I have collected some data from .xml api's and I need to manipulate it in a way to display something specific.   not my strongest point when it comes to maths & date data.   so ultimately I need it to echo something like the following:   "3 Days 4 Hours Remaining" or "14 Hours Remaining" (if below 24 hours!!!)   I use the following to pull my variables and to test by echo results.

	<?php  // Calculate total Fuel blocks
		$itemID = $record['itemID']; 
		$result = mysql_query("SELECT * FROM `ecmt_poslistdetails` WHERE itemID = '$itemID' AND (typeID='4051' OR typeID='4247' OR typeID='4246' OR typeID='4312')");
		$row = mysql_fetch_array($result);
		$fuelQty = $row[quantity]; 
		echo $fuelQty; 
	?>
        <br />
	<?php // Calculate total Fuel blocks used per hour
		$typeID = $record['typeID']; 
		$result = mysql_query("SELECT * FROM `ecmt_posfuel` WHERE typeID = $typeID");
		$row = mysql_fetch_array($result);
        $fuelUse = $row['fuel'];
		echo $fuelUse;
	?>

this gives me:   $fuelQty & $fuelUse   so for instance if fuel quantity is: 18480 and $fuelUse is: 40   the fuel used is 40x per hour and time remaining would be 462x Hours remaining but I want it to display: 19 Days 6 Hours Remaining   how can I achieve this format?

Hey guys only thing i can find online is examples of showing how much time is left until a predetermind time.

but what I need is how many minutes are left until the next hour hits

anyone have any ideas on this? Im wanting to do it in UNIX time

I found this function and take no credit for it, I'm trying to get it to show HH:MM:SS when I have the total number of seconds, but nothing is showing on the screen

  function sec2hms ($sec, $padHours = false) 
  {

    // start with a blank string
    $hms = "";
    
    // do the hours first: there are 3600 seconds in an hour, so if we divide
    // the total number of seconds by 3600 and throw away the remainder, we're
    // left with the number of hours in those seconds
    $hours = intval(intval($sec) / 3600); 

    // add hours to $hms (with a leading 0 if asked for)
    $hms .= ($padHours) 
          ? str_pad($hours, 2, "0", STR_PAD_LEFT). ":"
          : $hours. ":";
    
    // dividing the total seconds by 60 will give us the number of minutes
    // in total, but we're interested in *minutes past the hour* and to get
    // this, we have to divide by 60 again and then use the remainder
    $minutes = intval(($sec / 60) % 60); 

    // add minutes to $hms (with a leading 0 if needed)
    $hms .= str_pad($minutes, 2, "0", STR_PAD_LEFT). ":";

    // seconds past the minute are found by dividing the total number of seconds
    // by 60 and using the remainder
    $seconds = intval($sec % 60); 

    // add seconds to $hms (with a leading 0 if needed)
    $hms .= str_pad($seconds, 2, "0", STR_PAD_LEFT);

    // done!
    return $hms;
    
  }

The part of the code to show the data is below:
Code: [Select]
while ($row = mysql_fetch_array($result)) {
$sec = time() - strtotime($row['starttime']);
echo $sec; // print to screen to make sure $sec had a value
sec2hms($sec);

}
Any guidance on where I went wrong?

hi i am using yahoo api search i put a paragraph in a text area explode with ".Dot " and than serah each sentance one by one in yahoo api. Problem is i want when its get all sentancce in one site its give me result one time but my code give result as foreach loop end if it explode 5 time it give me same result 5 time but i want only one time

some one help me


$queryz=$_REQUEST['query'];
$queryz1=explode('.',$queryz);
foreach ($queryz1 as $k=>$v){
$q = build_query($v);
//exit();
performTask($q);

}



// To cache, we save the result xml to a filename that is a
// hash of the query string.  Note the use of tempnam() and
// rename() to make sure the file is created atomically.
function performTask($q=""){
$cache_file = '/tmp/yws_'.md5('http://search.yahooapis.com/WebSearchService/V1/webSearch'.$q);
if(file_exists($cache_file) && filemtime($cache_file) > (time()-7200)) {
  $raw = file_get_contents($cache_file);
} else {
  $raw = file_get_contents('http://search.yahooapis.com/WebSearchService/V1/webSearch'.$q);
  
  $tmpf = tempnam('/tmp','YWS');
  file_put_contents($tmpf, $raw);
  @rename($tmpf, $cache_file); 
}

$xml = simplexml_load_string($raw);
// Load up the root element attributes
foreach($xml->attributes() as $name=>$attr) $res[$name]=$attr;

$first = $res['firstResultPosition'];
$last = $first + $res['totalResultsReturned']-1;
echo "<p>Matched ${res[totalResultsAvailable]}, showing $first to $last</p>\n";
if(!empty($res['ResultSetMapUrl'])) {
  echo "<p>Result Set Map: <a href=\"${res[ResultSetMapUrl]}\">${res[ResultSetMapUrl]}</a></p>\n";
}
$stored="";
for($i=0; $i<$res['totalResultsReturned']; $i++) {
  
  
  foreach($xml->Result[$i] as $key=>$value) {


if(stristr($key,'ClickUrl')){
if(strpos($stored,$value)){
continue;
}
}  

if(stristr($key,'Title')) echo "<a href=\"$value\">$value</a> <br /> \n";
if(stristr($key,'ClickUrl')){echo "Url: <a href=\"$value\">$value</a> <br /> \n"; $stored.=$value;}
if(stristr($key,'Summary')) echo "$value <br /> \n";
if(stristr($key,'ModificationDate')) echo "Update: $value From Yahoo <br /> \n";
 

  }
  echo "<hr />\n";
}
next_prev($res, $first, $last);

}
done();
?>

hey guys im having trouble showing the news by the date it was submitted, I want to also seperate it into 3 seperate parts,

first section will have the Main news which is only 1 row, it will have the value 1 in the column named type (is this news main or recent). The date on it doesn't matter because i want to show it even tho there might be news that is ahead of it.

The next section will have 3 rows of recent news parts. I want to show the 3 most recent news that there are in the database with the value 2 in the column named type. I want it to show the recent news by the date submitted.

Okay the last part will have the old news. There I want to show 3 rows of news that is after the 3 rows of news in recent news. That value will be 2 in the column named type.

Here is my current code.


<?php
session_start();
if(isset($_SESSION['username']))
{

mysql_connect("localhost","root","");
mysql_select_db("chat");


        $result = mysql_query("SELECT * FROM `news` WHERE `type`='1' ORDER BY `news`.`newsid` DESC LIMIT 1");
        $query = mysql_query("SELECT * FROM news WHERE `type`='1' ");
        //$ifadmin_result = mysql_query("SELECT * FROM users WHERE `username`='$loggedin' ");

if(mysql_num_rows($query)!=0)
{
$loggedin = $_SESSION['username'];
    $myrow = mysql_fetch_array($result);
       echo "<b>Title: ";
       echo $myrow['title'];
       echo "</b><br>On: <i>";
       echo $myrow['dtime'];
       echo "</i><hr align=left width=160>";
       echo $myrow['text1'];
       
       
       //check if admin
       $ifadmin_result = mysql_query("SELECT * FROM users WHERE `username`='$loggedin'");
       $ifadmin = mysql_fetch_array($ifadmin_result);
       if ($ifadmin['admin'] == 1) { 
       echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
        || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
         || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><BR><BR>";
            }  
                else {
                echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><BR>";
            }
         //check if admin
         
       echo "<hr align=left width=500>";
       }
       else
       {
       echo "no rows<br>";
       }

        $iCount=0;
        $var=false;
        //RECENT
        $result = mysql_query("SELECT * FROM `news` WHERE `type`='2' ORDER BY `news`.`newsid` DESC LIMIT 6");
        //lets make a loop and get all news from the database
       while($myrow = mysql_fetch_array($result))
             {//begin of loop
               //now print the results:
               $iCount = $iCount+1;
                if($iCount >= 4) {
                    if($var == false) {
                    $var=true;
                           echo "<hr align=left width=500>";
                    echo '<div> More News</div';
                    }
                    //Generate your refcent news here echo the title etc.ma
                   echo "<div><b>Title: ";
                   echo $myrow['title'];
                   echo "</b> <i>On:" . $myrow['dtime'] . '</i></div>';
                   echo "<a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>";
                } 
                else
                {
               echo "<b>Title: ";
               echo $myrow['title'];
               echo "</b><br>On: <i>";
               echo $myrow['dtime'];
               echo "</i><br>";
               //echo "<hr align=left width=160>";
               echo $myrow['text1'];
               // Now print the options to (Read,Edit & Delete the news)
               
               
                              $ifadmin_result = mysql_query("SELECT * FROM users WHERE `username`='$loggedin'");

       $ifadmin = mysql_fetch_array($ifadmin_result);
       if ($ifadmin['admin'] == 1) 
            { 
       echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
        || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
         || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><BR><hr align=\"left\" width=\"160\">";
            }  
                else
            {
                echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><hr align=\"left\" width=\"160\">";
            }
               
               
               
               
               
               
               
               
               /*
               echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
                || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
                 || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><br><hr align=\"left\" width=\"160\">";
                 */
                }
                
                
             }//end of loop
             
}
else
{

mysql_connect("localhost","root","");
mysql_select_db("chat");

$result = mysql_query("SELECT * FROM `news` WHERE `type`='1' ORDER BY `news`.`newsid` DESC LIMIT 1");
        $query = mysql_query("SELECT * FROM news WHERE `type`='1' ");
if(mysql_num_rows($query)!=0)
{
    $myrow = mysql_fetch_array($result);
       echo "<b>Title: ";
       echo $myrow['title'];
       echo "</b><br>On: <i>";
       echo $myrow['dtime'];
       echo "</i><hr align=left width=160>";
       echo $myrow['text1'];
       echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><BR>";
       echo "<hr align=left width=500>";
       } else {
       echo "no rows<br>";
       }
        $iCount=0;
        $var=false;
        //RECENT
        $result = mysql_query("SELECT * FROM `news` WHERE `type`='2' ORDER BY `news`.`newsid` DESC LIMIT 6");
        //lets make a loop and get all news from the database
       while($myrow = mysql_fetch_array($result)) {
       //begin of loop
               //now print the results:
               $iCount = $iCount+1;
                if($iCount >= 4) {
                    if($var == false) {
                    $var=true;
                           echo "<hr align=left width=500>";
                    echo '<div> More News</div';
                    }
                    //Generate your refcent news here echo the title etc.ma
                   echo "<div><b>Title: ";
                   echo $myrow['title'];
                   echo "</b> <i>On:" . $myrow['dtime'] . '</i></div>';
                   echo "<a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>";
                } else {
               echo "<b>Title: ";
               echo $myrow['title'];
               echo "</b><br>On: <i>";
               echo $myrow['dtime'];
               echo "</i><br>";
               //echo "<hr align=left width=160>";
               echo $myrow['text1'];
               // Now print the options to (Read,Edit & Delete the news)
               echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><hr align=left width=160>"; 
                }
                                                    }//end of loop        





}             
?>

<br>
<hr align=left width=500>
<!--
<hr align=left width=500>
<br><br>
<a href=index.php>Home</a> 

<a href=add_news.php>Add News</a>
-->


Here is how my database table looks like


Dont mind the number of rows it is, I want it to show the first I guess 7 rows of news that is dated to the earliest time from present.
There soon will be hundreds of rows.

Here is how I made it fill in the row with the most recent time it was posted.
NOW()
in
$result = mysql_query("INSERT INTO news (title, dtime, text1, text2, type) VALUES ('$title',NOW(),'$text1','$text2','$type')");


Basically I want it to show the most recent rows based on the time they were posted.



Also, incase you need more information please post and il give me information.

I have a query that fetches all the dates in a date range then displays them in a Date:HH:MM;SS format.   However when displayed sometimes there are missing Hours as I don't have data for them and I would like to display it.  So right now I have something like this.

Date Column:                Revenue_Column:
07/29/2010 00:00:00   $250.00
07/29/2010 01:00:00   $150.00
07/29/2010 03:00:00   $350.00
07/29/2010 04:00:00   $450.00

As you can see 02:00:00 is missing, how can I use php or possibly mysql to fill in that gap?   I have tried creating an hours table and joining them and grouping by date however that doesn't seem to work.  Any ideas?

I have a script that runs a MySQL query and loops through a bunch of results.   For each person's name, I have a short bio that I want to show/hide by clicking on the person's name.  I have a basic start, but I can't figure out how to show/hide them individually. When I click on someone's name, it shows/hides all of the bio's.  I do have an individual ID for each person, and could use that somehow, but I'm scratching my head trying to figure out how to accomplish that.  Any ideas?   http://jsfiddle.net/APA2S/3644/  

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=348274.0

Hi,

I have a problem. i want to show the current date and time in my tables of the database. I want to show it because i want to show it on my report generated in php.

By the way i do not have a "date" field in my form. Can anyone help me out?

Thanks,
Heshan.