Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form action="fullridez.php">
- <h4 id="Filter">GPA</h4>
- <input id="FilterBox" name="gpa" type="text"/>
- <h4 id="Filter">Amount</h4>
- <input id="FilterBox" name="amount" type="text"/>
- <h4 id="Filter">School</h4>
- <input id="FilterBox" name="school" type="text"/>
- <button type="submit" id="FilterBox" onkeypress="checkEnter()" >
- <img src="search.png" width=15 height=15 />
- </button>
- </form>
- <script>
- </script>
- <?php
- $servername = "MariaDB";
- $username = "root@localhost";
- $password = ;
- $database = "scholarshipslist";
- $gpa = $_GET["gpa"];
- $amount = $_GET["amount"];
- $school = $_GET["school"];
- // Create connection
- $conn = new mysqli($servername, $username, $password, $database);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- echo "Connected successfully";
- $count = "SELECT 'id', 'school', 'gpa', 'amount' FROM 'scholarships'";
- $result = $conn->query($count);
- if ($result->num_rows > 0) {
- // output data of each row
- $sql = "SELECT * FROM 'scholarships' WHERE 'gpa' <= '".$gpa."'
- 'amount' <= '".$amount." 'school' == '" .$school."'";
- if (mysqli_query($conn, $sql)); {
- }
- echo $result;
- } else {
- echo "0 results";
- }
- $conn->close();
- <table>
- <tr><td>Col 1</td><td>Col 2</td><td>Col 3</td></tr>
- <?php
- while($row = mysql_fetch_assoc($result))
- {
- echo "<tr><td>"
- . $row['col_1'] . "</td><td>"
- . $row['col_2'] . "</td><td>"
- . $row['col_3'] . "</td></tr>";
- }
- ?>
- </table>
- <?php
- $num_rows = mysql_num_rows($result);
- for ($i=0;$i<$num_rows;$i++) { //loop through all rows of data
- $row = mysql_fetch_assoc($result); // your data is now: $row['fieldName']
- ?>
- <div>
- GPA <input name="" value="<?php echo($row['gpa'])?>;" type="text">
- AMOUNT <input name="" value="<?php echo($row['amount'])?>;" type="text">
- SCHOOL <input name="" value="<?php echo($row['school'])?>;" type="text">
- </div>
- <?php
- } //end of the loop
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement