Re: AW: AW: [PHP] MORE QUESTION - Editing Database
hi, download one of the php forum programs and look into their code. www.phpBB.com should be a good reference. --- Dani <[EMAIL PROTECTED]> wrote: > Hi ! > > How do I allow HTML entries into my database? > > I tried to insert a pre-formated text into my database. > When I pull the > data out and put it in a text field the formating is > still there, > HOWEVER when I retrive the record from the database > using "echo" all > the text formating is gone and it became just a straigh > line. What > function should I use in this case??? > > > Could anybody please help? > > Thank you! > Dani > > > Hi Dani, > > > > For sure you can use a database. There are two ways of > using your pr > > formatted text. > > > > 1)Allow HTML-entries for your database. Because the > bullets you have > > used in your mail are from a list-tag (), > arent they? By > > that way you the user has two know HTML. > > > > 2)Use simple entries. For example: Instead of the > bullets you have > > used, just use - as prefix for your list-item. Dont > use HTML-tags! > > > > Putting into the database is very easy. Because it > doesnt matter if > > theres any whitespace in the entry. In my opinion you > should use as > > type something like tinytext or text (MySQL !!!). The > text-type allows > > entries with a size of about 65.000 bytes (65.000 > letters !!). > > > > I hope I could help you again. > > > > Bye, Marcel > > > > P.S.: Sorry for my bad english, but the last time I > really needed it > > was in school (about 7 years ago !!!) > > > > -Ursprüngliche Nachricht- > > > > Von: Dani [mailto:[EMAIL PROTECTED]] > > Gesendet: Donnerstag, 10. Januar 2002 18:57 > > An: Marcel Besancon > > Betreff: Re: AW: [PHP] MORE QUESTION - Editing Database > > Wichtigkeit: Hoch > > > > Hi Marcel ! > > > > if for example I have got a pre formated text like > this: > > > > Tour > > Adventure Tour > > > >* Adult $123 > >* Children $123 > >* etc > > > > Because later when a user edit this online, the text > will be displayed > > on a web form (input text). I'm not sure that we can > still preserved > > the format of the text when we try to insert it back to > database. > > > > so...is it still possible > > > > Should I use BLOB as the type of the data in my > database or > > .. > > > > Thank you so much for your reply! It helps me to > understand more > > > > Sincerely, > > Dani > > > = Mehmet Erisen http://www.erisen.com __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: AW: AW: [PHP] MORE QUESTION - Editing Database
Hi ! How do I allow HTML entries into my database? I tried to insert a pre-formated text into my database. When I pull the data out and put it in a text field the formating is still there, HOWEVER when I retrive the record from the database using "echo" all the text formating is gone and it became just a straigh line. What function should I use in this case??? Could anybody please help? Thank you! Dani > Hi Dani, > > For sure you can use a database. There are two ways of using your pr > formatted text. > > 1)Allow HTML-entries for your database. Because the bullets you have > used in your mail are from a list-tag (), arent they? By > that way you the user has two know HTML. > > 2)Use simple entries. For example: Instead of the bullets you have > used, just use - as prefix for your list-item. Dont use HTML-tags! > > Putting into the database is very easy. Because it doesnt matter if > theres any whitespace in the entry. In my opinion you should use as > type something like tinytext or text (MySQL !!!). The text-type allows > entries with a size of about 65.000 bytes (65.000 letters !!). > > I hope I could help you again. > > Bye, Marcel > > P.S.: Sorry for my bad english, but the last time I really needed it > was in school (about 7 years ago !!!) > > -Ursprüngliche Nachricht- > > Von: Dani [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 10. Januar 2002 18:57 > An: Marcel Besancon > Betreff: Re: AW: [PHP] MORE QUESTION - Editing Database > Wichtigkeit: Hoch > > Hi Marcel ! > > if for example I have got a pre formated text like this: > > Tour > Adventure Tour > >* Adult $123 >* Children $123 >* etc > > Because later when a user edit this online, the text will be displayed > on a web form (input text). I'm not sure that we can still preserved > the format of the text when we try to insert it back to database. > > so...is it still possible > > Should I use BLOB as the type of the data in my database or > .. > > Thank you so much for your reply! It helps me to understand more > > Sincerely, > Dani >
AW: [PHP] MORE QUESTION - Editing Database
Hi Dani, i do prefer using a database. I think it is the most dynamic way for creating and (important !!!) managing a website. Preformatted text isn't a problem with a database. Bye, Marcel > -Ursprüngliche Nachricht- > Von: Dani [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 10. Januar 2002 18:37 > An: PHP LIST > Betreff: [PHP] MORE QUESTION - Editing Database > Wichtigkeit: Hoch > > Hi again! > > I'm trying to develop a website where the user can edit the article > online. What is the best way to do this? > > is it better using database or fopen() functions? > > in mycase because the text (article ) is containing some pre formated > text, which one is the best way to do it? > > Thank you! > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]