Guest User

Untitled

a guest
Mar 22nd, 2018
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. <div class="center" align="center" id="mydiv">Enter Search terms
  2. here: </div>
  3. <form align="center" style="width: 1000px; margin: 0px auto;"
  4. action="trial32_multi_search_simple_working.php" method="GET"
  5. name="form_filter">
  6. <b></b><br>
  7.  
  8. <input type="text" name="search" placeholder='Enter text here...'
  9. size='50'><br><br><br>
  10. <input type="submit" value="Search"> <br><br>
  11.  
  12. <?php
  13. $db_host = 'localhost'; // Server Name
  14. $db_user = 'user'; // Username
  15. $db_pass = 'password'; // Password
  16. $db_name = 'database'; // Database Name
  17.  
  18. $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
  19.  
  20. // Check connection
  21. if (!$conn) {
  22. die ('Failed to connect to MySQL: ' . mysqli_connect_error());
  23. }
  24.  
  25. $alt_table = "ALTER TABLE AllData ADD FULLTEXT(GeneIDs,
  26. AlternateGeneNames, Stressors, Title, Authors, PubYear, Methods,
  27. SequenceType, Species, Comments)";
  28.  
  29. $query = "Select * from AllData WHERE MATCH (GeneIDs,
  30. AlternateGeneNames, Stressors, Title, Authors, PubYear, Methods,
  31. SequenceType, Species, Comments) AGAINST
  32. ('DM03567_Dapma7bEVm000474t1 DM00899_Dapma7bEVm002503t1
  33. NCBI_GNO_996014')";
  34.  
  35. $sql = mysqli_query($conn, $query);
  36.  
  37. if (!$sql) {
  38. die ('SQL Error: ' . mysqli_error($conn));
  39. }
  40.  
  41. while ($row = mysqli_fetch_array($sql)) {
  42. echo $row['GeneIDs'] . ' ' . $row['AlternateGeneNames']. ' ' .
  43. $row['Stressors'].' ' . $row['Title']. ' ' . $row['Authors'].' '
  44. . $row['PubYear'].' ' . $row['Methods'].' ' .
  45. $row['SequenceType'].' ' . $row['Species'].' ' .
  46. $row['Comments'].'<br />';
  47. }
  48.  
  49. ?>
Add Comment
Please, Sign In to add comment