Kamis, 16 Februari 2012

save anggota

sintax anggota

require("conn.php");
$perintah = "INSERT INTO cust (kd_cust,nama,alamat,telp,hp,noktp,kk,slipgaji, ket) VALUES ('$_POST[kd_cust]', '$_POST[nama]', '$_POST[alamat]', '$_POST[telp]', '$_POST[hp]', '$_POST[noktp]', '$_POST[kk]', '$_POST[slipgaji]','$_POST[ket]')";
$result = mysql_query($perintah) or die ("gagal . ".mysql_error ());
if ($result)
{
echo "

save

include ("conn.php");
if (!$_REQUEST['nama']||!$_REQUEST['pass']){
?>
}else{
$id=$_REQUEST['id'];
$nama=$_REQUEST['nama'];
$pass=$_REQUEST['pass'];
$hak='client';
$sql = "insert into user value('$id','$nama','$pass','$hak')";
$query = mysql_query($sql);
if ($query){
echo "";
echo "";
}else{
echo "";
echo "";
}
?>
}
?>

cek cicil




cek cicil




panel admin

Daftar User
if(isset($_GET[halaman])) $halaman = $_GET[halaman]; else $halaman = 1;
$query = "select * from user order by id";
$tmp = mysql_query($query);
$pagesize = 5;
$startrow = ($halaman - 1) * $pagesize;
$rowcount = mysql_num_rows($tmp);
$pagecount = ceil($rowcount/$pagesize);
$query = $query . " limit $startrow, $pagesize";
$sql = mysql_query($query);
$warnaGenap = "#CCFF66";
$warnaGanjil = "#FFFBF2";
$counter = 1;
while ($data=mysql_fetch_array($sql))
{
if ($counter % 2 == 0) $warna = $warnaGenap;
else $warna = $warnaGanjil;
echo("
");
$counter++;
}
?>
ID
Nama
Password
Hak
Aksi
$data[id]
$data[nama]$data[pass]$data[hak]EditHapus
echo 'Hal ';
for($i = 1; $i <= $pagecount; $i++)
{
print " ";
}
?>

paneladmin.php

Daftar User
if(isset($_GET[halaman])) $halaman = $_GET[halaman]; else $halaman = 1;
$query = "select * from user order by id";
$tmp = mysql_query($query);
$pagesize = 5;
$startrow = ($halaman - 1) * $pagesize;
$rowcount = mysql_num_rows($tmp);
$pagecount = ceil($rowcount/$pagesize);
$query = $query . " limit $startrow, $pagesize";
$sql = mysql_query($query);
$warnaGenap = "#CCFF66";
$warnaGanjil = "#FFFBF2";
$counter = 1;
while ($data=mysql_fetch_array($sql))
{
if ($counter % 2 == 0) $warna = $warnaGenap;
else $warna = $warnaGanjil;
echo("
");
$counter++;
}
?>
ID
Nama
Password
Hak
Aksi
$data[id]
$data[nama]$data[pass]$data[hak]EditHapus
echo 'Hal ';
for($i = 1; $i <= $pagecount; $i++)
{
print " ";
}
?>