Advertisement
Guest User

Untitled

a guest
Mar 30th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.59 KB | None | 0 0
  1. <style type="text/css">
  2.  
  3. input[type=text] {
  4. border: 2px solid #bdbdbd;
  5. font-family: 'Roboto', Arial, Sans-serif;
  6. font-size: 15px;
  7. font-weight: 400;
  8. padding: .5em .75em;
  9. width: 300px;
  10. }
  11. input[type=text]:focus {
  12. border: 2px solid #757575;
  13. outline: none;
  14. }
  15. .autocomplete-suggestions {
  16. border: 1px solid #999;
  17. background: #FFF;
  18. overflow: auto;
  19. }
  20. .autocomplete-suggestion {
  21. padding: 2px 5px;
  22. white-space: nowrap;
  23. overflow: hidden;
  24. }
  25. .autocomplete-selected {
  26. background: #F0F0F0;
  27. }
  28. .autocomplete-suggestions strong {
  29. font-weight: normal;
  30. color: #3399FF;
  31. }
  32. .autocomplete-group {
  33. padding: 2px 5px;
  34. }
  35. .autocomplete-group strong {
  36. display: block;
  37. border-bottom: 1px solid #000;
  38. }
  39. </style>
  40. <td>:<input type="text" id="nama" name="nama" placeholder="Nama"></td>
  41.  
  42.  
  43. <script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
  44. <script type="text/javascript" src="https://cdn.staticaly.com/gh/devbridge/jQuery-Autocomplete/43b2953a/dist/jquery.autocomplete.min.js"></script>
  45.  
  46.  
  47. <script type="text/javascript">
  48. $(document).ready(function() {
  49. // Data yang ditamilkan pada autocomplete.
  50. var nama = [
  51. <?php
  52. # Variables
  53. $servername = "localhost";
  54. $username = "root";
  55. $password = "";
  56. $dbname = "ppdb3";
  57.  
  58. $connection = mysqli_connect($servername, $username, $password, $dbname);
  59. if (!$connection){
  60. die("Connection Failed:".mysqli_connect_error());
  61. }
  62.  
  63.  
  64. $query = mysqli_query($connection,"SELECT * FROM ip ORDER BY id DESC");
  65.  
  66. if(mysqli_num_rows($query)>0){
  67. while($data = mysqli_fetch_array($query)){
  68.  
  69. ?>
  70. { value: `<?php echo $data["ip"];?>`, data: `<?php echo $data["ip"];?>` },
  71. <?php }}
  72. ?>
  73. ];
  74.  
  75. // Selector input yang akan menampilkan autocomplete.
  76. $( "#nama" ).autocomplete({
  77. lookup: nama
  78. });
  79. })
  80. </script>
  81.  
  82.  
  83.  
  84. </body>
  85. </html>
  86. <!--
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement