编辑phpmyadmin blob字段 [英] edit phpmyadmin blob field

问题描述

嗯.

与在phpMyAdmin中查看Blob的内容相同，我有斑点.

就像给定URL的屏幕截图中一样，它显示为"blob".谢谢，phpmyadmin！你是最棒的！

And just like in the screenshot of the given url, it says "blob". Thanks, phpmyadmin! You're the best!

不过，与询问上述问题的家伙不同，我真的想编辑 blob值，然后保存它们.因此，如果我的Blob的文本为"ima blob yo"，并且由于上述解决方案，我可以看到该文本-我如何将其编辑为我是blob， .

Unlike the chap who asked the question above, though, I really want to edit the blob values, and then save them. So, if my blob has, as its text "ima blob yo" - and I can see that text, thanks to the solution given above - how do i edit that to "i am a blob, you".

我不希望每次编辑Blob时都上传文本文件，这就是手提包Bogue.就像我将要编辑文本字段一样，只想对其进行编辑.

I don't particularly want to upload a text file each time i edit a blob, that's totes bogue. Just want to edit it, as i would a text field.

欢呼！

推荐答案

啊. phpmyadmin网站上的此页面: http://www.phpmyadmin.net/documentation/#faq1_31

Ah. the phpmyadmin site, there this page: http://www.phpmyadmin.net/documentation/#faq1_31

$cfg['ProtectBinary'] boolean or string
Defines whether BLOB or BINARY columns are protected from editing when browsing a table's content. Valid values are:

    * FALSE to allow editing of all columns;
    * 'blob' to allow editing of all columns except BLOBS;
    * 'all' to disallow editing of all BINARY or BLOB columns.

好，接下来详细介绍如何允许我编辑Blob.

Ok, so that details how to allow me to edit my blobs.

我做了更改

$cfg['ProtectBinary'] = FALSE;
$cfg['ShowBlob'] = TRUE;

并将这两行作为我的config.inc.php文件的最后一行，由于我使用的是UBUNTU并使用了自动安装sudo apt-get install phpmyadmin，因此它们位于/etc/phpmyadmin/

and put these two as the last lines in my config.inc.php file, which, because i'm using UBUNTU and used the auto install sudo apt-get install phpmyadmin, was at /etc/phpmyadmin/

一切正常，有点.现在，我可以编辑我的Blob ...限制为phpmyadmin在"blob-view"中显示blob的当前内容，这是一堆数字或一些废话.

And everything worked, kinda. I can now edit my blobs... with the limitation that phpmyadmin shows the current contents of the blob in "blob-view", which is a whole bunch of numbers or some nonsense.

我发现一个简单的解决方案是:

Simple solution i found was to:

1. 覆盖文字.简单编辑并不是真正的选择，但是幸运的是，我不需要编辑，只需添加新数据即可.
2. 将功能"选项从...更改为……我不记得它是什么了，但这有点疯狂……只是空白".这与其他选项的函数选项默认值(整数等)相同.

欢呼声， 安德鲁

PS

$cfg['ShowBlob'] = TRUE;

来自我链接到的问题中的给定URL.张贴者指出这在phpmyadmin中无效，但几个月前我仅使用最新的sudo-get下载，因此仍然有效.实际上，我需要将该值输入以使编辑工作.

was from the given url in the question i linked to. The poster states it isn't effective in phpmyadmin, but i only downloaded using a latest sudo-get a few months back, so it still works. Actually, i needed to put that value in to get editing to work.

这篇关于编辑phpmyadmin blob字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！