$orderBy = filter_input(INPUT_GET, 'orderBy');
switch ($columnsOrder) {
case "id":
$data = getALLTestData($columnsOrder, $orderBy);
case "corp":
$data = getALLTestData($columnsOrder, $orderBy);
case "incorp_dt":
$data = getALLTestData($columnsOrder, $orderBy);
case "email":
$data = getALLTestData($columnsOrder, $orderBy);
case "owner":
$data = getALLTestData($columnsOrder, $orderBy);
case "zipcode":
$data = getALLTestData($columnsOrder, $orderBy);
case "phone":
$data = getALLTestData($columnsOrder, $orderBy);
?>
<table class="table">
<thead>
</thead>
<?php
foreach ($data as $row) {
?>
<!-- table of results -->
<tr>
<td><?php
echo $row['id'];
?>
</td>
<td><?php
$stmt = $db->prepare("SELECT * FROM corps");
}
if ($stmt && $stmt->execute($org)) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
?>
<!-- table -->
<center>
<br/><br/>
<?php
if ($action === 'View All') {
$searchby = filter_input(INPUT_POST, 'searchby');
$orderBy = filter_input(INPUT_POST, 'orderBy');
$oresults = getALLTestData($searchby, $orderBy);
}
?>
<!--Header Image-->
<img src="image/AC3.png" alt="AC" height="100" width="500">
</center>
<br/>
<table class="table table-striped">
<thead>
<th>Atlas Corporations:</th>
<th>Date:</th>
<th>E-mail:</th>
<th>Zip code:</th>
<th>Owner:</th>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href="css/bootstrap.css">
<title></title>
</head>
<body>
<?php
//connecting to the database connection file
include 'includes/dbConn.php';
include 'includes/dbData.php';
include 'index.php';
$results = getALLTestData($columnsOrder, $orderBy);
?>
<center>
<br />
<!-- Navigation -->
<button class="btn btn-default" onClick="location.href='create.php'">Add New</button>
<button class="btn btn-default" onclick="window.location.href='index.php'">Back</button>
<!--table to display the company names-->
<table class="table">
<thead>
</thead>
<?php
foreach ($results as $row) {
?>
