Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » Community » Coffee corner » saving and reading pdf file, binary file, image file in mysql
saving and reading pdf file, binary file, image file in mysql [message #57087] Sun, 23 May 2021 14:10 Go to previous message
BetoValle is currently offline  BetoValle
Messages: 142
Registered: September 2020
Location: Brasil Valinhos SP
Experienced Member
Hi,

I did a test by uploading a pdf file to a variable string and then saved it to mysql. Then I read the content for string, and saved it as a pdf. The result was totally incorrect. How can I do this considering pdf, binary and image files?

            String pdf="file.pdf";
            String bf ="file.exe";
            String if ="file.png";
        	
	    //how to load Files to save in mysql?;
            
            sql.Begin();
            String st="INSERT INTO test ";
            st += "(PDF,BF,IF)";
            st += " values (?,?,?)";  
            sql.Execute ( , , );
            sql.Commit();


            String st="select * from test ";
            sql.Execute (st);
            while ( sql.Fetch() )
            {
                ? SQL["PDF"]
                ? SQL["BF"]
                ? SQL["IF"]	
             }            

            //how to write content in files ?
              SaveFile(fpdf,?); 
              SaveFile(fbf,?); 
              SaveFile(fif,?); 



Thanks!
 
Read Message
Read Message
Read Message
Previous Topic: select file with windows explorer
Next Topic: Compile under Mac M1 for intel
Goto Forum:
  


Current Time: Sat Dec 04 11:43:56 CET 2021

Total time taken to generate the page: 0.02205 seconds