help with php pdo mysql

[mcolton]

What I want to do is run a query based on user input (fname, lname passed from an html program). If I don't find a record, I want to close the database and run a different htm file
Thanks for any help.

This is a piece of my code:

<?php
$fname = filter_input(INPUT_POST, "fname");
$lname = filter_input(INPUT_POST, "lname");

try    
    {
    $connect = new PDO('mysql:host=localhost;dbname=xxxxxx', "xxxxxx", "xxxxxx");
    echo 'Connected to database<br />';
    $connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "SELECT * FROM contacts WHERE firstname = '$fname' && lastname = '$lname' ";


    $connect = null;        
    }
             
catch(PDOException $e)
     {
     echo 'ERROR: ' . $e->getMessage();
     }
?>