Hi everyone, just wanted to know what type should i use in mysql database to store the urls (for linking purposes) of videos(from youtube,vimeo) and slides (from slideshare)...i just want to store the urls not the whole video..for tht i wud use directory/ file functions.. please help... helpful comments will be appreciated :)
Riu 2009 0 Junior Poster
blocblue 238 Posting Pro in Training Featured Poster
A VARCHAR[255] field should allow sufficient space for the URLs.
Riu 2009 0 Junior Poster
thnakyou so much
any other thing that should be mentioned while saving these types of fields in mysql?? actually iam new to mysql n php so dont have an idea what else should be used.. tanhks in advance :)
smantscheff 265 Veteran Poster
The varchar field should have at least 2.000 characters. URLs can be that long. See http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url
blocblue 238 Posting Pro in Training Featured Poster
@smantscheff -
I did wonder whether to suggest a longer length, but the likelihood of a URL being that long is very unlikely in my opinion.
@Rui_2009 -
My only other suggestion would be to not include the host name in the URL for files hosted on your server. This will make it easier to move between development, staging and live environments.
For Youtube, Vimeo URLs, etc, you'll obviously need the full URL.
Riu 2009 0 Junior Poster
yes i would need the full url thanks all :)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.