Basic PDO Connection & Insert Example

<?php

    $options    =    array(
                     PDO::ATTR_EMULATE_PREPARES    =>    false,
                     PDO::ATTR_ERRMODE             =>    PDO::ERRMODE_EXCEPTION
                     );

    $db         =    new PDO( 'mysql:host=HOSTNAME;dbname=DBNAME;charset=utf8', 'DBUSERNAME', 'DBPASSWORD', $options );

    $username   =    $_POST['username'];
    $password   =    $_POST['password'];
    $emailaddr  =    $_POST['emailaddr'];

    $stmt = $db->prepare("
        INSERT INTO table( field1, field2, field3, field4, field5 )
        VALUES( :field1, :field2, :field3, :field4, :field5 )
        ");

    $stmt->execute( array(
        ':field1' => $field1, ':field2' => $field2, ':field3' => $field3, ':field4' => $field4, ':field5' => $field5
        ) );

    $affected_rows = $stmt->rowCount();