Guest User

Untitled

a guest
Jul 28th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.99 KB | None | 0 0
  1. <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  2. <script type="text/javascript">
  3. $('#idcat').change(function(){
  4. var val = $(this).val();
  5. $('#idcat2').html('');
  6. $.ajax({
  7. type: 'POST',
  8. url: 'templates/megawebshop/html/com_virtuemart/category/show.php',
  9. data: {'model': val, 'url': val},
  10. success: function(data) {
  11. var obj = JSON.parse(data);
  12. obj.forEach(function(item) {
  13. $('#idcat2').append($("<option></option>").attr("value",item).text(item));
  14. })
  15. }
  16. });
  17. });
  18. $('#idcat2').change(function(){
  19. var val = $(this).val();
  20. $('#redirect').attr("value", $url)
  21. });
  22. </script>
  23. <input id="redirect" type="submit" name="submit" value="Кнопка" />
  24.  
  25. // файл show.php
  26.  
  27. $MODEL = $_POST['model'];
  28. $URL = $_POST['url'];
  29.  
  30.  
  31. if (isset($MODEL) && !empty($MODEL)) {
  32.  
  33. $query = "SELECT model FROM filtr_db WHERE marka='$MODEL'";
  34. $DB = mysql_query($query);
  35. // Обработаем
  36. $JSON = array();
  37. while ($row = mysql_fetch_assoc($DB)) {
  38. $JSON[] = $row['model'];
  39. }
  40.  
  41. // Выводим
  42. echo json_encode($JSON);
  43. } else {
  44. echo '[]';
  45. };
  46.  
  47. if (isset($URL) && !empty($URL)) {
  48. $query = "SELECT url FROM filtr_db WHERE model='$URL'";
  49. $DB = mysql_query($query);
  50. $url = array();
  51. while ($row=mysql_fetch_assoc($DB))
  52. {
  53. $url = $row['url'];
  54.  
  55. }
  56. }
  57.  
  58. $hostname = "localhost";
  59. $username = "root";
  60. $password = "";
  61. $dbName = "";
  62.  
  63.  
  64. mysql_connect($hostname, $username, $password) or die ("Не могу создать соединение");
  65. mysql_query('SET NAMES utf8') or header('Location: Error');
  66.  
  67. mysql_select_db($dbName) or die (mysql_error());
  68.  
  69.  
  70. $MODEL = $_POST['model'];
  71.  
  72.  
  73. if (isset($MODEL) && !empty($MODEL)) {
  74. $query = "SELECT model, url FROM filtr_db WHERE marka='$MODEL'";
  75. $DB = mysql_query($query);
  76. $JSON = array();
  77. while ($row = mysql_fetch_assoc($DB)) {
  78. $JSON[$row['model']] = $row['url'];
  79. }
  80.  
  81. echo json_encode($JSON);
  82. } else {
  83. echo '[]';
  84. }
  85.  
  86. success: function(data) {
  87. var obj = JSON.parse(data);
  88. $.each(obj, function( index, value ) {
  89. $('#idcat2').append($("<option></option>").attr("value",index).text(value));
  90. });
  91. }
  92.  
  93. <script type="text/javascript">
  94. $('#idcat2').change(function(){
  95. var val = $(this).val();
  96. window.location.href = val;
  97. });
  98. </script>
Add Comment
Please, Sign In to add comment