sort2-secondbackup

Bootstrap Example


[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”;

echo var_dump ($page_no);
echo var_dump ($total_records_per_page);
echo var_dump ($offset);
echo var_dump ($previous_page);
echo var_dump ($next_page);
echo var_dump ($adjacents);

echo var_dump ($total_records);
echo var_dump ($total_no_of_pages);
echo var_dump ($second_last);

// 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 “
Page [insert_php] echo $page_no.” of “.$total_no_of_pages;[/insert_php]