{"id":34050,"date":"2023-02-21T01:55:24","date_gmt":"2023-02-20T20:25:24","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/"},"modified":"2023-02-21T01:55:24","modified_gmt":"2023-02-20T20:25:24","slug":"solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/","title":{"rendered":"[Solved] Want to get drop down value on php sql query without page refresh"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-56491272\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"56491272\" data-parentid=\"56489028\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Use <strong>ajax<\/strong> <\/p>\n<pre><code>$.ajax({\n    url: \"fetchlist.php\",\n    dataType: 'json',\n    success: function(response){\n        \/\/ Here, you may bind response with your select HTML\n    }\n});\n<\/code><\/pre>\n<p>You may either return json from your php file and create DOM elements in response. Or, you may create HTML version and return as response. Suggestion will be to use <code>JSON<\/code> for better flexibility.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Want to get drop down value on php sql query without page refresh <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Use ajax $.ajax({ url: &#8220;fetchlist.php&#8221;, dataType: &#8216;json&#8217;, success: function(response){ \/\/ Here, you may bind response with your select HTML } }); You may either return json from your php file and create DOM elements in response. Or, you may create HTML version and return as response. Suggestion will be to use JSON for better &#8230; <a title=\"[Solved] Want to get drop down value on php sql query without page refresh\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\" aria-label=\"More on [Solved] Want to get drop down value on php sql query without page refresh\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[388,339,341],"class_list":["post-34050","post","type-post","status-publish","format-standard","hentry","category-solved","tag-jquery","tag-php","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Want to get drop down value on php sql query without page refresh - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Want to get drop down value on php sql query without page refresh - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Use ajax $.ajax({ url: &quot;fetchlist.php&quot;, dataType: &#039;json&#039;, success: function(response){ \/\/ Here, you may bind response with your select HTML } }); You may either return json from your php file and create DOM elements in response. Or, you may create HTML version and return as response. Suggestion will be to use JSON for better ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-20T20:25:24+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Want to get drop down value on php sql query without page refresh\",\"datePublished\":\"2023-02-20T20:25:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\"},\"wordCount\":65,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"jquery\",\"php\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\",\"name\":\"[Solved] Want to get drop down value on php sql query without page refresh - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-02-20T20:25:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Want to get drop down value on php sql query without page refresh\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Want to get drop down value on php sql query without page refresh - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Want to get drop down value on php sql query without page refresh - JassWeb","og_description":"[ad_1] Use ajax $.ajax({ url: \"fetchlist.php\", dataType: 'json', success: function(response){ \/\/ Here, you may bind response with your select HTML } }); You may either return json from your php file and create DOM elements in response. Or, you may create HTML version and return as response. Suggestion will be to use JSON for better ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/","og_site_name":"JassWeb","article_published_time":"2023-02-20T20:25:24+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Want to get drop down value on php sql query without page refresh","datePublished":"2023-02-20T20:25:24+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/"},"wordCount":65,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["jquery","php","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/","url":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/","name":"[Solved] Want to get drop down value on php sql query without page refresh - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-02-20T20:25:24+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-want-to-get-drop-down-value-on-php-sql-query-without-page-refresh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Want to get drop down value on php sql query without page refresh"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/34050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=34050"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/34050\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=34050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=34050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=34050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}