PDO 연결 및 프로시저 바인딩 예제

<?
$strConn = 'mysql:host='.$host.';dbname='.$maindb.';charset=utf8';
$db = new PDO($strConn, $id, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
 
$db->beginTransaction();
 
$isTransaction = 0;
$company_type = 0;
$bussiness_type = 0;
$str = 'aaa';
$id = -1;
$returnValue = -1;
 
$stmt = $db->prepare("CALL mpx_s_proc_insert_company(?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, @id, @return)");
$stmt->bindParam(1, $isTransaction, PDO::PARAM_INT);
$stmt->bindParam(2, $company_type, PDO::PARAM_INT);
$stmt->bindParam(3, $bussiness_type, PDO::PARAM_INT);
$stmt->bindParam(4, $str, PDO::PARAM_STR);
$stmt->bindParam(5, $str, PDO::PARAM_STR);
$stmt->bindParam(6, $str, PDO::PARAM_STR);
$stmt->bindParam(7, $str, PDO::PARAM_STR);
$stmt->bindParam(8, $str, PDO::PARAM_STR);
$stmt->bindParam(9, $str, PDO::PARAM_STR);
$stmt->bindParam(10, $str, PDO::PARAM_STR);
$stmt->bindParam(11, $str, PDO::PARAM_STR);
$stmt->bindParam(12, $str, PDO::PARAM_STR);
 
$stmt->execute();
print_r($db->query("SELECT @id, @return")->fetchAll());
echo "<br>";
 
$stmt = $db->prepare("CALL mpx_s_proc_insert_company(?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, @id, @return)");
$stmt->bindParam(1, $isTransaction, PDO::PARAM_INT);
$stmt->bindParam(2, $company_type, PDO::PARAM_INT);
$stmt->bindParam(3, $bussiness_type, PDO::PARAM_INT);
$stmt->bindParam(4, $str, PDO::PARAM_STR);
$stmt->bindParam(5, $str, PDO::PARAM_STR);
$stmt->bindParam(6, $str, PDO::PARAM_STR);
$stmt->bindParam(7, $str, PDO::PARAM_STR);
$stmt->bindParam(8, $str, PDO::PARAM_STR);
$stmt->bindParam(9, $str, PDO::PARAM_STR);
$stmt->bindParam(10, $str, PDO::PARAM_STR);
$stmt->bindParam(11, $str, PDO::PARAM_STR);
$stmt->bindParam(12, $str, PDO::PARAM_STR);
 
$stmt->execute();
print_r($db->query("SELECT @id, @return")->fetchAll());
 
$db->commit();
 
$db = null;
?>