Access the contents of form variables

sunit_modi

Hi,

Here my problem:

i have data store in a mysql database that was originally sent from a form. When i call back the data from the record in the database, the information is not seperated by carraige returns but instead displayed in a large continious text string.

So basically i want to seperate the text whereby when a carraige return value is found in the text 2 new lines are displayed breaking the text.

For example: (what is should look like)

Va pensiero Watson, Russell
Summertime Church, Charlotte

But instead, cuttently it is output as:

Va pensiero Watson, Russell 2. Summertime Church, Charlotte

I have done the following but it does not work

$track_info="$myrow[11]";
$length_finish=strlen ($myrow[11]);

( I have output the value of $length_finish and it does return the true result so i know that works!)

$length_start=1;
while ($length_start < $length_finish) {

// chr(13) = the ascii charactor for carraige return

	If ($track_info[$length_start]==(chr(13))) {
		echo ("<br />");
		echo ("<br />");
	}
	$length_start=$length_start + 1;
}

For some reason it wont let me access the individual element in the $track_info, i have tried displaying dummy statement i.e. $track_info[2] but does not display anything.

I hope there is enough information here to get the idea what i want.

Many Thanks.... again

Sunit

Mega

Firstly read through PEAR's standards for coding PHP, it makes everything easier if we all code to one standard 🙂

don't use parenthesis for echo

secondly can i have the query you're using

$result = mysql_query(<insert your query>);

while( $row = mysql_fetch_array($result) ){

// whatever the field is called
$row['name'] = nl2br($row['name']);

echo $row['name'];

}

some more information would help out a lot 🙂

sunit_modi

ok, here is the mysql stuff,

if (!($link = mysql_pconnect($DB_SERVER, $DB_LOGIN, $DB_PASSWORD))){
DisplayErrMsg(sprintf("internal error %d:%s\n", mysql_errno(), mysql_error()));
exit() ;
}

if (!(mysql_select_db($DB,$link))) {
echo(" ");
echo(" ");
echo (" Cannot Connect To Database Table");
exit();
}

$search="select * from inventory where item_no='$rowid';";
$myrow = mysql_fetch_row(mysql_query($search,$link));

whereby $myrow[11] being the 11th column in the table holding a textual information. The column type is mediumtext just so i can store loads of information.

Appologies in the standard in coding, still new to PHP and my other lanaguages get in the way which are simular... ada.... pascal... cobol....etc etc

Sunit

😃

MrAlaska

You want to pull it out of the database and display it on a webpage with the carriage returns preserved, right?

I had a similar problem, I handled it right from the form submission before I sent it to the database by replacing carraige returns with Of course, I had to do it AFTER stripping the HTML.

$message = str_replace("\r", " ", $message );

sunit_modi

ok, so your saying:

$track_info= str_replace("\r", " ", $track_info);
$description= str_replace("\r", " ", $description);
$result=MYSQL_QUERY("INSERT INTO inventory (item_no,category,image_present,bin_data,filename,filesize,filetype,title,artist,format,no_cd,track_info,description,price,sale_price,stock_level,reorder_level) ". "VALUES ('$item_no','$category','$image_present','$data','$form_data_name', '$form_data_size', '$form_data_type','$title','$artist','$format','$no_of_cds','$track_info','$description','$price','$sale_price','$stock_level','$reorder_level')");

ok giving it a crack now... hold on to your seats boys and girls.

Sunit

sunit_modi

Nice One Mate... Im impressed!!!!!!!!!!!!!!

It worked.

Great thats the 4th person i owe a beer to in phpbuilder.com
At this rate im going to flat broke

Thanks Again

Sunit
😃 😃 😃 😃 😃 😃 😃

MrAlaska

I'll take a beer anytime!

However, it dawns on me that fix might only work on Windows systems. I didn't even notice I had an \r in there, I believe non-Windows systems send an \n while windows systems send an \r\n (unless I have it backwards.

I suppose one could err on the safe side and use a preg_replace or multiple str_replaces to look for all possibilities. In my own code, however, I am currently switching to this format for now:

$message = nl2br($message);

which is a function provided by PHP that I did not know about until recently :eek:

Weedpacket

Originally posted by MrAlaska
I believe non-Windows systems send an \n while windows systems send an \r\n (unless I have it backwards.

No, you got it the right way around. The Windows convention of using two characters to indicate a new line in a text file is a hold over line-printer operation in the CP/M operating system it evolved from; it literally means "carriage-return, line-feed".

And note: Macintoshes just use an "\r".

MrAlaska

Originally posted by Weedpacket
And note: Macintoshes just use an "\r".

Damn, now I am gonna hafta check out the nl2br() function and make sure it does it right, or go back to explicitly checking for all combinations.

Do I know you Weedpacket? The guy I first heard about this from was an old school programmer I met at a Java class at WPI. You look and 'talk' just like him!

Weedpacket

Originally posted by MrAlaska
Do I know you Weedpacket? The guy I first heard about this from was an old school programmer I met at a Java class at WPI. You look and 'talk' just like him!

I'm afraid not; WPI? But I'll tell you...

Due to a critical shortfall in experienced programmers at a time when data processing was really taking off and becoming such an integral part of modern civilisation, a whole batch of us were cloned. However, success was too patchy for the practice to become economical - one of us became a mathematician, one a programmer, one became a comedian, one runs a commune in Melanesia, and one still isn't allowed access to sharp objects or writing instruments.

MrAlaska

lol I am afraid to ask!

(WPI is a school I went/am going to that I still haven't learned to spell the full name)