Ar kādu funkciju varētu izdzēst "Tukšās rindas" ?

[xmas12]

Sveiki.

Jautājums: Ar kādu funkciju izvadot tekstu no datubāzes - varētu izdzēst tukšās rindas, kuras tiek ievadītas nospiežot vairakas reizes "enter pogu"?

[briedis]

$teksts_bez_rindam = str_replace(array("\n", "\r"), null, $teksts);

Edited August 24, 2012 by briedis

[xmas12]

$teksts_bez_rindam = str_replace(array("\n", "\r"), null, $teksts);

tāpat izvada tas tukšās rindas.

[zintis8789]

Paradi sql lauka info

[xmas12]

Paradi sql lauka info

Izvada no IPB foruma tabulām.. Lauka nosaukums: "post" ar apzīmējumu: "mediumtext". Un pats teksts šis standarta:

 

W[b]elcome to your new Invision P[/b]ower Board!<br />
<br />
 <br />
<br />
Congratulations on your purchase of our software and setting up your community.  Please take some time and read through the Getting Started Guide and Administrator Documentation.  The Getting Started Guide will walk you through some of the necessary steps to setting up an IP.Board and starting your community. The Administrator Documentation takes you through the details of the capabilities of IP.Board.<br />
<br />
 <br />
<br />
You can remove this message, topic, forum or even category at any time.

[xmas12]

Izdevās pašam. Izmantoju:

 

$jauns_teksts = preg_replace('/<br \/>/iU', '', $vecais_teksts);

 

Un izdzēsu visus <br /> tagus arā.

[daGrevis]

\s{2,}