Question

我试图隐藏一个从非常慢的 API s 获取/处理数据的页面, 这样我就能快速地将数据装入用户。但是由于某种原因, 输出缓冲是空的吗?

<?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 . " ");

?>

任何帮助都会感激不尽!

Answer 1

您是否确保您的 $page 只包含数据库安全字符?

如果输出包含一个单 (例如) 怎么办?

Answer 2

您可以让 MySQL 编码$page 变量 :

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
));

Answer 3

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

同时,做一个:

<?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

友情链接