error:
success INSERT into files (name,data) values ("DirtCheap.htm","")
Warning: mssql_query(): message: Disallowed implicit conversion from data type varchar to data type binary, table 'SPARK.dbo.files', column 'data'. Use the CONVERT function to run this query. (severity 16) in c:\inetpub\wwwroot\sparktrial\fileopen.inc.php on line 17
Warning: mssql_query(): Query failed in c:\inetpub\wwwroot\sparktrial\fileopen.inc.php on line 17
CODE:
<?php
//REQUIRE 'db_connect.php';
function fileopen($file){
$handle = fopen("$file", "rb"); //OPEN THE FILE
$contents = fread($handle, filesize($file)); //READ IN THE FILE
fclose($handle); //CLOSE THE FILE
//echo $contents; //DEBUG TO SEE IF WE HAVE THE FILE
return($contents);
}
function filein($file,$contents,$msdb){
$filename = ltrim(strrchr($file,'\'),'\');
$ext = ltrim(strrchr($file,'.'),'.');
$submit = "INSERT into files (name,data) values (\"$filename\",\"$contents\")";
echo $submit;
mssql_query($submit);
}
function fileout($sow_id){
$retrieve = "SELECT data FROM files WHERE sow_id='$sow_id'";
mssql_query($retrieve, $msdb);
}
database has 3 fields in 'files' table file_id(int), name(varchar),data(binary)
