Re: ms sql and images..

likely [email protected] is the better place to ask this kind of 
question at, and you should get more responses, since this list is 
particular on the interest related to internationalisation with PHP.

Moriyoshi

"csr" <[email protected]> wrote:

> could anyone help me.
> I am trying to upload a jpg file into a ms sql server 2000 database with an
> image field and it's not working. This is the code so far..
> 
> $file = fopen ($HTTP_POST_FILES['upload_file']['tmp_name'],'rb')
>            or die ("File Open Failed ");  //this is the jpg file
> 
> $file_contents = fread ($file, filesize
> ($HTTP_POST_FILES['upload_file']['tmp_name']))
> or die (" Can't read ");
> fclose ($file);
> 
> //put file in database
> mssql_connect(HOST,USER,PASS) or die("unable to connect");
> mssql_select_db(PICTURE_DBASE) or die("unable to select database");
> //file data is the image field in the table files
> mssql_query($SQL="Insert into files (file_data) values ('$file_contents')")
>                    or die("MSSQL Query error: ". "<br><br>" );
> 
> 
> I got all sort of error messages from ms sql
> 
> any ideas.
> 
> thanks a lot
> csr.
> 
> 
> 
> -- 
> PHP Internationalization Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


-- 
PHP Internationalization Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php