API tools faq
paste
Advertisement
virbo

Select2 Ajax Codeigniter

virbo
Jul 5th, 2015
508
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.30 KB | None | 0 0
raw download clone embed print report
  1. ==============================================================================
  2. Database shop.sql
  3. ==============================================================================
  4. --
  5. -- Table structure for table `shop`
  6. --
  7.  
  8. CREATE TABLE IF NOT EXISTS `konsumen` (
  9. `id_konsumen` int(11) NOT NULL,
  10.   `nm_konsumen` varchar(50) NOT NULL,
  11.   `tgl_lahir` varchar(50) NOT NULL
  12. ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
  13.  
  14. --
  15. -- Dumping data for table `konsumen`
  16. --
  17.  
  18. INSERT INTO `konsumen` (`id_konsumen`, `nm_konsumen`, `tgl_lahir`) VALUES
  19. (1, 'BAGUS SETIAWAN PRIANTO', 'SALABENDA,23-10-1996'),
  20. (2, 'RICKIANSYAH SAADA', 'TINTINGAN,27-07-1996'),
  21. (3, 'DEVITA ANGGINI MANGGULELE', 'TANGKIANG,12-07-1996'),
  22. (4, 'WAYAN ARYA', 'SENTRALSARI,23-10-1995'),
  23. (5, 'SUSILAWATI', 'KOLAK,20-02-1997'),
  24. (6, 'SULASMI M BADING', 'TINTINGAN,19-06-1995'),
  25. (7, 'HARI SUPRIONO', 'LUWUK,10-10-1995'),
  26. (8, 'AGNES IMELDA HAGAPU', 'SULUBOMBANG,02-02-1995'),
  27. (9, 'FRISKILA PUTRI VALENTIA', 'HUNDUHON,14-02-1997'),
  28. (10, 'DWI LESTARI', 'KAMPANGAR,07-02-1997'),
  29. (11, 'INDRIANTI LAHASI', 'LUWUK,17-01-1997'),
  30. (12, 'YUSRI ROWID MANGADIL', 'LUWUK,24-01-1996'),
  31. (13, 'MIFTAH HAMUDE', 'TANGEBAN,01-02-1995'),
  32. (14, 'KADEK SANTAYANA', 'BANTA,31-01-1996'),
  33. (15, 'NURHASANAH S NONGE', 'LAMBANGAN,27-03-1987'),
  34. (16, 'CAHYUTARI', 'ABASON,23-07-1993'),
  35. (17, 'MOH ENOY RULIANSYAH', 'TANA NAGAYA,13-02-1996'),
  36. (18, 'LATIFAH ABD F LANASIR', 'BATUI,08-08-1997'),
  37. (19, 'SATRIYANO BANGUNAN', 'BULUNGKOBIT,01-01-1997'),
  38. (20, 'AYU RESTIKA', 'LUWUK,22-07-1994'),
  39. (21, 'RIZKI A HASAN', 'MONSONGAN,13-07-1996'),
  40. (22, 'NUR FIRDAYANTI LANIPI', 'BALANTAK,22-10-1994'),
  41. (23, 'SARI LESMANA', 'SINORANG,07-10-1996'),
  42. (24, 'METRINA SOTOMANI', 'BANGKETA,08-05-1996'),
  43. (25, 'MASLIPA', 'LUWUK,19-10-1996'),
  44. (26, 'NURFADILAH', 'LUWUK,10-07-1997'),
  45. (27, 'FERAWATI MUA', 'SIUNA,15-09-1996'),
  46. (28, 'BOY BADU', 'BALALON,17-08-1993'),
  47. (29, 'ASMIN NGINANG', 'MAMAULUSAN,13-04-1997'),
  48. (30, 'FRADITA SALAWALI', 'BALANTAK,09-06-1996'),
  49. (31, 'MOH PAJRIARISANDI NURSIN', 'BUNGIN,21-12-1995'),
  50. (32, 'FAUZIA', 'LUWUK,25-01-1996'),
  51. (33, 'SRI WAHYUNI ADE MULYANI', 'LUWUK,06-04-1998'),
  52. (34, 'I GEDE YOGA MURJANA', 'PASIR LAMBA,29-06-1996'),
  53. (35, 'SARI BOTI', 'LUWUK,30-12-1997'),
  54. (36, 'ALFIANTI DJAMIL', 'LUWUK,20-10-1996'),
  55. (37, 'WAYAN ENDRAWAN', 'TIRTA KENCANA,13-03-1995'),
  56. (38, 'FELIX STEPEN ANDREITNO L', 'SABANG,19-05-1996'),
  57. (39, 'MOH RIZKI MAIJA', 'LAMO,13-01-1996'),
  58. (40, 'CITRA FEBRIANTI AMBADO', 'TOMBOS,21-07-1997'),
  59. (41, 'WAODE SITTI HARTINA', 'ABELI,30-12-1996'),
  60. (42, 'NOVIATI M BAADIB', 'KINTOM,19-11-1996'),
  61. (43, 'JULRATIN', 'TARONGGO,15-07-1987'),
  62. (44, 'MOH ILHAM', 'SALAKAN,20-03-1996'),
  63. (45, 'CINDY GLORIA RONTE', 'LUWUK,14-06-1997'),
  64. (46, 'DARMAWATI LAANE', 'NGGELE,31-01-1996'),
  65. (47, 'SANANDA FATHONA H GENI', 'LUWUK,02-11-1995'),
  66. (48, 'RISKA BALIAS', 'LOMBA,13-09-1996'),
  67. (49, 'FITRA AULIA NUR', 'LUWUK,05-01-1996'),
  68. (50, 'JUWITAWATI', 'BALANTAK,11-01-1992'),
  69. (51, 'RUSPANDI MAKMUR DENDE', 'BALTONIB,21-06-1995'),
  70. (52, 'MOH AKBAR', 'LAMO,06-03-1996'),
  71. (53, 'MISNAWATI LABIALO', 'LUWUK,17-08-1996'),
  72. (54, 'NURMILA R BULASIMA', 'LUMBI-LUMBIA,18-12-1994'),
  73. (55, 'SOLEMAN USUMAN', 'UWEDAKA-DAKA,21-10-1996'),
  74. (56, 'I GEDE RUDIKA', 'TAHITISARI,15-02-1996'),
  75. (57, 'DWI FEBRIANTY NOHO', 'KINTOM,02-02-1996'),
  76. (58, 'SARLINCE', 'KOMBUTOKAN,05-07-1994'),
  77. (59, 'YULINDA M BONSE', 'LUWUK,13-03-1996'),
  78. (60, 'PANDU PERANTI', 'SALAKAN,25-06-1996'),
  79. (61, 'ANGGINI', 'PAISU BEBE,03-03-1996'),
  80. (62, 'GLASY ANGELICA YOSEPH', 'LUWUK,24-09-1996'),
  81. (63, 'WANDA NDEBA', 'JAYABAKTI,17-07-1996'),
  82. (64, 'AISYA M BASILA', 'POPISI,08-11-1996'),
  83. (65, 'MUH NUR ALAMSYAH', 'LUWUK,12-12-1996'),
  84. (66, 'FIFIN FIJAYANTI', 'DS GORONTALO,02-09-1996'),
  85. (67, 'WINDY MAKATENGKENG', 'LUWUK,24-08-1996'),
  86. (68, 'DELTA KITOMO', 'PAISUBOLOLI,25-11-1997'),
  87. (69, 'SYARIFAH ALWIYAH LATABILA', 'MOHABAK,04-04-1996'),
  88. (70, 'DITA ARISTHA PURESE', 'LUWUK,27-02-1997'),
  89. (71, 'KRISNAWATI MUA', 'RESARNA,22-03-1997'),
  90. (72, 'NURTELA BENDA', 'BATUI,23-10-1996'),
  91. (73, 'MUHAMMAD FAHRI S', 'LUWUK,29-06-1996'),
  92. (74, 'I WAYAN AGUS SUDANA', 'TOILI,29-04-1996'),
  93. (75, 'SUKRIYANTO B KASIM', 'MALAPO,12-04-1994'),
  94. (76, 'HERMAN WAHE', 'TOBING,05-10-1995'),
  95. (77, 'YUSMA HASMIN', 'KILOMA,16-03-1996'),
  96. (78, 'SUTRISMAN', 'KOLAK,25-08-1995'),
  97. (79, 'REYNALDI R KATILI', 'JAYABAKTI,15-03-1995'),
  98. (80, 'FATRI R SALOMA', 'SALANGANO,18-12-1996'),
  99. (81, 'SITTI HADIJAH LUANDE', 'AMBELANG,19-06-1997'),
  100. (82, 'YAYU SRI RAHAYU', 'PAISUBATU,24-02-1995'),
  101. (83, 'RAHAYU PRATIWI RUSYADI', 'LUWUK,17-09-1996'),
  102. (84, 'FIANI TANTRI SAHENA', 'TOMATA,21-06-1995'),
  103. (85, 'ANNISA RIZKI L HURAERA', 'LUWUK,05-09-1996'),
  104. (86, 'LASMI U BASILA', 'LUWUK,10-07-1997'),
  105. (87, 'SRIMUBARKA SANGKETA', 'BUNTA,28-05-1997'),
  106. (88, 'SYAFUTRI REZKIWANTI LAGUNI', 'LUWUK,28-10-1996'),
  107. (89, 'LINDA TOIMA', 'LUWUK,12-03-1997'),
  108. (90, 'RULLY NASRULLAH NDEO', 'LUWUK,12-12-1995'),
  109. (91, 'ALPINOVITA BABANGGAI', 'PAISUBATU,22-06-1997'),
  110. (92, 'LA MUHAIDIR TOMIA', 'GAY,04-10-1996');
  111.  
  112. --
  113. -- Indexes for table `konsumen`
  114. --
  115. ALTER TABLE `konsumen`
  116.  ADD PRIMARY KEY (`id_konsumen`);
  117.  
  118. --
  119. -- AUTO_INCREMENT for table `konsumen`
  120. --
  121. ALTER TABLE `konsumen`
  122. MODIFY `id_konsumen` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=93;
  123.  
  124.  
  125.  
  126. /* ======================================================================== */
  127. /* Models (m_konsumen.php) */
  128. /* ======================================================================== */
  129.  
  130. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  131.    class M_konsumen extends CI_Model {
  132.        
  133.        private $table_name = 'konsumen';
  134.        
  135.        
  136.        function __construct() {
  137.            parent::__construct();
  138.        }
  139.        
  140.        function select_by($cari,$kolom) {
  141.            $this->db->select($kolom)
  142.                 ->from($this->table_name)
  143.                 ->like('nm_konsumen',$cari);
  144.            $result = $this->db->get();
  145.            return $result;
  146.        }
  147.    }
  148.    
  149. /* End of file m_konsumen.php */
  150. /* Location: ./application/models/m_konsumen.php */
  151.  
  152.  
  153. /* ======================================================================== */
  154. /* Controller welcome.php */
  155. /* ======================================================================== */
  156.  
  157. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  158.  
  159. class Welcome extends CI_Controller {
  160.  
  161.     public function index()
  162.     {
  163.         $this->load->view('welcome_message');
  164.     }
  165.    
  166.     public function cari()
  167.     {
  168.         $cari = $this->input->get('q');
  169.         $temp = $this->m_konsumen->select_by($cari,'id_konsumen, nm_konsumen')->result_array();
  170.         echo json_encode($temp);
  171.     }
  172. }
  173.  
  174. /* End of file welcome.php */
  175. /* Location: ./application/controllers/welcome.php */
  176.  
  177.  
  178. /* ======================================================================== */
  179. /* View welcome_message.php */
  180. /* ======================================================================== */
  181. <!DOCTYPE html>
  182. <html lang="en">
  183. <head>
  184.     <meta charset="utf-8">
  185.     <title>Ambil Konsumen</title>
  186.  
  187.     <link href="<?php echo base_url();?>assets/css/bootstrap.min.css" rel="stylesheet">
  188.     <link href="<?php echo base_url();?>assets/css/select2.min.css" rel="stylesheet">
  189. </head>
  190. <body>
  191. <div class="container-fluid">
  192.     <div row>
  193.         <div class="col-md-4">
  194.             <select class="js_select js-states form-control" name="cari"></select>
  195.         </div>
  196.     </div>
  197. </div>
  198. <script src="<?php echo base_url();?>assets/js/jquery.js"></script>
  199. <script src="<?php echo base_url();?>assets/js/select2.full.min.js"></script>
  200. <script type="text/javascript">
  201.     $(document).ready(function() {
  202.        
  203.         $(".js_select").select2({
  204.             placeholder: "Pilih konsumen..",
  205.             ajax: {
  206.                 url: "<?php echo base_url();?>index.php/welcome/cari",
  207.                 dataType: 'json',
  208.                 delay: 20,
  209.                 data: function (cari) {
  210.                     return {
  211.                         q: cari.term, // search term
  212.                     };
  213.                 },
  214.                 processResults: function (data) {
  215.                     return {
  216.                         results: $.map(data, function(obj) {
  217.                             return { id: obj.id_konsumen, text: obj.nm_konsumen};
  218.                         })
  219.                     };
  220.                 },
  221.                 cache: true
  222.             },
  223.         });
  224.     });        
  225. </script>
  226. </body>
  227. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!