How to remove first paragraph of content in PHP?

Question

I have got field in database with intro contentrest of content....

How to remove first paragraph of content intro content using PHP?

assuming you have a string, why not just parse the string for the first instance of "" ? — Joel, Dec 20 '12 at 19:21
Take a look at [`DOMDocument`](http://php.net/manual/en/class.domdocument.php). — Leri, Dec 20 '12 at 19:23
look at Dagon's answer... or you can just query the database and then parse the result with a php function.. int index = strpos($result,""); — Joel, Dec 20 '12 at 19:24
related: [How to parse and process HTML/XML with PHP](http://stackoverflow.com/questions/3577641/how-to-parse-and-process-html-xml-with-php/3577662#3577662) — dualed, Dec 20 '12 at 19:54

score 1 · Accepted Answer · 2012-12-20T19:29:58.290

1

assuming mysql

SELECT SUBSTRING_INDEX(content_field, '</p>', 1) as cut from TABLE

replace in db:

update [table_name] set [field_name] = replace([field_name],SUBSTRING_INDEX([field_name], '</p>', 1),'');

edited Dec 20 '12 at 19:29

answered Dec 20 '12 at 19:21

But it will just select, but how to remove? – Newbie1 Dec 20 '12 at 19:23
[***NO*** Do not use RegEx to parse HTML](http://stackoverflow.com/questions/1732348/regex-match-open-tags-except-xhtml-self-contained-tags) – dualed Dec 20 '12 at 19:24
Why are you assuming it's in a database? – Barmar Dec 20 '12 at 19:24
Yes, but I have got it also as string before saving. In there a way to parse it before saving? – Newbie1 Dec 20 '12 at 19:34
well im now confused as to what you want. – Dec 20 '12 at 19:35
This will fail for everything non-trivial and you will most likely end up with broken markup, consider `
x
` – dualed Dec 20 '12 at 19:39
The solution mentioned in MySQL is fine, but if possible to do it before saving to database then it would be even better. – Newbie1 Dec 20 '12 at 19:40
@Newbie1 No it is not fine, as mentioned in my comment above. You should use a DOM parser like I wrote in my answer and PLB in the question comment. – dualed Dec 20 '12 at 19:41
OK, Thanks I will try to fix it based on your comments. Thanks guys! – Newbie1 Dec 20 '12 at 19:48

score 1 · Answer 2 · answered Dec 20 '12 at 19:26

1

Use a DOM parser. Maybe PHPQuery. You can then select the first element from the DOM and remove it

Pseudo Code:

$dom->firstChild()->remove();

answered Dec 20 '12 at 19:26

dualed

2 Answers2