- Beranda
- 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
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Mari bergabung, dapatkan informasi dan teman baru!
Website, Webmaster, Webdeveloper
23.3KThread•4.4KAnggota
Urutkan
Terlama
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru