doumi9618 2017-11-18 08:20
浏览 122

转义后如何将原始字符串保存到MYSQL中?

Example:

<?php
$uid = 'Pat/r'ick';
$string = mysql_escape_string($uid);

$query = 'INSERT INTO user (uid) VALUES ($string)';

?>

After escaped the string, mysql insert value 'Pat//r/'ick' into the table. What I understand is mysql_escape_string is just to escape string so that the query can run without any issue then still should be able to save the original value of the string after escaped. In this case, I expect Mysql to save value 'Pat/r'ick' into the table.

Can someone help me how to save the original string after escaped the string in the query?

  • 写回答

1条回答 默认 最新

  • dongyun3897 2017-11-18 09:06
    关注

    Maybe you have magic quotes enabled and the string is double quoted. So, turn off magic quotes in the php.ini.

    http://php.net/manual/en/security.magicquotes.php

    评论

报告相同问题?

悬赏问题

  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
  • ¥100 连续两帧图像高速减法
  • ¥15 如何绘制动力学系统的相图
  • ¥15 对接wps接口实现获取元数据
  • ¥20 给自己本科IT专业毕业的妹m找个实习工作
  • ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?