M("lk_employeeInfo","Null/表前缀","sqlsrv://账号:密码@服务器:端口/数据库")->query("select * from lk_employeeinfo where state = 'onJob'");

try{

    $db = sqlsrv_connect('服务器',array("UID"=>'账号', "PWD"=>'密码', "Database"=>"数据库"));

}catch(PDOException $e){

    echo "ERROR:".$e->getMessage();

}

$a = sqlsrv_query($db,"select * from lk_employeeinfo where state = 'onJob'");

while( $row = sqlsrv_fetch_array( $a, SQLSRV_FETCH_ASSOC) ) {

      echo $rew['roleid'];

}