<?php
    $localhost ="localhost";
    $username = "root";
    $password = "";
    $dbname = "sbnhs";
        try {
            $db = new PDO("mysql:host=$localhost;dbname:$dbname", $username, $password);
            $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            // echo "Success";
            $x = 0128;
            $sql = $db->prepare("SELECT * FROM $dbname.refcitymun WHERE provCode = :provcode");
            $sql->bindValue(':provcode', $x);
                if($sql->execute()) {
                    while($result = $sql->fetch()){
                    $desc = $result['citymunDesc'];
                    echo $desc;
                    }
                }else {
                    echo 'Query Error';
                }
        }catch (PDOException $e) {
            print 'Error: ' . $e->getMessage() . '</br>';
            die();
        }

    ?>

<?php
$localhost ="localhost";
$username = "root";
$password = "";
$dbname = "sbnhs";
    try {
        $db = new PDO("mysql:host=$localhost;dbname:$dbname", $username, $password);
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        // echo "Success";
        // $x = 0128;
        $sql = $db->prepare("SELECT * FROM $dbname.refcitymun WHERE provCode = 0128");
        // $sql->bindValue(':provcode', $x);
            if($sql->execute()) {
                while($result = $sql->fetch()){
                $desc = $result['citymunDesc'];
                echo $desc;
                }
            }else {
                echo 'Query Error';
            }
    }catch (PDOException $e) {
        print 'Error: ' . $e->getMessage() . '</br>';
        die();
    }

?>