- Beranda
- Programmer Forum
[ASK]DatePicker tidak masuk di database ?
...
TS
Ichida
[ASK]DatePicker tidak masuk di database ?
Sorry klo ini di anggap nyampah tapi mohon sekali bantuannya,
Para Suhu mohon Banget bantuannya saya masih newbie, mohon sekali bantuannya
jadi saya punya script php tapi date picker , nah datanya tidam mau masuk kedalam databse , kenapa yah ? apa yg salah
Yang bisa bantu saya kasih cendol
![[ASK]DatePicker tidak masuk di database ?](https://s.kaskus.id/images/2015/03/27/946507_20150327104806.PNG)
Para Suhu mohon Banget bantuannya saya masih newbie, mohon sekali bantuannya
jadi saya punya script php tapi date picker , nah datanya tidam mau masuk kedalam databse , kenapa yah ? apa yg salah
Yang bisa bantu saya kasih cendol
Quote:
Original Posted By index.php
<html>
<head>
<title>CRUD Dengan PHP </title>
<meta charset="utf-8">
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
[removed][removed]
[removed][removed]
<link rel="stylesheet" href="/resources/demos/style.css">
[removed]
$(function() {
$( "#duedate" ).datepicker({dateFormat : 'yy-mm-dd',
});
[removed]
<style type="text/css">
.labelfrm{
display:block;
font-size:small;
margin-top:5px;
}
.error{
font-size:small;
color:red;
}
</style>
</head>
<body>
<h1>Data Mahasiswa</h1>
<form action="input.php" method="post" id="frm">
<table align="center" border="1" >
<tr>
<td><label for="nis" class="labelfrm">NIS : </label></td>
<td><input type="text" name="nis" id="nis" maxlength="10" class="required" size="15"/></td>
</tr>
<tr>
<td><label for="nama" class="labelfrm" >NAMA : </label></td>
<td><input type="text" name="nama" id="nama" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="alamat" class="labelfrm">ALAMAT : </label></td>
<td><input type="text" name="alamat" id="alamat" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="initiatives" class="labelfrm">INITIATIVES : </label></td>
<td><input type="text" name="initiatives" id="initiatives" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="smart_target_2015" class="labelfrm">SMART TARGET 2015 : </label></td>
<td><input type="text" name="smart_target_2015" id="smart_target_2015" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="deadline" class="labelfrm">DEAD LINE : </label></td>
<td><input type="text" name="deadline" id="deadline" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="duedate" class="labelfrm">DUE DATE : </label></td>
<td><input type="text" id="duedate" ></td>
</tr>
</table>
<input type="submit" name="input" value="Simpan" id="input"/>
<input type="reset" name="clear" value="clear" id="clear"/>
</form>
<br><br>
<a href="data.php">Lihat Data</a>
</html>
<html>
<head>
<title>CRUD Dengan PHP </title>
<meta charset="utf-8">
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
[removed][removed]
[removed][removed]
<link rel="stylesheet" href="/resources/demos/style.css">
[removed]
$(function() {
$( "#duedate" ).datepicker({dateFormat : 'yy-mm-dd',
});
[removed]
<style type="text/css">
.labelfrm{
display:block;
font-size:small;
margin-top:5px;
}
.error{
font-size:small;
color:red;
}
</style>
</head>
<body>
<h1>Data Mahasiswa</h1>
<form action="input.php" method="post" id="frm">
<table align="center" border="1" >
<tr>
<td><label for="nis" class="labelfrm">NIS : </label></td>
<td><input type="text" name="nis" id="nis" maxlength="10" class="required" size="15"/></td>
</tr>
<tr>
<td><label for="nama" class="labelfrm" >NAMA : </label></td>
<td><input type="text" name="nama" id="nama" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="alamat" class="labelfrm">ALAMAT : </label></td>
<td><input type="text" name="alamat" id="alamat" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="initiatives" class="labelfrm">INITIATIVES : </label></td>
<td><input type="text" name="initiatives" id="initiatives" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="smart_target_2015" class="labelfrm">SMART TARGET 2015 : </label></td>
<td><input type="text" name="smart_target_2015" id="smart_target_2015" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="deadline" class="labelfrm">DEAD LINE : </label></td>
<td><input type="text" name="deadline" id="deadline" size="30" class="required"/></td>
</tr>
<tr>
<td><label for="duedate" class="labelfrm">DUE DATE : </label></td>
<td><input type="text" id="duedate" ></td>
</tr>
</table>
<input type="submit" name="input" value="Simpan" id="input"/>
<input type="reset" name="clear" value="clear" id="clear"/>
</form>
<br><br>
<a href="data.php">Lihat Data</a>
</html>
Quote:
Original Posted By input.php
<?php
include "koneksi.php";
$nis = $_POST['nis'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$initiatives = $_POST['initiatives'];
$smart_target_2015 = $_POST['smart_target_2015'];
$deadline = $_POST['deadline'];
//$duedate = date('Y-m-d',($_POST['duedate']));
$duedate = $_POST['duedate'];
$simpan = mysql_query("Insert Into tb_siswa values('$nis','$nama','$alamat','initiatives','smart_target_2015','deadline','duedate')");
header('location:data.php');
?>
<?php
include "koneksi.php";
$nis = $_POST['nis'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$initiatives = $_POST['initiatives'];
$smart_target_2015 = $_POST['smart_target_2015'];
$deadline = $_POST['deadline'];
//$duedate = date('Y-m-d',($_POST['duedate']));
$duedate = $_POST['duedate'];
$simpan = mysql_query("Insert Into tb_siswa values('$nis','$nama','$alamat','initiatives','smart_target_2015','deadline','duedate')");
header('location:data.php');
?>
Quote:
Original Posted By data.php
<?php
include "koneksi.php";
$query=mysql_query("select * from tb_siswa");
$jumlah=mysql_num_rows($query);
echo "Jumlah data ada : ".$jumlah;
?>
<table border="1" cellspacing="0">
<tr>
<th>Nim</th>
<th>Nama</th>
<th>ALamat</th>
<th>INITIATIVES</th>
<th>SMART TARGET 2015</th>
<th>DEAD LINE</th>
<th>DUE DATE</th>
<th>Aksi</th>
</tr>
<?php
while($row=mysql_fetch_array($query)){
?>
<tr>
<td><?php echo $row['Nim'];?></td>
<td><?php echo $row['Nama'];?></td>
<td><?php echo $row['Alamat'];?></td>
<td><?php echo $row['Initiatives'];?></td>
<td><?php echo $row['Smart_Target_2015'];?></td>
<td><?php echo $row['Deadline'];?></td>
<td><?php echo $row['Duedate'];?></td>
<td>
<a href="delete.php?nis=<?php echo $row['Nis']; ?>"><input type="submit" name="i" value="Simpan" /></a>
<a href="update.php?nis=<?php echo $row['Nis']; ?>"><input type="reset" name="c" value="clear" /></a>
</td>
<?php
}
?>
</table><br />
<a href="index.php">Tambah Data</a><br><br>
<?php
include "koneksi.php";
$query=mysql_query("select * from tb_siswa");
$jumlah=mysql_num_rows($query);
echo "Jumlah data ada : ".$jumlah;
?>
<table border="1" cellspacing="0">
<tr>
<th>Nim</th>
<th>Nama</th>
<th>ALamat</th>
<th>INITIATIVES</th>
<th>SMART TARGET 2015</th>
<th>DEAD LINE</th>
<th>DUE DATE</th>
<th>Aksi</th>
</tr>
<?php
while($row=mysql_fetch_array($query)){
?>
<tr>
<td><?php echo $row['Nim'];?></td>
<td><?php echo $row['Nama'];?></td>
<td><?php echo $row['Alamat'];?></td>
<td><?php echo $row['Initiatives'];?></td>
<td><?php echo $row['Smart_Target_2015'];?></td>
<td><?php echo $row['Deadline'];?></td>
<td><?php echo $row['Duedate'];?></td>
<td>
<a href="delete.php?nis=<?php echo $row['Nis']; ?>"><input type="submit" name="i" value="Simpan" /></a>
<a href="update.php?nis=<?php echo $row['Nis']; ?>"><input type="reset" name="c" value="clear" /></a>
</td>
<?php
}
?>
</table><br />
<a href="index.php">Tambah Data</a><br><br>
Quote:
0
3.2K
Kutip
4
Balasan
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.9KAnggota
Urutkan
Terlama
Komentar yang asik ya