I want to use a Wordpress style shortcode in my own CMS. For example, with Embedded Tweets, I can say:
[tweet 'TWEET URL']
and the tweet will be embedded with the standard format as supplied by Twitter. Similarly with YouTube videos:
[youtube 'YOUTUBE VIDEO']
will embed the YouTube video player. How would I do that with PHP and MySQL? I am not looking for a 'generic' system; manually adding shortcodes would work just fine with me, as long as I know what I am doing.