how to optimize my html code

Question

i have been saving buffer content in a mysql text field , but when content exceeded the number of characters limit, code is crunched.

so how can i optimize html buffer content by removing tabs and white spaces from the code using php ?

What problem are you trying to solve? Why are you even storing HTML in your database to begin with? — kba, Apr 12 '12 at 13:19
I'm with Kristian here, it's best to not store compiled HTML in a database. It gets messy, and you're just running into one of the problems now. — MetalFrog, Apr 12 '12 at 13:21

score 0 · Answer 1 · edited May 23 '17 at 12:11

0

You could use a regular expression like:

preg_replace("/\s+/", " ", $string);

That should replace all multiple white-spaces, tabs and new-lines with just one.

See also: How do I remove extra spaces, tabs and line feeds from a sentence and substitute them with just one space?

edited May 23 '17 at 12:11

Community

1
1

answered Apr 12 '12 at 13:13

tonymarschall

3,862
3
29
52

4
Now watch `
```
` elements blow up.
```
– Quentin Apr 12 '12 at 13:17
1

Not to mention scripts and attribute values. – Mr Lister Apr 12 '12 at 13:18
surely scrambled. But we are not into the OP problems with his html; though suggesting to add that it must be scriptless and pre-less html is good, going to add it to my ans – ShinTakezou Apr 12 '12 at 13:28

score 0 · Answer 2 · answered Apr 12 '12 at 13:17

0

You could compress the data with a function such as gzdeflate. See http://php.net/manual/en/function.gzdeflate.php

If this needs to go into a non-binary safe location, you could base64_encode the gzipped string, and store afterwards.

answered Apr 12 '12 at 13:17

pp19dd

3,625
2
16
21

ShinTakezou · Accepted Answer · 2012-04-12T13:31:05.033

0

Why don't you use a type able to keep all your data? E.g. LONGTEXT or MEDIUMTEXT? You can however strip away all repetition of space character using

preg_replace("/\s+/", " ", trim($s));

ADD

As noticed in comments, this will crunch every repeated "space" character even when it's meaningful. This won't work with default pre tag style, and with any other tag with CSS that changes the white-space attribute.

edited Apr 12 '12 at 13:31

answered Apr 12 '12 at 13:24

ShinTakezou

9,432
1
29
39

"won't work" means it will work, indeed, but it will waste the look of the original html. – ShinTakezou Apr 12 '12 at 13:33

how to optimize my html code

3 Answers3