I’m looking for suggestions in regards to storing other web addresses in mysql, to be pulled up later using PHP. I already have my column created as a varchar(255).
For example, would it be best to store Site Point as “sitepoint.com” or “http://sitepoint.com”. If I go with just “sitepoint.com” I can have PHP add the http:// to the beginning of it later in my webpage. I guess if the site is secure, it would be redirected… but if it is something other than http:// or https:// than I guess I could be in trouble.
I just want to know if there is a Best Practice for storing web addresses? Or what you found to work the best, etc…
Thank you for taking the time to read my post and any suggestions would be greatly appreciated. --Ben