Christian

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "pdo_test";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $ctrID = $conn->prepare("SELECT max(ID)+1 FROM customer");

    $sql = "SELECT COUNT(*) FROM customer WHERE FNAME='" . $_POST['FName'] . "';";
    $result = $conn->prepare($sql);
    $result->execute();
    $num_rows = $result->fetchColumn();

    if( !$num_rows ) {
        $sql = "INSERT INTO customer (FName, LName , Address)
        values (".
        "'" . $_POST['FName'] . "',".
        "'" . $_POST['LName'] . "',".
        "'" . $_POST['Address'] . "')";
        // use exec() because no results are returned
        $conn->exec($sql);
        echo "New record created successfully";
    } else {
        echo "Duplicate First Name!";
    }


    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?>