Re: HTML in MySQL?

[clint lenard]

Wow, thanks for all of the Information guys! I've learned alot and now I've 
actually been doing more brain storming... I've been reading all of these 
emails over and over - and they're helping me understand more!

What I'm trying to do is save "User Sites" in MySQL and use PHP to pull them 
out through the Database using a Virtual Directory (if that's what it could 
be called?) like: http://mysite,com/bob-in-germany or just 
http://mysite,com/bobingermany/

There may be a ton of these sites as time moves on and I'm just trying to 
make sure I learn as much as I can before I get a major problem on my 
hands... I know it may be resource intensive - but it just seems to be 
easier to delete unused sites through a DB rather than a File System I may 
not have full control over?

Anyways, Thanks again guys! This is helping alot! anymore feedback would be 
great!

- Clint

P.S. - Sorry Jasper for sending it to you and not the list... I'm new to 
GMail :(

On 9/11/05, Jasper Bryant-Greene <jasper@stripped> wrote:
> 
> Jasper Bryant-Greene wrote:
> > John Trammell wrote:
> >
> >> $input = "This is <br> the \n input"; # value from user
> >> $saved = "This is <br> the <br> input"; # value in database
> >> $recovered = "This is \n the \n input"; # retrieved from db, != $input
> >
> >
> > Please don't top-post. That is the perfect argument for not applying
> > nl2br() before saving the information in the database. It should be done
> > *when outputting* instead.
> >
> > <?php
> > $in = mysql_real_escape_string("This is <br> the \n input");
> > mysql_query("INSERT INTO my_table (my_field) VALUES ('$in')");
> >
> > $array =mysql_fetch_assoc(mysql_query("SELECT my_field FROM my_table"));
> > print(nl2br($array['my_field']));
> > ?>
> >
> > works exactly as intended.
> >
> 
> Oh, and I should mention you probably want to htmlspecialchars() that
> data too, if you actually want to see the <br> and if you want to
> protect from XSS attacks etc.
> 
> --
> Jasper Bryant-Greene
> Freelance web developer
> http://jasper.bryant-greene.name/
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> 
>