- Beranda
- Website, Webmaster, Webdeveloper
<ASK> cara ngedit database via php
...
TS
madeeby
<ASK> cara ngedit database via php
gan ane mau ngedit isi database ane via php.. ane sdh ada scriptx. tapi kagak berhasil mulu... tolongin ane donk, kira2 salahx dimana yaa 
ini scriptx gan:
*koneksi. php
<?php
$host="localhost";
$user="root";
$pass="";
$db="tkj";
$sambung=mysql_connect($host,$user,$pass);
mysql_select_db($db,$sambung);
?>
*editdosen.php
<?php
include("koneksi.php");
if (isset($_POST['simpanedit']))
{
$id_dosen = $_POST['txtid_dosen'];
$nama_dosen = $_POST['txtnama_dosen'];
$no_hp = $_POST['txtno_hp'];
$query1 = "UPDATE data_dosen SET nama_dosen = '$nama_dosen', no_hp='$no_hp' WHERE id_dosen='$id_dosen'";
$jalan = mysql_query('$query1');
if($jalan){
echo "[removed]alert('Data berhasil diinput')
location.replace('input.php');[removed]";
} else {
echo "gagal";
}}
?>
*formeditdosen.php
<?php
$sambung = mysql_connect("localhost","root","") or die ("Gagal connect ke server");
mysql_select_db("tkj") or die ("Gagal membuka database");
$id_dosen = $_GET['id_dosen'];
$query = "select *from data_dosen where id_dosen='$id_dosen'";
$result = mysql_query($query, $sambung) or die ("gagal melakukan query");
$dosen = mysql_fetch_array($result);
mysql_close ($sambung);
?>
<head>
<style>
fieldset {width:300px;}
#bagiankiri {background-color:#13425a;float:left;width:30%;margin-top:50px;}
#tabeldosen {background-color:#13425a;float:left;width:70%;margin-top:50px;}
.bersih {clear:both;}
</style>
</head>
<?php
include("halawal1.php"); ?>
<form method="post" action="editdosen.php">
<div id="bagiankiri">
<fieldset>
<legend>Input Data Dosen</legend>
<table id="inputdosen">
<tr>
<th>ID Dosen</th>
<th><input name="txtid_dosen" id="txtid_dosen" class="ctext" title="Masukkan NIP/ID Dosen" type="text" size="20" value="<?php echo $dosen['id_dosen']; ?>"></th>
</tr>
<tr>
<th>Nama Dosen</th>
<th><input name="txtnama_dosen" id="txtnama_dosen" class="ctext" title="Masukkan Nama Dosen" type="text" size="20" value="<?php echo $dosen['nama_dosen']; ?>"></th>
</tr>
<tr>
<th>No HP dosen</th>
<th><input name="txtno_hp" id="txtno_hp" class="ctext" title="Masukkan No HP Dosen" type="text" size="20" value="<?php echo $dosen['no_hp']; ?>"></th>
</tr>
</table>
<table id="buttondosen" name="buttondosen">
<tr><th></br></th></tr>
<tr>
<th><input name="simpanedit" type="submit" value="SIMPAN"/></th>
</tr>
</table>
</fieldset>
</div>
</form>
ini scriptx gan:
*koneksi. php
<?php
$host="localhost";
$user="root";
$pass="";
$db="tkj";
$sambung=mysql_connect($host,$user,$pass);
mysql_select_db($db,$sambung);
?>
*editdosen.php
<?php
include("koneksi.php");
if (isset($_POST['simpanedit']))
{
$id_dosen = $_POST['txtid_dosen'];
$nama_dosen = $_POST['txtnama_dosen'];
$no_hp = $_POST['txtno_hp'];
$query1 = "UPDATE data_dosen SET nama_dosen = '$nama_dosen', no_hp='$no_hp' WHERE id_dosen='$id_dosen'";
$jalan = mysql_query('$query1');
if($jalan){
echo "[removed]alert('Data berhasil diinput')
location.replace('input.php');[removed]";
} else {
echo "gagal";
}}
?>
*formeditdosen.php
<?php
$sambung = mysql_connect("localhost","root","") or die ("Gagal connect ke server");
mysql_select_db("tkj") or die ("Gagal membuka database");
$id_dosen = $_GET['id_dosen'];
$query = "select *from data_dosen where id_dosen='$id_dosen'";
$result = mysql_query($query, $sambung) or die ("gagal melakukan query");
$dosen = mysql_fetch_array($result);
mysql_close ($sambung);
?>
<head>
<style>
fieldset {width:300px;}
#bagiankiri {background-color:#13425a;float:left;width:30%;margin-top:50px;}
#tabeldosen {background-color:#13425a;float:left;width:70%;margin-top:50px;}
.bersih {clear:both;}
</style>
</head>
<?php
include("halawal1.php"); ?>
<form method="post" action="editdosen.php">
<div id="bagiankiri">
<fieldset>
<legend>Input Data Dosen</legend>
<table id="inputdosen">
<tr>
<th>ID Dosen</th>
<th><input name="txtid_dosen" id="txtid_dosen" class="ctext" title="Masukkan NIP/ID Dosen" type="text" size="20" value="<?php echo $dosen['id_dosen']; ?>"></th>
</tr>
<tr>
<th>Nama Dosen</th>
<th><input name="txtnama_dosen" id="txtnama_dosen" class="ctext" title="Masukkan Nama Dosen" type="text" size="20" value="<?php echo $dosen['nama_dosen']; ?>"></th>
</tr>
<tr>
<th>No HP dosen</th>
<th><input name="txtno_hp" id="txtno_hp" class="ctext" title="Masukkan No HP Dosen" type="text" size="20" value="<?php echo $dosen['no_hp']; ?>"></th>
</tr>
</table>
<table id="buttondosen" name="buttondosen">
<tr><th></br></th></tr>
<tr>
<th><input name="simpanedit" type="submit" value="SIMPAN"/></th>
</tr>
</table>
</fieldset>
</div>
</form>
Diubah oleh madeeby 03-07-2013 02:58
0
1.3K
5
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Website, Webmaster, Webdeveloper
23.3KThread•4.4KAnggota
Urutkan
Terlama
Komentar yang asik ya