Syntax Delete

9 06 2008

<?
include”konek.php”;
$sql=”delete from member where member=’$data’”;
$laksanakan=mysql_query($sql);
if ($laksanakan){
header(“location:tampil.php”);
}else{
echo “data gagal dihapus”;
}
?>





Syntax Save

9 06 2008

<?
$member=$_POST["member"];
$pass=$_POST["pass"];
$nama=$_POST["nama"];
$alamat=$_POST["alamat"];
$telepon=$_POST["telepon"];
$kota=$_POST["kota"];
$pekerjaan=$_POST["pekerjaan"];

include”konek.php”;
$sql=”insert into member(member,pass,nama,alamat,telepon,kota,pekerjaan) values (‘$member’,'$pass’,'$nama’,'$alamat’,'$telepon’,'$kota’,'$pekerjaan’)”;
$laksanakan = mysql_query($sql);

if ($laksanakan){
header(“location:index.php”);
}else{
echo “data tidak bisa disimpan”;
}
?>