Snippet description Snippet class
XHTML-base XHTML
Open image in new window JavaScript
Escape variables PHP
Fread-example PHP
SQL-timestamp to normal date PHP
Remove HTML-tags from string PHP
Formatting MySQL-datetime PHP
on Rollover go to frame Flash
Hiddenable box XHTML / CSS / JS


<?php

  
// MySQL timestamp (yyyymmddhhmmss) to dd.mm.yy hh:mm:ss
  // For example: 20050526111226 -> 26.05.2005 11:12:26

  
$timestamp=mysql_result($result,$i,"timestamp");

  
$year substr($timestamp04);
  
$month substr($timestamp42);
  
$day substr($timestamp62);
  
$hour substr($timestamp82);
  
$minute substr($timestamp102);
  
$second substr($timestamp122);
  
$timestamp date('d.m.Y H:i:s'mktime($hour$minute$second,
  
$month$day$year));

  echo 
$timestamp;

?>