PDO insert 정리

<?php

$dbh = new PDO('mysql:host=localhost;dbname=test', 'userId', 'password', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

/*

$connect = mysql_connect("localhost","test","password") or die("not bad");

$dbconn = mysql_select_db("homesi",$connect);

*/

$stmt = $dbh->prepare("INSERT INTO mans (userId, userName, userPassword, userCellphone, userTelephone, userEmail, userAddress, userMemo, userLevel, registDay) VALUES (:userId, :userName, :userPassword, :userCellphone, :userTelephone, :userEmail, :userAddress, :userMemo, 1, now())");

$stmt->bindParam(':userId',$userId);

$stmt->bindParam(':userName',$userName);

$stmt->bindParam(':userPassword',$userPassword);

$stmt->bindParam(':userCellphone',$userCellphone);

$stmt->bindParam(':userTelephone',$userTelephone);

$stmt->bindParam(':userEmail',$userEmail);

$stmt->bindParam(':userAddress',$userAddress);

$stmt->bindParam(':userMemo',$userMemo);

$userId = $_POST['userId'];

$userName = $_POST['userName'];

$userPassword = $_POST['userPassword'];

$userCellphone = $_POST['userCellphone'];

$userTelephone = $_POST['userTelephone'];

$userEmail = $_POST['userEmail'];

$userAddress = $_POST['userAddress'];

$userMemo = $_POST['userMemo'];

$stmt->execute();

//header("Location: list.php");

    /*

$userId = $_POST['userId'];

$userName = $_POST['userName'];

$userPassword = $_POST['userPassword'];

$userCellphone = $_POST['userCellphone'];

$userTelephone = $_POST['userTelephone'];

$userEmail = $_POST['userEmail'];

$userAddress = $_POST['userAddress'];

$userMemo = $_POST['userMemo'];

$SQL="insert into mans (userId, userName, userPassword, userCellphone, userTelephone, userEmail, userAddress, userMemo, userLevel, registDay)";

$SQL.="values ('$userId', '$userName', '$userPassword', '$userCellphone', '$userTelephone', '$userEmail', '$userAddress', '$userMemo', 1, now())";

mysql_query($SQL,$connect);

echo $SQL;

*/

echo $_POST['userId']."<br />";

echo $_POST['userName']."<br />";

echo $_POST['userPassword']."<br />";

echo $_POST['userCellphone']."<br />";

echo $_POST['userTelephone']."<br />";

echo $_POST['userEmail']."<br />";

echo $_POST['userAddress']."<br />";

echo $_POST['userMemo']."<br />";

?>