如何将html存储在mysql数据库中 [英] How to store html in a mysql database

问题描述

我试图将HTML存储在数据库中，因此当我从数据库中检索表单时，我需要将其显示为表单而不是文本。 有没有办法做到这一点？

这是表格

<$ p $
< input type ='hidden'name ='my-name ='< form id =''method =''action =''class =''>
& item-id'value = $ uid />
< input type ='hidden'name ='my-item-name'value = $ title />
< input type ='hidden 'name ='my-item-price'value ='1'/>
< input type ='hidden'name ='my-item-qty'value ='1'/>
< input type ='submit'name ='my-add-button'class ='button'value ='Add to cart'/>
< / form>;

当我从数据库检索上述内容时，它显示为文本，

数据库中的表单域也是 varchar（1000）

 包括（ 'adodb.inc.php'）; 
 include（'adodb-pager.inc.php'）; 
 $ sql ='选择title为TITLE，描述为DESCRIPTION，形式为添加到数据库，由数据库顺序sysdate desc'; 
 $ pager = new ADODB_Pager（$ db，$ sql）; 
 
 $ pager-> Render（）; 
  

谢谢

解决方案在数据库中存储文本时，可能使用 addslashes（）。

然后，当您从数据库返回文本时，需要类似在显示HTML文本之前， stripslashes（）。 PHP手册

I'm trying to store HTML in a database, so when I retrieve the form from the database, I need to show it as a form rather than text. Is there a way to do that?

This is the form

$form = "<form id='' method='' action='' class=''>
    <input type='hidden' name='my-item-id' value= $uid />
    <input type='hidden' name='my-item-name' value=$title />
    <input type='hidden' name='my-item-price' value='1' />
    <input type='hidden' name='my-item-qty' value='1' />
    <input type='submit' name='my-add-button' class='button' value='Add to cart'/>
     </form>";

at the moment when I retrieve the above from the database it shows as text,

also the form field in the database is varchar(1000)

include('adodb.inc.php');
include('adodb-pager.inc.php');
$sql = 'select title as "TITLE",description as "DESCRIPTION",form as "ADD TO CART" from mathspapers order by sysdate desc';
$pager = new ADODB_Pager($db,$sql);

$pager->Render();

Thanks

解决方案

When you are storing text in Database you probably use addslashes().
Then when you return text from Database you need something like stripslashes() before you show your HTML text. PHP Manual on stripslashes

这篇关于如何将html存储在mysql数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！