إنشاء إحصائيات المسجل في Php, التمهيد, مسقلي

Hai, ketemu lagi bersama saya portgastea tutorial kali ini adalah membuat statistik pendaftar dengan بي أتش بي,دفعة & mysqli
untuk statistik pendaftar kali ini saya mencoba mengunakan data statistik penerimaan siswa baru di smk dinamika pembangunan 1 jakarta, dimana kita bisa mendapatkan data calon siswa per jurusan yang mendaftar di smk dinamika pembangunan 1 jakarta.

Ok, langsung saja pertama kita buat database di phpmyadmin dengan nama statistik lalu membuat tabel seperti dibawah ini.

CREATE TABLE IF NOT EXISTS `master` (
`id_daftar` int(5) NOT NULL,
 
`s_nama` varchar(150) NOT NULL,
 
`s_jk` int(1) NOT NULL,
 
`s_agama` int(1) NOT NULL,
 
`s_tmp_lahir` varchar(100) NOT NULL,
 
`s_tgl_lahir` date NOT NULL,
 
`jrsn_pil1` int(4) NOT NULL,
 
`jrsn_pil2` int(4) NOT NULL,
 
`tgl_daftar` date NOT NULL,
 
`nisn` varchar(15) NOT NULL,
 
`noreg` varchar(10) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=173 ;

Setelah itu masukan data nya seperti dibawah ini :

INSERT INTO `master` (`id_daftar`, `s_nama`, `s_jk`, `s_agama`, `s_tmp_lahir`, `s_tgl_lahir`, `jrsn_pil1`, `jrsn_pil2`, `tgl_daftar`, `nisn`, `noreg`) VALUES
(30, 'GUSTI SUMAINDRA', 1, 1, 'sadadad', '2009-03-01', 1103, 1254, '2015-04-08', '0001', '0001'),
(31, 'AFIF PRASETYA', 1, 0, ", '0000-00-00', 0, 0, '2015-04-08', '0002', '0002'),
(32, 'RIO RIVALDO', 1, 1, 'BEKASI', '1999-06-19', 1289, 1103, '2015-04-08', '9994256564', '0003'),
(33, 'MITA OKTAVIANI', 2, 1, 'JAKARTA', '2000-10-16', 2063, 1174, '2015-04-09', '0004', '0004'),
(34, 'MUHAMMAD NAJRI ALGHIFARI', 1, 0, ", '0000-00-00', 0, 0, '2015-04-11', '0005', '0005'),
(35, 'MUHAMAD YUSUP', 1, 1, 'JAKARTA', '2000-04-01', 1254, 1289, '2015-04-13', '0006', '0006'),
(39, 'RIZKI RAHMAN', 1, 1, 'Jakarta', '2000-01-06', 1289, 1254, '2015-04-14', '0008', '0008'),
(40, 'MIZAM FADHLAN ANANDA', 1, 1, 'Jakarta', '2000-08-24', 2063, 1289, '2015-04-15', '0009', '0009'),
(41, 'AZKIYAI FAIZIN', 1, 1, 'JAKARTA', '1999-12-29', 2063, 1289, '2015-04-15', '0010', '0010'),
(42, 'ANDIKA FEBRIANA', 1, 1, '04', '2000-02-04', 2063, 1174, '2015-04-15', '0011', '0011'),
(43, 'ANAK ANUNG ANINDITO', 1, 1, 'JAKARTA', '2000-06-04', 2063, 1174, '2015-04-15', '0012', '0012'),
(44, 'RIZKY APRIANTO', 1, 1, 'Bekasi', '2000-04-15', 2063, 1174, '2015-04-15', '0013', '0013'),
(45, 'AVREDHO OZA YAMADHA', 1, 1, 'ngawi', '2000-03-25', 1289, 1103, '2015-04-15', '0014', '0014'),
(46, 'SAYYID MUHAMMAD', 1, 1, 'BEKASI', '2000-08-25', 1289, 1174, '2015-04-16', '0015', '0015'),
(47, 'ABDUL WAHAB', 1, 0, ", '0000-00-00', 0, 0, '2015-04-17', '0016', '0016'),
(48, 'ADE AGIL BUDI PRASETYO', 1, 1, 'BEKASI', '2000-05-12', 1289, 2063, '2015-04-18', '0018', '0018'),
(49, 'MUHAMMAD RIAN HASANI', 1, 0, ", '0000-00-00', 0, 0, '2015-04-18', '0019', '0019'),
(50, 'FATURRAHMAN', 1, 1, 'jakarta', '2000-09-18', 1289, 1103, '2015-04-18', '0020', '0020'),
(51, 'M. YUSUF EKO PRASETYO', 1, 1, 'SEMARANG', '2000-11-06', 1289, 2063, '2015-04-20', '0021', '0021'),
(52, 'M. DINA FRIZA', 1, 0, ", '0000-00-00', 0, 0, '2015-04-20', '0022', '0022'),
(53, 'M. FAHRI', 1, 1, 'jakarta', '2000-01-18', 1254, 1174, '2015-04-20', '0023', '0023'),
(54, 'AHMAD LATHOIFUL AWARIF', 1, 1, 'bekasi', '2000-09-07', 1254, 1174, '2015-04-20', '0024', '0024'),
(55, 'MUHAMMAD FAJAR', 1, 1, 'jakarta', '2001-01-01', 1289, 1174, '2015-04-20', '0011312741', '0025'),
(57, 'DAFIN NOUVAL ARIEF', 1, 1, 'bekasi', '2000-05-08', 1289, 2063, '2015-04-20', '0007', '0007'),
(58, 'RIFALDI PRATAMA', 1, 1, 'bekasi', '2000-07-05', 1289, 1254, '2015-04-20', '0026', '0026'),
(59, 'RISKY ANTONIO', 1, 0, ", '0000-00-00', 0, 0, '2015-04-21', '0028', '0028'),
(60, 'AGUS SETIAWAN', 1, 1, 'JAKARTA', '2000-08-02', 1289, 1254, '2015-04-21', '0029', '0029'),
(61, 'MUHAMMAD KHARRIS AMBIEYA', 1, 1, 'Jakarta', '2000-03-03', 1289, 1103, '2015-04-21', '0030', '0030'),
(62, 'DIMAS ARYA PRASETYO', 1, 1, 'jakarta', '2000-06-23', 1289, 1103, '2015-04-21', '0031', '0031'),
(64, 'MUHAMMAD JOUNAIDI K', 1, 1, 'JAKARTA', '2000-06-07', 1254, 2063, '2015-04-22', '0032', '0032'),
(65, 'FIRMAN MAULANA', 1, 1, 'JAKARTA', '2000-12-29', 1289, 2063, '2015-04-22', '0017', '0017'),
(66, 'ASEP HERMANSYAH', 1, 1, 'jakarta', '2000-05-26', 1103, 2063, '2015-04-22', '0027', '0027'),
(67, 'SETYO ADJIE WIBOWO', 1, 1, 'Kebumen', '1999-10-25', 1254, 1289, '2015-04-22', '0033', '0033'),
(68, 'ACHMAD RIZAL NOVRIANTO', 1, 1, 'jakarta', '1999-11-16', 1254, 1289, '2015-04-22', '9995637039', '0034'),
(71, 'NAFIS NURPAUZAN', 1, 1, 'Jakarta', '2000-06-30', 1103, 1289, '2015-04-22', '0035', '0035'),
(72, 'M.JANUAR SN', 1, 1, 'BEKASI', '2000-01-28', 1289, 1254, '2015-04-22', '0036', '0036'),
(76, 'M. SYAIPUL ROZAK NOER', 1, 0, ", '0000-00-00', 0, 0, '2015-04-23', '0037', '0037'),
(77, 'TRY SEPTYAN S', 1, 1, 'BEKASI', '2000-09-29', 1103, 1254, '2015-04-23', '0038', '0038'),
(78, 'AFIF NANDA RIZKILLAH', 1, 1, 'JAKARTA', '2000-03-09', 1289, 1254, '2015-04-24', '0039', '0039'),
(79, 'RACHMAT WAHYU RIFAI', 1, 1, 'JAKARTA', '2000-07-17', 1103, 1289, '2015-04-24', '0040', '0040'),
(80, 'SADAM BILAGUNA', 1, 1, 'Jakarta', '2000-02-20', 1289, 1103, '2015-04-25', '0041', '0041'),
(81, 'MUHAMMAD RIAN AZHIM', 1, 1, 'BEKASI', '2000-05-14', 1289, 1103, '2015-04-25', '0007014806', '0042'),
(82, 'DWI PRAYUDI', 1, 1, 'magelang ', '2000-07-11', 1289, 1254, '2015-04-27', '0043', '0043'),
(83, 'MUHAMMAD AKROM FAHMI', 1, 1, 'JAKARTA', '2001-02-04', 2063, 1289, '2015-04-27', '0044', '0044'),
(84, 'ACHMAD FAOZI', 1, 1, 'Brebes', '2000-03-29', 1103, 1289, '2015-04-27', '0045', '0045'),
(85, 'MUHAMMAD RIESKY PUTRA', 1, 1, 'Jakarta', '2000-06-08', 1103, 1289, '2015-04-27', '0046', '0046'),
(86, 'RIZKI MAULANA', 1, 1, 'JAKARTA', '1999-08-21', 1103, 1289, '2015-04-27', '0047', '0047'),
(87, 'IRFAN MULYANA', 1, 1, 'pandeglang', '2000-06-14', 1289, 1103, '2015-04-28', '0048', '0048'),
(88, 'MOHAMAD BAHRUDIN', 1, 1, 'JAKARTA', '2000-07-24', 2063, 1174, '2015-04-28', '0049', '0049'),
(89, 'RAIHANSYAH', 1, 1, 'jakrta ', '1999-08-25', 1289, 1174, '2015-04-28', '0050', '0050'),
(90, 'HERMAWAN', 1, 1, 'JAKARTA', '2000-01-10', 2063, 1103, '2015-04-28', '0051', '0051'),
(91, 'RUDI SALAM', 1, 1, 'JAKARTA', '2000-07-03', 1174, 2063, '2015-04-29', '0052', '0052'),
(92, 'KUAT FEBRIYANTO', 1, 1, 'JAKARTA', '2000-02-21', 1289, 1103, '2015-04-30', '0053', '0053'),
(93, 'LUTFI LUPIK HIDAY', 1, 1, 'PURWORJO', '2000-02-21', 1289, 1254, '2015-04-30', '0054', '0054'),
(94, 'FACHMI TRI PRASOJO', 1, 1, 'JAKARTA', '2000-02-22', 1254, 1289, '2015-04-30', '0055', '0055'),
(95, 'OKY SAPUTRA', 1, 1, 'JAKARTA', '1999-10-04', 1254, 1289, '2015-04-30', '0056', '0056'),
(96, 'NIKELSON', 1, 3, 'SUMATERA UTARA', '2000-05-20', 2063, 1289, '2015-04-30', '0057', '0057'),
(97, 'ALDI TAUFIQURRAHMAN', 1, 1, 'JAKARTA', '2000-03-29', 2063, 1289, '2015-04-30', '0058', '0058'),
(99, 'RIYADI ANDY SAPUTRA', 1, 1, 'PURWOREJO', '2000-01-08', 2063, 1174, '2015-04-30', '0059', '0059'),
(101, 'REZA RIZKI ISHIKAWA', 1, 1, 'JAKARTA', '1998-08-12', 1103, 1289, '2015-04-30', '9980907262', '0060'),
(102, 'MUHAMMAD RIZKI SETIAWAN', 1, 1, 'sragen', '2000-03-09', 1289, 2063, '2015-05-02', '0061', '0061'),
(103, 'MUHAMMAD DAVID FEBRIANSYAH JIBRAN', 1, 1, 'Jakarta', '2001-02-02', 1289, 2063, '2015-05-02', '0062', '0062'),
(104, 'PRAMUDYA CHANDRA UMBARAN', 1, 1, 'JAKARTA', '2000-07-07', 1289, 1103, '2015-05-02', '0063', '0063'),
(105, 'AHMAD BAGUS SATRIO', 1, 1, 'JAKARTA', '2000-07-14', 2063, 1174, '2015-05-02', '0064', '0064'),
(106, 'MUHAMMAD HAEDAR', 1, 1, 'BEKASI', '1999-04-02', 1254, 1289, '2015-05-02', '0065', '0065'),
(107, 'PAJAR BAHARI', 1, 1, 'JAKARTA', '1998-10-21', 1289, 1254, '2015-05-04', '0066', '0066'),
(108, 'EKANTO PRASETYO ADI', 1, 1, 'JAKARTA', '2000-05-04', 1289, 1254, '2015-05-04', '0067', '0067'),
(109, 'TEGUH PRAYOGA', 1, 1, 'KEBUMEN', '1999-06-05', 1289, 1254, '2015-05-04', '0068', '0068'),
(110, 'MUHAMMAD DZAKY FADILLAH YAHYA', 1, 1, 'JAKARTA', '2000-03-26', 2063, 1289, '2015-05-04', '0069', '0069'),
(111, 'AJI PAMUNGKAS', 1, 0, ", '0000-00-00', 0, 0, '2015-05-05', '0070', '0070'),
(112, 'GALIH MAULANA', 1, 1, 'BEKASI', '2000-06-09', 1289, 1254, '2015-05-05', '0071', '0071'),
(113, 'HILMI YAHYA', 1, 1, 'Garut', '2000-05-15', 1289, 1174, '2015-05-05', '0072', '0072'),
(114, 'AKMAL HAFIDH', 1, 0, ", '0000-00-00', 0, 0, '2015-05-05', '0073', '0073'),
(115, 'MUHAMMAD RAFLIANA', 1, 1, 'jakrta', '2000-05-26', 1289, 1103, '2015-05-06', '0074', '0074'),
(116, 'TIO LUTFI HAMBALI', 1, 1, 'BEKASI', '1999-10-30', 2063, 1254, '2015-05-06', '0075', '0075'),
(117, 'MUHAMMAD ANDI LALA', 1, 0, ", '0000-00-00', 0, 0, '2015-05-06', '0076', '0076'),
(118, 'DWI YULIANTO WIBOWO', 1, 1, 'Jakarta', '2000-03-27', 1254, 1103, '2015-05-07', '0078', '0078'),
(119, 'M. RIZKY', 1, 1, 'jakarta', '2000-06-16', 1289, 2063, '2015-05-07', '0002291391', '0077'),
(120, 'KUSNO HENDRAWAN S', 1, 1, 'JAKARTA', '1999-12-12', 2063, 1289, '2015-05-07', '0079', '0079'),
(121, 'EKO SAPTO PUTRA', 1, 1, 'jakarta', '1998-04-08', 1289, 2063, '2015-05-07', '0080', '0080'),
(122, 'WISNU SAPUTRA', 1, 1, 'JAKARTA', '1999-11-17', 1289, 1254, '2015-05-08', '0081', '0081'),
(123, 'M. NUR ZULFIANDA', 1, 1, 'JAKARTA', '2000-03-31', 1289, 1254, '2015-05-08', '0082', '0082'),
(124, 'INDRA PURNOMO', 1, 1, 'JAKARTA', '1999-12-05', 1289, 1254, '2015-05-08', '0083', '0083'),
(125, 'UZZI MUZHOFFAR', 1, 1, 'JAKARTA', '2000-03-11', 1254, 2063, '2015-05-08', '0084', '0084'),
(126, 'DAVIT SAN HAM', 1, 1, 'JAKARTA', '2000-06-12', 1103, 2063, '2015-05-08', '0085', '0085'),
(127, 'BAHRUL HAYAT', 1, 1, 'purwakarta', '2000-11-18', 2063, 1289, '2015-05-08', '0086', '0086'),
(128, 'ACHMAD AMRI', 1, 0, ", '0000-00-00', 0, 0, '2015-05-08', '0087', '0087'),
(129, 'FAJRUL FALAH', 1, 0, ", '0000-00-00', 0, 0, '2015-05-09', '0088', '0088'),
(130, 'ACHMAD FAUZI', 1, 1, 'JAKARTA', '2000-01-29', 1254, 1289, '2015-05-09', '0089', '0089'),
(131, 'ANNISA TULJANNAH', 2, 1, 'Jakarta', '1999-08-02', 2063, 1174, '2015-05-09', '0090', '0090'),
(132, 'DIKI MAULANA YUSUF', 1, 1, 'JAKARTA', '1999-07-23', 2063, 1103, '2015-05-09', '0091', '0091'),
(133, 'MUHAMAD DJIO NOVI YANTO', 1, 1, 'Jakarta', '1999-11-29', 1289, 1174, '2015-05-09', '0092', '0092'),
(134, 'MUHAMMAD ADI SYAHPUTRO', 1, 1, 'BOYOLALI', '1999-03-21', 1289, 1174, '2015-05-09', '0093', '0093'),
(135, 'DICKY AGUS SETIAWAN', 1, 1, 'KEBUMEN', '1999-08-13', 1289, 1174, '2015-05-09', '0094', '0094'),
(136, 'SURYA NANDA IBRAHIM', 1, 1, 'JAKARTA', '2000-06-24', 1289, 1254, '2015-05-09', '0095', '0095'),
(137, 'AGUNG PANGESTU', 1, 1, 'JAKARTA', '1999-06-24', 1103, 1289, '2015-05-09', '0096', '0096'),
(138, 'FAJAR SURYANA', 1, 1, 'jakarta', '2000-06-11', 1289, 1103, '2015-05-09', '0097', '0097'),
(139, 'RIZKI DWI HAMZAH', 1, 1, 'JAKARTA', '1999-11-03', 1289, 1254, '2015-05-09', '0098', '0098'),
(140, 'MUHAMMAD FAKHRIF', 1, 1, 'Jakarta', '2000-02-19', 1254, 1289, '2015-05-11', '0099', '0099'),
(141, 'ADITYAPERMANA', 1, 1, 'JAKARTA', '2000-08-08', 2063, 1103, '2015-05-11', '0100', '0100'),
(142, 'NUR ARIFFIN', 1, 1, 'BEKASI', '1999-11-13', 1254, 1103, '2015-05-11', '0101', '0101'),
(143, 'IQWANUL HAKIKI', 1, 1, 'jakarta ', '2000-08-21', 1254, 1103, '2015-05-11', '0102', '0102'),
(144, 'MAULANA BAGUS FEBRIYANTO', 1, 1, 'tegal', '2000-02-06', 1289, 1254, '2015-05-11', '0103', '0103'),
(145, 'ADITYA KUSUMA ROWI', 1, 1, 'JAKARTA', '1999-04-19', 1289, 1254, '2015-05-11', '0104', '0104'),
(147, 'ALDINUGROHO', 1, 0, ", '0000-00-00', 0, 0, '2015-05-11', '0105', '0105'),
(148, 'JEFRY PRASETYO', 1, 0, ", '0000-00-00', 0, 0, '2015-05-11', '0106', '0106'),
(149, 'MUHAMMAD ARMAN FIRDAUS', 1, 1, 'JAKARTA', '2000-04-05', 1254, 2063, '2015-05-11', '0107', '0107'),
(150, 'ROLIN YUSTRIA', 1, 1, 'JAKARTA', '2000-07-27', 1254, 1174, '2015-05-11', '0108', '0108'),
(151, 'NAUFAL MUHAMMAD T', 1, 1, 'KLATEN', '2000-04-22', 1289, 2063, '2015-05-11', '0109', '0109'),
(152, 'MUHAMMAD FATHUL', 1, 1, 'JAKARTA', '2000-03-25', 1289, 1254, '2015-05-11', '0110', '0110'),
(153, 'RENDI MAULANA', 1, 1, 'JAKARTA', '2000-02-20', 2063, 1289, '2015-05-11', '0111', '0111'),
(154, 'RIZKI ARDIANSYAH PUTRA', 1, 1, 'jakarta timur', '1999-10-13', 2063, 1289, '2015-05-11', '0112', '0112'),
(155, 'ARIF SETIAWAN', 1, 1, 'JAKARTA', '2000-03-07', 1289, 1254, '2015-05-11', '0113', '0113'),
(156, 'RIDWAN ARDIANSYAH', 1, 1, 'JAKARTA', '2000-08-07', 2063, 1254, '2015-05-11', '0114', '0114'),
(157, 'YULISTIYANA', 2, 1, 'JAKARTA', '1999-04-26', 1174, 2063, '2015-05-11', '0115', '0115'),
(158, 'YOSEF YONANDA', 1, 1, 'indramayu', '1999-11-27', 1254, 1289, '2015-05-11', '0116', '0116'),
(159, 'MUHAMMAD DWI CAHYO', 1, 1, 'JAKARTA', '2000-06-10', 1289, 1103, '2015-05-11', '0117', '0117'),
(160, 'AGUNG HENDRAWAN', 1, 1, 'magelang', '2000-03-13', 1254, 1174, '2015-05-11', '0118', '0118'),
(161, 'RIZKINUGROHO', 1, 1, 'JAKARTA', '1999-12-18', 1289, 1103, '2015-05-12', '0', '0119'),
(162, 'FAUZAN ALFIANSYAH', 1, 1, 'JAKARTA', '1999-11-07', 1254, 1289, '2015-05-12', '0120', '0120'),
(163, 'AHMAD JAIS', 1, 0, ", '0000-00-00', 0, 0, '2015-05-12', '0121', '0121'),
(164, 'HAROM', 1, 1, 'JAKARTA', '2000-03-12', 1289, 1103, '2015-05-12', '0122', '0122'),
(165, 'PUTRA TRI PRASTYO', 1, 1, 'BEKASI', '2000-07-16', 1103, 1174, '2015-05-12', '0123', '0123'),
(166, 'ABDUL AZIZ', 1, 1, 'JAKARTA', '1999-05-07', 1289, 1103, '2015-05-12', '0124', '0124'),
(167, 'TEGUH HASBALLAH', 1, 0, ", '0000-00-00', 0, 0, '2015-05-12', '0125', '0125'),
(168, 'MUHAMAD FACHRI SYAHPUTRA', 1, 0, ", '0000-00-00', 0, 0, '2015-05-12', '0126', '0126'),
(169, 'RIZQY DANENDRA', 1, 1, 'JAKARTA', '2001-02-08', 1254, 1174, '2015-05-12', '0011173783', '0127'),
(170, 'EGI ROHMAN', 1, 0, ", '0000-00-00', 0, 0, '2015-05-12', '0128', '0128'),
(171, 'ARSY HERIYANTO', 1, 1, 'JAKARTA', '2000-03-30', 1254, 1289, '2015-05-12', '0129', '0129'),
(172, 'AFDHOL DINILHAQ', 1, 1, 'bekasi', '1999-10-12', 1289, 2063, '2015-05-12', '0130', '0130');

Selanjutnya kita buat table jurusan dengan nama t_jurusan seperti dibawah ini

CREATE TABLE IF NOT EXISTS `t_jurusan` (
`id_jur` int(5) NOT NULL,
  `jurusan` varchar(30) NOT NULL,
  `jur_ket` varchar(10) NOT NULL,
  `kdjur` varchar(10) NOT NULL,
  `quota` varchar(5) NOT NULL,
  `kelas` varchar(5) NOT NULL,
  `bayar` varchar(20) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2064 ;
 
--
-- Dumping data إلى عن على table `t_jurusan`
--
 
INSERT INTO `t_jurusan` (`id_jur`, `jurusan`, `jur_ket`, `kdjur`, `quota`, `kelas`, `bayar`) VALUES
(0, 'Kosong', ", ", ", ", "),
(1103, 'TITL', ", ", '160', '4', '3400000'),
(1174, 'TAV', ", ", '120', '2', '3400000'),
(1254, 'TP', ", ", '160', '4', '3400000'),
(1289, 'TKR', ", ", '160', '4', '3400000'),
(2063, 'TKJ', ", ", '160', '4', '4045000');

Jika data sudah masuk kita buat folder di htdocs, nama terserah anda pada kali ini saya membuat folder dengan nama statistik,
lalu kita buat file php baru dengan nama config.php lalu masukan script dibawah ini

<?بي أتش بي
 
$db = جديد mysqli("مضيف محلي",'جذر', "12345", 'statistik');
 
إذا($db->connect_errno > 0){
 
ال('Unable to connect to database [" . $db->connect_error . "]");
 }
 
?>

Jika file config sudah selesai kita download boostrap dan copy folder assets beserta isinya ke folder statistik download jga easypiechart yang nanti nya kita gunakan untuk membuat grafik, copy file easypiechat yang berisi jquery.easy-pie-chart.css & jquery.easy-pie-chart.js ke folder assets\css

Selanjutnya kita buat file index.php masukan script dibawah ini

index.php   
<?بي أتش بي
تضمن "koneksi.php";
?>
 
<!DOCTYPE html>
<html lang="en">
  <رئيس>
    <meta charset="utf-8">
    <عنوان>Membuat Statistik Pendaftar dengan Php,Boostrap dan Mysqli</عنوان>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="">
 
    <!-- Le styles -->
	    <link href="assets/css/bootstrap.css" rel="stylesheet" media="screen">
        <link href="assets/css/bootstrap-responsive.min.css" rel="stylesheet" media="screen">
		 <link href="assets/css/bootstrap.min.css" rel="stylesheet" media="screen">
		<link href="assets/css/easypiechart/jquery.easy-pie-chart.css" rel="stylesheet" media="screen">
    <أسلوب>
      الجسم {
        padding-top: 60مقصف; /* 60بكسل لجعل الحاوية تذهب طوال الطريق إلى أسفل الشريط العلوي */
      }
    </أسلوب>
    <link href="assets/css/bootstrap-responsive.css" rel="stylesheet">
 
    <!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
    <!--[if lt IE 9]>
      <script src="../assets/js/html5shiv.js"></النصي>
    <![إنهاء إذا]-->
 
    <!-- Fav and touch icons -->
    <link rel="apple-touch-icon-precomposed" sizes="144x144" href="assets/ico/apple-touch-icon-144-precomposed.png">
    <link rel="apple-touch-icon-precomposed" sizes="114x114" href="assets/ico/apple-touch-icon-114-precomposed.png">
      <link rel="apple-touch-icon-precomposed" sizes="72x72" href="assets/ico/apple-touch-icon-72-precomposed.png">
                    <link rel="apple-touch-icon-precomposed" href="assets/ico/apple-touch-icon-57-precomposed.png">
                                   <link rel="shortcut icon" href="assets/ico/favicon.png">
  </رئيس>
 
  <الجسم>
 
    <div class="navbar navbar-inverse navbar-fixed-top">
      <div class="navbar-inner">
        <div class="container">
          <button type="button" class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
            <span class="icon-bar"></امتداد>
            <span class="icon-bar"></امتداد>
            <span class="icon-bar"></امتداد>
          </زر>
          <a class="brand" href="http://andeznet.com">AndezNet</أ>
          <div class="nav-collapse collapse">
            <ul class="nav">
              <li class="active"><a href="#">الصفحة الرئيسية</أ></في ال>
              <في ال><a href="#">Grafik</أ></في ال>
              <في ال><a href="#">تسجيل خروج</أ></في ال>
            </ال>
          </شعبة><!--/.nav-collapse -->
        </شعبة>
      </شعبة>
    </شعبة>
 
<div class="container">
<h2>STATISTIK PENDAFTAR</h2>
<h3>Penerimaan Siswa Baru <a href="https:facebook.com/smkdp1n2">SMK Dinamika Pembangunan 1 Jakarta</أ></h3>
<p>Berdasarkan Jurusan</p>
 
<div class="block-content collapse in">
 
<?بي أتش بي
 
$hasil = mysqli_query($db,"SELECT * FROM t_jurusan where id_jur >1");
في حين ($البيانات = mysqli_fetch_row($hasil))
{
$kodejur= $البيانات[0];
$jurusan= $البيانات[1];
$quota=$البيانات[4];
 
$hasil2 = mysqli_query($db,"SELECT count(*) as jum FROM master WHERE jrsn_pil1 = '$kodejur"");
$data2 = mysqli_fetch_row($hasil2);
$jumlah = $data2[0]; 
$datapercent= $jumlah / $quota * 100;
 
 
صدى صوت"			
<div class='span1'>
<div class='chart' data-percent='".الجزء الفرعي($datapercent,0,4)."'>".الجزء الفرعي($datapercent,0,4)."% <span class='label label-info'>".$jurusan."</امتداد></شعبة>
</شعبة>";
 
};
 
 
?>
</شعبة>
 
 
<div class="table-responsive">	  
<table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered" >
<?بي أتش بي
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
صدى صوت "<tr><th>NO</th><th>JURUSAN</th><th>KELAS</th><th>L</th><th>P</th><th>JUMLAH SISWA</th><th>QUOTA</th><th>KURANG</th>";  
 
$no = 1;
 
$totalSiswa = 0;
 
$hasil = mysqli_query($db,"SELECT * FROM t_jurusan where id_jur >1");
في حين ($البيانات = mysqli_fetch_row($hasil))
{
 
$kodejur= $البيانات[0];
 
$jurusan= $البيانات[1];
$quota=$البيانات[4]; 
$kelas=$البيانات[5]; 
$totalkelas+=$kelas; 
$totalquota+=$quota; 
 
$hasil2 = mysqli_query($db,"SELECT count(*) as jum FROM master WHERE jrsn_pil1 = '$kodejur"");
$data2 = mysqli_fetch_row($hasil2);
$jumlah = $data2[0]; 
 
$hasillaki = mysqli_query($db,"SELECT count(*) as laki FROM master WHERE s_jk='1' and jrsn_pil1 = '$kodejur"");
$datalaki = mysqli_fetch_row($hasillaki);
$jumlahlaki = $datalaki[0]; 
 
$hasilP = mysqli_query($db,"SELECT count(*) as P FROM master WHERE s_jk='2' and jrsn_pil1 = '$kodejur"");
$dataP = mysqli_fetch_row($hasilP);
$jumlahP = $dataP[0]; 
 
$kurang=$jumlah-$quota;
$totalsiswa += $jumlah; 
$totallaki+= $jumlahlaki; 
$totalP+= $jumlahP; 
$totalkurang+=$kurang;
 
 
صدى صوت "<tr><td>".$no."</td><td>".$jurusan."</td><td>".$kelas."</td><td>".$jumlahlaki."</td><td>".$jumlahP."</td><td>".$jumlah."&nbsp Siswa</td><td>".$quota."&nbsp Siswa</td><td>".$kurang."&nbsp Siswa</td>";
 
 
$no++;
}
 
صدى صوت "<tr><td colspan='2'>JUMLAH</td><td>".$totalkelas."</td><td>".$totallaki."</td><td>".$totalP."</td><td>".$totalsiswa."&nbsp Siswa</td><td>".$totalquota."&nbsp Siswa</td><td>".$totalkurang."&nbsp Siswa</td>";
 
 
 
?>
</الطاولة> 
</شعبة>	  
 
</الطاولة> 	 
 
    </شعبة> <!-- /container -->
 
	<div class="row-fluid">
			<div class="span12">
			  <div class="row-fluid">
				<div class="alert alert-info">
					<a name="contact"></أ>
				  <h2>www.andeznet.com</h2>
				  <p class="text-info">Gudang Teknologi & Informasi</p>
				  <p>&copy; <a href="http://andeznet.com">www.andeznet.com</أ>&nbsp<?بي أتش بي صدى صوت date("Y");?></p>
				</شعبة><!--/span-->
			  </شعبة><!--/row-->
			</شعبة><!--/span-->
	</شعبة><!--/row-->
 
 
    <!-- Le javascript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="assets/js/jquery.js"></النصي>
    <script src="assets/js/bootstrap-transition.js"></النصي>
    <script src="assets/js/bootstrap-alert.js"></النصي>
    <script src="assets/js/bootstrap-modal.js"></النصي>
    <script src="assets/js/bootstrap-dropdown.js"></النصي>
    <script src="assets/js/bootstrap-scrollspy.js"></النصي>
    <script src="assets/js/bootstrap-tab.js"></النصي>
    <script src="assets/js/bootstrap-tooltip.js"></النصي>
    <script src="assets/js/bootstrap-popover.js"></النصي>
    <script src="assets/js/bootstrap-button.js"></النصي>
    <script src="assets/js/bootstrap-collapse.js"></النصي>
    <script src="assets/js/bootstrap-carousel.js"></النصي>
    <script src="assets/js/bootstrap-typeahead.js"></النصي>
 
	<script src="assets/js/bootstrap.min.js"></النصي>
    <script src="assets/css/easypiechart/jquery.easy-pie-chart.js"></النصي>
 
	<النصي>
        $(وظيفة() {
            // Easy pie charts
            $('.chart').easyPieChart({animate: 1000});
        });
     </النصي>
 
  </الجسم>
</لغة البرمجة>

Jika sudah buka browser kita lalu ketik localhost/statistik jika sudah benar maka akan muncul seperti gambar dibawah ini :

statistik data pendaftar dengan php,mysqli, دفعة
Apabila chart nya tidak tampil maka cek folder easypiechart apa sudah ada di directory assets/css ?
Apabila data tidak tampil maka cek file config.php username,كلمه السر & database nya apa sudah sesuai ?

Ok sekian tutorial kali ini, mudah-mudahan tutorial kali ini bisa bermanfaat. Amin

Download Souce Code

DEMO

Happy Coding & برمجة

ربما يعجبك أيضا...

2 استجابات

  1. Rudi يقول:

    min, klo pas klik tombol edit di salah satu daftar biodata, kan menuju halaman lain tuh, tapi daftar biodata lain juga muncul di bawahnya, gimana caranya ya biar gk muncul juga ?

اترك رد

لن يتم نشر عنوان بريدك الإلكتروني. الحقول المطلوبة محددة *