PHP - Mysql Exact Equivalent Of The Php "time()" Function

hello i got this small function i`m working on to get the date of a month something like get current date - 1 but not sure how to handle jan month can someone help me please ?



$month = date('m') - 1;
$date_startt = date('Y').'-'.$luna.'-01';
$timestamp_start = strtotime($data_start);

Hi guys.

I want to make two records.

1)Current time and date.
2)Time and date after 20 seconds.

Now i have this piece of code:
Code: [Select]
<?php
$hr  = 0;
$min = 0;
$sec = 11;

echo $date = date("Y-m-d H:i:s");echo "\n";
echo $modified = time() + (0 * 0 * 0 * 20);

?>

I think there is something wrong with this line:
Code: [Select]
<?php
echo $modified = time() + (0 * 0 * 0 * 20);1
?>I get something like this: 1324668576.

You can check this http://kingstonuni.atspace.co.uk/RPG/muziejus.php link to get a better view.

Any help would be appreciated. Thank you.

I have a php code that call a process (a java program). The process runs in background for a so long time - from 1 minute to 2 hours. I make the process call using exec:

<?php
function execInBackground($cmd) {
    if (substr(php_uname(), 0, 7) == "Windows"){
        pclose(popen("start /B ". $cmd, "r"));
    }
    else {
        exec($cmd . "  &> /dev/null &");
    }
}
$command = "java ... ReadEmailsCmdLine 2>&1";
execInBackground($command);

echo "FINALIZADO";

Though the command runs in background it looks that the PHP code wait for the command completion to send a answer to client browser because I just see "FINALIZADO" after the java program finished its execution.

Does someone know how I can solve this problem? Or at least does have a hint/pointer for that?

Since now I thanks any comment/suggestion

Write a function Counter() that keeps track of the number of times it is called. This function should not take any parameters and return the number of times that it has been called.

Hey guys, im having a slight issue with comparing mysql time stamp.
I'm using the timestamp in mysql to show how many people are online with in 5 minutes.

$sql = mysql_query("SELECT name,id FROM users WHERE DATE_SUB(NOW(),
INTERVAL 5 MINUTE) <= last_active ORDER BY id ASC"); 

But I want to grab last_active from the data base and compare it like below.  I dont know if strtotime just doesnt compare with mysql time stamp or what?

if($last_active > strtotime('-5 minutes')) {

echo "<td>Online</td>";
}else{
echo "<td>Offline</td>";

} 

Hello guys. I am creating a PHP/mySQL based RPG. I have implemented training feature in it. So i want to make training possible every 15 minutes or so. Can you give me an advice how to achieve that? Thank you!

I need to write a bit of code to select some mp3's (actually, just the titles) from a database...but I need to select them based on last play (which is a timestamp field in the DB) AND I need to select 14 minutes worth of them (and not more than 15 minutes).  I currently do NOT know how long each song is...

So, if every song was 2 minutes long, I would need 7 songs.  If each song was 3 minutes long, I'd need to select 5 of them.

I currently do NOT have a length field in the db (the boss sprung this on me after I designed the DB).  A few questions:

Would it be best to have a column of TIME (mysql time...not the name of the column)? 

Would it be best to have a column for the raw size of the file (each file is the same bitrate, so I could do the math - plus it would be probably be easier to import raw filesize using php into the db)

Would it be easier to do something else?

Once we answer that, I'll start with some code...and probably be back for help!

hey, here is the code I am using.

Code: [Select]
mysql_connect("localhost","XXXXXX","XXXXXX") or die("Could not connect.");
mysql_select_db("XXXXXX");

$query="SELECT * FROM VIDEO_SESSIONS";
$result=mysql_query($query);

while ($db_field = mysql_fetch_assoc($result)) {
$timeslider = $db_field['timeslider'];
}

$message=$_POST['message'];

$name=$me['first_name'];

if(isset($_POST['submit'])){

    if(strlen($message)<1)

   {
      print "You did not input a message";
   }

   else if(strlen($name)<1)

   {
      print "Please login with Facebook to post a message";
   }

 
      else

      {


         $insertmessage="INSERT INTO CHAT_SESSIONS
(user_id,user_message,current_time)
VALUES
('$name', '$message', '$timeslider')";
         mysql_query($insertmessage);
         echo mysql_error();


      }

   }


?>
I am getting this error everytime I try and INSERT into the database

" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_time) VALUES ('Luke', 'Hello?', '00:23:00')' at line 2 "

it works fine without the '$timeslider' which is a time stored on the database in the format 00:00:00
why does it not want to store the time back in a different table.. same format!?

hello guys.

i sitting here at my pc , have used alot days on google and forums.
but i just cant seem to find what i am looking for

so i hope that anyone here got a min to tell me what to do 

okai soo what i am looking for is a php / mysql script that can countdown for a user , when its finish add a number ( to usertabel[2].
and the problem is it need to do it also if the user closes the browser.

i am total lost , have no ide to fix / wihte it
 



Sorry for my spelling i am danish 

First, I would like to say when i tried to recover my account from this website, I took me 10 attempts to get the captcha right and then finally it said it sent me an email to my gmail account. I checked spam folder and everything there was no such email from this site. Then I decided to create a new account, well, it took me another 10 attempts to get the captcha right and finally when it was submitted, the page was loading for around 3 minutes before it signed me in.   My question is about the php date() function. It accepts a format to display a time. In the following example I use F for full representation of month, d for 2-digit day of month with leading zeros, Y for full year, g for 12-hour format without leading 0s, s for seconds and A for meridiem. It uses the correct format, but it gives me the wrong time. My local time is 4:43 and it prints out 4:12:   <?php
    echo "<p>order processed on " . date("F d, Y g:sA") . "</p>";
?>   Why is it 30 minutes behind?

Hello,

When I use this function, the time always refers to January 1st 1970 ?! How come?
I get the output '4 decades 1 year 11 months' regardless of which date I enter into the function.. ?

Code: [Select]
function timeAgo($tm,$rcs = 2) {
    $cur_tm = time(); $dif = $cur_tm-$tm;
    $pds = array('second','minute','hour','day','week','month','year','decade');
    $lngh = array(1,60,3600,86400,604800,2630880,31570560,315705600);
    for($v = sizeof($lngh)-1; ($v >= 0)&&(($no = $dif/$lngh[$v])<=1); $v--); if($v < 0) $v = 0; $_tm = $cur_tm-($dif%$lngh[$v]);
 
    $no = floor($no); if($no <> 1) $pds[$v] .='s'; $x=sprintf("%d %s ",$no,$pds[$v]);
    if(($rcs > 0)&&($v >= 1)&&(($cur_tm-$_tm) > 0)) $x .= timeAgo($_tm, --$rcs);
    return $x;
}

When I call for the function I use this:
Code: [Select]
timeAgo($row['dateposted'])

The format in the database for 'dateposted' is:
Code: [Select]
2006-08-14 23:29:23

Any ideas what I am doing wrong? Thanks a million

I think it is unusual but i dont know to fix it.  when my computer clock shows 16: 13 hours , date() reuturns 10:43:16 . My systems time zone is +5.30 GMT.
how does date() subtracts 5.30 hrs from the system time?

I wrote this bit of code to get the next six datetimes of a certain date. It was working perfectly until this week.

Code: [Select]
<?php
$start = "2011-11-06";

$num_days = 6;
for ($i = 0; $i <= $num_days; $i += 1)
{
$stamp = strtotime($start) + ($i * 86400);

echo date('l - n/d/Y - h:i a',$stamp)."<br/>";

}


?>
The 2011-11-06 is a Sunday so i would expect to get the following:

Sunday - 11/06/2011 - 12:00 am
Monday - 11/07/2011 - 12:00 am
Tuesday - 11/08/2011 - 12:00 am
Wednesday - 11/09/2011 - 12:00 am
Thursday - 11/10/2011 - 12:00 am
Friday - 11/11/2011 - 12:00 am
Saturday - 11/12/2011 - 12:00 am

instead it is producing:

Sunday - 11/06/2011 - 12:00 am
Sunday - 11/06/2011 - 11:00 pm
Monday - 11/07/2011 - 11:00 pm
Tuesday - 11/08/2011 - 11:00 pm
Wednesday - 11/09/2011 - 11:00 pm
Thursday - 11/10/2011 - 11:00 pm
Friday - 11/11/2011 - 11:00 pm

How should i go about fixing this so it doesn't happen again?

Hello..
I'm a somewhat beginner in php, but i decided to create my own basic forums system with a content managing system. Right now I'm trying to figure out how to make a thread link be at the top of the list for the forum display page, when someone posts a response or creates a new thread. HELP MUCH APPRECIATED 

I get a "No database selected" error whenever I submit information on my register.php page, which is:


<?php

include_once('includes/config.php');
include_once('functions.php');

$return_content = AccountRelated(null, null, 3);

?>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style/style.css" />
<title><?php echo $title; ?></title>
</head>
<body>

<div class="logo"><a href="index.php"><img src="style/images/logo.png" border="0"></a></div>

<center>

<div class="background">

<div class="container">

<?php echo $return_content; ?>

</div>

</div>
</center>

</body>
</html>


But after I click submit, I get the "No database selected" error, but using WAMP, I include config.php which holds the following details:


<?php

$title = "NovaUpload - File Uploader";

mysql_connect("localhost", "", "");
mysql_select_db("data");

?>


And if functions.php is required, he


<?php

function AccountRelated($username, $password, $query_type)
{

if($query_type == 1)

{

$set_query = mysql_query("SELECT COUNT(d.username), u.date, u.username FROM uploads d, users u WHERE d.username = '$username' AND u.username = '$username' LIMIT 1") or die(mysql_error());

//user must not exist

if(mysql_num_rows($set_query) == 0)

{

$content_return = 'Sorry, no information was found';

}

else

{

$grab = mysql_fetch_assoc($set_query);

//login information

if($grab['COUNT(d.username)'] > 0)

{

$welcome_return = "You have uploaded ". $grab['COUNT(d.username)'] ." files. You've registered on ". $grab['u.date'] ."!";

}

else

{

$welcome_return = "You have uploaded 0 files. You've registered on ".$grab['date'] . "!";

}

}

}

elseif($query_type == 2)

{

$set_query = mysql_query("SELECT title,views,downloads,description,username,date FROM uploads LIMIT 20");

if(mysql_num_rows($set_query) == 0)

{

$content_return = "Sorry, there are currently no files uploaded to view.";

}

else

{

//display all files

while($row = mysql_fetch_assoc($set_query) == 0)

{

echo $row['title']."<br/>";

}

}

}

elseif($query_type == 3)

{

$username = mysql_real_escape_string($_POST['username']);

$password = sha1(sha1(md5($_POST['password'])));

if(!$username || !$password)

{

$return_content = "All fields are required! <table><form action='register.php' method='POST'>

<tr><td>Username</td><td><input type='text' name='username' maxlength='20'></td></tr>

<tr><td>Password</td><td><input type='text' name='password' maxlength='30'</td></tr>

<tr><td><input type='submit' value='Register'></td></tr>

</form></table>";

}

else

{

$set_query = mysql_query("SELECT username FROM users WHERE username = '$username' LIMIT 1");

if(mysql_num_rows($set_query) == 0)

{

$return_content = "You have successfully registered the account ". $username ." with the

password ". $_POST['password'] ."!";

mysql_query("INSERT INTO users VALUES (null, '$username', '$password', 0, 0, '". date("M-d-Y") ."', '". $_SERVER['REMOTE_ADDR'] ."')") or die(mysql_error());

}

else

{

$return_content = "An account with this username already exists.";

}

}

return $return_content;

}

else

{

//nothing to process

}
}
?>