Please feel free to ask for clarification if the scope of work is not clear. I want to make sure you can complete the project before bidding. If you have done a project like this in the past, this is a big plus!!!!
I need a BYTE ARRAY script written to retrieve an encrypted image file located in a specific path on my server and managed through the MS SQL server.
Attached is an screen shot of the DB and encrypted relationship, the db (MS SQL 2008), and encrypted files from my test servers.
You should be able to re-attach the DB to your local MSSQL Server.
The end results would be a web page which has an hlink for the 'DocumentID' to open the image document (pdf, png, jpg, etc..) via the web. You should be able to provide me a URL simply with a couple of 'Given' links that would open the files I sent you for testing purposes. Once this has proven out, we will test on my test server to proof the code.
Snippet below will give you an idea on how to retrieve a document from SQL. We read it to BYTE ARRAY to pass it to Web, but it needs to be re-written to work within php.
Dim result As Byte() = Nothing
Dim dms As New [login to view URL]()
[login to view URL] = username
If Not [login to view URL] Then
[login to view URL](False)
End If
Dim fname As String = [login to view URL](documentNumber)
If [login to view URL] > 0 Then
Dim finfo As New [login to view URL](fname)
Dim extensions As String() = {".jpg", ".bmp", ".png"}
If [login to view URL]([login to view URL]) Then
Dim fs1 As [login to view URL]
fs1 = [login to view URL](fname, [login to view URL], [login to view URL])
Dim breader As New [login to view URL](fs1)
Dim fsize As Integer = [login to view URL]
result = New Byte(fsize) {}
[login to view URL](result, 0, fsize)
[login to view URL]()
[login to view URL]()
Else
result = [login to view URL](fname)
End If
End If
I understood that u need a BYTE ARRAY script to retrieve an encrypted image file located in a specific path on my server and managed through the MS SQL server.
I will attach DB to local server also. It is an easy task for me and i can easily do it.
i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level