Hi, I just loaded new os (windows7 proessional) to my machine
along with later version of xampp and when I run php files I get php code
I could use some advice. thanks!
here is the code:
<html><body>
<hr>
<center><b><font size=+2> 515 Certification Expiration Report</font><br>06/22/2020 - 06/22/2021<p>
<hr>
<?php
//Open a new connection to the MySQL server
require_once "hoappsdb-connect.php";
//MySqli Select Query
$results = $mysqli->query (SELECT * FROM waitlist");
echo "<table border=1>";
echo "<th>unit#</th>";
echo "<th>resident name</th>";
echo "<th>movein date</th>";
echo "<th>effect date</th>";
echo "<th>expire date</th>";
echo "<th>days left</th>";
echo "<th colspan=3>recertification notification</th>";
echo "</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['apt'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['moveindate'] . "</td>";
echo "<td>" . $row['effdate'] . "</td>";
echo "<td>" . $row['expdate'] . "</td>";
echo "<td>" . $row['daysleft'] . "</td>";
echo "<td>" . $row['90date'] . "</td>";
echo "<td>" . $row['60date'] . "</td>";
echo "<td>" . $row['30date'] . "</td>";
echo "</tr>";
}
echo "</table>";
// Free result set
mysqli_free_result($result);
} else{
echo "No records matching your query were found.";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
</body></html>
here is the result:
515 Certification Expiration Report
06/22/2020 - 06/22/2021
query (SELECT * FROM waitlist"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
unit# resident name movein date effect date expire date days left recertification notification
" . $row['apt'] . " " . $row['name'] . " " . $row['moveindate'] . " " . $row['effdate'] . " " . $row['expdate'] . " " . $row['daysleft'] . " " . $row['90date'] . " " . $row['60date'] . " " . $row['30date'] . "
"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>
along with later version of xampp and when I run php files I get php code
I could use some advice. thanks!
here is the code:
<html><body>
<hr>
<center><b><font size=+2> 515 Certification Expiration Report</font><br>06/22/2020 - 06/22/2021<p>
<hr>
<?php
//Open a new connection to the MySQL server
require_once "hoappsdb-connect.php";
//MySqli Select Query
$results = $mysqli->query (SELECT * FROM waitlist");
echo "<table border=1>";
echo "<th>unit#</th>";
echo "<th>resident name</th>";
echo "<th>movein date</th>";
echo "<th>effect date</th>";
echo "<th>expire date</th>";
echo "<th>days left</th>";
echo "<th colspan=3>recertification notification</th>";
echo "</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['apt'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['moveindate'] . "</td>";
echo "<td>" . $row['effdate'] . "</td>";
echo "<td>" . $row['expdate'] . "</td>";
echo "<td>" . $row['daysleft'] . "</td>";
echo "<td>" . $row['90date'] . "</td>";
echo "<td>" . $row['60date'] . "</td>";
echo "<td>" . $row['30date'] . "</td>";
echo "</tr>";
}
echo "</table>";
// Free result set
mysqli_free_result($result);
} else{
echo "No records matching your query were found.";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
</body></html>
here is the result:
515 Certification Expiration Report
06/22/2020 - 06/22/2021
query (SELECT * FROM waitlist"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
unit# resident name movein date effect date expire date days left recertification notification
" . $row['apt'] . " " . $row['name'] . " " . $row['moveindate'] . " " . $row['effdate'] . " " . $row['expdate'] . " " . $row['daysleft'] . " " . $row['90date'] . " " . $row['60date'] . " " . $row['30date'] . "
"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>