doufen3838 2012-01-19 07:53
浏览 117
已采纳

在MYSQL数据库上更新base64_encode()序列化数组? [关闭]

after saving base64_encode() serilized array now I do have a problem on how to update the data

Array
(
    [dates] => Array
        (
            [0] => 2012-01-18
            [1] => 2012-02-18
            [2] => 2012-03-18
            [3] => 2012-04-18
            [4] => 2012-05-18
        )

    [amount] => Array
        (
            [0] => 2000
            [1] => 2000
            [2] => 2000
            [3] => 2000
            [4] => 2000
        )

    [deposit] => Array
        (
            [0] => 0
            [1] => 0
            [2] => 0
            [3] => 0
            [4] => 0
        )

)

for example I want to update the value of [deposit][2] where [dates][2] 2012-03-18

I have no idea on how to update the base64_encode() serilized array, is this posible to make?

-> after hearing from expert answer I do change my database structure with Col. Shrapnel advice thank you so much to all response

  • 写回答

2条回答 默认 最新

  • dongpu1331 2012-01-19 08:20
    关注

    That is why storing base64 encoded serialized data in the database is extremely bad idea.

    You have to redesign your database, getting rid of base64_encode and serialized data.
    While using base64 with database makes absolutely no sense by any means, storing serialized data in the database is like mending an electronic device with stone hammer.

    The main difference between database and ancient scroll of parchment is to give an individual access to whatever bit of information, and you are ruined that purpose completely, using stone-age way of storing data. Please, educate yourself and learn proper ways of using databases.

    Database itself IS a perfect storage for the data structure from your example. You just have to add another table with fields date, amount, deposit and record_id and link that table to one that currently contains that base64 encoded array.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图问题
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题