PHP code sample to do the "tinyURL" bit...
<?
$link = mysql_connect(MYSQLHOST, MYSQLUSER, MYSQLPASS) or die("Could not
connect");
mysql_select_db(MYSQLDB) or die("Could not select database");
$strURL="http://invalidvaluelocation";;
$result2 = mysql_query("SELECT strURL FROM tblRedirects WHERE txtShortCode=
\"" . @$_GET["code"] . "\";") or die("Query failed");
if (mysql_num_rows($result2)>0) while ($line = mysql_fetch_array($result2,
MYSQL_ASSOC)) if ($line["strURL"]!="") $strURL=$line["strURL"];
header ("Location: $strURL");
?>
On 07/11/2007, Brian Butterworth <[EMAIL PROTECTED]> wrote:
>
>
>
> On 06/11/2007, James Cox <[EMAIL PROTECTED]> wrote:
> >
> >
> > On 6 Nov 2007, at 00:07, Andrew Bowden wrote:
> >
> > From: [EMAIL PROTECTED] on behalf of James Cox
> >
> > 'course, bbc.co.uk has had some kind of redirect magic for a while:
> > http://bbc.co.uk/zanelowe/
> >
> >
> >
> > First time I've seen a big fat httpd.conf called magic :)
> >
> >
> >
> > and there I was thinking you had some nice routing controller thin-app
> > which had some clever logging, tracking and management of such urls.... :)
> >
>
> 1544804416 entries would be a bit much for a httpd.conf file, I suspect
> what would be required is a ... database.
>
>
> though i suspect the problem (and usage of tinyurl) is that to get
> > one of those nice urls hooked up, you gotta email someone a request,
> > who needs to get approval from a manager....
> >
> >
> >
> > Well lets just say there is a process and it has to be done sensibly
> > else you'd get loads of random redirects. Although I still think
> > bbc.co.uk/breakfast should go to a big portal page for all the BBC's
> > breakfast shows :)
> >
> >
> >
> >
> >
> >
> > --
> >
> > *James Cox,
> > *Internet Consultant
> > t: 07968 349990 e: [EMAIL PROTECTED] w: http://imaj.es/
> >
> >
> >
> >
>
>
>
> --
> Please email me back if you need any more help.
>
> Brian Butterworth
> www.ukfree.tv
>
--
Please email me back if you need any more help.
Brian Butterworth
www.ukfree.tv
