PHP - Round Time To Nearest 15 Minutes

How can I order this query of zip codes within the radius by nearest?

  /**
     * Get Zipcode By Radius
     * @param  string $zip    US zip code
     * @param  ing $radius    Radius in miles
     * @return array         List of nearby zipcodes
     */
    protected function get_zipcodes_by_radius ( $zip, $radius )
    {
        $sql = 'SELECT distinct(zip) FROM zip_codes WHERE (3958*3.1415926*sqrt((latitude-'.$zip->latitude.')*(latitude-'.$zip->latitude.') + cos(latitude/57.29578)*cos('.$zip->latitude.'/57.29578)*(longitude-'.$zip->longitude.')*(longitude-'.$zip->longitude.'))/180) <= '.$radius.';';
        $zip_codes = array();
        if ( $result = $this->db->query( $sql ) )
        {
            while( $row = $result->fetch_object() )
            {
                array_push( $zip_codes, $row->zip );
            }
            $result->close();
        }
        return $zip_codes;
    }

 

How do I find the nearest div of dynamically added html?

I have a database with Users as a table. It has the normal stuff, id, username, password, and I have anther in it called lastactive. It is int(11) , and I am wondering how I would make a sql query select the users in the database 'users' and see who has been active in the past 15 mins.

By the way, the lastactive time gets updated by the function time()

Here is my code:

<?php
$online = mysql_query("SELECT * from users WHERE (TIMESTAMPDIFF(MINUTE, `lastactive`, NOW()) < 15) ORDER by lastactive DESC") or die (mysql_error());
while($online = mysql_fetch_assoc($online)) {
echo '<a style="color:#F0CD87;" href="profile?id='.$online['user_id'].'">';
echo ucFirst($online['username']);
echo '</a>, ';
}
?>


Here is how the last active gets updated.

<?php
if(isset($_SESSION['logged'])) {
mysql_query("UPDATE `users` SET `lastactive`='" . time() . "' WHERE `username`='" . $_SESSION['username'] . "'");
}
?>


Again its not showing the users that have been on since 15 minutes ago, even tho it updates the users last active on every page since its in the footer.php part. which is on every page.

Thanks for the upcoming help.

so i have a mysql column with a datetime and i was wondering how i could make it echo the time in "X minutes ago" or "X hours ago" and also, when its more then 24 hours old, delete the entire entry

I have a forum script I made that has thread bumping for the thread creator only. I am trying to limit the amout of time the creator can bump to be every 10 minutes.

Here's my code.

list($title, $creator, $locked, $hidden, $moved, $lastbump) = mysql_fetch_row(mysql_query('SELECT title, creator, locked, hidden, moved, lastbump FROM forum_threads WHERE id="'.$_GET['threadid'].'"'));

if(($locked == 1 || $hidden == 1 || $moved == 1) && !$_SESSION['rights'] == 2){

header("location: thread.ws?id=".$_GET['threadid']."&page=".$_GET['page']."");

} else {

if($creator == $_SESSION['username']){

mysql_query("UPDATE forum_threads SET lastbump = NOW() WHERE id='".$_GET['threadid']."'");

} else {

header("location: thread.ws?id=".$_GET['threadid']."&page=".$_GET['page']."");

}

}

I've created a demo page for my CMS, and I want to delete itself and make a fresh content install.

I got the delete part figured out, but what about uploading fresh content files? (only a few text files).

Here's the delete part:

Code: [Select]
<?php
$expiretime=720; // minutes (in how many minutes it deletes the files)

$tmpFolder="tmp/"; // where to delete the files - be careful with this.
$fileTypes="*.*";

foreach (glob($tmpFolder . $fileTypes) as $Filename) {

$FileCreationTime = filectime($Filename);
$FileAge = time() - $FileCreationTime; 

if ($FileAge > ($expiretime * 60)){

//deleting files:
unlink($Filename);
}

}
?>

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

Unfortunately I do not know how to go about doing this in php any simple examples of time and date will be great.


So what I am trying to do is, display to minutes until the next half hour as well as the seconds until the next minute.  Eg.
Code: [Select]
<?php echo $minutes; ?>:<?php echo $seconds; ?>

Any help using the time and or date functions in this case will be great.

Thank you for your stupendous help.
Brian

This topic has been moved to JavaScript Help.

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

Other than if statement, is there a way to change a duration give in seconds (e.g. 5746 seconds) to the standard format of x hours and y minutes and z seconds?

hi know who to round a number to the nearest whole number,

if i use

echo round(9.5); it echo's 10
and if i use
echo round(9.2); it echo's 9

i want it so it always rounds up?

can anyone help?

cheers matt

hello guys, im creating a search result page that uses pagination, and im trying to figure out how many total pages their are going to be in my links with the page numbers. this is probably something really simple, ive been writing scripts for the last few hours and have a bit of a headache, any help would be appreciated here's the coding and the results i want:


<?php

$per_page = 10;
$rows = mysql_query("SELECT COUNT(*) FROM articles WHERE text LIKE $string"); // this will return 31
$pages = $rows / $per_page; // returns 3.1
$total_pages = round($pages); // returns 3, want to round 3.1 up to 4 here

?>

i have a price i want to add 10%-15% to the base price and that the result

will be rounded to 9 in the ones digit place.

for example

85 +15%=97.7
$result=99

117+15%=134.55
$result = 139

played with round() and ceil()

This works
echo $data3['value'];

But this doesn't
echo round($data3['value'], 2);

Can someone please advise me as to what I am doing wrong?