MEMBUAT WEB PENJUALAN UNTUK ADMIN MENGGUNAKAN PHP

Script Layout/head.php :

<html>

<head>

<title>Arief.com</title>

window.dataLayer = window.dataLayer || [];

function gtag(){dataLayer.push(arguments);}

gtag('js', new Date());

gtag('config', 'UA-119386393-1');

</script>

</head>

<body>

Script Layout/navbar.php :

<form>

</a>

</div>

</div>

<label class="col-sm-12 col-md-2 col-form-label">Subject</label>

</div>

<button class="btn btn-primary">Search</button>

</div>

</form>

</div>

</a>

</div>

</a>

<ul>

<li>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed...</p>

</a>

</li>

<li>

<h3>Lea R. Frith</h3>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed...</p>

</a>

</li>

<li>

<h3>Erik L. Richards</h3>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed...</p>

</a>

</li>

<li>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed...</p>

</a>

</li>

<li>

<h3>Renee I. Hansen</h3>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed...</p>

</a>

</li>

<li>

<h3>Vicki M. Coleman</h3>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed...</p>

</a>

</li>

</ul>

</div>

</span>

</a>

<?php if($_SESSION["cstatus"]=="Administrator"){ ?>

<?php } else if($_SESSION["cstatus"]=="Kasir"){ ?>

<a class="dropdown-item" href="?mnu=profile"><i class="dw dw-user1"></i> Profile</a>

<?php } else{} ?>

</div>

Layout Settings

<span class="btn-block font-weight-400 font-12">User Interface Settings</span>

</h3>

</div>

<h4 class="weight-600 font-18 pb-10">Header Background</h4>

<a href="javascript:void(0);" class="btn btn-outline-primary header-white active">White</a>

</div>

<h4 class="weight-600 font-18 pb-10">Sidebar Background</h4>

<a href="javascript:void(0);" class="btn btn-outline-primary sidebar-light ">White</a>

</div>

<h4 class="weight-600 font-18 pb-10">Menu Dropdown Icon</h4>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<button class="btn btn-danger" id="reset-settings">Reset Settings</button>

</div>

Script Layout/sidebar.php :

</a>

</div>

</a>

</li>

<?php

if($_SESSION["cstatus"]=="Administrator"){

echo'

<span class="micon dw dw-edit2"></span><span class="mtext">Admin</span>

</a>

</li>

<span class="micon dw dw-edit2"></span><span class="mtext">Pelanggan</span>

</a>

</li>

<span class="micon dw dw-library"></span><span class="mtext">Produk</span>

</a>

</li>

<li>

<span class="micon dw dw-chat3"></span><span class="mtext">Chat Admin</span>

</a>

</li>';

} else if($_SESSION["cstatus"]=="Kasir"){

echo'

<span class="micon dw dw-edit2"></span><span class="mtext">Profil</span>

</a>

</li>

<span class="micon dw dw-edit2"></span><span class="mtext">Pelanggan</span>

</a>

</li>

<span class="micon dw dw-library"></span><span class="mtext">Produk</span>

</a>

</li>

<li>

<span class="micon dw dw-chat3"></span><span class="mtext">Chat Admin</span>

</a>

</li>';

} else{} ?>

<li>

</li>

</ul>

</div>

Script Layout/js.php :

Script Index.php :

<?php

if (version_compare(phpversion(), "5.3.0", ">=") == 1)

error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

else

error_reporting(E_ALL & ~E_NOTICE);

<?php

session_start();

//error_reporting(0);

require_once "konmysqli.php";

$mnu = "";

if (isset($_GET["mnu"])) {

$mnu = $_GET["mnu"];

}

if(!isset($_SESSION["cid"])){

die("<script>location.href='login.php';</script>");

}

require_once"layout/head.php";

require_once"layout/navbar.php";

require_once"layout/sidebar.php";

<?php

if($mnu=="profile"){include"profile.php";}

else if($mnu=="admin"){include"admin/admin.php";}

else if($mnu=="pelanggan"){include"pelanggan/pelanggan.php";}

else if($mnu=="produk"){include"produk/produk.php";}

else if($mnu=="kpelanggan"){include"pelanggan/kpelanggan.php";}

else if($mnu=="kproduk"){include"produk/kproduk.php";}

else if($mnu=="login"){include"login.php";}

else if($mnu=="register"){include"register.php";}

else if($mnu=="logout"){include"logout.php";}

else if($mnu=="produk"){include"produk.php";}

else{include"home.php";}

</div>

Terima Kasih Telah Berbelanja Diweb - Arief.com</a>

</div>

<?php

include"layout/js.php";

Script Login.php :

<?php

session_start();

require_once "konmysqli.php";

<html>

<head>

<title>Arief.com</title>

window.dataLayer = window.dataLayer || [];

function gtag(){dataLayer.push(arguments);}

gtag('js', new Date());

gtag('config', 'UA-119386393-1');

</script>

</head>

