unix command to delete line break for php command

Question

I have php files with SQL queries broken into multiples lines. for example:

$sql = "select count( aa." . BOOK_ART_ID . ") as book_count
                from " . BOOK_ART_TABLE . " as aa
                inner join " . AUTHER_TABLE . " as l on aa." . BOOK_ART_AUTHER_ID . " = l." . AUTHER_ID . " AND
                    l." . AUTHER_CODE . " = '" . "'     
                where aa." . BOOK_ART_TITLE_ID . " = " . $book_id;

I'm trying to extract all SQL statements from the PHP files. I tried grep on $sql and only getting the first line back.

How do I extract entire SQL string from all PHP files?

I was thinking more around deleted line break until ';' character.

Seeing as the SQL contains PHP constants, what use it this going to be? You'd be better off to parse the string in PHP and output it no? — scrowler
– scrowler, Commented Sep 23, 2015 at 0:47

sat · Accepted Answer · 2015-09-23 05:22:04Z

1

You can try this sed,

sed -n '/\$sql/{ :loop; N; s/ *\n *//g; /;/{p;q}; t loop}' yourfile

Test:

$ sed -n '/\$sql/{ :loop; N; s/ *\n *//g; /;/{p;q}; t loop}' yourfile
$sql = "select count( aa." . BOOK_ART_ID . ") as book_countfrom " . BOOK_ART_TABLE . " as aainner join " . AUTHER_TABLE . " as l on aa." . BOOK_ART_AUTHER_ID . " = l." . AUTHER_ID . " ANDl." . AUTHER_CODE . " = '" . "'where aa." . BOOK_ART_TITLE_ID . " = " . $book_id;

edited Sep 23, 2015 at 5:22

answered Sep 23, 2015 at 0:49

sat

15k7 gold badges49 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

unix command to delete line break for php command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related