Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/question/public_html/scripts.php on line 1574
Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/question/public_html/scripts.php on line 1574
Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/question/public_html/scripts.php on line 1574
Q: SQL Express
Submitted By: JohnP, 310 days, , 20 minutes ago
I am learning web dev, I need to understand how to insert documents within sql databases? How do you directly link them within the database?
Please try not to post duplicate answers... if you see an answer that you want to post, just add a vote to it and you can add a note as well. Thank You
1
0
Why do I need a title
Submitted By: anon ( 310 days, , 17 minutes ago )
A lot of SQL servers have a BINARY field type. You can write the raw file there and store the content type in a VARCHAR field and when somebody needs the file, just query for it and output the raw content with the appropriate content type. An alternative is to just store the files on the local file system in uniquely named folders w/ uniquely named filenames and then insert the full/partial path to each file into a VARCHAR field in the database.
0
0
Consider a CMS
Submitted By: GreenAlien ( 309 days, 17 hours, 47 minutes ago )
If you want to save formatted pages (eg with bold text, links, various colours, inserted images etc) then you may want to check out a Content Management System. There's loads to choose from, and they generally do the saving of documents to a SQL database (often mysql) transparently. A knock on effect is being able to quickly search those documents without having to implement that feature separately.
Alternatively if it's just regular documents, like Word or PDF documents, then you can store them in a BLOB field in your database. Personally I don't like doing that though, and if this is necessary I usually just store the file on the server and store a short textual link to it in the database