21,887
社区成员
发帖
与我相关
我的任务
分享求助:图片存入数据库的问题,急,在线等
想实现存图片到数据库,用以下的程序:up.htm选择图片，upload.php3存入数据库
在upload.php3的
$stmt = OCIParse($conn,"INSERT INTO PICTURES (id,mime, picture) VALUES (pic_seq.NEXTVAL, 'image/jpeg', EMPTY_BLOB()) RETURNING picture
出现parse error 问题，水能帮忙看一下
up.htm：
<html>
<head><title>文件上传</title></head>
<body>
<form enctype="multipart/form-data" action="upload.php3" method="post">
请选择要上传的文件: <br>
<input name="picture" type=file accept="image/*"><br>
<input type=submit value="上传"></form>
</body>
</html>
upload.php3:
<?php
$conn = OCILogon ("outln", "outln","photo")
$stmt = OCIParse($conn,"INSERT INTO PICTURES (id,mime, picture) VALUES (pic_seq.NEXTVAL, 'image/jpeg', EMPTY_BLOB()) RETURNING picture INTO :PICTURE");
$lob = OCINewDescriptor($conn, OCI_D_LOB);
OCIBindByName($stmt, ':PICTURE', &$lob, -1, OCI_B_BLOB);
OCIExecute($stmt);
if($lob->savefile($lob_upload)){
OCICommit($conn);
echo "上传成功<br>";
}else{
echo "上传失败<br>";
}
//释放LOB对象
OCIFreeDesc($lob);
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
按理说upload.php3应该不会出错，因为是从网上找到的别人已经用过成功的案例
是不是up.htm里有什么地方错了
清指教
在upload.php3的
$stmt = OCIParse($conn,"INSERT INTO PICTURES (id,mime, picture) VALUES (pic_seq.NEXTVAL, 'image/jpeg', EMPTY_BLOB()) RETURNING picture
出现parse error 问题，水能帮忙看一下
up.htm：
<html>
<head><title>文件上传</title></head>
<body>
<form enctype="multipart/form-data" action="upload.php3" method="post">
请选择要上传的文件: <br>
<input name="picture" type=file accept="image/*"><br>
<input type=submit value="上传"></form>
</body>
</html>
upload.php3:
<?php
$conn = OCILogon ("outln", "outln","photo")
$stmt = OCIParse($conn,"INSERT INTO PICTURES (id,mime, picture) VALUES (pic_seq.NEXTVAL, 'image/jpeg', EMPTY_BLOB()) RETURNING picture INTO :PICTURE");
$lob = OCINewDescriptor($conn, OCI_D_LOB);
OCIBindByName($stmt, ':PICTURE', &$lob, -1, OCI_B_BLOB);
OCIExecute($stmt);
if($lob->savefile($lob_upload)){
OCICommit($conn);
echo "上传成功<br>";
}else{
echo "上传失败<br>";
}
//释放LOB对象
OCIFreeDesc($lob);
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
按理说upload.php3应该不会出错，因为是从网上找到的别人已经用过成功的案例
是不是up.htm里有什么地方错了
清指教
...全文
请发表友善的回复…
发表回复
