PROS! Something easy? Converting/Replacing

brianb

Hello,

Here's my dilema...

I have certain data being entered into my MySQL database. The for mat the data show up in isn't always the same, but I need it to be entered into my DB the same each time...

Here's how things have been going into my database:

Example 1: Data1
Example 2: Data1 
Example 3: Data1 Data2
Example 4: Data1 Data2 
Example 5: Data1 Data2 
Example 6: Data1 Data2

Now, the data has been going in in one of these patterns...so, you can see when I query my database the HTML can look a little funky...

Before this data goes into my DB, I'd like it to be formatted in 1 of 2 ways:

If the return only brings back 1 entry of data like:
 Data1
OR
Data1 
...then I'd like it to print just that data and NO html .
If the return brings back 2 entries of data like any of these:

Data1 Data2
 Data1 Data2 
Data1 Data2 
 Data1 Data2

I'd like what's in betwen those break tags to be seperated by commas, of course getting rid of those pesky breaks at the beginning and end of the strings...

Any help is appreciated!

Thanks in advance!

diego25

Try this:

<?php 
function format($str) {
  $str = preg_replace('/(^<br>)|(<br>$)/i', '', $str);
  $str = str_replace(array('<br>','<BR>'), ',', $str);
  return $str;
}

print format('<BR>Data1') . "\n";
print format('Data1<BR>') . "\n";
print format('<BR>Data1<BR>Data2') . "\n";
print format('<BR>Data1<BR>Data2<BR>') . "\n";
print format('Data1<BR>Data2<BR>') . "\n";
print format('<BR>Data1<BR>Data2<BR>') . "\n";
?>

Diego

brianb

Hi!

Working like a charm for everything except the entries with the tags at the begining...like so:

Data1

How to I get rid of that tag? Something like this?

$str=preg_replace('/(^ )|( $)/i','',$str);

Please help. We're almost there!!!

cmburns69

A design decision that might make everything easier in the long run (but I don't know, given my limited knowledge of the problem) would be to change your database structure to have a column for data1 and data2. You could strip out the " "s before you inserted the data, and then just display it at will.

Tom Brown
Netnexus: Where gamers play
http://www.netnexus.com

brianb

That's what were doing here...but the everything needs to be stored into the same field.

Anyone have any ideas on this?

basically, IF a tag is prsent at the front of the data...strip it!

diego25

I'm just trying to repost the same code again...

<?php

function format($str) {

  $str = preg_replace('/(^<br>)|(<br>$)/i', '', $str);

  $str = str_replace(array('<br>','<BR>'), ',', $str);

  return $str;

}



print format('<BR>Data1') . "\n";

print format('Data1<BR>') . "\n";

print format('<BR>Data1<BR>Data2') . "\n";

print format('<BR>Data1<BR>Data2<BR>') . "\n";

print format('Data1<BR>Data2<BR>') . "\n";

print format('<BR>Data1<BR>Data2<BR>') . "\n";

?>

Diego

diego25

Ok, for some reason the board is adding a space after the :

$str = preg_replace('/(^ )|(

it should be (hopefully it will output ok):

$str = preg_replace('/(^ )|(

<edit>Ok, it didn't output correctly. Ok, then just remove the space you see after the and before the parenthesis</edit>

After you change that, my function will work as expected.

Diego

brianb

hahaha...

I know how it is. I can't even copy and paste anything from this board or I'll get parse errors up the ying yang because of weird characters that get entered.

Anyway, I retyped the entire function from scratch and everything works like a charm!

Thanks for the help! I understand how it works now!

Thanks again! 🙂