PHP Insert File From A Directory

Question

I have upload file via FTP in a directory, Now i am try to save that file into database and delete file in FTP Directory... Here is my code

$myimage = "C:\upload\satu.xml";;
$image = file_get_contents($myimage);
$content=addslashes($image);

$conn = oci_connect('ARTERI','password','192.168.1.1/Mutual');
$stid = oci_parse($conn, "INSERT INTO MMSHOSPITAL.HASIL_PEMERIKSAAN (ID, ID_REGISTRASSI, ID_UNIT_LAYANAN, CONTENT)".
                         "VALUES('1', '172', 'ACT', '".$content."') ");
oci_execute($stid);
oci_close($conn);

Help me please... that code is not work to save file in the table of my database..

y are u saving file only save path to file.

Arun Killu
– Arun Killu

2013-01-22 03:48:12 +00:00
Commented Jan 22, 2013 at 3:48 — Arun Killu
– Arun Killu, Commented Jan 22, 2013 at 3:48
no, i need save file not just the path..

Niken Swandarini
– Niken Swandarini

2013-01-22 03:50:23 +00:00
Commented Jan 22, 2013 at 3:50 — Niken Swandarini
– Niken Swandarini, Commented Jan 22, 2013 at 3:50
How is CONTENT defined? Is it LOB?

Ja͢ck
– Ja͢ck

2013-01-22 04:03:02 +00:00
Commented Jan 22, 2013 at 4:03 — Ja͢ck
– Ja͢ck, Commented Jan 22, 2013 at 4:03

Arun Killu · Accepted Answer · 2013-01-22 03:51:36Z

1

$myimage = "C:\upload\satu.xml";
$image = is_file($myimage);//this return true of false
$content=file_get_contents($myimage);//this reads the content of file as string

answered Jan 22, 2013 at 3:51

Arun Killu

14.3k5 gold badges38 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Niken Swandarini Over a year ago

this script i have try but invalid value, content column is blob in my table of oracle database

Niken Swandarini Over a year ago

should i change into another type?

Arun Killu Over a year ago

blob is ok it stores as binary . no problem

Arun Killu Over a year ago

just select the content and display using correct content type .it will work

Niken Swandarini Over a year ago

STIL ERRORRRORA-01465: invalid hex number in C:\xampp\htdocs\MMSBank\file\upload.php on line 25

|

Collectives™ on Stack Overflow

PHP Insert File From A Directory

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related