Правильный запрос

$sql = 'SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour';
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':colour' => 'red'));

$query = $db_connect->prepare("INSERT INTO `directory` (`id`, `audit`, `name`, 
    `post_address`, `home_phone`) VALUES (NULL, '".$audit."', '".$name."', '".$post_address."', 
    '".$home_phone."')");
    $query->execute();

# безымянные placeholders
$data = array(NULL, 'Audit', 'Name', 'Past Address', 'Home phone');
$query = $db_connect->prepare(INSERT INTO directory (id, audit, name, post_address, home_phone) VALUES (?, ?, ?, ?, ?));
$query->execute($data);

$data = array(NULL, 'Audit', 'Name', 'Past Address', 'Home phone');

$audit

# безымянные placeholders
$data = array(NULL, 'Audit', 'Name', 'Past Address', 'Home phone');
$query = $db_connect->prepare(INSERT INTO directory (id, audit, name, post_address, home_phone) VALUES (?, ?, ?, ?, ?) WHERE id = ?);
$query->execute($data, array($id));

$query->execute( array_merge($data, array($id)) );

$query = $db_connect->prepare("SELECT * FROM `directory` WHERE `id_dir` = ?");
    $query->execute(array($num));
    $search = $query->fetch(PDO::FETCH_ASSOC);
$audit = $search['audit'];
    $name = $search['name'];
    $post_address = $search['post_address'];
$query = $db_connect->prepare("UPDATE `directory` SET `audit` = '".$audit."', `name` = '".$name."', 
        `post_address` = '".$post_address."' WHERE `id_dir` = ? AND `color` = ?");
        $query->execute(array($num, 1));

$name = '....';
echo $name;

echo '....';

$audit = $search['audit'];

$query = $db_connect->prepare("SELECT * FROM `directory` WHERE `id_dir` = ?");
    $query->execute(array($num));
    $search = $query->fetch(PDO::FETCH_ASSOC);
$audit = $search['audit'];
    $name = $search['name'];
    $post_address = $search['post_address'];
$query = $db_connect->prepare("UPDATE `directory` SET `audit` = '".$audit."', `name` = '".$name."', 
        `post_address` = '".$post_address."' WHERE `id_dir` = ? AND `color` = ?");
        $query->execute(array($num, 1));

 $query = $db_connect->prepare("SELECT * FROM `directory` WHERE name LIKE '%".$s."%' 
        OR sex LIKE '%".$s."%' ... LIMIT 200");
    $query->execute()

array($s, $s...$s)

'%".$s."%'