On 07/11/2007, Adam <[EMAIL PROTECTED]> wrote:
>
> Brian,
>
> I hope your not using the code below anywhere as it looks wide open to
> SQL Injection.
Of course not. It was simply a response to the rather dumb suggestion of
doing it via httpd.conf
Adam
>
> Quoting Brian Butterworth <[EMAIL PROTECTED]>:
> > 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
> >
>
>
>
>
>
> -
> Sent via the backstage.bbc.co.uk discussion group. To unsubscribe, please
> visit http://backstage.bbc.co.uk/archives/2005/01/mailing_list.html.
> Unofficial
> list archive: http://www.mail-archive.com/[email protected]/
>
--
Please email me back if you need any more help.
Brian Butterworth
www.ukfree.tv
