Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="center" align="center" id="mydiv">Enter Search terms
- here: </div>
- <form align="center" style="width: 1000px; margin: 0px auto;"
- action="trial32_multi_search_simple_working.php" method="GET"
- name="form_filter">
- <b></b><br>
- <input type="text" name="search" placeholder='Enter text here...'
- size='50'><br><br><br>
- <input type="submit" value="Search"> <br><br>
- <?php
- $db_host = 'localhost'; // Server Name
- $db_user = 'user'; // Username
- $db_pass = 'password'; // Password
- $db_name = 'database'; // Database Name
- $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
- // Check connection
- if (!$conn) {
- die ('Failed to connect to MySQL: ' . mysqli_connect_error());
- }
- $alt_table = "ALTER TABLE AllData ADD FULLTEXT(GeneIDs,
- AlternateGeneNames, Stressors, Title, Authors, PubYear, Methods,
- SequenceType, Species, Comments)";
- $query = "Select * from AllData WHERE MATCH (GeneIDs,
- AlternateGeneNames, Stressors, Title, Authors, PubYear, Methods,
- SequenceType, Species, Comments) AGAINST
- ('DM03567_Dapma7bEVm000474t1 DM00899_Dapma7bEVm002503t1
- NCBI_GNO_996014')";
- $sql = mysqli_query($conn, $query);
- if (!$sql) {
- die ('SQL Error: ' . mysqli_error($conn));
- }
- while ($row = mysqli_fetch_array($sql)) {
- echo $row['GeneIDs'] . ' ' . $row['AlternateGeneNames']. ' ' .
- $row['Stressors'].' ' . $row['Title']. ' ' . $row['Authors'].' '
- . $row['PubYear'].' ' . $row['Methods'].' ' .
- $row['SequenceType'].' ' . $row['Species'].' ' .
- $row['Comments'].'<br />';
- }
- ?>
Add Comment
Please, Sign In to add comment