1. PHP
  2. Load Data From Database Via ComboBox and Display in Input Box

Load Data From Database Via ComboBox and Display in Input Box

Submitted by vandita pandit on Friday, June 14, 2013 - 17:57.
Language
PHP
This is a simple application for beginners that loads data from database via combo-box and displays respective data in input box. Sample code:
  1. <html>
  2. <head>
  3. <script>
  4. function showgrains(str)
  5. {
  6. if (str=="")
  7.   {
  8.   document.getElementById("txtHint").innerHTML="";//txtHint is an event handler
  9.   return;
  10.   }
  11. if (window.XMLHttpRequest)  //XMLHttp request object is created and we are checking whether ajax works in diffrent browsers..i.e we are checking browser compatibity
  12.   {// code for IE7+, Firefox, Chrome, Opera, Safari
  13.   xmlhttp=new XMLHttpRequest();
  14.   }
  15. else
  16.   {// code for IE6, IE5
  17.   xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  18.   }
  19. xmlhttp.onreadystatechange=function()//xmlhttprequest object is configured
  20.   {
  21.   if (xmlhttp.readyState==4 && xmlhttp.status==200)//asyncronous request to web server
  22.     {
  23.     document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
  24.     }
  25.   }
  26. xmlhttp.open("GET","getgrainsinfo.php?q="+str,true);
  27. xmlhttp.send();
  28. }
  29. </script>
  30. </head>
  31. <body>
  32.  
  33. <form>
  34. <select name="grains" onChange="showgrains(this.value)">
  35. <option value="">Select a grain:</option>
  36. <option value="cotton">cotton</option>
  37. <option value="cumin">cumin</option>
  38. <option value="flowers">flowers</option>
  39. <option value="turmeric">turmeric</option>
  40. <option value="cashewnut">cashewnut</option>
  41. </select>
  42. </form>
  43. <br>
  44. <div id="txtHint"><b>grains info will be listed here.</b></div>
  45.  
  46.  
  47. </body>
  48. </html>

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Tags
simple database applcation which loads data from database via combo box and displays in input box

Add new comment

About text formats
  • 124 views