Databases
StackOverflow2013
Postsdbo
POSQL :: Display [INT] as [DD/MM/YYYY]
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL :: Display [INT] as [DD/MM/YYYY]
    text
    copied!<p>I want to display $eventdate (saved as a <strong>unix time INT value</strong> on SQL server), <strong>in the format DD/MM/YYYY</strong> (or similar).</p> <p>Thanks!</p> <pre><code> ... $entry_display .= &lt;&lt;&lt;ENTRY_DISPLAY &lt;div class="post"&gt; $eventdate &lt;/div&gt; ... </code></pre> <p>EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:EDIT:</p> <p>Heres the whole code:</p> <pre><code>&lt;?php class simpleCMS { var $host; var $username; var $password; var $table; public function display_public() { $q = "SELECT * FROM eventsDB WHERE eventdate &gt; UNIX_TIMESTAMP() ORDER BY eventdate ASC LIMIT 30"; $r = mysql_query($q); if ( $r !== false &amp;&amp; mysql_num_rows($r) &gt; 0 ) { while ( $a = mysql_fetch_assoc($r) ) { $title = stripslashes($a['title']); $author = stripslashes($a['author']); $bodytext = stripslashes($a['bodytext']); $eventdate = stripslashes($a['eventdate']); $created = stripslashes($a['created']); $entry_display .= &lt;&lt;&lt;ENTRY_DISPLAY &lt;div class="post"&gt; &lt;table class="eventstable" cellspacing="0" cellpadding="0"&gt; &lt;tr&gt; &lt;td&gt;&lt;img src="media/icons/icon_calendar.gif"/&gt; &lt;b&gt;$title &lt;/b&gt;&lt;/td&gt; &lt;td class="right"&gt;echo date("Y-m-d H:i:s", $eventdate); &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="2" class="small"&gt;$bodytext &lt;i&gt;by $author&lt;/i&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; ENTRY_DISPLAY; } } else { $entry_display = &lt;&lt;&lt;ENTRY_DISPLAY &lt;h2&gt; Your brand new Events Page! &lt;/h2&gt; &lt;p&gt; No entries have been made yet. Follow my instructions to make a new event! &lt;/p&gt; ENTRY_DISPLAY; } $entry_display .= &lt;&lt;&lt;ADMIN_OPTION &lt;p class="admin_link"&gt; &lt;a href="{$_SERVER['PHP_SELF']}?admin=97538642"&gt;&lt;/a&gt; &lt;/p&gt; ADMIN_OPTION; return $entry_display; } public function display_admin() { return &lt;&lt;&lt;ADMIN_FORM &lt;form action="{$_SERVER['PHP_SELF']}" method="post"&gt; &lt;label for="title"&gt;Title:&lt;/label&gt;&lt;br /&gt; &lt;input name="title" id="title" type="text" maxlength="150" /&gt; &lt;div class="clear"&gt;&lt;/div&gt; &lt;label for="bodytext"&gt;Body Text:&lt;/label&gt;&lt;br /&gt; &lt;textarea name="bodytext" id="bodytext"&gt;&lt;/textarea&gt; &lt;div class="clear"&gt;&lt;/div&gt; &lt;label for="author"&gt;Author:&lt;/label&gt;&lt;br /&gt; &lt;input name="author" id="author" type="text" maxlength="100" /&gt; &lt;div class="clear"&gt;&lt;/div&gt; &lt;label for="eventdate"&gt;Date (DD/MM/YY):&lt;/label&gt;&lt;br /&gt; &lt;input name="eventdate" id="eventdate" type="text" maxlength="100" /&gt; &lt;div class="clear"&gt;&lt;/div&gt; &lt;input type="submit" value="Create This Event!" /&gt; &lt;/form&gt; &lt;br /&gt; &lt;a href="../events.php"&gt;Back to Events&lt;/a&gt; ADMIN_FORM; } public function write($p) { if ( $_POST['title'] ) $title = mysql_real_escape_string($_POST['title']); if ( $_POST['bodytext']) $bodytext = mysql_real_escape_string($_POST['bodytext']); if ( $_POST['author']) $author = mysql_real_escape_string($_POST['author']); if ( $_POST['eventdate']) $eventdate = strtotime($_POST['eventdate']); if ( $title &amp;&amp; $bodytext &amp;&amp; $author ) { $created = time(); $sql = "INSERT INTO eventsDB VALUES('$title','$bodytext','$created','$author','$eventdate')"; return mysql_query($sql); } else { return false; } } public function connect() { mysql_connect($this-&gt;host,$this-&gt;username,$this-&gt;password) or die("Could not connect. " . mysql_error()); mysql_select_db($this-&gt;table) or die("Could not select database. " . mysql_error()); return $this-&gt;buildDB(); } private function buildDB() { $sql = &lt;&lt;&lt;MySQL_QUERY CREATE TABLE IF NOT EXISTS eventsDB ( title VARCHAR(150), bodytext TEXT, created VARCHAR(100), author VARCHAR(100), eventdate INT(15), ) MySQL_QUERY; return mysql_query($sql); } } ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload