PHPからSQLServer2014

php7 
SQLserver2014

$dbh->query('SET NAMES utf8');は不要

・読み出し
 try
  { 
   $dsn = 'sqlsrv:server=localhost\sql2014;database=your_dab';
   $user='yourid';
   $password='yourpassword';
   $dbh=new PDO($dsn,$user,$password);
   
   $sql = 'select hkbn,cd,na,rna,eymd,pno from co_hinmta where hkbn = 2 and cd =?';
   $stmt = $dbh->prepare($sql);
   $data[] = $code;
   $stmt->execute($data);
     
   $rec=$stmt->fetch(PDO::FETCH_ASSOC); 
   $dbh=null;         
  }
  catch (Exception $e)
  {
   print '障害が発生しております';
   exit(); 
  }
  return $rec;

・追加
  try
  {
  $dsn = 'sqlsrv:server=localhost\sql2014;database=your_dab';
  $user='yourid';
  $password='yourpassword';
  $dbh=new PDO($dsn,$user,$password);

  $sql = 'INSERT INTO co_hinmta (hkbn,cd,na,rna,eymd,pno) VALUES (2,:cd,:na,:rna,:eymd,:pno)';
  $stmt = $dbh->prepare($sql);
  $data = array();
  $data[':cd'] = $_SESSION['cd'];
  $data[':na'] = $_SESSION['na'];
  $data[':rna'] = $_SESSION['rna'];
  $data[':eymd'] = $_SESSION['eymd'];
  $data[':pno'] = $_SESSION['pno'];

  $stmt->execute($data);

  $dbh=null;

  $_SESSION['msg']=$_SESSION['na'].'を追加しました<br/>';

  }
  catch (Exception $e)
  {
   $_SESSION['errmsg'] = '障害が発生しております';
   $_SESSION['msg']='';
  }

・変更

 try
  {
  $dsn = 'sqlsrv:server=localhost\sql2014;database=your_dab';
  $user='yourid';
  $password='yourpassword';
  $dbh=new PDO($dsn,$user,$password);
  $sql = 'UPDATE co_hinmta SET hkbn=2,na=:na,rna=:rna,eymd=:eymd,pno=:pno WHERE cd =:cd';
  $stmt = $dbh->prepare($sql);
  $data = array();
  $data[':na'] = $_SESSION['na'];
  $data[':rna'] = $_SESSION['rna'];
  $data[':eymd'] = $_SESSION['eymd'];
  $data[':pno'] = $_SESSION['pno'];
  $data[':cd'] = $_SESSION['cd'];
  $stmt->execute($data);
  $dbh=null;

  $_SESSION['msg']=$_SESSION['na'].'を変更しました<br/>';

  }
  catch (Exception $e)
  {
   $_SESSION['errmsg'] = '障害が発生しております';
   $_SESSION['msg']='';
  }
 }