PHP - Set Up The Time With The Correct Date Format

I have a field called date_time in the database which is of type datetime.
I have a form which on submit needs to enter the current date and time in the date_time field.
I know I can get the current time using time()
$time=time();
Can do I do some kind of manipulation using strtotime() and store in the database in  datetime format?

Hello All, 
  Need an advise in finishing this task please. 
 

function convertTimeFormat($time12Hour) {
// Initialized required variable to an empty string.
		$time24Hour = ""; 

// Used explode() function to break the string into an array and stored its value in $Split variable. 
		$Split = explode(":",$time12Hour); // print_r(explode (":", $time12Hour)); => Array ( [0] => 09 [1] => 50 [2] => 08AM )

// Retrieved only "hour" from the array and stored in $Hour variable. 
		$Hour = $Split[0];   

    $Split[2] = substr($Split[2],0,2);

// Used stripos() function to find the position of the first occurrence of a string inside another string.	
		if($Hour == '12' && strpos($time12Hour,"AM")!== FALSE) {
			// Code here 
		} elseif(strpos($time12Hour,"PM")!== FALSE && $Hour != "12") {
			// code here
		}
		return  $time24Hour;
	}
	$time12Hour = "09:50:08AM";
	$result = convertTimeFormat($time12Hour);
	print_r($result); 

/*
Input : "09:50:08AM";
Output : "21:50:08PM";
*/

 

Hey guys,
How would I go about subtracting Today from a previous day to find the difference?

For example, I want to subtract TODAY from a previous date in my database, to determine if the difference is greater than 1 day.

Any ideas? I tried doing the subraction in TIMESTAMPS, but when I convert the date back to Y-m-d H:i:s, I got some weird year and time.
 

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.

I have the following query:
 $getVideos = mysql_query("SELECT catergory, COUNT(catergory) as 'catCount' FROM videos GROUP BY catergory"); 

Using this in PHPMyAdmin returns the correct results of:
catergory | catCount
   0 

  |    7
   1 

  |    1
   10     |    2

How would get those results into a PHP array or what not...I have done this before but along time ago and cannot for the life of me remember how to do it.

Hopefully someone can point me in the right direction?

Regards, PaulRyan.

I have a script that runs a query against a MySQL database, then, if it returns a resultset, it takes the 'freindly name from an array containg the database connections, then adds the data for the resultset.
Unfortunately at the minute, it doesn't quite work the way that I want.

So far I have:

//get list of servers to query, and choose them one at a time
for($a = 0; $a <sizeof($slaveRes_array); $a++)  {
$con = mysql_connect($slaveRes_array[$a]['server'], $slaveRes_array[$a]['user'], $slaveRes_array[$a]['password']); 
mysql_select_db($dbs, $con);
//get list of MySQL Queries, and run them against the current server, one at a time        
for($b = 0; $b <sizeof($query_array); $b++) {
$SlaveState = mysql_query($query_array[$b]['query1'], $con); 

// 1st Query
// If there is a resultset, get data and put into array
while($row = mysql_fetch_assoc($SlaveState)) {  
for($c = 0; $c <mysql_num_rows($SlaveState); $c++) {
$slave_array[]['name'] = $slaveRes_array[$a]['database'];
for($d = 0; $d <mysql_num_fields($SlaveState); $d++) {
$slave_array[][mysql_field_name($SlaveState,$d)] = mysql_result($SlaveState,$c,mysql_field_name($SlaveState,$d));  
}}
}
}
// Run Query2...Query3....etc.
         }


The problem is that at the minute it puts each field into a separate part of the array e.g.

Array (
        => Array ( [name] => MySQL02_5083 ) [1] => Array ( [Slave_IO_State] => Waiting for master to send event )
   [2] => Array ( [Master_Host] => localhost )
   [3] => Array ( [Master_User] => root )

Whereas what I am trying to achieve is more like:
Array (
        => Array ( [name] => MySQL02 ) [Slave_IO_State] => Waiting for master to send event )
   [Master_Host] => localhost )
   [Master_User] => root )...
           [1] => Array ( [name] => MySQL03
etc. etc.

But I can't see how to achieve this?

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.

Hey Guys!
I have the following doubt.

When echoing from Server like this:

Code: [Select]
echo "time=" . time();
I get the time in the following raw format: 1299272294

I would really like to echo it with this format: Tue Mar 1 23:50:00 GMT-0300 2011

Is there a way I could do that?

Really looking forward for some help on this one,

Thanks a lot in advance!
Cheers!

Hello, I got myself a RSS feed for my posts, which can be seen he
codexplained.tk/feed/rss.php

This is the code used for it:
Code: [Select]
<?php
// header
header("Content-Type: application/xml; charset=UTF-8");
require("../widgets/functions.php");

// Make a MySQL Connection
connectToDB();

echo '
<rss version="2.0">
<channel>
<title>Codexplained RSS Feed</title>
<link>http://www.codexplained.tk</link>
<description>For all your coding needs</description>
<language>en</language>
';

$query = "SELECT * FROM posts ORDER BY Id DESC LIMIT 15";
$res = mysql_query($query);

$num=mysql_numrows($res);

$i = 0;
while ($i < $num)
{
$subject=mysql_result($res,$i,"Subject");
$id=mysql_result($res,$i,"Id");
$content=mysql_result($res,$i,"Content");

$content = str_replace("<br />", "\n", $content);
$content = str_replace("<?php", "&lt;?php", $content);
$content = str_replace("?>", "?&gt;", $content);
$content = htmlentities($content);
$content = substr($content, 0,400);

echo '
<item>
<title>'.$subject.'</title>
<link>http://www.codexplained.tk/index.php?postDetails='.$id.'</link>
<description>'.$content.'</description>
</item>';
$i++;
}
echo '
</channel>
</rss>
';
?>
Now, I wish to know how to make the time display correctly, and not just according to refresh date.

I tried something with <pubDate> but I couldn't figure it out. Help would be appreciated!

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

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.

Hi everyone

I have a column in an sql database which stores time in minutes.
I'm trying to turn these minutes into this kind of format:
  1:00pm
12:30am
  6:15pm

I looked on W3C and there was the %r which seemed to format this way but I cant get it to work >.<

Code: [Select]
$time1=$f3/60;
 $time2= date_format($f4, '%r');

Does anyone know how to achieve this? THANKS!!!

How can I format my time value (initially created by using time()) to ISO 8601 so it can be used in the format described he

http://timeago.yarp.com/

Thanks

I have the time time now viewed as 17:11.
The time $Start_Time is 17:00. The time $End_time is 18:00.

Can I use this to check if time is in between starttime and endtime? Or do I have to convert it to other formats before it understand that I'm comparing it as times and not just numbers?

if($Start_Time < $Now_time && End_Time > $Now_time){
}

I used the following code to convert the length in seconds to min:second format
$sec=$duration % 60;
if ($sec=="0"){
$min=$duration/60;
$duration=''.$min.':00';
}else{
$min=(($duration-$sec)/60);
$duration=''.$min.':'.$sec.'';
}
everything is OK, but it shows 35:5 instead of 35:05. I mean it disregards the first 0 when the second is 1-digit.