Counter Result


“;

$servername = “localhost”;
$username = “surcharg_mexasf2”;
$password = “mexasf2@”;
$dbname = “surcharg_mexasf”;

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

$sql1 = “SELECT * FROM `counters_counts` WHERE `counter_id` = 1”;
$sql2 = “SELECT * FROM `counters_counts` WHERE `counter_id` = 2”;
$sql3 = “SELECT * FROM `counters_counts` WHERE `counter_id` = 3”;
$sql4 = “SELECT * FROM `counters_counts` WHERE `counter_id` = 4″;

$result1 = $conn->query($sql1);
$result2 = $conn->query($sql2);
$result4 = $conn->query($sql4);

echo ”

Counters

“;
echo “Take the pledge (Link #1): ” . $result1->num_rows . ”
“;
echo “Upload your logo (Link #2): ” . $result2->num_rows . ”
“;
echo “Order a free tent card (Link #4): ” . $result4->num_rows . ”
“;

}

?>