PHP - Convert Datetime Format

Code: [Select]
<?php
$myServer = "202.138.125.155";
$myUser = "micro_fms";
$myPass = "micro_fms*#$";
$myDB = "micro_fms"; 

//create an instance of the  ADO connection object
$conn = new COM("ADODB.Connection")or die("Cannot start ADO");

//define connection string, specify database driver
$connStr = "PROVIDER='SQLOLEDB'; SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB; 

//Open the connection to the database
$conn->open($connStr);

//$table_name=$_GET['Device'];
$table_data=$_GET['Data'];
$data=(explode(",",$table_data));

$table_name=$data[0];
$speed=$data[1];
$time=$data[2];
$date=$data[3];
$lat=$data[4];
$long=$data[5];
//$newdate = substr($date,6,2) . "-" . substr($date,0,2) . "-" substr($date,3,2);
$datetime=$date.$time;


$new_lat = substr($lat,0,2).'.'.substr($lat,2);
$new_long = substr($long,0,2).'.'.substr($long,2);

echo $table_name."<br>";
echo $speed."<br>";
echo $new_lat."<br>";
echo $new_long."<br>";
echo $datetime."<br>";

$query="insert into $table_name (DeviceNumber,Speed,dtDateTime,Latitude,Longitude)values('$table_name','$speed','$datetime','$new_lat','$new_long')";


//execute the SQL statement and return records
$rs = $conn->execute($query);
if($rs)
{
echo 'Values Inserted';
}
else
{
echo "faile";
}
?>


Hi friends...
I have two variables ($date and $time). I concat these two strings and make a new variable called "$datetime". Now in above code I want to insert it into table but I got the following error. Code: [Select]
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Conversion failed when converting datetime from character string.' in C:\wamp\www\FMS\fms.php:44 Stack trace: #0 C:\wamp\www\FMS\fms.php(44): com->execute('insert into A00...') #1 {main} thrown in C:\wamp\www\FMS\fms.php on line 44
In my database, data type of column in which I want to insert is Date time stamp though I have string type ($datetime) variable.
I think I have to convert this $datetime variable string to "DateTime type first but don't have any idea about it.
Please help??/
Thanks in advance....

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?

Hi I was going to start a new project which need to convert files from one fomrat to other like, you can check a site here  online-convert.com , there they give user to convert in various fomats. please check

my question is i have idea how to do these conversion with ffmpeg and php.
Code: [Select]
Audio converter
Video converter
Image converter
Hash generator
can someone please tell me how to do these conversion.
Code: [Select]
Document converter
Ebook converter

Thanks for any help

Can anyone please tell me how I convert DD-MM-YYY (text) to TIME (unix)

thought I'd say that I have this line at the top of all my pages, just in case it means a different code.

Code: [Select]
date_default_timezone_set('Europe/London'); //### Set the default timezone

while I'm reading the cell value '20/09/1980' from an excel file using phpexcel class method

 $student[$i]['d_o_b'] = $objWorksheet->getCell('G' . $intRow)->getValue();

 getting the value as '29484' pls help me to convert it into the date format again.

Hi,

I need to post to a form with cURL. I'am sending strings in Headers format...

There are some documentation or some function that translates from the human readable format to the Headers format?

For example:

Human readable format:
Quote

Vendo bicicleta. Como nova.


Headers format:
Quote

Vendo%20bicicleta.%20Como%20nova.


The problem is not the spaces but more the accents. I write in Portuguese.

Can you give me some clue?


Best Regards,

Does anyone know how I can convert linux epoch number such as 1292878800 to the UTC format?

Ricky

Hi. I have an input field where a date is entered, format dd-mm-yy. I need to query the database to see if this date exists. How can I convert the date to yyyymmdd before the query?

Thanks

Hi, I have a connection set up to an API using a PHP script - the API sends back data in JSON format, and if I capture it and echo it, it displays in extremely unfriendly format on the screen.

I've tried to find a way to convert this data into readable format, ideally in a HTML table, but although there are articles on converting manually inputted JSON data into a HTML table using Javascript, I can't find a way to do it from a PHP variable.

This is what I have so far:

if ($_POST['getcompany']) {
$companyname = $_POST['_Name'];
	
$ch = curl_init();

$data_array2 =  array(
      'token' => $token
);
$make_call2 = json_encode($data_array2);
	//echo 'Token is '.$token;
	$token2 = substr($token, 14);
	$token3 = substr($token2, 0, -3);
	
	//echo 'Token 2 is '.$token3;
	//echo 'Company Name is '.$companyname;

//curl_setopt($ch, CURLOPT_GET, 1);
//curl_setopt($ch, CURLOPT_POSTFIELDS, $make_call2);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json','Authorization: '.$token3.'')); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_URL, 'https://connectionurl?countries=GB&name='.$companyname);

//Execute the request
$result = curl_exec($ch);

echo 'Companies: '.$result; //This displays the data provided by the search, but is in JSON format

 

So I need a way to get the data held in $result, into a HTML table. Any idea how I can do this?

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 wish to know how i can convert this date 24-09-2010 to this format 2010-09-24

This code gives me 1969-12-31 18:33:30
Code: [Select]
<?=date('d M Y', $val['Created']);?> 
and this one gives me 2010-11-04 03:52:54  WHICH IS THE RIGHT ONE - BUT i need to format as above.
Code: [Select]
<?=$val['Created']?>
this happens on the same line of code.

What is wrong?

Hello All, I have the following code:

Code: [Select]
echo "<table width='615px' cellpadding='3' cellspacing='4' align='center'>";
echo "<tr>";
echo "<td align='left' width='150px'>";
echo  substr($row['date'],0,11); 
echo "</td>";
echo "<td align='left' width='465px'>";
echo $row["food"] ;
echo "</td>";
echo "</tr>";
echo "</table>";
And this outputs:

Apr 4 2011    Chicken Ceasar Salad, Garlic Toast, Cloddhoppers, Applesauce, & Milk

(etc.)

How can I add "Mon" in front of "Apr 4 2011"?

thanks!

Hi Everyone,

Please have a look at this, and tell me if its right?
I am generating a sitemap for my website dynamically.

The date I am providing: 2012-02-24 11:56:09 and this is the output I am getting: 2012-02-24T11:56:09Z
now I am not sure of the Z at the end of the returned value.

I think I am looking for something similar to this: 2012-03-12T12:00:02+02:00

not to sure what I am doing wrong and where it gets the timezone from, I am guessing from the php config file.

any help would be much appreciated. thanks

My code:

Code: [Select]
<lastmod><?php echo $time->toAtom($post['Post']['modified']); ?></lastmod>

Hey, does anybody know a good function, where I can have the trendy "time ago" functionality?   A good tutorial would be cool, too.   I would be using the datetime function off MySQL.