blocks|key|1372044|text|一般来说，是的，序列化和反序列化是可行的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372045|但是，如果您的数据很简单，保存为逗号分隔的字符串可能更适合存储空间。例如，如果您知道您的数组将只是一个数字列表，那么您应该使用内爆/爆炸。这就是1,2,3和a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}之间的区别。|offset|length|style|CODE|1372046|如果不是，则序列化和反序列化所有情况下的工作。|1372047|entityMap^0|0|20|5|26|U|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

Generally, yes, serialize and unserialize are the way to go.

If your data is something simple, though, saving as a comma-delimited string would probably be better for storage space. If you know that your array will just be a list of numbers, for example, then you should use implode/explode. It's the difference between <code>1,2,3</code> and <code>a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}</code>.

If not, then serialize and unserialize work for all cases.

blocks|key|1372203|text|只需使用序列化PHP函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372204|<?php
$myArray+=+array('1',+'2');
$seralizedArray+=+serialize($myArray);
?>|code-block|syntax|javascript|1372205|但是，如果您使用的是像这样的简单数组，那么您还不如使用implode和explode.Use一个空数组，而不是new。|1372206|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Just use the serialize PHP function:

<pre><code>&lt;?php
$myArray = array('1', '2');
$seralizedArray = serialize($myArray);
?&gt;
</code></pre>

However, if you are using simple arrays like that you might as well use implode and explode.Use a blank array instead of new.

blocks|key|1372583|text|序列化/取消序列化用于在数据库中存储的数组|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372584|访问http://php.net/manual/en/function.serialize.php|offset|length|1372585|来自PHP手册：|1372586|在页面上的"Return“下查看|1372587|返回一个字符串，该字符串包含可以存储在任何地方的值的字节流表示形式。|1372588|请注意，这是一个可能包含空字节的二进制字符串，因此需要进行存储和处理。例如，serialize()输出通常应该存储在数据库的BLOB字段中，而不是CHAR或文本字段中。|1372589|注意:如果要将html存储到blob中，请确保对其进行base64编码，否则可能会破坏序列化函数。|1372590|示例编码：|1372591|$YourSerializedData+=+base64_encode(serialize($theHTML));|code-block|syntax|javascript|1372592|$YourSerializedData现在可以存储在blob中了。|style|CODE|1372593|从blob获取数据后，您需要base64_decode，然后反序列化示例解码：|1372594|$theHTML+=+unserialize(base64_decode($YourSerializedData));|1372595|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.serialize.php^0|0|2|1B|0|0|0|0|0|0|0|0|0|0|J|0|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|F|3|G|5|6|7|1H|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1I|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1J|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1K|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1L|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1M|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1N|8|@]|9|@]|A|$U|V]]|$1|W|3|X|5|6|7|1O|8|@$D|1P|E|1Q|Y|Z]]|9|@]|A|$]]|$1|10|3|11|5|6|7|1R|8|@]|9|@]|A|$]]|$1|12|3|13|5|T|7|1S|8|@]|9|@]|A|$U|V]]|$1|14|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|1B]]]]

Serialize/Unserialize array for storage in a DB

Visit <a href="http://php.net/manual/en/function.serialize.php" rel="noreferrer">http://php.net/manual/en/function.serialize.php</a>

From the PHP Manual:

Look under "Return" on the page

Returns a string containing a byte-stream representation of value that can be stored anywhere.

Note that this is a binary string which may include null bytes, and needs to be stored and handled as such. For example, serialize() output should generally be stored in a BLOB field in a database, rather than a CHAR or TEXT field.

Note: If you want to store html into a blob, be sure to base64 encode it or it could break the serialize function. 

Example encoding: 

<pre><code>$YourSerializedData = base64_encode(serialize($theHTML));
</code></pre>

<code>$YourSerializedData</code> is now ready to be stored in blob.

After getting data from blob you need to base64_decode then unserialize
Example decoding:

<pre><code>$theHTML = unserialize(base64_decode($YourSerializedData));
</code></pre>

blocks|key|1372362|text|我发现最好的方法是将数组保存为带有分隔符的数据字符串|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372363|$array+=+array("value1",+"value2",+"value3",+"...",+"valuen");
$array_data+=+implode("array_separator",+$array);

