PDO數(shù)據(jù)綁定問(wèn)題

求指教聯(lián)表查詢用PDO怎么綁定。代碼如下：
更正，好像找到了。

try{
        $pdo = new PDO($dns,$user,$pwd);
    /*
    * SELECT t.*,w.USERNAME FROM emper t JOIN emper_account w
                   WHERE t.`EMPID` = w.`EMPID`
                   AND w.`USERNAME` = 'username'
                   AND w.`PASS` = 'password'
    */
/* 舊的sql代碼
        $sqls = "select t.*,w.USERNAME FROM emper t 
                                       JOIN emper_account w 
                                       where t.EMPID = w.EMPID
                                       and w.USERNAME= ".$username." and w.PASS=".$pass.";";
                                       */
    //  新的
$sqls = "select t.*,w.USERNAME FROM emper t 
                                       JOIN emper_account w 
                                       where t.EMPID = w.EMPID
                                       and w.USERNAME= "."'".$username." and w.PASS="."'".$pass."';";
        echo $sqls."<br/>";
        $sql = $pdo->prepare($sqls);
        
        $sql->execute();
        $abmo = $sql->fetchAll(PDO::FETCH_ASSOC);
        
        echo count($abmo);
        
        for($i=0;$i<count($abmo);$i++){
            
            echo $abmo[$i]['empid']."<br />";
        }    
                        
    }catch(Exception $e){    
        echo $e->getMessage()."<br/>";    
    }

//已經(jīng)解決。更改輸出代碼，如下：

for($i=0;$i<count($abmo);$i++){
            
            echo $abmo[$i]['EMPID']."<br />";
            echo $abmo[$i]['EMPNAME']."<br />";
            echo $abmo[$i]['LEADERID']."<br />";
            echo $abmo[$i]['JOBNAME']."<br />";
            echo $abmo[$i]['MBPHONE']."<br />";
            echo $abmo[$i]['USERNAME']."<br />";
        }    

頁(yè)面輸入如下：

果然只有將問(wèn)題拋出來(lái)之后腦子轉(zhuǎn)起來(lái)才快。。。
再次感謝。。