{"id":456,"date":"2012-12-03T05:39:43","date_gmt":"2012-12-03T09:39:43","guid":{"rendered":"http:\/\/www.searchenginegenie.com\/programming-blog\/?p=456"},"modified":"2013-05-13T01:29:56","modified_gmt":"2013-05-13T05:29:56","slug":"tutorial-to-get-values-from-database-on-selection-of-dropdown-in-php","status":"publish","type":"post","link":"https:\/\/www.searchenginegenie.com\/programming-blog\/tutorial-to-get-values-from-database-on-selection-of-dropdown-in-php\/","title":{"rendered":"Tutorial to get values from database on selection of dropdown in PHP"},"content":{"rendered":"

PHP Fetch Tutorial<\/h2>\n

Fetching Data From Database on selection of dropdown value<\/h3>\n

Step 1:\u00a0<\/strong><\/p>\n

Get the list of countries from database and populate in drop-down.<\/p>\n

[php]
\n$ctry_qry = mysql_query(\u201cSELECT * FROM countries ORDER BY name;\u201d);?>
\n\/\/Calling Function
\n<select name="\u201dctry\u201d"> <option value="\u201d&quot;">Select Country<\/option><\/select>
\n<select name="\u201dctry\u201d"><option value="\u201d<?PHP">\u201d><!–?PHP echo $ctry[‘name’]; ?–><\/option><\/select>
\n[\/php]<\/p>\n

Consider that we choose\u00a0 India from the dropdown list.<\/p>\n

\"countries-dropdown-list-values-from-database\"<\/a><\/p>\n

Step:2<\/strong><\/p>\n

<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Add a simple javascript function which will run onchange<\/p>\n

[javascript]
\nfunction reloaddata(ctryid) {
\nwindow.location.href="http:\/\/localhost\/rotatetheglobe\/admin\/try.php?ctryid=" + ctryid;
\n}
\n[\/javascript]<\/p>\n

Step:3<\/strong><\/p>\n

<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Reload the page in JS and pass the currently selected country id<\/p>\n

\"values-fetched-from-db-on-country-selection\"<\/a><\/p>\n

Step:4<\/strong><\/p>\n

Get the country id from query string and fetch the required values from the database<\/p>\n

[php]
\n<?PHP<\/pre>
\n<div><code>if<\/code><code>(isset(<\/code><code>$_REQUEST<\/code><code>[<\/code><code>’ctryid'<\/code><code>])) {<\/code><\/div>
\n<div><code>$ctryinfo_qry<\/code> <code>= mysql_query(<\/code><code>"SELECT * FROM country_info where ctry_root_id=’"<\/code><code>.<\/code><code>$_REQUEST<\/code><code>[‘ctryid<\/code><code>’]."'<\/code> <code>ORDER BY ctry_info_id ;");<\/code><\/div>
\n<div><code>?><\/code><\/div>
\n<pre>[\/php]<\/p>\n

Fetch array is used to fetch the respective row from record set . Using fetch array in while loop is used get a new row of MySQL information until the condition is TRUE.When there are no more rows the function will return FALSE causing the while loop to stop!<\/p>\n

[php]
\n<textarea id="msgpost" name="ctry_about" rows="10" cols="50"> <?php echo $ctry_inf[‘ctry_about’];?><\/textarea>
\n <!–?php } ?–><\/p>\n

[\/php]<\/p>\n

CLICK HERE <\/a>to view the complete output<\/h2>\n

Possible Errors to occur:<\/strong><\/p>\n

    \n
  • JS Error<\/li>\n
  • Couldn’t get the value from the query string<\/li>\n
  • Page not found<\/li>\n<\/ul>\n

    Must Follow
    \n<\/strong><\/p>\n

      \n
    • Make Sure the querystring variable and the $_REQUEST variable is same<\/li>\n<\/ul>\n
        \n
      • Make sure your onchange function is same name as that you call in your code.<\/li>\n<\/ul>\n

        Must know before reading this article<\/strong><\/p>\n

          \n
        • PHP Basics<\/li>\n
        • HTML Basics<\/li>\n
        • DB Handling<\/li>\n<\/ul>\n

          Coming Up:<\/strong><\/p>\n

            \n
          • How to configure a site to work in your local host when you are running windows<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

            PHP Fetch Tutorial Fetching Data From Database on selection of dropdown value Step 1:\u00a0 Get the list of countries from database and populate in drop-down. [php] $ctry_qry = mysql_query(\u201cSELECT * FROM countries ORDER BY name;\u201d);?> \/\/Calling Function <select name="\u201dctry\u201d"> <option value="\u201d&quot;">Select Country<\/option><\/select> <select name="\u201dctry\u201d"><option value="\u201d<?PHP">\u201d><!–?PHP echo $ctry[‘name’]; ?–><\/option><\/select> [\/php] Consider that we choose\u00a0 India from […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":66,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":526,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/456\/revisions\/526"}],"wp:attachment":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}