Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="well">
- <?php
- //MySQL Database Connect
- include '/includes/dbconnect.php';
- $result = mysqli_query($conn,"SELECT * FROM webpilot ORDER BY NEXT_EVENT ASC");
- if(mysqli_num_rows($result) >= 1) {
- echo '<table class="table table-striped table-bordered table-hover">';
- echo "<tr><th>ID</th><th>NAME:</th><th>EPOCH</th></tr>";
- while($row = mysqli_fetch_array($results)) {
- echo "<tr><td>";
- echo $row['ID'];
- echo "</td><td>";
- echo $row['NAME'];
- echo "</td><td>";
- echo $row['NEXT_EVENT'];
- echo "</td></tr>";
- }
- echo "</table>";
- }
- ?>
- </div> <!-- well -->
- <?php
- $localhost="xxx.xx.xxx.com";
- $username="dboxxxxxxx";
- $password="xxxxxx";
- $database="dbxxxxxx";
- $conn = mysqli_connect($localhost,$username,$password,$database);
- //test if connection failed
- if(mysqli_connect_errno()){
- die("connection failed: "
- . mysqli_connect_error()
- . " (" . mysqli_connect_errno()
- . ")");
- }
- ?>
- $result = mysqli_query($conn,"SELECT * FROM webpilot ORDER BY NEXT_EVENT ASC");
- if(mysqli_num_rows($result) >= 1) {
- echo '<table class="table table-striped table-bordered table-hover">';
- echo "<tr><th>ID</th><th>NAME:</th><th>EPOCH</th></tr>";
- //while($row = mysqli_fetch_array($results)) {
- ^^^^^^^^
- while($row = mysqli_fetch_array($result)) {
- ini_set('display_errors', 1);
- ini_set('log_errors',1);
- error_reporting(E_ALL);
- mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); `
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement