How to insert image data into SQL Server with php?

white_ice

I come from China.Please give me a sample codes.Thanks!!
I have a problem.
I create a image datatype in SQL Server,the name is img.
The code like these:

$ptemp=$_FILES["myPic"]["tmp_name"];
$imgLocation = str_replace("\\","/", $ptemp);
$filehandle=fopen($imgLocation,"rb") or die("Can't open file!");
$sqlPic=addslashes(fread($filehandle,$psize));
fclose($filehandle);
$strsql="insert into mytable (img) values ('".$sqlPic."')";
//...
mssql_query($strsql);
//...

But no success!! Please help me. Thanks.
The note like this:
Warning: mssql_query(): Query failed ......

white_ice

🙂

CarpeDiem

maybe you need litle change :-)
change this

$imgLocation = str_replace("\","/", $ptemp);

$imgLocation = str_replace("\\","/", $ptemp);

$oldChar=chr(92); 
$imgLocation = str_replace($oldChar,"/", $ptemp);

white_ice

$imgLocation = str_replace("\\","/", $ptemp);

¡ü I open this file no problem.
But the SQL Server is error. I think may be the SQL sentence is error.Please help me. Would you give me a sample code?Thank you. 🙂

pjleonhardt

look at your first post...
see how most of your code is red??/
this is because you missed a " somewhere and it's reading that whole thing as part of that
$imgLocation variable...
why?? Because \ is a note to PHP to ignore the next character and to parse it as if it were a regular character.. Solution?

$imgLocation = str_replace("\\\","/", $ptemp);

Should work.... The first \ says... dont use PHP to parse the next character... and the second \ is the actual \ that it's replacing.. They way you had it was telling it to ignore the " after your .

Hope that helps 🙂

edit:
on second thought... you might need three... i tried posting it with 2, and it came up with only one on the board, so i added three and it took it right.. maybe it is just a problem with the board display though... But i think it is sposed to be 2, not 3.. try both tho :-p

LordShryku

Two will work. The board strips slashes