What do you mean the video is broken

Whilst checking a few things on the pages already created on the site I spotted a video link that was no longer working. This got me thinking, how woudl I know if a video link stopped working at some point in time unless i checked them all all the time. So I came up with the idea of adding in a bit below the video that people can click if the video itself is no longer working. This thing puts an entry into the db to flag it as being reported (still leaves the video on the page) but now the response on the page says the video has been reported as being broken and will be looked into.

Now this means that I am opening up a db connection on the public side of the site that will need access to the insert something into the DB. To this point I have been limiting the ability of the front end connection to only select to stop anyone putting things into or trying to delete things from the DB if they managed to hack it. This prompted me to create a way to validate all the info passed before inserting and at the same time amend the info that is passed between some of the pages. Now the only way an entry is flagged as the video not working, is if 3 different pieces of information passed to this page check out as exactly matching which cant ever match any other item.

All good so far but I have now inadvertently created a great error checking way (some extra checks including some regular expressions) that I am going to apply to the other public facing pages. It also turns out the way I have structures my urls works really well with the method which makes it all even easier to implement which makes me super super happy.