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]
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 (li/li), 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
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 (li/li), 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]