douci4026 2012-11-16 10:48
浏览 49
已采纳

echo out mysql_real_escape引号在引用或双引号后切断字符串

I'm experiencing this odd, yet annoying syntax problem for browsers. By coding the way below, I lose all the strings after the special character: "

    echo '<td><input type=text style=width:100px name=itembrand value="' . $itembrand . ' " </td>';
    echo '<td><input type=text style=width:150px name=itemname value="' . $itemname . '" </td>';
    echo '<td><input type=text style=width:150 name=serialnr value="' . $serialnr . '" </td>';
    echo '<td><input type=text style=width:150px name=addinfo value="' . $addinfo . '" </td><td>';

If I code the other way around, I lose everything after the ':

    echo "<td><input type=text style=width:37px name=code value='" . $code ."' </td>";
    echo "<td><input type=text style=width:100px name=itembrand value='" . $itembrand . "' </td>";
    echo "<td><input type=text style=width:150px name=itemname value='" . $itemname . "' </td>";
    echo "<td><input type=text style=width:150 name=serialnr value='" . $serialnr . "' </td>";
    echo "<td><input type=text style=width:150px name=addinfo value='" . $addinfo . "' </td><td>";

What is the correct syntax, to echo out database items even with ' and " together with the strings after it?

Note:
I'm using <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> and the database entry is right, so this must be something with the syntax.

  • 写回答

1条回答 默认 最新

  • drt41563 2012-11-16 10:48
    关注

    Ok, I used htmlspecialchars() to get this right. The code will be like:

        echo '<td><input type=text style=width:100px name=itembrand value="' . htmlspecialchars($itembrand) . ' " </td>';
        echo '<td><input type=text style=width:150px name=itemname value="' . htmlspecialchars($itemname) . '" </td>';
        echo '<td><input type=text style=width:150 name=serialnr value="' . htmlspecialchars($serialnr) . '" </td>';
        echo '<td><input type=text style=width:150px name=addinfo value="' . htmlspecialchars($addinfo) . '" </td><td>';
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测