$query+=+"INSERT+INTO+my_tbl_name+(id,+array_data)+VALUES(NULL,'"+.+$array_data+.+"');";|code-block|syntax|javascript|1372364|然后，您可以使用简单的查询搜索存储在数组中的数据|1372365|$query+=+"SELECT+*+FROM+my_tbl_name+WHERE+array_data+LIKE+'%25value3%25'";|1372366|使用explode()函数将"array_data“字符串转换为数组|1372367|$array+=+explode("array_separator",+$array_data);|1372368|请注意，这不适用于多维数组，并确保您的"array_separator“是唯一的，并且在数组值中不存在。|1372369|小心！如果您只是将表单数据放入数据库中，您将陷入陷阱，因为表单数据不是SQL安全的！必须使用mysql_real_escape_string处理表单值，或者如果使用MySQLi+mysqli::real_escape_string，或者如果值是整型或布尔型转换(int)+(布尔值|offset|length|1372370|$number+=+(int)$_POST['number'];
$checked+=+(boolean)+$_POST['checked'];

$name+=+mysql_real_escape_string($db_pt,+$_POST['name']);
$email+=+mysqli_obj->real_escape_string($_POST['email']);|1372371|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.mysql-real-escape-string.php|1|http://www.php.net/manual/en/mysqli.real-escape-string.php^0|0|0|0|0|0|0|0|1A|O|0|2H|Q|1|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1D|8|@]|9|@$S|1E|T|1F|1|1G]|$S|1H|T|1I|1|1J]]|A|$]]|$1|U|3|V|5|D|7|1K|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]|14|$5|Z|10|11|A|$12|15]]]]

The best way, that I found to myself is save array as data string with separator characters

<pre><code>$array = array("value1", "value2", "value3", "...", "valuen");
$array_data = implode("array_separator", $array);

$query = "INSERT INTO my_tbl_name (id, array_data) VALUES(NULL,'" . $array_data . "');";
</code></pre>

You can then search data, stored in your array with simple query

<pre><code>$query = "SELECT * FROM my_tbl_name WHERE array_data LIKE '%value3%'";
</code></pre>

use explode() function to convert "array_data" string to array

<pre><code>$array = explode("array_separator", $array_data);
</code></pre>

note that this is not working with multidimensional arrays and make sure that your "array_separator" is unique and had not exist in array values. 

Be careful !!! if you just will take a form data and put in database, you will be in trap, becous the form data isn't SQL-safe ! you must handle your form value 
with <a href="http://php.net/manual/en/function.mysql-real-escape-string.php">mysql_real_escape_string</a> or if you use MySQLi <a href="http://www.php.net/manual/en/mysqli.real-escape-string.php">mysqli::real_escape_string</a>
or if value are integer or boolean cast (int) (boolean) on them 

<pre><code>$number = (int)$_POST['number'];
$checked = (boolean) $_POST['checked'];

$name = mysql_real_escape_string($db_pt, $_POST['name']);
$email = mysqli_obj-&gt;real_escape_string($_POST['email']);
</code></pre>

blocks|key|1156955|text|序列化和反序列化是很常见的。您还可以通过json_encode和json_decode使用JSON来实现一种不太特定于PHP的格式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156956|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Serialize and unserialize are pretty common for that. You could also use JSON via json_encode and json_decode for a less PHP-specific format.

blocks|key|1372523|text|如前所述-如果你不需要在数组中搜索数据，你可以使用serialize+-但这是"php+only“。因此，我建议使用json_decode+/+json_encode+--不仅是为了性能，还为了可读性和可移植性(其他语言，如javascript可以处理json_encoded数据)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1372524|entityMap|0|LINK|mutability|MUTABLE|url|https://www.php.net/manual/en/function.json-decode.php|1|https://www.php.net/manual/en/function.json-encode.php^0|1M|B|0|20|B|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

As mentioned before - If you do not need to search for data within the array, you can use serialize - but this is "php only". So I would recommend to use <a href="https://www.php.net/manual/en/function.json-decode.php" rel="nofollow noreferrer">json_decode</a> / <a href="https://www.php.net/manual/en/function.json-encode.php" rel="nofollow noreferrer">json_encode</a> - not only for performance but also for readability and portability (other languages such as javascript can handle json_encoded data).

blocks|key|1372662|text|您可以将数组保存为json。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372663|有关于json数据类型的文档：https://dev.mysql.com/doc/refman/5.7/en/json.html|offset|length|1372664|我认为这是最好的解决方案，并将帮助您通过避免疯狂的函数来维护代码的可读性。|1372665|我希望这对你有帮助。|1372666|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/json.html^0|0|F|1D|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

You can save your array as a json. 
there is documentation for json data type: <a href="https://dev.mysql.com/doc/refman/5.7/en/json.html" rel="nofollow">https://dev.mysql.com/doc/refman/5.7/en/json.html</a> 
I think this is the best solution, and will help you maintain your code more readable by avoiding crazy functions. 
I expect this is helpful for you.

blocks|key|1157079|text|是的，序列化/反序列化是我在许多开源项目中看到最多的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1157080|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Yup, serialize/unserialize is what I've seen the most in many open source projects.

blocks|key|1372176|text|查看内部函数，由于值在数组中，因此您希望将数组的值放入mysql查询中，该查询将值插入到表中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372177|$query+=+"INSERT+INto+hardware+(specifications)+VALUES+(".implode(",",$specifications).")";|code-block|syntax|javascript|1372178|如果数组中的值是文本值，则需要添加引号|1372179|$query+=+"INSERT+INto+hardware+(specifications)+VALUES+("'.implode("','",$specifications)."')";

