donglu9978 2018-06-16 23:33
浏览 97
已采纳

MariaDB 10.2 json插入对PHP无效

I'm trying to save a lot of data inside my MariaDB 10.2 database with JSON. The data contain's ' " / \ | and a lot more special characters.

When I do json_encode and after that directly json_decode I got a nice working array, however, when I use json_encode and saves it to the database and after I select the column and do json_decode it will return NULL in PHP. Also JSON_VALID('ms_routing_data') in SQL returns mostly 0.

Before this, all my data was stored serialized in the database without having problems with special characters.

Here I have an example of my script and data from my database. https://pastebin.com/EWvFr10p

  • 写回答

1条回答 默认 最新

  • dtxa49711 2018-06-17 14:39
    关注

    I got my problem solved. It was easier than I thought it would be.

    I can just use the most basic variant of json_encode() without flags. All I needed to is adding mysqli_real_escape_string() on my insert. Now all my data returns valid JSON.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 输出区间内所有的完数的个数。 要简单点的程序
  • ¥15 asp.core 权限控制怎么做,需要控制到每个方法
  • ¥20 while循环中OLED显示中断中的数据不正确
  • ¥15 这个视频里的stm32f4代码是怎么写的
  • ¥15 串口发送数据和接收数据
  • ¥15 JNA调用DLL报堆栈溢出错误(0xC00000FD)
  • ¥15 请教SGeMs软件的使用
  • ¥15 自己用vb.net编写了一个dll文件,如何只给授权的用户使用这个dll文件进行打包编译,未授权用户不能进行打包编译操作?
  • ¥50 深度学习运行代码直接中断
  • ¥20 需要完整的共散射点成像代码