mktime one column

[mrtechguy]

How can one go from a mktime output to a date when calling from a MySQL database.

What I have done it stored a date/time in the seconds since 1st Jan ... and now what I would like to do is get everything from the database and dump it into a table (Which I have done) but I wish to do the opposite of mktime (if someone could tell me what that is I would appreciate it) and then put that value in instead of the

so instead of
1012618440
I have
02/02/02 13:54

Thanks
MTG

[frikikip]

Do you want to format your date in php or MySQL.

In php its :

$dateFormatted = date("m/d/Y H:i:s", $timestamp);
http://www.php.net/manual/en/function.date.php

But you can also format your date in MySQL :

SELECT DATE_FORMAT(yourDateColumn, '%m/%d/%Y %H:%i:%s') AS myDate;
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Cheers,

Marv

[mrtechguy]

Ok,

The script is below.

<?php
include "config.php";

$link = mysql_connect($db_host, $db_user, $db_passwd);
mysql_select_db($mysql_db);
$query = 'SELECT * FROM bookings';
$result = mysql_query($query);
echo('<center><b>Details on upcoming tech events are below<b>');
echo "<table border='1'> <tr><td>ID</td><td>Booker Name</td> <td>Contact Name</td> <td>Event Name</td>
<td>Time</td> 
<td>Block(s)</td> <td>Venue</td>
<td>Other General </td>
<td>Other Time </td>
<td>Packup</td>
<td>Setup</td>
<td>Other Sound Specs. </td>
<td>Other Sound </td>
<td>Foldback</td>
<td>Tape</td>
<td>PC</td>
<td>Projector</td>
<td>DVD Player </td>
<td>CD Player </td>
<td>Mic</td>
<td>W/l Mic </td>
<td>PA</td>
<td>House</td>
<td>Casual</td>
<td>Formal</td>
<td>Spot</td>
<td>Gels</td>
<td>Specify Gels </td>
<td>Event Description </td>
<td>Screen</td>
<td>Carpet</td>
<td>Curtains Open </td>
</tr>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";
echo ('</center>');
// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?> 

and the booking is created by

<?php
include "config.php";
$varnames = array(
    'booker',
    'contact',
    'event',
    'date', // bogus entry, will be filled later
    'block',
    'where',
    'oth_gen',
    'other_time',
    'packup',
    'setup',
    'oth_so_spec',
    'other_sound',
    'fbs',
    'tape',
    'pc',
    'proj',
    'dvdp',
    'cdp',
    'mic',
    'wlm',
    'pa',
    'house',
    'cas',
    'form',
    'spot',
    'colo',
    'colo_spec',
    'oth_lig',
    'oth_li_spec',
    'des'
);
#     
$_GET['date'] = mktime($_GET['h'], $_GET['m'], '0', $_GET['mo'], $_GET['d'], $_GET['y']);   

foreach($varnames as $varname) {
    $varvalues[] = isset($_GET[$varname])?$_GET[$varname]:'no';
}
#     
$mysql = mysql_connect($db_host, $db_user, $db_passwd);
mysql_select_db($mysql_db, $mysql);
$query = "INSERT INTO bookings VALUES ('".implode("','",$varvalues)."')";
mysql_query($query, $mysql) or die(mysql_error());
mysql_close($mysql);
echo('The booking has been added. A technician will contact you soon.');
#  ?>

As you can see when the booking is added the date is stored as a INT.

I want to using the script above make the date from a INT into a proper date without manually getting that field, etc

MTG

[frikikip]

try rewriting this:

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
} 

to this:

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $type => $col_value) {
       if($type == "date") {
          echo "\t\t<td>".date("m/d/Y H:i:s", $col_value)."</td>\n";
      } else {
          echo "\t\t<td>$col_value</td>\n";
      }
   }
   echo "\t</tr>\n";
} 

Or something. (haven't tested it)

[mrtechguy]

nope that still gives the seconds since 1st jan ... time.

would it be something with the if($type... part?

MTG

Just so you know I am a little bit of a php n00b so could you please explain any scripts so I can learn

Thanks