|
![](/images/resource/spacer.gif) |
|
php ไม่สามารถบันทึกข้อมูล ชนิด long raw ลง database oracle ในฟิล์ Image ได้ |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
อ้างอิงจากกระทู้ https://www.thaicreate.com/php/forum/116341.html
Code ด้านล่าง ในการบันทึกข้อมูลลง database oracle ฟิล์ Image เป็น LONG RAW ไม่สามารถบันทึกได้
พอจะแนะนำได้ไหมครับว่าต้องแก้เป็นอย่างไร(จำเป็นต้องใช้ long raw) ครับ
//*** Insert Record ***//
$db=ocilogon("user","5878", "test");
$lob = oci_new_descriptor($objConnect, OCI_D_LOB);
$strSQL = "INSERT INTO FILES ";
$strSQL .="(FILESID,NAME,FILESTYPE,IMAGE) VALUES ";
$strSQL .="(seq_next_filesid.nextval,'".$_POST["txtName"]."' ";
$strSQL .=",'".$_FILES["filUpload"]["type"]."',:fileimage";
$fileimage = file_get_contents( $_FILES['filUpload']['tmp_name'] );
$objParse = oci_parse($objConnect, $strSQL);
oci_bind_by_name($objParse, ':fileimage', $fileimage, -1, SQL_LBI);
$objExecute = oci_execute($objParse, OCI_DEFAULT);
$lob->savefile($_FILES['filUpload']['tmp_name']);
if($objExecute)
{
oci_commit($objConnect);
echo "Copy/Upload Complete<br>";
}
else
{
oci_rollback($objConnect);
echo "Copy/Upload is not Complete";
}
oci_free_descriptor($lob);
oci_free_statement($objParse);
oci_close($objConnect);
}
?>
ลองรันแล้ว error ตามภาพด้านล่างครับ
![php290558 php290558](https://www.thaicreate.com/upload/stock/20150529133732.jpg?v=1001)
รบกวนท่านผู้รู้ช่วยแนำนำหน่อยครับ
ขอบคุณมากครับ
Tag : PHP, Oracle
![](/images/adv.jpg?v=1001)
|
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-06-02 13:31:42 |
By :
puupha |
View :
748 |
Reply :
2 |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
PHP Upload Oracle BLOB (Binary Data)
![](/images/bbcode/grin.gif?v=1001)
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-06-03 10:25:38 |
By :
mr.win |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 03
|