PMA_token |s:32:"3b262a3f365f285c445b39625f3a6b5e"; HMAC_secret |s:16:".s/PnO09%<4y{ADQ";auth_type|s:3:"env";browser_access_time|a:2:{s:7:"default";i:1586364193;s:36:"ae3c1e3d-6a9c-8f93-ae72-7aeab113bd79";i:1586364314;}encryption_key|s:32:"·öᳺsáâ-qaÛÞ ’ñíJï¸(«Í_";relation|a:1:{i:1;a:22:{s:11:"PMA_VERSION";s:5:"4.9.4";s:7:"relwork";b:0;s:11:"displaywork";b:0;s:12:"bookmarkwork";b:0;s:7:"pdfwork";b:0;s:8:"commwork";b:0;s:8:"mimework";b:0;s:11:"historywork";b:0;s:10:"recentwork";b:0;s:12:"favoritework";b:0;s:11:"uiprefswork";b:0;s:12:"trackingwork";b:0;s:14:"userconfigwork";b:0;s:9:"menuswork";b:0;s:7:"navwork";b:0;s:17:"savedsearcheswork";b:0;s:18:"centralcolumnswork";b:0;s:20:"designersettingswork";b:0;s:19:"exporttemplateswork";b:0;s:8:"allworks";b:0;s:4:"user";N;s:2:"db";N;}}cache|a:2:{s:25:"server_1_kecamatanbanyuwa";a:18:{s:14:"mysql_cur_user";s:26:"kecamatanbanyuwa@localhost";s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:6:{i:0;s:20:"kecamata\_pelayanan2";i:1;s:14:"kecamata\_nota";i:2;s:14:"kecamata\_ijin";i:3;s:19:"kecamata\_pelayanan";i:4;s:14:"kecamata\_home";i:5;s:23:"kecamatanbanyuwa\_nota2";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:12:"is_superuser";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:10:"Basis data";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:8:"Pengguna";s:6:"export";s:6:"Ekspor";s:6:"import";s:5:"Impor";s:8:"settings";s:10:"Pengaturan";s:6:"binlog";s:9:"Log biner";s:11:"replication";s:9:"Replikasi";s:4:"vars";s:8:"Variabel";s:7:"charset";s:12:"Set Karakter";s:7:"plugins";s:6:"Plugin";s:6:"engine";s:5:"Mesin";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:8:"Struktur";s:3:"sql";s:3:"SQL";s:6:"search";s:4:"Cari";s:5:"query";s:5:"Kueri";s:6:"export";s:6:"Ekspor";s:6:"import";s:5:"Impor";s:9:"operation";s:7:"Operasi";s:10:"privileges";s:9:"Hak Akses";s:8:"routines";s:7:"Routine";s:6:"events";s:5:"Event";s:8:"triggers";s:7:"Trigger";s:8:"tracking";s:9:"Pelacakan";s:8:"designer";s:8:"Desainer";s:15:"central_columns";s:12:"Tengah kolom";}s:19:"profiling_supported";b:1;s:17:"menu-levels-table";a:11:{s:6:"browse";s:8:"Jelajahi";s:9:"structure";s:8:"Struktur";s:3:"sql";s:3:"SQL";s:6:"search";s:4:"Cari";s:6:"insert";s:9:"Tambahkan";s:6:"export";s:6:"Ekspor";s:6:"import";s:5:"Impor";s:10:"privileges";s:9:"Hak Akses";s:9:"operation";s:7:"Operasi";s:8:"tracking";s:9:"Pelacakan";s:8:"triggers";s:7:"Trigger";}}s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1586363291;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1583290772;s:9:"userprefs";a:2:{s:4:"lang";s:2:"id";s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:2:"id";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1586363291;}two_factor_check|b:1;git_location|N;is_git_revision|b:0;tmpval|a:16:{s:15:"favorite_tables";a:1:{i:1;a:0:{}}s:13:"recent_tables";a:1:{i:1;a:2:{i:0;a:2:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";}i:1;a:2:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:16:"kecamata_netbill";s:5:"query";a:10:{s:32:"159d50dfff3dabfea6660dfb8662ad2b";a:8:{s:3:"sql";s:468:"-- -------------------------------------------------------- -- -- Table structure for table `t_transaksi` -- CREATE TABLE IF NOT EXISTS `t_transaksi` ( `id_transaksi` varchar(30) NOT NULL, `id_pelanggan` varchar(50) NOT NULL, `nominal` int(7) NOT NULL, `bukti` varchar(50) NOT NULL, `tgl_bayar` date NOT NULL, `tgl_validasi` date NOT NULL, `status` enum('pending','lunas') NOT NULL, PRIMARY KEY (`id_transaksi`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"c2ac3184104b6515d9c26d90c24ce0ee";a:8:{s:3:"sql";s:789:"-- -- Dumping data for table `t_transaksi` -- INSERT INTO `t_transaksi` (`id_transaksi`, `id_pelanggan`, `nominal`, `bukti`, `tgl_bayar`, `tgl_validasi`, `status`) VALUES ('INV001', 'SN02', 100000, '', '2015-08-01', '2015-08-02', 'lunas'), ('INV004', 'SN02', 50000, '', '2015-08-19', '2015-08-28', 'lunas'), ('INV005', 'SN03', 75000, '', '2015-08-05', '0000-00-00', 'pending'), ('INV006', 'SN03', 50000, '', '2015-08-08', '0000-00-00', 'pending'), ('INV007', 'SN03', 50000, '', '2015-08-28', '2015-08-21', 'lunas'), ('INV008', 'SN03', 50000, '', '2015-08-21', '0000-00-00', 'pending'), ('INV011', 'SN03', 75, '', '2015-08-30', '0000-00-00', 'pending'), ('INV012', 'SN03', 75, '', '2015-08-28', '0000-00-00', 'pending'), ('INV013', 'SN03', 75000, '', '2015-08-24', '0000-00-00', 'pending')";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"be6b1608ad68ae73b92882fc304f8815";a:8:{s:3:"sql";s:382:"-- -------------------------------------------------------- -- -- Table structure for table `t_user` -- CREATE TABLE IF NOT EXISTS `t_user` ( `id_pelanggan` varchar(25) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(40) NOT NULL, `level` enum('admin','pelanggan') NOT NULL, UNIQUE KEY `id_pelanggan` (`id_pelanggan`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"35055a3540c20fa4828d4103867813b0";a:8:{s:3:"sql";s:317:"-- -- Dumping data for table `t_user` -- INSERT INTO `t_user` (`id_pelanggan`, `username`, `password`, `level`) VALUES ('SN01', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin'), ('SN02', 'afika', 'd94ac5196f76d7562f5f9fd7ab478484', 'pelanggan'), ('SN03', 'user', 'ee11cbb19052e40b07aac0ca060c23ee', 'pelanggan')";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"b532b4cddc206882410cc338025fd0ff";a:8:{s:3:"sql";s:240:"-- -- Constraints for dumped tables -- -- -- Constraints for table `t_user` -- ALTER TABLE `t_user` ADD CONSTRAINT `t_user_ibfk_1` FOREIGN KEY (`id_pelanggan`) REFERENCES `t_pelanggan` (`id_pelanggan`) ON DELETE CASCADE ON UPDATE CASCADE";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"314a2a6af715a117719831abd47a7e59";a:8:{s:3:"sql";s:62:"/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"3156cc0fff730d17edc1acfdb05ed71c";a:8:{s:3:"sql";s:64:"/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"dcdde952b3211bb4e1b0a9110e18a57f";a:8:{s:3:"sql";s:62:"/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"7eb434fd719eef637126df833e4ebd70";a:8:{s:3:"sql";s:22:"SELECT * FROM `t_user`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";s:1:"0";s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"ab6758de97dfb399be4603d90f33a78c";a:8:{s:3:"sql";s:27:"SELECT * FROM `t_transaksi`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";s:1:"0";s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";s:1:"0";s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:16:"kecamata_netbill";a:2:{s:6:"t_user";a:0:{}s:11:"t_transaksi";a:0:{}}}}s:20:"possible_as_geometry";b:1;}ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}Import_message|a:2:{s:7:"message";s:161:"
Impor telah selesai, 22 kueri dilakukan. (netbill.sql)
";s:11:"go_back_url";s:33:"db_import.php?db=kecamata_netbill";}is_multi_query|b:0;sql_history|a:15:{i:0;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:1;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:2;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:3;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:4;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";s:8:"sqlquery";s:27:"SELECT * FROM `t_transaksi`";}i:5;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:6;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:7;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:8;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:9;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";s:8:"sqlquery";s:27:"SELECT * FROM `t_transaksi`";}i:10;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";s:8:"sqlquery";s:27:"SELECT * FROM `t_transaksi`";}i:11;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";s:8:"sqlquery";s:27:"SELECT * FROM `t_transaksi`";}i:12;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:6:"t_user";s:8:"sqlquery";s:22:"SELECT * FROM `t_user`";}i:13;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";s:8:"sqlquery";s:27:"SELECT * FROM `t_transaksi`";}i:14;a:3:{s:2:"db";s:16:"kecamata_netbill";s:5:"table";s:11:"t_transaksi";s:8:"sqlquery";s:27:"SELECT * FROM `t_transaksi`";}}errors|a:0:{}