Assallammualaikm mas robby gimana kita menampilkan jumlah daftar peserta yang di paket A contoh kasus nya adalah saya memiliki daftar paket keberangkatan dengan id_=5(diambil per/id) kemudian ada customer daftar paket di id_=5/sesuai id yang dipilih dan saya ingin menampilkan di view tabel bahwa di paket trsbut sudah ada 2 orang(hanya contoh) , intinya adalah saya ingin menampilkan jumlah orang yang terdaftar pada paket yang dipilih seperti gambar dibawah ini yang saya tandai kotak merah terima kasih. berikut tablenya CREATE TABLE `tbl_customer` ( `nama_depan` varchar(80) NOT NULL, `id_cus` int(12) NOT NULL, `id_` int(12) NOT NULL, `id_paket` int(12) NOT NULL, `keberangkatan_tanggal` varchar(30) NOT NULL, `id_agent` int(12) NOT NULL, `kode_cus` varchar(20) NOT NULL, `nama_tengah` varchar(80) NOT NULL, `nama_belakang` varchar(80) NOT NULL, `tempat_lahir` varchar(80) NOT NULL, `tgl_lahir` date NOT NULL, `id_status_menikah` int(12) NOT NULL, `id_jenis_kelamin` int(12) NOT NULL, `no_pasport` varchar(45) NOT NULL, `tgl_issued_pasport` date NOT NULL, `tgl_expired_pasport` date NOT NULL, `tempat_imigrasi_pasport` varchar(80) NOT NULL, `no_identitas` varchar(30) NOT NULL, `alamat` text NOT NULL, `no_telp` varchar(15) NOT NULL, `no_hp` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `no_virtual_account` varchar(100) NOT NULL, `foto` varchar(100) NOT NULL, `nama_mahrom` varchar(80) NOT NULL, `hub_mahrom` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Jun 18, 2017 at 05:59 AM -- Server version: 10.1.13-MariaDB -- PHP Version: 5.6.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `db_travel` -- -- -------------------------------------------------------- -- -- Table structure for table `bld_paket` -- CREATE TABLE `bld_paket` ( `id_` int(12) NOT NULL, `id_paket` int(12) NOT NULL, `keberangkatan_tanggal` varchar(50) NOT NULL, `program_hari` varchar(2) NOT NULL, `harga` double NOT NULL, `fee` double NOT NULL, `name` varchar(9) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `bld_paket` -- INSERT INTO `bld_paket` (`id_`, `id_paket`, `keberangkatan_tanggal`, `program_hari`, `harga`, `fee`, `name`) VALUES (1, 10, '30 april 2017', '9', 28000000, 0, ''), (2, 11, '28 Mei 2017', '9', 0, 0, ''), (3, 11, '28 mei 2017', '9', 0, 0, ''), (4, 12, '28 mei-awal juli 2017', '40', 0, 0, ''), (5, 16, 'November 2017', '12', 15000000, 0, ''), (6, 16, 'November 2017', '09', 20000000, 1000000, ''), (7, 16, 'November 2017', '12', 25500000, 1000000, 'QUAD'), (8, 16, 'November 2017', '12', 26500000, 1000000, 'TRIPLE'), (9, 16, 'November 2017', '12', 27000000, 1000000, 'DOUBLE'), (10, 16, 'November 2017', '15', 27500000, 1000000, 'QUAD'), (11, 16, 'November 2017', '15', 28500000, 1000000, 'TRIPLE'), (12, 16, 'November 2017', '15', 29000000, 1000000, 'DOUBLE'), (13, 20, 'November 2017', '12', 28000000, 1000000, 'QUAD'), (14, 20, 'November 2017', '12', 29500000, 1000000, 'TRIPLE'), (15, 20, 'November 2017', '12', 30000000, 1000000, 'DOUBLE'), (16, 16, 'Mulai November 2017 (awal musim)', '9', 23000000, 1000000, 'QUAD'), (17, 16, 'Mulai November 2017 (awal musim)', '9', 24500000, 1000000, 'TRIPLE'), (18, 16, 'Mulai November 2017 (awal musim)', '9', 25000000, 1000000, 'DOUBLE'), (19, 11, '28 mei-1 juli 2018', '40', 25000000, 0, 'QUAD'), (20, 11, '28 mei-1 juli 2018', '40', 28000000, 0, 'TRIPLE'), (21, 11, '28 mei-1 juli 2018', '40', 40000000, 0, 'DOUBLE'); -- -- Indexes for dumped tables -- -- -- Indexes for table `bld_paket` -- ALTER TABLE `bld_paket` -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bld_paket` -- ALTER TABLE `bld_paket` MODIFY `id_` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Ada 1 File Kiriman : 1. Untitled50.png (98 KB) |