The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Retaining line breaks when data comes back out of mysql?
I have a project I am working on and I have data saved in my database that has line breaks retained. My problem is that when I go through and pull the row of data from my database and put the cells into a $variable I no longer have the line breaks....
As an example: $name=$row[name]; $seasons=$row[seasons]; Assuming that $seasons is a list of seasons with line breaks or white space to format the output... what command do I need so that the output will retain line breaks? Thanks! |
#2
|
||||
|
||||
Setting one variable equal to another will not change the original content... My guess is your line breaks are "\n" (whitespace) and not HTML breaks - so when you output it, they are ignored. Look at the nl2br function - this will add in <br /> with each new line.
Edit: alternatively, you can wrap your output in <pre> ... </pre> to retain whitespace. |
#3
|
|||
|
|||
My issue is that I am trying to reuse data entered by another script...
THANK YOU!!! The nl2br function was what I needed!!! |
#4
|
|||
|
|||
OK, I am close but not quite there yet...
From the help above I have been able to export my data from my database to a php page and the text is retainining line breaks. Following is an example of what the data looks like: File 1 PHP Code:
Quote:
File 1 (Later in the code) PHP Code:
What I can not figure out for the life of me is what do I need to do to get the output variable posted from in File #1 to retain the line breaks (\n) when the gets to my second file so that my second file can do a mysql UPDATE.... The line breaks are critical for my project as the values I am updating are lists of items. Thanks for any advise! |
#5
|
||||
|
||||
Quarterbore, I'm not really sure what you are asking. If you want to chat about it (easier to solve problems in real time), you can find my contact info in my profile.
|
#6
|
|||
|
|||
Well, I can describe it better....
I have a Database I am building that serves up information to a Timeshare Resorts Database as in the following link: http://www.timeshareforums.com/resor...e.php?resort=1 Before I added the nl2br function my text was running on (no line breaks) but as you can see it is all formated now. What I need to do is create a script that will allow me to edit the data as there are too many errors in the data for me to use phpmyadmin to correct them. The database was actually created using vBaLinks but the vBaLinks program was too limiting for me to use the data as I want so I created a new database with my resort information and now I am trying to flesh out the rest of the tools I need to edit and serve up the data. Also, does anybody suggest a good MYSQL book? I have a few PHP books but I really need to buy a good MYSQL book to help me get through these issues... Edit: Here is a sample page: http://www.timeshareforums.com/editr...php?resort=300 The code is set such that the value in the RCI Season info comes from this: PHP Code:
Note: This is not updating anything in my database as obviously if it were I would have this locked down... My full output template looks like the following so you can see the data I am working with: http://www.timeshareforums.com/resor...php?resort=300 When I am done I hope to integrate this into my vB system to asign edit permissions and the like but as of now it is a stand alone application to keep in "simple" OK, I talked with a SQL developer at work and he gave me a hint that seems to have solved my problems.... To send a $variable and retain the line breaks it is necessary to convert it to html before passing the value via a POST command... For example: PHP Code:
PHP Code:
This was a major victory but it is rather anti-climatic that two lines of code that are that short were all I needed... Now I can work on programing the rest of my page... WOW! |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|