PHP上传图片写入MSSQL数据库
现在做一个项目PHP+MSSQL
为了兼容c/s的一个客户端,所以PHP上传的图片要写入MSSQL数据库的image类型字段里,客户端才能正常显示图片。
//使用的存储过程
CREATE PROCEDURE sp_table1
(
@pics image
)
AS
INSERT INTO Table1(pics) VALUES(@pics)
GO
<?php
if ($_FILES["FileUpload1"] != null) {
$tmp_name = $_FILES["FileUpload1"]["tmp_name"];
$fp = fopen($tmp_name, "rt");
if(!$fp) die("file open error");
$EmpPhoto = fread($fp, filesize($tmp_name));
fclose($fp);
$db = mssql_connect("127.0.0.1", "sa", "liuyang");
mssql_select_db("test", $db);
$stmt = mssql_init("sp_table1", $db);
mssql_bind($stmt, "@pics", $EmpPhoto, SQLVARCHAR);
mssql_execute($stmt);
mssql_close($db);
exit();
}
?>
<form name="form1" method="post" action="" id="form1" enctype="multipart/form-data">
<table class="tNomal" height="100%" width="100%">
<tr>
<td><input type="file" name="FileUpload1" id="FileUpload1" style="width:100%;" />
<br />
<input type="submit" name="Button1" value="上传" id="Button1" /></td>
</tr>
</table>
总是报如下三个错误
Warning: mssql_bind() [function.mssql-bind]: Unable to set parameter in D:\usr\home\php\Discuz!_5.5.0_SC_GBK\upload\sp_image.php on line 18
Warning: mssql_execute() [function.mssql-execute]: message: 过程 'sp_table1' 需要参数 '@pics',但未提供该参数。 (severity 16) in D:\usr\home\php\Discuz!_5.5.0_SC_GBK\upload\sp_image.php on line 21
Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in D:\usr\home\php\Discuz!_5.5.0_SC_GBK\upload\sp_image.php on line 21
Call Stack
请问一下有没有高手应该怎么解决此问题啊。