Manajemen Barang

PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC]); } catch (PDOException $e) { die(json_encode(['error' => 'Koneksi gagal: ' . $e->getMessage()])); } $api = $_GET['api']; // LIST if ($api === 'list') { $search = $_GET['search'] ?? ''; $page = max(1, intval($_GET['page'] ?? 1)); $limit = max(1, min(100, intval($_GET['limit'] ?? 10))); $offset = ($page - 1) * $limit; $sort = $_GET['sort'] ?? 'id'; $order = strtoupper($_GET['order'] ?? 'DESC') === 'ASC' ? 'ASC' : 'DESC'; $allowed = ['id','nama_barang','harga','stok']; if (!in_array($sort, $allowed)) $sort = 'id'; $where = ''; $params = []; if ($search) { $where = "WHERE nama_barang LIKE :s"; $params[':s'] = "%$search%"; } $cnt = $pdo->prepare("SELECT COUNT(*) as t FROM tbl_barang $where"); $cnt->execute($params); $total = $cnt->fetch()['t']; $q = $pdo->prepare("SELECT * FROM tbl_barang $where ORDER BY $sort $order LIMIT :l OFFSET :o"); foreach ($params as $k => $v) $q->bindValue($k, $v); $q->bindValue(':l', $limit, PDO::PARAM_INT); $q->bindValue(':o', $offset, PDO::PARAM_INT); $q->execute(); die(json_encode(['data' => $q->fetchAll(), 'total' => (int)$total, 'page' => $page, 'pages' => ceil($total / $limit)])); } // CREATE if ($api === 'create' && $_SERVER['REQUEST_METHOD'] === 'POST') { $d = json_decode(file_get_contents('php://input'), true); if (!$d || !$d['nama_barang']) die(json_encode(['error' => 'Nama wajib diisi'])); $q = $pdo->prepare("INSERT INTO tbl_barang (nama_barang, harga, stok) VALUES (:n, :h, :s)"); $q->execute([':n' => $d['nama_barang'], ':h' => floatval($d['harga']), ':s' => intval($d['stok'])]); die(json_encode(['ok' => true, 'msg' => 'Barang ditambahkan'])); } // UPDATE if ($api === 'update' && $_SERVER['REQUEST_METHOD'] === 'PUT') { $id = intval($_GET['id'] ?? 0); $d = json_decode(file_get_contents('php://input'), true); if (!$id || !$d) die(json_encode(['error' => 'Data tidak valid'])); $q = $pdo->prepare("UPDATE tbl_barang SET nama_barang=:n, harga=:h, stok=:s WHERE id=:id"); $q->execute([':n' => $d['nama_barang'], ':h' => floatval($d['harga']), ':s' => intval($d['stok']), ':id' => $id]); die(json_encode(['ok' => true, 'msg' => 'Barang diupdate'])); } // DELETE if ($api === 'delete' && $_SERVER['REQUEST_METHOD'] === 'DELETE') { $id = intval($_GET['id'] ?? 0); if (!$id) die(json_encode(['error' => 'ID tidak valid'])); $pdo->prepare("DELETE FROM tbl_barang WHERE id=:id")->execute([':id' => $id]); die(json_encode(['ok' => true, 'msg' => 'Barang dihapus'])); } die(json_encode(['error' => 'Endpoint tidak ditemukan'])); } ?> Manajemen Barang

ID ▲	Nama Barang ▲	Harga ▲	Stok ▲	Aksi
📦 Memuat...

Memuat...

📦 Tambah Barang

⚠️ Hapus Barang

Yakin hapus?