connect_error) { die("Koneksi gagal: " . $conn->connect_error); }
// === Upload Excel ===
if(isset($_POST['upload'])){
require 'vendor/autoload.php';
$file = $_FILES['file']['tmp_name'];
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile($file);
$spreadsheet = $reader->load($file);
$sheet = $spreadsheet->getActiveSheet()->toArray();
foreach($sheet as $i => $row){
if($i == 0) continue; // skip header
$nama = $row[1];
$tagihan = $row[2];
$buku = $row[3];
$lks = $row[4];
$jumlah = $row[5];
$conn->query("INSERT INTO tagihan (nama, tagihan_lalu, buku, lks, jumlah)
VALUES ('$nama','$tagihan','$buku','$lks','$jumlah')");
}
echo "Upload sukses!
";
}
// === Input pembayaran ===
if(isset($_POST['bayar'])){
$id = $_POST['id'];
$jumlah = $_POST['jumlah'];
$conn->query("UPDATE tagihan SET jumlah = jumlah - $jumlah WHERE id=$id");
$conn->query("INSERT INTO pembayaran (id_siswa, jumlah, tanggal) VALUES ('$id','$jumlah',NOW())");
echo "Pembayaran tercatat!
";
}
?>
connect_error) {
die("Koneksi gagal: " . $conn->connect_error);
}
// Variabel pesan alert
$alert = "";
// === Upload Excel ===
if(isset($_POST['upload'])){
require 'vendor/autoload.php';
$file = $_FILES['file']['tmp_name'];
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile($file);
$spreadsheet = $reader->load($file);
$sheet = $spreadsheet->getActiveSheet()->toArray();
foreach($sheet as $i => $row){
if($i == 0) continue; // skip header
$nama = $row[1];
$tagihan = $row[2];
$buku = $row[3];
$lks = $row[4];
$jumlah = $row[5];
$conn->query("INSERT INTO tagihan (nama, tagihan_lalu, buku, lks, jumlah)
VALUES ('$nama','$tagihan','$buku','$lks','$jumlah')");
}
$alert = "✅ Upload sukses!
";
}
// === Input pembayaran ===
if(isset($_POST['bayar'])){
$id = $_POST['id'];
$jumlah = $_POST['jumlah'];
$conn->query("UPDATE tagihan SET jumlah = jumlah - $jumlah WHERE id=$id");
$conn->query("INSERT INTO pembayaran (id_siswa, jumlah, tanggal) VALUES ('$id','$jumlah',NOW())");
$alert = "💰 Pembayaran tercatat!
";
}
?>
Aplikasi Tagihan Siswa
📘 Aplikasi Tagihan Siswa
| No |
Nama |
Tagihan Lalu |
Buku |
LKS |
Sisa Jumlah |
query("SELECT * FROM tagihan");
$no=1;
while($d=$q->fetch_assoc()){
echo "
| $no |
{$d['nama']} |
{$d['tagihan_lalu']} |
{$d['buku']} |
{$d['lks']} |
{$d['jumlah']} |
";
$no++;
}
?>