- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
<ask> tidak bisa simpan ke database
TS
hardy6889
<ask> tidak bisa simpan ke database
Pagi gaaaann..
Ane Lagi Belajar PHP ni gaan, Sekalian Untuk ngerjin TA (Tugas Akhir)
Buat agan agan yang udah master tolong bantu ane yaah..
Masalahnya gini gaaan..
Ane Kan mau Buat Form Inputan. Trus Pas Ane Coba Input Kenapa Tidak Bisa Input Ke Database Yah Gan?
Padahal Ane Tes Koneksi Suda Conect
Ip Server, Username Database, Sama Passwordnya Juga Sudah Bener
Spoiler for :
Nih Gan Scriptnya:
inputsiswa.php
Code:
<html>
\t<meta charset="UTC+7">
<head>
\t<title>Input Nama Siswa</title>
</head>
<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.4.js"></script>
<script src="http://ajax.microsoft.com/ajax/jquery.ui/1.8.5/jquery-ui.js"></script>
<script src="http://cachedcommons.org/cache/modernizr/1.5.0/javascripts/modernizr.js"></script>
<link href="http://ajax.microsoft.com/ajax/jquery.ui/1.8.5/themes/redmond/jquery-ui.css"
rel="stylesheet" type="text/css" />
<body>
\t<h2>Menambah Siswa Baru</h2>
<form name="formtambah" action="inputsiswa2.php" method="post">
\t<table border="1" bgcolor="#9ACD32">
\t\t<tr>
\t\t<td><b>NAMA</b></td>
\t\t<td> <input name="txtnama" type="text" size="20" maxlength="20" /></td>
\t\t</tr>
\t\t<tr>
\t\t<td><b>Tanggal Lahir</b></td>
\t\t<td> <input name="txttgllhr" type="date" /></td>
\t\t\t<script>
\t\t\t\t$(function() {
\t\t\t\t // Check if the browser supports the date input type
\t\t\tif (!Modernizr.inputtypes.date){
\t\t// Add the jQuery UI DatePicker to all
\t\t\t // input tags that have their type attributes
\t\t// set to 'date'
\t\t$('input[type=date]'.datepicker({
\t\t // specify the same format as the spec
\t\t dateFormat: 'yy-mm-dd'
\t\t\t});
\t\t\t\t}
\t\t\t\t\t});
\t\t\t</script>
\t\t</tr>
\t\t<tr>
\t\t<td><b>Tempat Lahir</b></td>
\t\t<td> <input name="txttmptlhr" type="text" size="20" maxlength="20" /></td>\t
\t\t</tr>
\t\t<tr>
\t\t<td><b>Alamat</b></td>
\t\t<td> <input name="txtalamat" type="text" size="50" maxlength="200" /></td>
\t\t</tr>
\t\t<tr>
\t\t<td><b>Telphone</b></td>
\t\t<td> <input name="txttlp" type="tetx" size="20" maxlength="20"/></td>\t
\t\t</tr>
\t\t<tr>
\t\t<td><b>Jenis Kelamin</b></td>
\t\t<td><input name="radiojnsklmn" type="radio"
\t\t\tvalue="1" checked />Pria
\t\t \t<input name="radiojnsklmn" type="radio"
\t\t\tvalue="2" />Wanita</td>
\t\t</tr>
\t\t<tr>
\t\t\t<td colspan="2"> <p style="text-align: center;"><input name="cmbsimpan" type="submit" value="Simpan" /></p></td>
\t\t</tr>
\t\t
\t\t
\t\t
\t</table>
\t
\t
</form>\t
\t
</body>\t
\t
\t
\t
</html>
inputsiswa2.php
Code:
<html>
<head>
\t<title>Menympan Data Siswa</title>
</head>
<body>
<?php
//Mengambil Data Dari inputsiswa
$txtnama = $_POST['txtnama'];
$txttgllhr = $_POST['txttgllhr'];
$txttmptlhr = $_POST ['txttmptlhr'];
$txtalamat = $_POST ['txtalamat'];
$txttlp = $_POST['txttlp'];
$radiojnsklmn = $_POST ['radiojnsklmn'];
// Proses mysql
$Server = "192.168.2.6";
$pemakai = "bejo" ;
$password = "1234";
$id_mysql = mysql_connect($Server,$pemakai,$password);
$db_belajar = mysql_select_db("belajar", $id_mysql);
$sql = "INSERT INTO belajar (nama,jnsklmn,tgllhr,tmptlhr,alamat,telp)";
\t"VALUES ('$txtnama','$txttgllhr','$txttmptlhr','$txtalamat','$txttlp','$radiojnsklmn'
$hasil = mysql_query($sql, $id_mysql);
if (empty($hasil))
\tprint("Gagal Menyimpan Data nama='$txtnama'");
else
\tprint ("Data Telah Tersimpan nama='$txtnama'");
mysql_close($id_mysql);
?>\t
</body>\t
\t
\t
</html>
0
15.1K
10
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan