jezskill
asked on
Displaying fomatted mysql date field
in the code window is my code to sdisplay a form that allows a user to edit information, the last diaplayed form element is the Expiry date field, I have tried all sorts of ways to format it so that it displays as DD-MM-YYYY , but no luck, I am probably missing something simple.
Where does the date_format function come into play , before the form code or in the form element below?
<p>
<label for="Expiry">Expiry <em>*</em></label>
<input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
</p>
thanks in advance.
Where does the date_format function come into play , before the form code or in the form element below?
<p>
<label for="Expiry">Expiry <em>*</em></label>
<input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
</p>
thanks in advance.
$user_edit = '<div><form id="edituser" method="post"><input type="hidden" name="action" value="updateuser">
<fieldset>
<p>
<label for="name">Name <em>*</em></label>
<input id="name" name="name" size="25" maxlength="255" class="required" value="' . $row_user_edit['name'] . '"/>
</p>
<p>
<label for="local_authority_id">Local Authority <em>*</em></label>
<select style="width:175px;" name="local_authority_id" id="local_authority_id" value="' . $local_auth_name['la_name'] . '">
'.$local_authority_option.'
</select>
</p>
<p>
<label for="school_learning_est_id" >School or Learning Establishment name <em>*</em></label>
<select style="width:175px;" name="school_learning_est_id" id="school_learning_est_id" value="' . $school_name['School'] . '">'.$tblschool_new_option.'</select>
</p>
<p>
<label for="email">E-Mail <em>*</em></label>
<input id="email" name="email" size="25" maxlength="100" class="required email" value="' . $row_user_edit['email'] . '"/>
</p>
<p>
<label for="telephonenumber">Telephone Number <em>*</em></label>
<input name="telephonenumber" id="telephonenumber" size="25" maxlength="100" class="required" value="' . $row_user_edit['telephonenumber'] . '"/>
</p>
<p>
<label for="Expiry">Expiry <em>*</em></label>
<input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
</p>
<p>
<input class="submit" type="submit" value="Submit"/>
</p>
</fieldset></form></div>';
Sorry "d/m/Y" for 4 digit year
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It all depends on how you store that Expiry date.
I currently store all date/time based columns as integer values (unix timestamps) when using mySQL/PHP.
If it is stored as a unix timestamp, use the function date("d-m-Y, $row_user_edit['Expiry']) to format the timestamp loaded from database.
If stored as a mySQL datetime field, you'll need to make a function to convert MySQL's standard datetime format of YYYY-MM-DD to DD-MM-YYYY
Since you have another question open to ask abotu storing a date in format DD-MM-YYYY in a mysql date field, I will now assume that this is what you will need.
Look at these functions to swap sequence of the dates in a string:
function MysqlToPhpDate ($string) {
$arr = explode('-', 'string) // array nog is like this: $arr[0] = '2010'; $arr[1] = '09'; $arr[2] = '08';
$datePhp = $arr[2].'-'.$arr[1].'-'.$a
return $datePhp;
}
function PhpToMysqlDate ($string) {
$arr = explode('-', 'string) // array nog is like this: $arr[0] = '08'; $arr[1] = '09'; $arr[2] = '2010'
$dateMysql = $arr[2].'-'.$arr[1].'-'.$a
return $dateMysql;
}
You will need to do check/correction of the input field, since users can input it as a string and who knows how they will format the inputted date.
I currently store all date/time based columns as integer values (unix timestamps) when using mySQL/PHP.
If it is stored as a unix timestamp, use the function date("d-m-Y, $row_user_edit['Expiry']) to format the timestamp loaded from database.
If stored as a mySQL datetime field, you'll need to make a function to convert MySQL's standard datetime format of YYYY-MM-DD to DD-MM-YYYY
Since you have another question open to ask abotu storing a date in format DD-MM-YYYY in a mysql date field, I will now assume that this is what you will need.
Look at these functions to swap sequence of the dates in a string:
function MysqlToPhpDate ($string) {
$arr = explode('-', 'string) // array nog is like this: $arr[0] = '2010'; $arr[1] = '09'; $arr[2] = '08';
$datePhp = $arr[2].'-'.$arr[1].'-'.$a
return $datePhp;
}
function PhpToMysqlDate ($string) {
$arr = explode('-', 'string) // array nog is like this: $arr[0] = '08'; $arr[1] = '09'; $arr[2] = '2010'
$dateMysql = $arr[2].'-'.$arr[1].'-'.$a
return $dateMysql;
}
You will need to do check/correction of the input field, since users can input it as a string and who knows how they will format the inputted date.
This is pretty well understood in the knowledge base of "industry best practices" -- please read this article and post back here with any specific questions. HTH, ~Ray
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html
No offense meant to johnwarde, but strtotime() can also return FALSE. That's why you might want to read the article I posted.
ASKER
yes of course, I tried johnwardes solution first and it worked for me. I wil review your article and comment back,
regards
regards
http://php.net/manual/en/function.date.php
<input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . date("d/m/y", $row_user_edit['Expiry']) . '"/>