PDO预处理【数据库先编译再传值执行】

<style type="text/css">
  .form {
    box-shadow:10px 10px 5px #000;
    position: absolute;
    top:3%;
    left:86%;
    width:195px;
    height:300px;
    border:1px solid #888;
    padding-left:10px;
    padding-right:10px;
    /*position: relative;*/
    /*text-align: center;*/
  }
  .form form {
    position: absolute;
    top:10%;
    left:5%;


  }
  .form form p.password {
    margin-top:25px;
  }
  .form form p.tips {
    margin-top:25px;
    font-size: 12px;
    opacity: 0.5;
  }
  .form form p.tips a {
    opacity: 0.5;
    color:#000;

  }
  .form form p.tips a:hover {
    text-decoration: none;
    opacity: 1;
  }
  .form .submit {
    background-color: #000;
    color:#fff;
    border:none;
    width:30%;
    height:25px;
    margin:0 auto;
    margin-left:105px;
    margin-top:20px;
  }
</style>

<div class="container-fluid">
  <div class="container">
    <div class="form">
      <form method="post" action="#">
        <p class="name-p">name</p>
        <input class="name-input" type="text" placeholder="your name , please..." name="name" />
        <p class="password">password</p>
        <input class="password-input" type="password" name="password" placeholder="your password" />
        <p class="tips"><a href="#">if you forget your password click here,please</a></p>
        <input class="submit" type="submit" value="sign-up" />
      </form>
    </div>
  </div>
</div>

$name = $_POST['name'];
  $money = $_POST['password'];
  try {
    $pdo = new PDO("mysql:host->127.0.0.1;dbname=yangbo","root","");
//    设置错误.使用模式为异常模式
    $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
//    设置PDO的sql语句不自动提交，关闭自动提交
//    $pdo->setAttribute(PDO::ATTR_AUTOCOMMIT,0);
  }catch(PDOException $e){
    echo "Mysql连接失败".$e->getMessage()."<br />";
    exit;
  }
  echo "mysql连接成功<br />";
  try {
    $pdo->exec("use yangbo");
    $stmt = $pdo->prepare("insert into table_3 (name,money)values(?,?)");
    var_dump($stmt);
    $stmt->bindParam(1,$name);
    $stmt->bindParam(2,$money);
    $stmt->execute();
  }catch(PDOException $e){
    echo "错误提示".$e."<br />";
  }