Riwayat Nota Penjualan

Koneksi gagal: " . mysqli_connect_error() . "

"); } $no_hp = mysqli_real_escape_string($conn, $_GET['no_hp']); // Query Data $query = "SELECT no_faktur_penjualan, tgl_penjualan, netto,no_sha FROM tabel_penjualan WHERE notelp = '$no_hp' and tgl_penjualan >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) ORDER BY tgl_penjualan DESC"; $result = mysqli_query($conn, $query); if (mysqli_num_rows($result) > 0) { echo '
'; while ($row = mysqli_fetch_assoc($result)) { echo ""; } echo '
Tanggal Total (Netto) Aksi
".date('d M Y', strtotime($row['tgl_penjualan']))." Rp ".number_format($row['netto'], 0, ',', '.')." Lihat
'; } else { echo "

Data tidak ditemukan untuk nomor HP tersebut.

"; } mysqli_close($conn); } ?>