gavenf Posted May 8, 2007 Share Posted May 8, 2007 Hi there, I have a database calld "Planitteacher" in Mysql with a table called "uploads". In this table are the following columns "id, description, data, filename, filesize, filetype, title, class, subject, web1, email, and state". The "data" colum is a longblob with the filename, filetype and filesize relating to it. I can upload all types of files such as .doc, .xls, .pdf, .txt no problems. My problem occurs when trying to make a PHP search function to return the results. I cant figure out how to return the results o the search so that I can then click on a link which will allow me to download the associated files from the search. What I would like is to have the searh return a result that shows the general information and then offers a clickable link to download any files that are associated with that information. Can anyone assist. Quote Link to comment https://forums.phpfreaks.com/topic/50459-longblob-results-not-working/ Share on other sites More sharing options...
igor berger Posted May 8, 2007 Share Posted May 8, 2007 Well, you can search by what ever field you like, once the record or records are retrived in mysql array then echo the link of the file in html with description etc... Quote Link to comment https://forums.phpfreaks.com/topic/50459-longblob-results-not-working/#findComment-247949 Share on other sites More sharing options...
gavenf Posted May 8, 2007 Author Share Posted May 8, 2007 Sorry but I have no clue ho to do what you are saying. Could you show me what you mean? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/50459-longblob-results-not-working/#findComment-247950 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.