Untuk itu agar memudahkan saat menginput tanggal kita bisa saja mengubah dengan format Tanggal-Bulan-Tahun. Contohnya seperti tampilan berikut
Tetapi masalahnya timbul saat kita akan memasukan data tanggal tersebut ke database MySQL. Oleh karena itu, kita mesti mengubah format date menjadi Tahun-Bulan-Tanggal kembali saat proses insert ke database.Berikut ini contoh script singkatnya.
<?php
if (isset($_POST['submit'])){
$tgl = $_POST['tgl'];
$date = date_create($tgl);
echo date_format($date, 'Y-m-d');
}else{
?>
<html>
<head>
<link type="text/css" href="jqueryui/css/south-street/jquery-ui-1.8.16.custom.css" rel="Stylesheet" />
<script type="text/javascript" src="jqueryui/js/jquery-1.6.2.min.js"></script>
<script type="text/javascript" src="jqueryui/js/jquery-ui-1.8.16.custom.min.js"></script>
<script type='text/javascript'>
$(document).ready(function(){
$("#date").datepicker({dateFormat:"dd-mm-yy"});
});
</script>
</head>
<body>
<form method="post" action="test.php">
<input type="text" name="tgl" id='date'>
<input type="submit" name="submit">
</form>
</body>
</html>
<?php
}
?>
Dan saat kita klik submit query, maka format date berubah sesuai dengan format date pada MySQL kembali
?>
5 komentar:
thanks
okeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
MAACIH OM
Matur suwun sanget
baguuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuus
Posting Komentar