How to strip data out of html code in MYSQL/PHP

Question

I have a table in MYSQL that looks like this (notice the html code):

===================================================================|
|           Question                         |   Answer            |
=========+===========+=============================================|
| <p> Do you listen to music? </p>           |        YES          |            
|------------------------------------------------------------------|
| Who is your favorite music artists?        | Justin Beiber       | 
|------------------------------------------------------------------|
|<script>Are you a Male or female?</script>  |      M              | 
|------------------------------------------------------------------|

I am using PHPExcel in PHP to extract that data and place it in an excel file, and that table is what my excel file looks like.

In excel I want the html removed so that the fields only contain the question:

===================================================================|
|           Question                         |   Answer            |
=========+===========+=============================================|
|     Do you listen to music?                |        YES          |            
|------------------------------------------------------------------|
| Who is your favorite music artists?        | Justin Beiber       | 
|------------------------------------------------------------------|
|      Are you a Male or female?             |      M              | 
|------------------------------------------------------------------|

The code in PHP:

$col=1; // 1-based index
while($row_data = mysql_fetch_assoc($result)) {

$row= 1;

    foreach ($row_data as $key=>$value) {

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$row++;
    }
    $col++;

}

$row=1;
while($row_data = mysql_fetch_assoc($result2)) {
$col=0;

    foreach($row_data as $value) {

   $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
        $row++;

    $col++;}
}

Is this question the same as stackoverflow.com/questions/13243332 ? — Pang
– Pang, Commented Dec 4, 2012 at 0:53
No, that question is how to remove a row with html. This is just about stripping the html and leaving the data. — Merica
– Merica, Commented Dec 4, 2012 at 1:00

Community · Accepted Answer · 2023-11-17 20:42:18Z

2

Use strip_tags()

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, strip_tags($value));

This is a good example of why HTM should not be mixed with content in a database

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Dec 4, 2012 at 0:51

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Merica Over a year ago

You're right about that. I didn't think it would be so easy. Thanks!

Collectives™ on Stack Overflow

How to strip data out of html code in MYSQL/PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related