Selamat Datang ..... Buat shobat2 ,,,,,
welcome kalau bahasa inggrisnya .....
di sini shobat blogger bisa saling share tentang keilmuan Kita di bidang IT ,,,,, baik itu yang simple sampai yang luar bisa ,,, contoh membuat aplikasi besar ,,,,,
di sini saya akan membagi ilmu sedikit tentang PHP yaitu DML (Data Manipulation Language) tapi hanya insert ajj because saya yang lain saya sendiri belum begitu faham / artinya baru tau ....
langsung ajj menuju Ke TKP
Kembali ke LAPTOP
Di sini saya menggunakan database "TOKO"
____ Koneksi .php _____
<?php
$conn = mysql_connect ("localhost","root","");
$sukses = mysql_select_db ("toko",$conn);
?>
Di sini file Koneksi.php akan di include kan pada file di bawah ini
coding nya seperti ini
include "koneksi.php";
lanjut ......................
____tambah_data.php____
<!DOCTYPE html>
<!-- Website template by freewebsitetemplates.com -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>BLACKBERRY BUSSINES</title>
<link rel="stylesheet" href="css/style.css" type="text/css" charset="utf-8" />
<!--[if lte IE 7]>
<link rel="stylesheet" href="css/ie.css" type="text/css" charset="utf-8" />
<![endif]-->
</head>
<body>
<div id="header">
<font align="center" face="Tempus Sans ITC" size="200" color="white"><b>BlackberryBusinnes</b></font>
<div id="navigation">
<ul>
<li><a href="home_admin.php?b=index">Home</a></li>
<li><a href="home_admin.php?b=produk">Daftar Produk</a></li>
<li><a href="home_admin.php?b=kontak">Kontak Kami</a></li>
<li><a href="login.php?op=out">LogOut</a> </li>
</ul>
</div>
<div id="search">
<form action="" method="">
<input type="text" value="Search" class="txtfield" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" />
<input type="submit" value="" class="button" />
</form>
</div>
</div> <!-- /#header -->
<div id="contents">
<div class="background">
<div id="solutions">
<div id="input">
<fieldset style="width:48%;margin:auto;border:outset">
<legend><font face="Times New Roman, Times, serif" size="4"> Tambah Data BlackBerry </font></legend>
<form action="" method="post">
<table width="540" border="0" align="center" cellpadding="4" cellspacing="4" id="insert">
<?php
$tambah = $_POST['tambah'];
if($tambah){
include "koneksi.php";
$id=$_POST['txtId'];
$nama=$_POST['txtNama'];
$type=$_POST['txtType'];
$stok=$_POST['txtStok'];
$harga=$_POST['txtHarga'];
if(!$sukses){
echo "Koneksi Gagal";
}else{
$sql = "insert into bb values('$id','$nama','$type','$stok','$harga')";
$ab = mysql_query($sql,$conn);
if($ab){
echo "<script>alert('Data berhasi Disimpan')</script>";
echo "<script>document.location.href='home_admin.php?b=produk'</script>";
}
}
}
?>
<tr>
<td width="191"><font face="times new roman">Id BlackBerry</font></td>
<td width="6">:</td>
<td width="305"><input type="text" value="Masukkan Id BB" name="txtId" class="txtfield" size="20" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td><font face="times new roman">Nama BlackBerry</font></td>
<td>:</td>
<td><input type="text" value="Masukkan Nama BB" name="txtNama" class="txtfield" size="50" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td><font face="times new roman">Type BlackBerry</font></td>
<td>:</td>
<td><input type="text" value="Masukkan Type BB" name="txtType" class="txtfield" size="50" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td><font face="times new roman">Stok</font></td>
<td>:</td>
<td><select name="txtStok" class="txtfield" selected="">
<?php
for($i=1;$i<=100;$i++){
echo "<option> $i</option>";
}
?>
</select>
</tr>
<td><font face="times new roman">Harga Satuan</font></td>
<td>:</td>
<td><input type="text" value="Masukkan Harga Satuan BB" name="txtHarga" class="txtfield" size="30" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td> </td>
<td> </td>
<td><input type="submit" name="tambah"value="TAMBAH" /></td>
</tr>
</table>
</body>
</html>
Good Luck shobat .....
semoga succses full
welcome kalau bahasa inggrisnya .....
di sini shobat blogger bisa saling share tentang keilmuan Kita di bidang IT ,,,,, baik itu yang simple sampai yang luar bisa ,,, contoh membuat aplikasi besar ,,,,,
di sini saya akan membagi ilmu sedikit tentang PHP yaitu DML (Data Manipulation Language) tapi hanya insert ajj because saya yang lain saya sendiri belum begitu faham / artinya baru tau ....
langsung ajj menuju Ke TKP
Kembali ke LAPTOP
Di sini saya menggunakan database "TOKO"
____ Koneksi .php _____
<?php
$conn = mysql_connect ("localhost","root","");
$sukses = mysql_select_db ("toko",$conn);
?>
Di sini file Koneksi.php akan di include kan pada file di bawah ini
coding nya seperti ini
include "koneksi.php";
lanjut ......................
____tambah_data.php____
<!DOCTYPE html>
<!-- Website template by freewebsitetemplates.com -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>BLACKBERRY BUSSINES</title>
<link rel="stylesheet" href="css/style.css" type="text/css" charset="utf-8" />
<!--[if lte IE 7]>
<link rel="stylesheet" href="css/ie.css" type="text/css" charset="utf-8" />
<![endif]-->
</head>
<body>
<div id="header">
<font align="center" face="Tempus Sans ITC" size="200" color="white"><b>BlackberryBusinnes</b></font>
<div id="navigation">
<ul>
<li><a href="home_admin.php?b=index">Home</a></li>
<li><a href="home_admin.php?b=produk">Daftar Produk</a></li>
<li><a href="home_admin.php?b=kontak">Kontak Kami</a></li>
<li><a href="login.php?op=out">LogOut</a> </li>
</ul>
</div>
<div id="search">
<form action="" method="">
<input type="text" value="Search" class="txtfield" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" />
<input type="submit" value="" class="button" />
</form>
</div>
</div> <!-- /#header -->
<div id="contents">
<div class="background">
<div id="solutions">
<div id="input">
<fieldset style="width:48%;margin:auto;border:outset">
<legend><font face="Times New Roman, Times, serif" size="4"> Tambah Data BlackBerry </font></legend>
<form action="" method="post">
<table width="540" border="0" align="center" cellpadding="4" cellspacing="4" id="insert">
<?php
$tambah = $_POST['tambah'];
if($tambah){
include "koneksi.php";
$id=$_POST['txtId'];
$nama=$_POST['txtNama'];
$type=$_POST['txtType'];
$stok=$_POST['txtStok'];
$harga=$_POST['txtHarga'];
if(!$sukses){
echo "Koneksi Gagal";
}else{
$sql = "insert into bb values('$id','$nama','$type','$stok','$harga')";
$ab = mysql_query($sql,$conn);
if($ab){
echo "<script>alert('Data berhasi Disimpan')</script>";
echo "<script>document.location.href='home_admin.php?b=produk'</script>";
}
}
}
?>
<tr>
<td width="191"><font face="times new roman">Id BlackBerry</font></td>
<td width="6">:</td>
<td width="305"><input type="text" value="Masukkan Id BB" name="txtId" class="txtfield" size="20" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td><font face="times new roman">Nama BlackBerry</font></td>
<td>:</td>
<td><input type="text" value="Masukkan Nama BB" name="txtNama" class="txtfield" size="50" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td><font face="times new roman">Type BlackBerry</font></td>
<td>:</td>
<td><input type="text" value="Masukkan Type BB" name="txtType" class="txtfield" size="50" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td><font face="times new roman">Stok</font></td>
<td>:</td>
<td><select name="txtStok" class="txtfield" selected="">
<?php
for($i=1;$i<=100;$i++){
echo "<option> $i</option>";
}
?>
</select>
</tr>
<td><font face="times new roman">Harga Satuan</font></td>
<td>:</td>
<td><input type="text" value="Masukkan Harga Satuan BB" name="txtHarga" class="txtfield" size="30" onBlur="javascript:if(this.value==''){this.value=this.defaultValue;}" onFocus="javascript:if(this.value==this.defaultValue){this.value='';}" /></td>
</tr>
<td> </td>
<td> </td>
<td><input type="submit" name="tambah"value="TAMBAH" /></td>
</tr>
</table>
</body>
</html>
Good Luck shobat .....
semoga succses full