使用 PHP 将 LaTeX 公式插入 MySQL 时会自动删除反斜杠 [英] Backslashes are auto-removed while inserting LaTeX formulas to MySQL with PHP

问题描述

我正在用PHP编写简单的数学问题生成程序.有添加问题的用户，也有可以自我检查的用户.对于数学公式的问题，我正在使用LaTeX.但是在将公式插入MySQL数据库后，反斜杠被删除，公式变得不可用.这是LaTeX公式的示例:

I'm writing simple math question generating program in PHP. There are users who add questions, and users who can examine themselves. For the questions with math formulas I am using LaTeX. But after inserting formula to MySQL database backslashes are removed and formula becomes unusable. Here is example of LaTeX formula:

\[
  \mathbf{V}_1 \times \mathbf{V}_2 =
   \begin{vmatrix}
    \mathbf{i} & \mathbf{j} & \mathbf{k} \\
    \frac{\partial X}{\partial u} & \frac{\partial Y}{\partial u} & 0 \\
    \frac{\partial X}{\partial v} & \frac{\partial Y}{\partial v} & 0 \\
   \end{vmatrix}
\]

和插入数据库后的公式相同:

And same formula after insertion to database:

[
  mathbf{V}_1   imes mathbf{V}_2 =
   egin{vmatrix}
    mathbf{i} & mathbf{j} & mathbf{k} 
    frac{partial X}{partial u} & frac{partial Y}{partial u} & 0 
    frac{partial X}{partial v} & frac{partial Y}{partial v} & 0 
   end{vmatrix}
]

此公式在渲染后如何显示:

And how this formula shown after being rendered :

如何防止自动删除反斜杠?

How can I prevent auto removing of backslashes?

推荐答案

在插入包含LaTeX公式的字符串之前，我已经在php中尝试了此功能，并且可以正常工作:

I've tried this function in php before inserting the string containing LaTeX formula and it works:

$question_with_latex = mysql_real_escape_string($question_with_latex); 

这篇关于使用 PHP 将 LaTeX 公式插入 MySQL 时会自动删除反斜杠的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！