function get_all_records(){ $con = getdb(); $Sql = "SELECT * FROM employeeinfo"; $result = mysqli_query($con, $Sql); if (mysqli_num_rows($result) > 0) { echo "
"; while($row = mysqli_fetch_assoc($result)) { echo ""; } echo "
EMP ID First Name Last Name Email Registration Date
" . $row['emp_id']." " . $row['firstname']." " . $row['lastname']." " . $row['email']." " . $row['reg_date']."
"; } else { echo "you have no records"; } }