Resources Provincial

CODC has prepared listings of provincial resources for adults with disabilities. You will find organizations that provide information, referral, and/or direct services.

[insert_php]
$servername = “localhost”;
$username = “codc_adm2”;
$password = “8vTA2nBTh6L”;
$dbname = “codc_wp”;

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

$sql = “SELECT *
FROM `codc_resource`
WHERE `r_cat` = 2
ORDER BY `codc_resource`.`r_name` ASC”;

$result = $conn2->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo “” . $row[“r_name”] . “
“;
echo $row[“r_description”] . “
“;
echo “
“;
$r_address = $row[“r_address”];
if ($r_address)
{
echo $row[“r_address”] . ” “;
}
$r_city = $row[“r_city”];
if ($r_city)
{
echo $r_city . ” “;
}
$r_province = $row[“r_province”];
if ($r_province)
{
echo $r_province . ” ” ;
}
$r_postal_code = $row[“r_postal_code”];
if ($r_postal_code)
{
echo $r_postal_code . ” “;
}
if (($r_address) or ($r_city) or ($r_province) or ($r_postal_code))
{
echo “
“;
}
$r_phone = $row[“r_phone”];
if ($r_phone )
{
echo “Phone: ” . $r_phone . “
“;
}
$r_phone_tf = $row[“r_phone_tf”];
if ($r_phone_tf)
{
echo “Phone (Toll Free): ” . $r_phone_tf . “
“;
}
$r_tty_voice = $row[“r_tty_voice”];
if ($r_tty_voice)
{
echo “Phone (Tty-Voice): ” . $r_tty_voice . “
“;
}
$r_voice_tty = $row[“r_voice_tty”];
if ($r_voice_tty)
{
echo “Phone (Voice-Tty): ” . $r_voice_tty . “
“;
}
$r_tty_tty = $row[“r_tty_tty”];
if ($r_tty_tty)
{
echo “Phone (Tty-Tty): ” . $r_tty_tty . “
“;
}
$r_url = $row[“r_url”];
if ($r_url)
{
echo “Website: ” . $r_url . “
“;
}
$r_email = $row[“r_email”];
if ($r_email)
{
echo “eMail: ” . $r_email . “
“;
}
echo “

“;
}
}
else
{
echo “0 results”;
}
$conn2->close();
[/insert_php]

Joining Our Newsletter

Using MailerLite for Newsletter Service