API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 1st, 2017
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.40 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3.     <title>Thesis Demo Database</title>
  4. </head>
  5. <body>
  6.     <h1 align=center>Soybean Database Search</h1>
  7.     <hr>
  8. <?php
  9.  
  10. require_once('DB.php');
  11.  
  12. $db_host = "herdingcat";
  13. $db_username = "user";
  14. $db_password = "ps";
  15. $db_database = "foobar";
  16.  
  17. $connection = DB::connect("mysql://$db_username:$db_password@$db_host/$db_database");
  18.  
  19. if (DB::isError($connection))
  20. {
  21.   die ("Could not connect to the database: </br>".DB::errorMessage($connection));
  22. }
  23.  
  24. $items[0] = $pt = htmlentities($_GET["pt"]);
  25. $items[1] = $year = htmlentities($_GET["year"]);
  26. $items[2] = $site = htmlentities($_GET["site"]);
  27. $items[3] = $pn = htmlentities($_GET["pn"]);
  28. $items[4] = $line = htmlentities($_GET["line"]);
  29. $items[5] = $rep = htmlentities($_GET["rep"]);
  30. $items[6] = $lsh = htmlentities($_GET["lsh"]);
  31. $items[7] = $fc = htmlentities($_GET["fc"]);
  32. $items[8] = $pc = htmlentities($_GET["pc"]);
  33. $items[9] = $podh = htmlentities($_GET["podh"]);
  34. $items[10] = $plh_start = htmlentities($_GET["plh_start"]);
  35. $items[11] = $plh_end = htmlentities($_GET["plh_end"]);
  36. $items[12] = $nnms_start = htmlentities($_GET["nnms_start"]);
  37. $items[13] = $nnms_end = htmlentities($_GET["nnms_end"]);
  38. $items[14] = $nb_start = htmlentities($_GET["nb_start"]);
  39. $items[15] = $nb_end = htmlentities($_GET["nb_end"]);
  40. $items[16] = $lsl_start = htmlentities($_GET["lsl_start"]);
  41. $items[17] = $lsl_end = htmlentities($_GET["lsl_end"]);
  42. $items[18] = $ll_start = htmlentities($_GET["ll_start"]);
  43. $items[19] = $ll_end = htmlentities($_GET["ll_end"]);
  44. $items[20] = $lw_start = htmlentities($_GET["lw_start"]);
  45. $items[21] = $lw_end = htmlentities($_GET["lw_end"]);
  46. $items[22] = $st_start = htmlentities($_GET["st_start"]);
  47. $items[23] = $st_end = htmlentities($_GET["st_end"]);
  48. $items[24] = $sw_start = htmlentities($_GET["sw_start"]);
  49. $items[25] = $sw_end = htmlentities($_GET["sw_end"]);
  50. $items[26] = $l_start = htmlentities($_GET["l_start"]);
  51. $items[27] = $l_end = htmlentities($_GET["l_end"]);
  52. $items[28] = $podha_start = htmlentities($_GET["podha_start"]);
  53. $items[29] = $podha_end = htmlentities($_GET["podha_end"]);
  54. $items[30] = $n1sp_start = htmlentities($_GET["n1sp_start"]);
  55. $items[31] = $n1sp_end = htmlentities($_GET["n1sp_end"]);
  56. $items[32] = $n2sp_start = htmlentities($_GET["n2sp_start"]);
  57. $items[33] = $n2sp_end = htmlentities($_GET["n2sp_end"]);
  58. $items[34] = $n3sp_start = htmlentities($_GET["n3sp_start"]);
  59. $items[35] = $n3sp_end = htmlentities($_GET["n3sp_end"]);
  60. $items[36] = $n4sp_start = htmlentities($_GET["n4sp_start"]);
  61. $items[37] = $n4sp_end = htmlentities($_GET["n4sp_end"]);
  62. $items[38] = $nppp_start = htmlentities($_GET["nppp_start"]);
  63. $items[39] = $nppp_end = htmlentities($_GET["nppp_end"]);
  64. $items[40] = $s2pl_start = htmlentities($_GET["s2pl_start"]);
  65. $items[41] = $s2pl_end = htmlentities($_GET["s2pl_end"]);
  66. $items[42] = $s2pw_start = htmlentities($_GET["s2pw_start"]);
  67. $items[43] = $s2pw_end = htmlentities($_GET["s2pw_end"]);
  68. $items[44] = $pwpp_start = htmlentities($_GET["pwpp_start"]);
  69. $items[45] = $pwpp_end = htmlentities($_GET["pwpp_end"]);
  70. $items[46] = $swpp_start = htmlentities($_GET["swpp_start"]);
  71. $items[47] = $swpp_end = htmlentities($_GET["swpp_end"]);
  72. $items[48] = $ss_start = htmlentities($_GET["ss_start"]);
  73. $items[49] = $ss_end = htmlentities($_GET["ss_end"]);
  74. $items[50] = $seedl_start = htmlentities($_GET["seedl_start"]);
  75. $items[51] = $seedl_end = htmlentities($_GET["seedl_end"]);
  76. $items[52] = $seedw_start = htmlentities($_GET["seedw_start"]);
  77. $items[53] = $seedw_end = htmlentities($_GET["seedw_end"]);
  78. $items[54] = $pwt_start = htmlentities($_GET["pwt_start"]);
  79. $items[55] = $pwt_end = htmlentities($_GET["pwt_end"]);
  80.  
  81. $colname = array('pt','year','site','pn','line','rep','lsh','fc','pc','podh','plh','nnms','nb','lsl','ll','lw','st','sw','l','podha','n1sp','n2sp','n3sp','n4sp','nppp','s2pl','s2pw','pwpp','swpp','ss','seedl','seedw','pwt');
  82. $match_method = htmlentities($_GET["match_method"]);
  83.  
  84. $self = htmlentities($_SERVER['PHP_SELF']);
  85.  
  86. for($i = 0,$j = 0; $i < count($items); $i++)
  87. {
  88.   if (empty($items[i]))
  89.   {
  90.     $j++;
  91.   }
  92. }
  93.  
  94. if ($j == 56)
  95. {
  96.   echo ('
  97.  <form action="'.$self.'" method="GET">
  98.    <label><br>Population Type <input type="text" name="pt" /></label></br>
  99.    <label><br>Year <input type="text" name="year" /></label></br>
  100.    <label><br>Site <input type="text" name="site" /></label></br>
  101.    <label><br>Planting Number <input type="text" name="pn" /></label></br>
  102.    <label><br>Line <input type="text" name="line" /></label></br>
  103.    <label><br>Repitition <input type="text" name="rep" /></label></br>
  104.    <label><br>Flower Color <input type="text" name="fc" /></label></br>
  105.    <label><br>Pubescence Color <input type="text" name="pc" /></label></br>
  106.    <label><br>Podding Habit <input type="text" name="podh" /></label></br>
  107.    <label><br>Plant Height <input type="text" name="plh_start" /><input type="text" name="plh_end" /></label></br>
  108.    <label><br>Number of Nodes in Main Stem <input type="text" name="nnms_start" /><input type="text" name="nnms_end" /></label></br>
  109.    <label><br>Branches <input type="text" name="nb_start" /><input type="text" name="nb_end" /></label></br>
  110.    <label><br>Leafstalk Length <input type="text" name="lsl_start" /><input type="text" name="lsl_end" /></label></br>
  111.    <label><br>Leaf Length <input type="text" name="ll_start" /><input type="text" name="ll_end" /></label></br>
  112.    <label><br>Leaf Width <input type="text" name="lw_start" /><input type="text" name="lw_end" /></label></br>
  113.    <label><br>Stem Thickness <input type="text" name="st_start" /><input type="text" name="st_end" /></label></br>
  114.    <label><br>Stem Weight <input type="text" name="sw_start" /><input type="text" name="sw_end" /></label></br>
  115.    <label><br>Lodge <input type="text" name="l_start" /><input type="text" name="l_end" /></label></br>
  116.    <label><br>Podding Height <input type="text" name="podha_start" /><input type="text" name="podha_end" /></label></br>
  117.    <label><br>Number of 1-seed Pods <input type="text" name="n1sp_start" /><input type="text" name="n1sp_end" /></label></br>
  118.    <label><br>Number of 2-seed Pods <input type="text" name="n2sp_start" /><input type="text" name="n2sp_end" /></label></br>
  119.    <label><br>Number of 3-seed Pods <input type="text" name="n3sp_start" /><input type="text" name="n3sp_end" /></label></br>
  120.    <label><br>Number of 4-seed Pods <input type="text" name="n4sp_start" /><input type="text" name="n4sp_end" /></label></br>
  121.    <label><br>Number of Pods Per Plant <input type="text" name="nppp_start" /><input type="text" name="nppp_end" /></label></br>
  122.    <label><br>2-seed Pod Length <input type="text" name="s2pl_start" /><input type="text" name="s2pl_end" /></label></br>
  123.    <label><br>2-seed Pod Width <input type="text" name="s2pw_start" /><input type="text" name="s2pw_end" /></label></br>
  124.    <label><br>Pod Weight Per Plant <input type="text" name="pwpp_start" /><input type="text" name="pwpp_end" /></label></br>
  125.    <label><br>Seed Weight Per Plant <input type="text" name="swpp_start" /><input type="text" name="swpp_end" /></label></br>
  126.    <label><br>Seed Size <input type="text" name="ss_start" /><input type="text" name="ss_end" /></label></br>
  127.    <label><br>Seed Length <input type="text" name="seedl_start" /><input type="text" name="seedl_end" /></label></br>
  128.    <label><br>Seed Width <input type="text" name="seedw_start" /><input type="text" name="seedw_end" /></label></br>
  129.    <label><br>Podwall Thickness <input type="text" name="pwt_start" /><input type="text" name="pwt_end" /></label></br>
  130.    Match Method <select name="match_method" size="1"><br>
  131.    <option>Fuzzy -- AND</option>
  132.    <option>Fuzzy -- OR</option>
  133.    </select></br>
  134.    <input type="submit" value="Search" />
  135.    <button type="reset">Reset</button>
  136.  </form>');
  137. }
  138. else
  139. {
  140.   $store = array();
  141.   $colstore = array();
  142.   $data = array();
  143.   $number = array();
  144.   for($i = 0; $i < 9; $i++)
  145.   {
  146.     $value = $items[$i];
  147.     if (!empty($value))
  148.     {
  149.       $colstore[] = $colname[$i];
  150.       $store[] = $items[$i];
  151.     }
  152.   }
  153.   for($i = 10,$j = 0; $i < count($items); $i += 2,$j++)
  154.   {
  155.     $value1 = $items[$i];
  156.     $value2 = $items[$i+1];
  157.     if (!empty($value1) && !empty($value2))
  158.     {
  159.       $colstore[] = $colname[$i-$j];
  160.       $store[] = '$colname[$i-$j] > $items[$i] AND $colname[$i-$j] < $items[$i+1]';
  161.     }
  162.   }
  163.   var_dump($store);
  164.   var_dump($colstore);
  165.   #if ($match_method == 'Fuzzy -- AND')
  166.  #{
  167.    
  168. ?>
  169.  
  170. </body>
  171. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!