</a>

</div>

<ul>

<li><a href="register.php">Register</a></li>

</ul>

</div>

</div>

<h2 class="text-center text-primary">Login To Arief.com</h2>

</div>

</div>

</div>

</div>

</form>

</div>

</body>

</html>

<?php

if (isset($_POST["Login"])) {

$usr = $_POST["user"];

$pas = $_POST["pass"];

$sql1 = "select * from `$tbadmin` where `username`='$usr' and `password`='$pas' and `status`='Aktif'";

if (getJum($conn, $sql1) > 0) {

$d = getField($conn, $sql1);

$kode = $d["id_admin"];

$nama = $d["nama_admin"];

$bagian = $d["keterangan"];

$_SESSION["cid"] = $kode;

$_SESSION["cnama"] = $nama;

$_SESSION["cstatus"] = $bagian;

echo "<script>alert('Otentikasi " . $_SESSION["cstatus"] . " an " . $_SESSION["cnama"] . " (" . $_SESSION["cid"] . ") berhasil Login!');

document.location.href='index.php?mnu=home';</script>";

} else {

session_destroy();

echo "<script>alert('Otentikasi Login GAGAL !,Silakan cek data Anda kembali...');

document.location.href='index.php?mnu=login';</script>";

}

Tampilan Script Login :

Tampilan Script Database Admin : db_master/tb_admin

Script home.php :

</div>

Selamat Datang Diweb Jual Beli Laptop Terpercaya!<div class="weight-600 font-30 text-blue"><a href="http://localhost/webadmin/" target="_blank">Arief.com!</a></div>

</h4>

<p class="font-18 max-width-600">Saya membuka usaha ruko laptop ini, agar dapat membuka lowongan pekerjaan bagi orang-orang yang belum mendapatkan pekerjaan. Alasan saya membuat bisnin tersebut yaaa biar sukses/cepet kaya-lah apalagi wkwkwk.</p>

</div>

</div>

<div class="weight-600 font-14">Fast Response</div>

</div>

</div>

<div class="weight-600 font-14">Terjual</div>

</div>

</div>

<div class="weight-600 font-14">Campaign</div>

</div>

</div>

<div class="h4 mb-0">Rp.1 Miliar</div>

<div class="weight-600 font-14">Profite</div>

</div>

<h2 class="h4 mb-20">Activity</h2>

</div>

<h2 class="h4 mb-20">Rating Toko</h2>

</div>

<h2 class="h4 pd-20">Produk Terlaris</h2>

<tr>

<th>Gambar</th>

<th>Harga</th>

<th>Kategori</th>

<th>Status</th>

</tr>

<?php

$sql = "select * from `$tbproduk` order by `id_produk` asc";

$jum = getJum($conn, $sql);

$arr = getData($conn, $sql);

foreach ($arr as $d) {

$id_produk = $d["id_produk"];

$nama_produk = ucwords($d["nama_produk"]);

$deskripsi = $d["deskripsi"];

$gambar = $d["gambar"];

$harga = $d["harga"];

$kategori = $d["kategori"];

$status = $d["status"];

$keterangan = $d["keterangan"];

<tr>

<td><img src="ypathfile/<?php echo $gambar; ?>" width="70" height="70" alt=""></td>

</tr>

<?php } ?>

</table>

</div>

Tampilan Script Home :

Script profile.php :

<h4>Profile</h4>

</div>

<li class="breadcrumb-item"><a href="?mnu=profile1">Profile</li>

</nav>

</div>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

<?php

$id_admin = $_SESSION["cid"];

$sql = "select * from `$tbadmin` where `id_admin`='$id_admin'";

$d = getField($conn, $sql);

$id_admin = $d["id_admin"];

$nama_admin = $d["nama_admin"];

$username = $d["username"];

$password = $d["password"];

$telepon = $d["telepon"];

$email = $d["email"];

$status = $d["status"];

$keterangan = $d["keterangan"];

<h5 class="mb-20 h5 text-blue">Informasi Kontak</h5>

<ul>

<li>

<span>Email Address:</span>

<?php echo $email; ?>

</li>

<li>

<span>Phone Number:</span>

<?php echo $telepon; ?>

</li>

<li>

<span>Negara:</span>

Indonesia

</li>

</ul>

</div>

<h5 class="mb-20 h5 text-blue">Social Media Links</h5>

</ul>

</div>

<h5 class="mb-20 h5 text-blue">Key Skills</h5>

</div>

</div>

</div>

<h6 class="mb-5 font-14">Bootstrap</h6>

</div>

<h6 class="mb-5 font-14">JavaScript</h6>

</div>

<a class="nav-link active" data-toggle="tab" href="#setting" role="tab">Register</a>

</li>

</ul>

<label>Nama Lengkap</label>

</div>

<label>Email</label>

</div>

<label>Telepon</label>

</div>

<label>Username</label>

</div>

<label>Password</label>

</div> <div class="form-group">

<label class="custom-control-label weight-400" for="customCheck1-1">Saya setuju untuk menerima email pemberitahuan</label>

</div>

</div>

</li>

</ul>

</form>

</div>

</body>

</html>

<?php

if (isset($_POST["Update"])) {

$id_admin = strip_tags($_POST["id_admin"]);

$username = strip_tags($_POST["username"]);

$nama_admin = strip_tags($_POST["nama_admin"]);

$password = strip_tags($_POST["password"]);

$telepon = strip_tags($_POST["telepon"]);

$email = strip_tags($_POST["email"]);

$status = strip_tags($_POST["status"]);

$keterangan = strip_tags($_POST["keterangan"]);

$sql = "update `$tbadmin` set

`nama_admin`='$nama_admin',

`username`='$username',

`password`='$password',

`telepon`='$telepon' ,

`email`='$email'

where `id_admin`='$id_admin'";

$ubah = process($conn, $sql);

if ($ubah) {

echo "<script>alert('Data $nama_admin berhasil diubah !');document.location.href='?mnu=profile';</script>";

} else {

echo "<script>alert('Data $nama_admin gagal diubah...');document.location.href='?mnu=profile';</script>";

}

} //else simpan

Tampilan Script profile:

Script admin.php :

<?php

$pro = "simpan";

$nama_admin = "";

$username = "";

$password = "";

$telepon = "";

$email = "";

$status = "Aktif";

$keterangan = "";

function PRINT(pk) {

win = window.open('admin/admin_print.php?pk=' + pk, 'win', 'width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=0');

}

</script>

function buka(url) {

window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');

}

</script>

<?php

$sql = "select `id_admin` from `$tbadmin` order by `id_admin` desc";

$jum = getJum($conn, $sql);

$kd = "ADM";

if ($jum > 0) {

$d = getField($conn, $sql);

$idmax = $d['id_admin'];

$urut = substr($idmax, 3, 2) + 1; //01

if ($urut < 10) {

$idmax = "$kd" . "0" . $urut;

} else {

$idmax = "$kd" . $urut;

}

} else {

$idmax = "$kd" . "01";

}

$id_admin = $idmax;

<?php

if (isset($_GET["pro"]) && $_GET["pro"] == "ubah") {

$id_admin = $_GET["kode"];

$sql = "select * from `$tbadmin` where `id_admin`='$id_admin'";

$d = getField($conn, $sql);

$id_admin = $d["id_admin"];

$id_admin0 = $d["id_admin"];

$nama_admin = $d["nama_admin"];

$username = $d["username"];

$password = $d["password"];

$telepon = $d["telepon"];

$email = $d["email"];

$status = $d["status"];

$keterangan = $d["keterangan"];

$pro = "ubah";

}

$(function() {

$("#accordion").accordion({

collapsible: true

});

</script>

<h3>Input Data Admin</h3>

<div>

<tr>

<th width="70"><label for="id_admin">ID Admin</label>

<th width="9">:

</tr>

<tr>

<td><label for="nama_admin">Nama Admin</label>

<td>:

</td>

</tr>

<tr>

<td height="24"><label for="username">Username</label>

<td>:

</tr>

<tr>

<td height="24"><label for="password">Password</label>

<td>:

</tr>

<tr>

<td height="24"><label for="telepon">Telepon</label>

<td>:

</td>

</tr>

<tr>

<td height="24"><label for="email">Email</label>

<td>:

</td>

</tr>

<tr>

<td><label for="status">Status</label>

<td>:

<input type="radio" name="status" id="status" checked="checked" value="Aktif" <?php if ($status == "Aktif") {

echo "checked";

} ?> />Aktif

<input type="radio" name="status" id="status" value="Tidak Aktif" <?php if ($status == "Tidak Aktif") {

echo "checked";

} ?> />Tidak Aktif

</td>

</tr>

<tr>

<td height="24"><label for="keterangan">Keterangan</label>

<td>:

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</div>

<?php

$sqlc = "select distinct(`status`) from `$tbadmin` order by `status` asc";

$jumc = getJum($conn, $sqlc);

if ($jumc < 1) {

echo "<h1>Maaf data Admin belum tersedia</h1>";

}

$arrc = getData($conn, $sqlc);

foreach ($arrc as $dc) {

$status = $dc["status"];

<h3>Data Admin <?php echo $status ?>:</h3>

<div>

Cetak | <img src='ypathicon/print.png' title='PRINT' OnClick="PRINT('<?php echo $status; ?>')"> |

<th width="10%">ID Admin</td>

<th width="20%">Nama Admin</td>

<th width="20%">Telepon</td>

<th width="20%">Email</td>

<th width="20%">Keterangan</td>

</tr>

<?php

$sql = "select * from `$tbadmin` where `status`='$status' order by `id_admin` desc";

$jum = getJum($conn, $sql);

if ($jum > 0) {

//--------------------------------------------------------------------------------------------

$batas = 10;

$page = 1;

if (isset($_GET['page'])) {

$page = $_GET['page'];

}

if (empty($page)) {

$posawal = 0;

$page = 1;

} else {

$posawal = ($page - 1) * $batas;

}

$sql2 = $sql . " LIMIT $posawal,$batas";

$no = $posawal + 1;

//--------------------------------------------------------------------------------------------

$arr = getData($conn, $sql2);

foreach ($arr as $d) {

$id_admin = $d["id_admin"];

$nama_admin = ucwords($d["nama_admin"]);

$username = $d["username"];

$password = $d["password"];

$telepon = $d["telepon"];

$email = $d["email"];

$status = $d["status"];

$keterangan = $d["keterangan"];

$color = "#dddddd";

if ($no % 2 == 0) {

$color = "#eeeeee";

}

echo "<tr bgcolor='$color'>

<td>$id_admin</td>

<td>$nama_admin</td>

<td>$telepon</td>

<td>$email</td>

<td>$keterangan</td>

<a href='?mnu=admin&pro=hapus&kode=$id_admin'><img src='ypathicon/ha.png' title='hapus'

onClick='return confirm(\"Apakah Anda benar-benar akan menghapus \"$nama_admin\" pada data admin ?..\")'></a></div></td>

</tr>";

$no++;

} //for dalam

} //if

else {

echo "<tr><td colspan='6'><blink>Maaf, Data admin belum tersedia...</blink></td></tr>";

}

</table>

<?php

$jmldata = $jum;

if ($jmldata > 0) {

if ($batas < 1) {

$batas = 1;

}

$jmlhal = ceil($jmldata / $batas);

echo "<div class=paging>";

if ($page > 1) {

$prev = $page - 1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?page=$prev&mnu=admin'>« Prev</a></span> ";

} else {

echo "<span class=disabled>« Prev</span> ";

}

for ($i = 1; $i <= $jmlhal; $i++)

if ($i != $page) {

echo "<a href='$_SERVER[PHP_SELF]?page=$i&mnu=admin'>$i</a> ";

} else {

echo " <span class=current>$i</span> ";

}

if ($page < $jmlhal) {

$next = $page + 1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?page=$next&mnu=admin'>Next »</a></span>";

} else {

echo "<span class=disabled>Next »</span>";

}

echo "</div>";

} //if jmldata

$jmldata = $jum;

echo "<p align=center>Total data <b>$jmldata</b> item</p>";

echo "</div>";

} //for atas

</div>

<?php

if (isset($_POST["Simpan"])) {

$pro = strip_tags($_POST["pro"]);

$id_admin = strip_tags($_POST["id_admin"]);

$id_admin0 = strip_tags($_POST["id_admin0"]);

$username = strip_tags($_POST["username"]);

$nama_admin = strip_tags($_POST["nama_admin"]);

$password = strip_tags($_POST["password"]);

$telepon = strip_tags($_POST["telepon"]);

$email = strip_tags($_POST["email"]);

$status = strip_tags($_POST["status"]);

$keterangan = strip_tags($_POST["keterangan"]);

if ($pro == "simpan") {

$sql = " INSERT INTO `$tbadmin` (

`id_admin` ,

`nama_admin` ,

`username` ,

`password` ,

`telepon` ,

`email` ,

`status` ,

`keterangan`

) VALUES (

'$id_admin',

'$nama_admin',

'$username',

'$password',

'$telepon',

'$email',

'$status',

'$keterangan'

)";

$simpan = process($conn, $sql);

if ($simpan) {

echo "<script>alert('Data $nama_admin berhasil disimpan !');document.location.href='?mnu=admin';</script>";

} else {

echo "<script>alert('Data $nama_admin gagal disimpan...');document.location.href='?mnu=admin';</script>";

}

} else {

$sql = "update `$tbadmin` set

`nama_admin`='$nama_admin',

`username`='$username',

`password`='$password',

`telepon`='$telepon' ,

`email`='$email',

`status`='$status',

`keterangan`='$keterangan'

where `id_admin`='$id_admin0'";

$ubah = process($conn, $sql);

if ($ubah) {

echo "<script>alert('Data $nama_admin berhasil diubah !');document.location.href='?mnu=admin';</script>";

} else {

echo "<script>alert('Data $nama_admin gagal diubah...');document.location.href='?mnu=admin';</script>";

}

} //else simpan

}

<?php

if (isset($_GET["pro"]) && $_GET["pro"] == "hapus") {

$id_admin = $_GET["kode"];

$sql = "delete from `$tbadmin` where `id_admin`='$id_admin'";

$hapus = process($conn, $sql);

if ($hapus) {

echo "<script>alert('Data $id_admin berhasil dihapus !');document.location.href='?mnu=admin';</script>";

} else {

echo "<script>alert('Data $id_admin gagal dihapus...');document.location.href='?mnu=admin';</script>";

}

     Tampilan Script Admin :
   Tampilan Script Database Admin : db_master/tb_master

     Script pelanggan.php :

<?php

$pro = "simpan";

$nama_pelanggan = "";

$username = "";

$password = "";

$telepon = "";

$email = "";

$status = "Aktif";

$alamat = "";

$keterangan = "";

function PRINT(pk) {

win = window.open('pelanggan/pelanggan_print.php?pk=' + pk, 'win', 'width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=0');

}

</script>

function buka(url) {

window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');

}

</script>

<?php

$sql = "select `id_pelanggan` from `$tbpelanggan` order by `id_pelanggan` desc";

$jum = getJum($conn, $sql);

$kd = "PLG";

if ($jum > 0) {

$d = getField($conn, $sql);

$idmax = $d['id_pelanggan'];

$urut = substr($idmax, 3, 2) + 1; //01

if ($urut < 10) {

$idmax = "$kd" . "0" . $urut;

} else {

$idmax = "$kd" . $urut;

}

} else {

$idmax = "$kd" . "01";

}

$id_pelanggan = $idmax;

<?php

if (isset($_GET["pro"]) && $_GET["pro"] == "ubah") {

$id_pelanggan = $_GET["kode"];

$sql = "select * from `$tbpelanggan` where `id_pelanggan`='$id_pelanggan'";

$d = getField($conn, $sql);

$id_pelanggan = $d["id_pelanggan"];

$id_pelanggan0 = $d["id_pelanggan"];

$nama_pelanggan = $d["nama_pelanggan"];

$username = $d["username"];

$password = $d["password"];

$telepon = $d["telepon"];

$email = $d["email"];

$status = $d["status"];

$alamat = $d["alamat"];

$keterangan = $d["keterangan"];

$pro = "ubah";

}

$(function() {

$("#accordion").accordion({

collapsible: true

});

</script>

<h3>Input Data pelanggan</h3>

<div>

<tr>

<th width="70"><label for="id_pelanggan">ID pelanggan</label>

<th width="9">:

</tr>

<tr>

<td><label for="nama_pelanggan">Nama pelanggan</label>

<td>:

</td>

</tr>

<tr>

<td height="24"><label for="username">Username</label>

<td>:

</tr>

<tr>

<td height="24"><label for="password">Password</label>

<td>:

</tr>

<tr>

<td height="24"><label for="telepon">Telepon</label>

<td>:

</td>

</tr>

<tr>

<td height="24"><label for="email">Email</label>

<td>:

</td>

</tr>

<tr>

<td><label for="status">Status</label>

<td>:

<input type="radio" name="status" id="status" checked="checked" value="Aktif" <?php if ($status == "Aktif") {

echo "checked";

} ?> />Aktif

<input type="radio" name="status" id="status" value="Tidak Aktif" <?php if ($status == "Tidak Aktif") {

echo "checked";

} ?> />Tidak Aktif

</td>

</tr>

<tr>

<td height="24"><label for="alamat">alamat</label>

<td>:

<td>

</td>

</tr>

<tr>

<td height="24"><label for="keterangan">Keterangan</label>

<td>:

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</div>

<?php

$sqlc = "select distinct(`status`) from `$tbpelanggan` order by `status` asc";

$jumc = getJum($conn, $sqlc);

if ($jumc < 1) {

echo "<h1>Maaf data pelanggan belum tersedia</h1>";

}

$arrc = getData($conn, $sqlc);

foreach ($arrc as $dc) {

$status = $dc["status"];

<h3>Data pelanggan <?php echo $status ?>:</h3>

<div>

Cetak | <img src='ypathicon/print.png' title='PRINT' OnClick="PRINT('<?php echo $status; ?>')"> |

<th width="10%">ID pelanggan</td>

<th width="20%">Nama pelanggan</td>

<th width="20%">Telepon</td>

<th width="20%">Email</td>

<th width="20%">status</td>

<th width="20%">alamat</td>

<th width="20%">Keterangan</td>

</tr>

<?php

$sql = "select * from `$tbpelanggan` where `status`='$status' order by `id_pelanggan` desc";

$jum = getJum($conn, $sql);

if ($jum > 0) {

//--------------------------------------------------------------------------------------------

$batas = 10;

$page = 1;

if (isset($_GET['page'])) {

$page = $_GET['page'];

}

if (empty($page)) {

$posawal = 0;

$page = 1;

} else {

$posawal = ($page - 1) * $batas;

}

$sql2 = $sql . " LIMIT $posawal,$batas";

$no = $posawal + 1;

//-------------------------------------------------------------------------------------------

$arr = getData($conn, $sql2);

foreach ($arr as $d) {

$id_pelanggan = $d["id_pelanggan"];

$nama_pelanggan = ucwords($d["nama_pelanggan"]);

$username = $d["username"];

$password = $d["password"];

$telepon = $d["telepon"];

$email = $d["email"];

$status = $d["status"];

$alamat = $d["alamat"];

$keterangan = $d["keterangan"];

$color = "#dddddd";

if ($no % 2 == 0) {

$color = "#eeeeee";

}

echo "<tr bgcolor='$color'>

<td>$id_pelanggan</td>

<td>$nama_pelanggan</td>

<td>$telepon</td>

<td>$email</td>

<td>$status</td>

<td>$alamat</td>

<td>$keterangan</td>

<a href='?mnu=pelanggan&pro=hapus&kode=$id_pelanggan'><img src='ypathicon/ha.png' title='hapus'

onClick='return confirm(\"Apakah Anda benar-benar akan menghapus \"$nama_pelanggan\" pada data pelanggan ?..\")'></a></div></td>

</tr>";

$no++;

} //for dalam

} //if

else {

echo "<tr><td colspan='6'><blink>Maaf, Data pelanggan belum tersedia...</blink></td></tr>";

}

</table>

<?php

$jmldata = $jum;

if ($jmldata > 0) {

if ($batas < 1) {

$batas = 1;

}

$jmlhal = ceil($jmldata / $batas);

echo "<div class=paging>";

if ($page > 1) {

$prev = $page - 1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?page=$prev&mnu=pelanggan'>« Prev</a></span> ";

} else {

echo "<span class=disabled>« Prev</span> ";

}

for ($i = 1; $i <= $jmlhal; $i++)

if ($i != $page) {

echo "<a href='$_SERVER[PHP_SELF]?page=$i&mnu=pelanggan'>$i</a> ";

} else {

echo " <span class=current>$i</span> ";

}

if ($page < $jmlhal) {

$next = $page + 1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?page=$next&mnu=pelanggan'>Next »</a></span>";

} else {

echo "<span class=disabled>Next »</span>";

}

echo "</div>";

} //if jmldata

$jmldata = $jum;

echo "<p align=center>Total data <b>$jmldata</b> item</p>";

echo "</div>";

} //for atas

</div>

<?php

if (isset($_POST["Simpan"])) {

$pro = strip_tags($_POST["pro"]);

$id_pelanggan = strip_tags($_POST["id_pelanggan"]);

$id_pelanggan0 = strip_tags($_POST["id_pelanggan0"]);

$username = strip_tags($_POST["username"]);

$nama_pelanggan = strip_tags($_POST["nama_pelanggan"]);

$password = strip_tags($_POST["password"]);

$telepon = strip_tags($_POST["telepon"]);

$email = strip_tags($_POST["email"]);

$status = strip_tags($_POST["status"]);

$alamat = strip_tags($_POST["alamat"]);

$keterangan = strip_tags($_POST["keterangan"]);

if ($pro == "simpan") {

$sql = " INSERT INTO `$tbpelanggan` (

`id_pelanggan` ,

`nama_pelanggan` ,

`username` ,

`password` ,

`telepon` ,

`email` ,

`status` ,

`alamat` ,

`keterangan`

) VALUES (

'$id_pelanggan',

'$nama_pelanggan',

'$username',

'$password',

'$telepon',

'$email',

'$status',

'$alamat',

'$keterangan'

)";

$simpan = process($conn, $sql);

if ($simpan) {

echo "<script>alert('Data $nama_pelanggan berhasil disimpan !');document.location.href='?mnu=pelanggan';</script>";

} else {

echo "<script>alert('Data $nama_pelanggan gagal disimpan...');document.location.href='?mnu=pelanggan';</script>";

}

} else {

$sql = "update `$tbpelanggan` set

`nama_pelanggan`='$nama_pelanggan',

`username`='$username',

`password`='$password',

`telepon`='$telepon' ,

`email`='$email',

`status`='$status',

`alamat`='$alamat',

`keterangan`='$keterangan'

where `id_pelanggan`='$id_pelanggan0'";

$ubah = process($conn, $sql);

if ($ubah) {

echo "<script>alert('Data $nama_pelanggan berhasil diubah !');document.location.href='?mnu=pelanggan';</script>";

} else {

echo "<script>alert('Data $nama_pelanggan gagal diubah...');document.location.href='?mnu=pelanggan';</script>";

}

} //else simpan

}

<?php

if (isset($_GET["pro"]) && $_GET["pro"] == "hapus") {

$id_pelanggan = $_GET["kode"];

$sql = "delete from `$tbpelanggan` where `id_pelanggan`='$id_pelanggan'";

$hapus = process($conn, $sql);

if ($hapus) {

echo "<script>alert('Data $id_pelanggan berhasil dihapus !');document.location.href='?mnu=pelanggan';</script>";

} else {

echo "<script>alert('Data $id_pelanggan gagal dihapus...');document.location.href='?mnu=pelanggan';</script>";

}

Tampilan Script pelanggan:

Tampilan Script Database Admin : db_master/tb_pelanggan

Script produk.php :

<?php

$pro = "simpan";

$nama_produk = "";

$deskripsi = "";

$gambar = "";

$harga = "";

$kategori = "";

$status = "Aktif";

$keterangan = "";

function PRINT(pk) {

win = window.open('produk/produk_print.php?pk=' + pk, 'win', 'width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=0');

}

</script>

function buka(url) {

window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');

}

</script>

<?php

$sql = "select `id_produk` from `$tbproduk` order by `id_produk` desc";

$jum = getJum($conn, $sql);

$kd = "PRD";

if ($jum > 0) {

$d = getField($conn, $sql);

$idmax = $d['id_produk'];

$urut = substr($idmax, 3, 2) + 1; //01

if ($urut < 10) {

$idmax = "$kd" . "0" . $urut;

} else {

$idmax = "$kd" . $urut;

}

} else {

$idmax = "$kd" . "01";

}

$id_produk = $idmax;

<?php

if (isset($_GET["pro"]) && $_GET["pro"] == "ubah") {

$id_produk = $_GET["kode"];

$sql = "select * from `$tbproduk` where `id_produk`='$id_produk'";

$d = getField($conn, $sql);

$id_produk = $d["id_produk"];

$id_produk0 = $d["id_produk"];

$nama_produk = $d["nama_produk"];

$deskripsi = $d["deskripsi"];

$gambar = $d["gambar"];

$harga = $d["harga"];

$kategori = $d["kategori"];

$status = $d["status"];

$keterangan = $d["keterangan"];

$pro = "ubah";

}

$(function() {

$("#accordion").accordion({

collapsible: true

});

</script>

<h3>Input Data produk</h3>

<div>

<tr>

<th width="70"><label for="id_produk">ID produk</label>

<th width="9">:

</tr>

<tr>

<td><label for="nama_produk">Nama produk</label>

<td>:

</td>

</tr>

<tr>

<td height="24"><label for="deskripsi">Deskripsi</label>

<td>:

</tr>

<tr>

<td height="24"><label for="gambar">Gambar</label>

<td>:

</tr>

<tr>

<td height="24"><label for="harga">Harga</label>

<td>:

</td>

</tr>

<tr>

<td height="24"><label for="kategori">Kategori</label>

<td>:

</td>

</tr>

<tr>

<td><label for="status">Status</label>

<td>:

<input type="radio" name="status" id="status" checked="checked" value="Tersedia" <?php if ($status == "Tersedia") {

echo "checked";

} ?> />Tersedia

<input type="radio" name="status" id="status" value="Tidak Tersedia" <?php if ($status == "Tidak Tersedia") {

echo "checked";

} ?> />Tidak Tersedia

</td>

</tr>

<tr>

<td height="24"><label for="keterangan">Keterangan</label>

<td>:

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>

</div>

<?php

$sqlc = "select distinct(`status`) from `$tbproduk` order by `status` asc";

$jumc = getJum($conn, $sqlc);

if ($jumc < 1) {

echo "<h1>Maaf data produk belum tersedia</h1>";

}

$arrc = getData($conn, $sqlc);

foreach ($arrc as $dc) {

$status = $dc["status"];

<h3>Data produk <?php echo $status ?>:</h3>

<div>

Cetak | <img src='ypathicon/print.png' title='PRINT' OnClick="PRINT('<?php echo $status; ?>')"> |

<th width="10%">ID produk</td>

<th width="20%">Nama produk</td>

<th width="20%">Deskripsi</td>

<th width="20%">harga</td>

<th width="20%">kategori</td>

<th width="40%">gambar</td>

<th width="20%">status</td>

<th width="20%">Keterangan</td>

</tr>

<?php

$sql = "select * from `$tbproduk` where `status`='$status' order by `id_produk` asc";

$jum = getJum($conn, $sql);

if ($jum > 0) {

//--------------------------------------------------------------------------------------------

$batas = 10;

$page = 1;

if (isset($_GET['page'])) {

$page = $_GET['page'];

}

if (empty($page)) {

$posawal = 0;

$page = 1;

} else {

$posawal = ($page - 1) * $batas;

}

$sql2 = $sql . " LIMIT $posawal,$batas";

$no = $posawal + 1;

//--------------------------------------------------------------------------------------------

$arr = getData($conn, $sql2);

foreach ($arr as $d) {

$id_produk = $d["id_produk"];

$nama_produk = ucwords($d["nama_produk"]);

$deskripsi = $d["deskripsi"];

$gambar = $d["gambar"];

$harga = $d["harga"];

$kategori = $d["kategori"];

$status = $d["status"];

$keterangan = $d["keterangan"];

$color = "#dddddd";

if ($no % 2 == 0) {

$color = "#eeeeee";

}

echo "<tr bgcolor='$color'>

<td>$id_produk</td>

<td>$nama_produk</td>

<td>$deskripsi</td>

<td>$harga</td>

<td>$kategori</td>

<td><div align='center'>";

echo"<a href='#' onclick='buka(\"produk/zoom.php?id=$id_produk\")'>

<img src='$YPATH/$gambar' width='40' height='40' /></a></div>";

echo"</td>

<td>$status</td>

<td>$keterangan</td>

<a href='?mnu=produk&pro=hapus&kode=$id_produk'><img src='ypathicon/ha.png' title='hapus'

onClick='return confirm(\"Apakah Anda benar-benar akan menghapus \"$nama_produk\" pada data produk ?..\")'></a></div></td>

</tr>";

$no++;

} //for dalam

} //if

else {

echo "<tr><td colspan='6'><blink>Maaf, Data produk belum tersedia...</blink></td></tr>";

}

</table>

<?php

$jmldata = $jum;

if ($jmldata > 0) {

if ($batas < 1) {

$batas = 1;

}

$jmlhal = ceil($jmldata / $batas);

echo "<div class=paging>";

if ($page > 1) {

$prev = $page - 1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?page=$prev&mnu=produk'>« Prev</a></span> ";

} else {

echo "<span class=disabled>« Prev</span> ";

}

for ($i = 1; $i <= $jmlhal; $i++)

if ($i != $page) {

echo "<a href='$_SERVER[PHP_SELF]?page=$i&mnu=produk'>$i</a> ";

} else {

echo " <span class=current>$i</span> ";

}

if ($page < $jmlhal) {

$next = $page + 1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?page=$next&mnu=produk'>Next »</a></span>";

} else {

echo "<span class=disabled>Next »</span>";

}

echo "</div>";

} //if jmldata

$jmldata = $jum;

echo "<p align=center>Total data <b>$jmldata</b> item</p>";

echo "</div>";

} //for atas

</div>

<?php

if (isset($_POST["Simpan"])) {

$pro = strip_tags($_POST["pro"]);

$id_produk = strip_tags($_POST["id_produk"]);

$id_produk0 = strip_tags($_POST["id_produk0"]);

$nama_produk = strip_tags($_POST["nama_produk"]);

$deskripsi = strip_tags($_POST["deskripsi"]);

$harga = strip_tags($_POST["harga"]);

$kategori = strip_tags($_POST["kategori"]);

$status = strip_tags($_POST["status"]);

$keterangan = strip_tags($_POST["keterangan"]);

$gambar0 = strip_tags($_POST["gambar0"]);

if ($_FILES["gambar"] != "") {

move_uploaded_file($_FILES["gambar"]["tmp_name"], "$YPATH/" . $_FILES["gambar"]["name"]);

$gambar = $_FILES["gambar"]["name"];

} else {

$gambar = $gambar0;

}

if (strlen($gambar) < 1) {

$gambar = $gambar0;

}

if ($pro == "simpan") {

$sql = " INSERT INTO `$tbproduk` (

`id_produk` ,

`nama_produk` ,

`deskripsi` ,

`gambar` ,

`harga` ,

`kategori` ,

`status` ,

`keterangan`

) VALUES (

'$id_produk',

'$nama_produk',

'$deskripsi',

'$gambar',

'$harga',

'$kategori',

'$status',

'$keterangan'

)";

$simpan = process($conn, $sql);

if ($simpan) {

echo "<script>alert('Data $nama_produk berhasil disimpan !');document.location.href='?mnu=produk';</script>";

} else {

echo "<script>alert('Data $nama_produk gagal disimpan...');document.location.href='?mnu=produk';</script>";

}

} else {

$sql = "update `$tbproduk` set

`nama_produk`='$nama_produk',

`deskripsi`='$deskripsi',

`gambar`='$gambar',

`harga`='$harga' ,

`kategori`='$kategori',

`status`='$status',

`keterangan`='$keterangan'

where `id_produk`='$id_produk0'";

$ubah = process($conn, $sql);

if ($ubah) {

echo "<script>alert('Data $nama_produk berhasil diubah !');document.location.href='?mnu=produk';</script>";

} else {

echo "<script>alert('Data $nama_produk gagal diubah...');document.location.href='?mnu=produk';</script>";

}

} //else simpan

}

<?php

if (isset($_GET["pro"]) && $_GET["pro"] == "hapus") {

$id_produk = $_GET["kode"];

$sql = "delete from `$tbproduk` where `id_produk`='$id_produk'";

$hapus = process($conn, $sql);

if ($hapus) {

echo "<script>alert('Data $id_produk berhasil dihapus !');document.location.href='?mnu=produk';</script>";

} else {

echo "<script>alert('Data $id_produk gagal dihapus...');document.location.href='?mnu=produk';</script>";

}

Tampilan Script produk:

Tampilan Script Database Admin : db_master/tb_produk

MEMBUAT WEB PENJUALAN UNTUK ADMIN MENGGUNAKAN PHP

Diposting olehArief_ichwan.f

0 Komentar

Keluarga Cemara

Master.php

ORMIK 2023!

KATAR RT 11

Script HTML dan CSS Beserta Foto Hasilnya

MEMBUAT WEB PENJUALAN UNTUK ADMIN MENGGUNAKAN PHP

Diposting olehArief_ichwan.f

Anda mungkin menyukai postingan ini

0 Komentar