PHP: How can I cache a page using output buffer?

Question

I'm trying to cache a page that gets/processes data from very slow API's - so I can load it quickly to the user. But for some reason the output buffer is empty?

<?php

ob_start();

// here I have php scripting accessing api's for information

?>


// Here I have HTML content with some php conditions and echos to filter and display the gathered information

// then I try to save the buffered page to the database:

<?php

//connect to database
$page = ob_get_contents();

mysql_query("UPDATE `pages` SET `page_cache` = '" . $page . "' WHERE `page_id` = '" . $page_id . "'");

?>

Any help would be appreciated!

What is the output if you var_dump($page) instead of issuing a query? — Jeff Lambert
– Jeff Lambert, Commented May 21, 2012 at 15:16
You should call ob_end_clean() at the end of working with output buffer. Try to comment ob_start() - do you see any output? — Jan Turoň
– Jan Turoň, Commented May 21, 2012 at 15:18
What Jan means is what do you see if you don't buffer anything, but just display the page. — Cylindric
– Cylindric, Commented May 21, 2012 at 15:27

Cylindric · Accepted Answer · 2012-05-21 15:14:57Z

1

Are you making sure your $page contains only database-safe characters?

What happens if the output contains a single ' for example?

answered May 21, 2012 at 15:14

Cylindric

5,8945 gold badges48 silver badges70 bronze badges

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

3 Comments

Joe Over a year ago

I try to echo or print_r $page before it gets to the database bit and it prints nothing

Cylindric Over a year ago

Hmm okay, so it doesn't seem to be a database query error. (Although you do need to sort that too)

Joe Over a year ago

cool thanks for the heads up for when I hopefully get this working :)

pp19dd · Accepted Answer · 2012-05-21 15:25:49Z

0

You may want to let MySQL encode that $page variable:

mysql_query(sprintf(
    "UPDATE `pages` SET `page_cache`='%s' WHERE `page_id`=%s",
    mysql_real_escape_string( $page ),
    intval( $page_id )  // assuming it's an int
));

answered May 21, 2012 at 15:25

pp19dd

3,6232 gold badges18 silver badges21 bronze badges

1 Comment

Cylindric Over a year ago

@Joe, this is basically what I was talking about to keep your inserts clean :)

Suman · Accepted Answer · 2012-05-21 22:14:36Z

0

Check whether output buffering is on in your /etc/php.ini: http://www.php.net/manual/en/outcontrol.configuration.php

Also, do an:

<?php echo ob_get_contents(); ?>

If it prints FALSE, then output buffering may not be enabled: http://php.net/manual/en/function.ob-get-contents.php

answered May 21, 2012 at 22:14

Suman

9,6215 gold badges52 silver badges65 bronze badges

Collectives™ on Stack Overflow

PHP: How can I cache a page using output buffer?

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related