$html= '';

 $html=$html.'<form method="post" action ="tokuta_mmain.php">';

 $html=$html.'<table>';

 $html=$html.'<tr>';

 $html=$html.'<th>選択</th>';

 $html=$html.'<th>コード</th>';

 $html=$html.'<th>取引先名</th>';

 $html=$html.'</tr>';

include("mpdf60/mpdf.php");

$mpdf=new mPDF('ja', 'A4');

$mpdf->ignore_invalid_utf8 = true;

$stylesheet = file_get_contents("style.css");

$mpdf->WriteHTML($stylesheet,1);

$mpdf->WriteHTML($html);

$mpdf->Output();

4.バーコードを印字　NE-7とQR

5.改ページ

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']='';
  }
 }