sort2

[insert_php]
$servername = ‘localhost’;
$username = ‘i3141100_wp2’;
$password = ‘I.YLB7jy7H9JwGZ199H12’;
//$dbname = localhost;
$dbname = ‘i3141100_wp2’;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error)
{
die(“Connection failed: ” . $conn->connect_error);
}
else
{

global $wpdb;
if (isset($_GET[‘page_no’]) && $_GET[‘page_no’]!=””) {
$page_no = $_GET[‘page_no’];
} else {
$page_no = 1;
}

//set # of records to be displayed
$total_records_per_page = 100;

//get the count of records and number of pages
$total_records = $wpdb->get_var(“SELECT COUNT(*) FROM cbraepeople “);
$total_no_of_pages = ceil($total_records / $total_records_per_page);
// total pages minus 1
$second_last = $total_no_of_pages – 1;

//set some other variables
$offset = ($page_no-1) * $total_records_per_page;
$previous_page = $page_no – 1;
$next_page = $page_no + 1;
$adjacents = “2”;

// Get the result…
$resultsA = $wpdb->get_results (“SELECT fname, lname, lastyr,currstat
FROM cbraepeople LIMIT $offset, $total_records_per_page”, ARRAY_A);

}
$i=0;
foreach ($resultsA as $row)
{
echo “

“;
echo “

“;

echo “

“;

echo “

“;

echo “

“;
echo “

“;
$i++;
}

[/insert_php]

First Name	Last Name	Last Year Attended	Current Status For Event
“; echo “$row[fname]”; echo “	“; echo “$row[lname]”; echo “	“; echo “$row[lastyr]”; echo “	“; echo “$row[currstat]”; echo “

• 
  1){
  echo “href=’?page_no=$previous_page'”;
  }
  [/insert_php]
  >Previous

  [insert_php]
  if ($total_no_of_pages <= 25) { for ($counter = 1; $counter <= $total_no_of_pages; $counter++) { if ($counter == $page_no) { echo "

“;
}

else {
echo “

• $counter

“;
}
}
}
[/insert_php]

• = $total_no_of_pages){
  echo “class=’disabled'”;
  }
  [/insert_php]
  >
  Next

[insert_php]
if($page_no < $total_no_of_pages){ echo "

• Last ››

“;
}
[/insert_php]