PDO执行SQL语句【2】

  try {
    $pdo = new PDO("mysql:host->127.0.0.1;dbname=yangbo","root","");
    $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  }catch(PDOException $e){
    echo "Mysql连接失败".$e->getMessage()."<br />";
    exit;
  }
  echo "mysql连接成功<br />";

  try {
    $pdo->exec("use yangbo");
    $pdo->exec("set names utf8;");
    $pdo->exec("insert into table_1(name,age)values('杨波',25);");
    echo $pdo->lastinsertid();
//    $affecter_row = $pdo->query("select * from table_1 where id<4;");
//    var_dump($affecter_row);
  }catch(PDOException $e){
    echo "异常信息".$e->getMessage();
  }