Lists within articles

JMJimmy

Hi,

I'm attempting to create a news system for a friend and I've come accross a stumbling point. Right now I have the following script:

$results = query("SELECT headline, article WHERE articleId = '$_GET[aid]'");
if(num_rows($results) > 0){
while($line = fetch_assoc($results)){
$headline  = stripslashes($line[headline]);
$article   = explode("<br />", nl2br(stripslashes($line[article])));
}
} else {
//do something else
}

This works well and puts it into the HTML template just fine echoing out the first two elements in the array into specific points to allow for an image then looping through the rest of the array to spit it all out. All surrounded by tags. However he would like to be able to put ]LIST[some text]/LIST[ into the code and apply different rules to that section. Very similar to the ]LIST[ ...code... ]/LIST[ in these forums.

within the ]LIST[]/LIST[ section of code new lines should only be replaced by and not put into tags.

I have no personal experience with anything like this and searches in google and phpbuilder.com haven't turned up anything I could apply.

Any help would be appreciated.

Thanks,

JMJimmy

LordShryku

Fairly suprizing that this works, considering you don't specify which table to pull from in your SQL query....

JMJimmy

...FROM news...

it's actually a longer set of code & a longer query - I deleted a bunch to make it easier to read. Deleted FROM news by accident.

JMJimmy

tbach2

I would imagine what you need is preg_match, although I'm too brain dead to figure out the regex at the moment.

could you explain what this accomplishes:

explode("<br />", nl2br(stripslashes($line[article])));

JMJimmy

Sure,

The user enters information as they would in this forum, to preserve new lines I call the nl2br() function however in the html template there is an image enclosed in a table, if you have the following that is created by nl2br():

article text 
article text <TABLE><tr><td><img src=someimg></td></tr></table>
article text 
etc

you end up with an image in between two paragraphs:

texttexttext //array element 1
texttexttext //array element 2
image
image
image
texttexttext //array element 3
etc

So I call explode on the tags to put the text into an array. I spit out the first two elements of that array into pre-placed tags and then loop through the rest of the array echoing out as $array[$i] the end result is:

texttexttext //array element 1
text image //array element 2 & single image
text image
text image
texttexttext //array element 3
etc

Essentially making a practical replacement for the ALIGN property in IMG tags. Now, before ppl start saying "why didn't you just do it on \n or \r instead of doing both nl2br and explode" the reason is that it didn't handle multiple vs single new lines properly - it would skip some lines for some reason... I'm assuming because of some lines having \n and others \n\r

As for preg_match you're thinking something like:

preg_match_all("/^[\[LIST\]]+*+[\[\/LIST\]]", $article_array[$i], $lists, PREG_SET_ORDER)){
for($i=0;$i<$lists;$i++){
  $html .= '<LI>'.$lists[$i].'</LI>';
}
echo $html;

something like that? I have never used preg_match (and avoid regex at all costs... I'm really bad at them lol, I'm sure the one above is all wrong). If that is right how do yo get it back into the correct spot in the article to be spit out (since it would be called prior to nl2br())?

JMJimmy