mysql_query($query);|1372180|此外，如果您不想要重复的值，请将"+into“切换为"IGNORE”，这样只会将唯一值插入到表中。|1372181|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

check out the implode function, since the values are in an array, you want to put the values of the array into a mysql query that inserts the values into a table.

<pre><code>$query = "INSERT INto hardware (specifications) VALUES (".implode(",",$specifications).")";
</code></pre>

If the values in the array are text values, you will need to add quotes

<pre><code>$query = "INSERT INto hardware (specifications) VALUES ("'.implode("','",$specifications)."')";

mysql_query($query);
</code></pre>

Also, if you don't want duplicate values, switch the "INto" to "IGNORE" and only unique values will be inserted into the table.

blocks|key|1372443|text|我建议使用内爆/爆炸的字符，你知道它不会包含在任何单独的数组项目中。然后将其作为字符串存储在SQL中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372444|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I would suggest using implode/explode with a character that you know will not be contained in any of the individual array items. Then store it in SQL as a string.

blocks|key|1372699|text|您可以将序列化对象(数组)插入到mysql示例serialize($object)中，还可以取消序列化对象示例unserialize($object)的序列化。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1372700|entityMap^0|N|I|1J|K|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

you can insert serialized object ( array ) to mysql , example <code>serialize($object)</code> and you can unserize object example <code>unserialize($object)</code>

blocks|key|1372271|text|不是将其保存到数据库中，而是将其保存到文件中，稍后再调用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1372272|许多php应用程序(比如sugarcrm)只是使用var_export将数组中的所有数据回显到一个文件中。这是我用来保存我的配置数据的方法：|1372273|private+function+saveConfig()+{
++++file_put_contents($this->_data['pathtocompileddata'],'<?php'+.+PHP_EOL+.+'$acs_confdata+=+'+.+var_export($this->_data,true)+.+';');++++++++
}|code-block|syntax|javascript|1372274|我认为这是保存数据的更好方法！|1372275|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Instead of saving it to the database, save it to a file and then call it later. 

What many php apps do (like sugarcrm) is to just use var_export to echo all the data of the array to a file. 
This is what I use to save my configurations data: 

<pre><code>private function saveConfig() {
 file_put_contents($this-&gt;_data['pathtocompileddata'],'&lt;?php' . PHP_EOL . '$acs_confdata = ' . var_export($this-&gt;_data,true) . ';'); 
}
</code></pre>

I think this is a better way to save your data!

What is a good way to save an array of data to a single mysql field? 

Also once I query for that array in the mysql table, what is a good way to get it back into array form?

Is serialize and unserialize the answer?

Save PHP array to MySQL?

将一组数据保存到单个mysql字段的好方法是什么？另外，当我在mysql表中查询该数组时，有什么好方法可以将其恢复为数组形式？序列化和反序列化是答案吗？

问将PHP数组保存到MySQL？
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将PHP数组保存到MySQL？EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将PHP数组保存到MySQL？
EN