･｢･ﾗ･�ｱ｡ｼ･ｷ･逾筅ﾇ｡｢･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋ｡ﾖﾂ遉ｭ､ﾊ｡ﾗ･ﾇ｡ｼ･ｿ､ﾊﾇｼ､ｹ､� ﾉｬﾍﾗ､ｶ､ｸ､�ｳ､ﾈ､ｬ､｢､�ｫ､筅ｷ､�ﾞ､ｻ､｣｡ﾖﾂ遉ｭ､ﾊ｡ﾗ､ﾈ､ﾏ｡｢ｰ�ﾌﾅｪ､ﾋ､ﾏ ｡ﾖ4kb ﾄﾙｰﾊｾ蝪ﾗ､ﾘ､ｷ､ﾞ､ｹ､ｬ｡｢･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋ､隍ﾃ､ﾆ､ﾏ 32kb ､ｯ､鬢､､ﾞ､ﾇ､ﾏ ｡ﾖﾂ遉ｭ､､｡ﾗ､ﾈﾈｽﾃﾇ､ｵ､�ｺ､ﾋ､ｹ､爨ｳ､ﾈ､筅｢､熙ﾞ､ｹ｡｣･鬘ｼ･ｸ･ｪ･ﾖ･ｸ･ｧ･ｯ･ﾈ､ﾏ ･ﾆ･ｭ･ｹ･ﾈ､｢､�､､ﾏ･ﾐ･､･ﾊ･熙ﾎﾎｾﾊ�､ﾎｷﾁｼｰ､ﾈ､�ﾀ､ﾞ､ｹ｡｣ PDO ､ﾇ､ｳ､ﾎ･鬘ｼ･ｸ･ﾇ｡ｼ･ｿｷｿ､ｷ､ｦ､ﾋ､ﾏ｡｢ PDOStatement::bindParam() ､� PDOStatement::bindColumn() ､ﾎ･ｳ｡ｼ･��､ﾋ ｷｿ･ｳ｡ｼ･ﾉ､ﾈ､ｷ､ﾆ PDO::PARAM_LOB ､ﾈﾍﾑ､ｷ､ﾞ､ｹ｡｣ PDO::PARAM_LOB ､ﾘﾄ熙ｹ､�ﾈ｡｢PDO ､ﾏ ･ﾇ｡ｼ･ｿ､ｹ･ﾈ･遙ｼ･爨ﾋ･ﾞ･ﾃ･ﾗ､ｷ､ﾞ､ｹ｡｣､ｳ､�ﾋ､隍遙｢ PHP ･ｹ･ﾈ･遙ｼ･� API ､ﾈﾍﾑ､ｷ､ﾆ･ﾇ｡ｼ･ｿ､ｷ､ｨ､�隍ｦ､ﾋ､ﾊ､熙ﾞ､ｹ｡｣
ﾎ�13 ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹﾆ筅ﾎｲ霖�ｽｼｨ､ｹ､�
､ｳ､ﾎﾎ网ﾇ､ﾏ $lob ､ﾈ､､､ｦﾌｾﾁｰ､ﾎﾊﾑｿﾋ LOB ､ﾐ･､･ﾉ､ｷ｡｢ fpassthru() ､ﾈﾍﾑ､ｷ､ﾆ､ｽ､�ﾖ･鬣ｦ･ｶ､ﾋﾁｮ､ｷ､ﾞ､ｹ LOB ､ﾏ･ｹ･ﾈ･遙ｼ･爨ﾇﾉｽ､ｵ､��ﾎ､ﾇ｡｢ fgets()｡｢fread() ､ｪ､隍ﾓ stream_get_contents() ､ﾈ､､､ﾃ､ｿｴﾘｿ� ｻﾈﾍﾑ､ｹ､�ｳ､ﾈ､ｬ､ﾇ､ｭ､ﾞ､ｹ｡｣
<?php
$db = new PDO('odbc:SAMPLE', 'db2inst1', 'ibmdb2');
$stmt = $db->prepare("select contenttype, imagedata from images where id=?");
$stmt->execute(array($_GET['id']));
$stmt->bindColumn(1, $type, PDO::PARAM_STR, 256);
$stmt->bindColumn(2, $lob, PDO::PARAM_LOB);
$stmt->fetch(PDO::FETCH_BOUND);
header("Content-Type: $type");
fpassthru($lob);
?>
ﾎ�14 ｲ霖�ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋﾁﾞﾆ�､ｹ､�
､ｳ､ﾎﾎ网ﾇ､ﾏ｡｢･ﾕ･｡･､･�ｪ｡ｼ･ﾗ･ｷ､ﾆ､ｽ､ﾎ･ﾏ･ﾉ･�� PDO ､ﾋﾅﾏ､ｷ｡｢ LOB ､ﾈ､ｷ､ﾆ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋﾁﾞﾆ�､ｷ､ﾞ､ｹ｡｣PDO ､ﾏ｡｢･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋｱ�､ｸ､ｿ ､筅ﾃ､ﾈ､簀ｬﾀﾚ､ﾊﾊ�ﾋ｡､ﾇ･ﾇ｡ｼ･ｿ､霹ﾀ､ｷ､ﾞ､ｹ｡｣
<?php
$db = new PDO('odbc:SAMPLE', 'db2inst1', 'ibmdb2');
$stmt = $db->prepare("insert into images (id, contenttype, imagedata) values (?, ?, ?)");
$id = get_new_id(); // ｿｷ､ｷ､､ ID ､荀�ﾆ､�ｿ､皃ﾎｲｿ､鬢ｫ､ﾎｴﾘｿ�
// ･ﾕ･ｩ｡ｼ･爨ｫ､鬣ﾕ･｡･､･�｢･ﾃ･ﾗ･悅ｼ･ﾉ､ｷ､ﾆ､､､�ﾈｲｾﾄ熙ｷ､ﾞ､ｹ｡｣
// ｾﾜｺﾙ､ﾊｾﾏ PHP ､ﾎ･ﾉ･ｭ･螂皈ﾈ､ｲｾﾈ､ｯ､ﾀ､ｵ､､｡｣
$fp = fopen($_FILES['file']['tmp_name'], 'rb');
$stmt->bindParam(1, $id);
$stmt->bindParam(2, $_FILES['file']['type']);
$stmt->bindParam(3, $fp, PDO::PARAM_LOB);
$db->beginTransaction();
$stmt->execute();
$db->commit();
?>
ﾎ�15 ｲ霖�ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾋﾁﾞﾆ�､ｹ､�: Oracle
Oracle ､ﾏ｡｢･ﾕ･｡･､･�ｫ､� LOB ､ﾞﾆ�､ｹ､��ﾋ｡､ｬﾂｾ､ﾈ､ﾏｾｯ､ｷｰ网､､ﾞ､ｹ｡｣ ､ﾞ､ｿ｡｢ﾉｬ､ｺ･ﾈ･鬣ｶ･ｯ･ｷ･逾筅ﾇﾁﾞﾆ�､ｷ､ﾊ､ｱ､�ﾐ､ﾊ､熙ﾞ､ｻ､｣ ､ｽ､�ﾊｳｰ､ﾎｾ�遑｢ｿｷ､ｷ､ｯﾁﾞﾆ�､ｵ､�ｿ LOB ､ﾏﾄｹ､ｵ･ｼ･惕ﾈ､ﾊ､遙｢･ｯ･ｨ･熙ﾎ ｼﾂｹﾔｻ�､ﾋｰﾅﾌﾛﾅｪ､ﾋ･ｳ･ﾟ･ﾃ･ﾈ､ｵ､�ﾞ､ｹ｡｣
<?php
$db = new PDO('oci:', 'scott', 'tiger');
$stmt = $db->prepare("insert into images (id, contenttype, imagedata) " .
"VALUES (?, ?, EMPTY_BLOB()) RETURNING imagedata INTO ?");
$id = get_new_id(); // ｿｷ､ｷ､､ ID ､荀�ﾆ､�ｿ､皃ﾎｲｿ､鬢ｫ､ﾎｴﾘｿ�
// ･ﾕ･ｩ｡ｼ･爨ｫ､鬣ﾕ･｡･､･�｢･ﾃ･ﾗ･悅ｼ･ﾉ､ｷ､ﾆ､､､�ﾈｲｾﾄ熙ｷ､ﾞ､ｹ｡｣
// ｾﾜｺﾙ､ﾊｾﾏ PHP ､ﾎ･ﾉ･ｭ･螂皈ﾈ､ｲｾﾈ､ｯ､ﾀ､ｵ､､｡｣
$fp = fopen($_FILES['file']['tmp_name'], 'rb');
$stmt->bindParam(1, $id);
$stmt->bindParam(2, $_FILES['file']['type']);
$stmt->bindParam(3, $fp, PDO::PARAM_LOB);
$stmt->beginTransaction();
$stmt->execute();
$stmt->commit();
?>