Peoples Gospel Church

260 Reading History: Mark

[hide for=”!logged”]

Legend: ✓ = Already Read ✕ = Not Yet Read &#10687 = Record as Read

Please click the Chapter link to read the content.

[insert_php]
global $current_user;
get_currentuserinfo();

$servername = "mysql.peoplesgospelchurch.org";
$username = "pgcmysql";
$password = "Pr@yerW0rks!2020";
$dbname = "pgc260";
$count = "0";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM Mark WHERE user_login = '$current_user->user_login'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {

if ($row["CH001"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH001 ⦿

";
if ($row["CH002"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH002 ⦿

";
if ($row["CH003"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH003 ⦿

";
if ($row["CH004"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH004 ⦿

";
if ($row["CH005"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH005 ⦿

";
if ($row["CH006"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH006 ⦿

";
if ($row["CH007"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH007 ⦿

";
if ($row["CH008"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH008 ⦿

";
if ($row["CH009"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH009 ⦿

";
if ($row["CH010"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH010 ⦿

";
if ($row["CH011"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH011 ⦿

";
if ($row["CH012"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH012 ⦿

";
if ($row["CH013"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH013 ⦿

";
if ($row["CH014"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH014 ⦿

";
if ($row["CH015"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH015 ⦿

";
if ($row["CH016"] == 1) { echo "

✓ "; $count = $count+1; } else { echo "

✕ "; } echo "CH016 ⦿

";

echo "

";
echo "

Total Read Count: " . $count . "/16

";
}
} else {

echo "

Total Read Count: 0/16

";
echo "You have not read any Chapter in this book. Please start from the beginning：

";
echo "✕ CH001
" ;

}
$conn->close();

[/insert_php]

[/hide]
[hide for="logged"]

Please register/login first and then press the Tracking button again.

You must be logged in to use the 260 Reading Tracker feature. If you do not have an account, please register one at the PGC Member Area.

[wplfta_login_form]

Register | Reset Password
[/hide]

February 15, 2018

admin

Leave a Reply

You must be logged in to post a comment.