如何在where子句中添加另一列

Question

I am having issue trying to figure out how to add another column to my where clause not sure how to do it. I need it to have FIRSTNAME and LASTNAME since the existing database has two columns.

   <?php



    header('Content-Type: application/json');


    try {

    $dbName = "C:\\inetpub\\wwwroot\\fpdb\\staffing.mdb";
     $db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)};charset=UTF-8; DBQ=$dbName; Uid=; Pwd=;");

    }
    catch (PDOException $e) {
      echo $e->getMessage();
    }
    $Employee_Name=  trim($_POST["Employee_Name"]);       
            $params = array( ':FIRSTNAME' => $Employee_Name);

    $query = $db->prepare("
        SELECT * FROM tbl_USERS
        WHERE FIRSTNAME=:FIRSTNAME");

    $query->execute($params);

    $result = $query->fetch(PDO::FETCH_ASSOC);
    $EMPLOYEE_NUMBER=trim('EMPLOYEE_NUMBER');
    $rc= $result[$EMPLOYEE_NUMBER];

    echo json_encode ($rc);

?>

Answer 1

$Employee_Name=  trim($_POST["Employee_Name"]);       
        $params = array( ':FIRSTNAME' => $Employee_Name, ':LASTNAME'=>$Employee_Lastname );

$query = $db->prepare("
    SELECT * FROM tbl_USERS
    WHERE FIRSTNAME=:FIRSTNAME and LASTNAME=:LASTNAME");

I'm guessing the column names above but generally the right idea