fork download
copy 
  1. <?php 
  2.  
  3. 	error_reporting(0);
  4. 	header("Content-type: text/html; charset=utf-8");
  5. 	include 'sqlConnect.php';
  6.  
  7. 	$search = $_POST['search_fraza'];
  8. 	$formId = $_POST['form_id'];
  9. 	$search = addslashes($search);
  10. 	$search = htmlspecialchars($search);
  11. 	$search = stripslashes($search);
  12. 	if($search == ''){
  13. 		exit("Начните вводить запрос");
  14. 	}
  15.  
  16. 	mysqli_query($sqlConnect, 'SET NAMES utf8');
  17. 	$query = mysqli_query($sqlConnect, "SELECT * FROM collections WHERE collection_name LIKE '%". $search ."%'");
  18. 	if(mysqli_num_rows($query) > 0){
  19. 		$sql = mysqli_fetch_array($query);
  20. 		do{
  21. 			echo "<a href='#' class='confirm' onClick=\"document.getElementById('$formId').value='$sql[collection_name]'; document.getElementById('resSearch$formId').innerHTML = '';\">$sql[collection_name]</a><br>";
  22. 		}while($sql = mysqli_fetch_array($query));
  23. 	}else{
  24. 	   echo "<div>Нет результатов</div>";
  25. 	}
  26.  
  27. ?>      	
  28.  
  29.  
  30.  
  31. <!DOCTYPE html>
  32. <html>
  33. <head>
  34. 	<title>Поиск</title>
  35. 	<meta charset="utf-8">
  36. <script type="text/javascript" src="js/jquery-1.5.1.min.js"></script>
  37. <script>
  38. 	$(document).ready(function(){
  39. 		var i = 1;
  40. 		$('#add').click(function() {
  41. 			$('<div class=field>Нуменклатура ' + i +': <input name="search" type="text" class="search" id="'+i+'"><div id="resSearch'+i+'">Начните вводить запрос</div></div>').fadeIn(100).appendTo('#inputs');
  42. 			i++;
  43. 			if (i != 1) {
  44. 				$('#remove').css("visibility", "visible");
  45. 			}
  46. 		});
  47.  
  48. 		$('#remove').click(function() {
  49. 		if(i > 1) {
  50. 			$('.field:last').remove();
  51. 			$('.imgNumber:last').remove();
  52. 			console.log(i);
  53. 			i--; 
  54. 			if (i == 1) {
  55. 				$('#remove').css("visibility", "hidden");
  56. 			}
  57. 		}
  58. 		});
  59. 	});
  60. </script>
  61. <script type="text/javascript">
  62. 	$(function() {
  63. 		$(".search").keyup(function(){
  64. 			var search = $(this).val();
  65. 			var formId = this.id;
  66. 			//alert(".resSearch"+formId);
  67.  
  68. 			$.ajax({
  69. 				type: "POST",
  70. 				url: "search.php",
  71. 				data: {"search_fraza": search, "form_id": formId},
  72. 				cache: false,						
  73. 				success: function(response){
  74. 					$("#resSearch"+formId).html(response);
  75. 				}
  76. 			});
  77. 			return false;
  78.  
  79. 		});
  80. 	});
  81. </script>
  82. </head>
  83. <body>
  84. 	<form action="search.php" method="post" name="form" onsubmit="return false;">
  85. 		<a href='#' id='add' style='border-bottom: 1px dashed #808080;'>Добавить картинку</a><a href='#' id='remove' style='visibility: hidden; border-bottom: 1px dashed #808080'> | Удалить последнее</a>
  86. 		<div id="inputs">
  87.  
  88. 		</div>
  89. 		<!--Живой поиск 1:<br> 
  90. 		<input name="search" type="text" class="search" id="1">
  91. 		<div id='resSearch1'>Начните вводить запрос</div>
  92.  
  93. 		<br><br><br><br>
  94.  
  95. 		Живой поиск 2:<br> 
  96. 		<input name="search" type="text" class="search" id="2">
  97. 		<div id='resSearch2'>Начните вводить запрос</div>
  98.  
  99. 		<input name="search" type="text" id="search">
  100. 		<small>Вводите на английском языке</small>-->
  101. 	</form>
  102. </body>
  103. </html>
Success #stdin #stdout 0.03s 52480KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Начните вводить запрос
https://ideone.com/0BFzHr
language:
PHP (php 7.3.5)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!