Donald Louch Title Logo

Bi-weekly Update (3)

Update is being currently constructed! Please check back later for the official update!

October 12th, 2018 to October 26th, 2018

General Thoughts

I have decided to use the DigitalOcean Spaces object storage platform to host the video files. I did go with the servers that are in San Fransisco as there as none in Canada. My hopes is that they add Canadian servers in the future. With this I'll be able to accept more videos and store them on CDN servers for faster and better optimized coverage. I'm currently configuring this right now!

Issues

Issue 1:4 From Bi-Weekly Update (1): I have finally fixed the issue with accepting "breaks, quotation marks, and apostrophes" within the upload function! I decided to post about on StackOverFlow to see if there was a solution as $ITEM = mysqli_real_escape_string($CONNECTION, $_POST['FEILD']) and $ITEM = nl2br($_POST['FEILD']) weren't allowing me to get all the strings. But from a solution mysqli_real_escape_string($CONNECTION, nl2br($_POST['FEILD'])) worked! I have tried to do the reverse but had no luck and didn't think to try the correct way!

Issue 1:6 From Bi-Weekly Update (1): I did end up by going with DigitalOcean and Spaces to store my files! However, a new somewhat of an issue arose.

1) In order for me to work with DigitalOcean Spaces I need to use an API/SDK and I decided to go with Amazon's AWS SDK as it is compatible with Spaces and seems to be fairly modular! I further adapted code from the community article on DigitalOcean "How to use DigitalOcean Spaces with the AWS S3 SDKs?" to allow me to accept these uploads!

Successes

Changes

View Bi-weekly (3) Repository: COMING SOON! View Working Website: Sitemap*

*Note a user account is needed to access the sitemap! You may use "TestUser" password "123456AbC!" if you would like to proceed without creating an account!