blocks|key|253299|text|使用implode|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|253300|implode("%7C",$type);|code-block|syntax|javascript|253301|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/implode^0|2|7|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Use <a href="http://php.net/implode" rel="noreferrer">implode</a>
<pre><code>implode(&quot;|&quot;,$type);
</code></pre>

blocks|key|3151095|text|您可以使用json_encode()|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3151096|<?php
$arr+=+array('a'+=>+1,+'b'+=>+2,+'c'+=>+3,+'d'+=>+4,+'e'+=>+5);

echo+json_encode($arr);
?>|code-block|syntax|javascript|3151097|稍后，只需使用json_decode()解码数据库中的字符串即可。其他任何东西都是没有用的，会保持数组关系的完整性以供以后使用！|style|BOLD|3151098|entityMap|0|LINK|mutability|MUTABLE|url|http://us3.php.net/manual/en/function.json-encode.php|1|http://us3.php.net/manual/en/function.json-decode.php^0|5|D|0|0|0|1A|I|7|D|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@$A|12|B|13|K|L]]|9|@$A|14|B|15|1|16]]|C|$]]|$1|M|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

You can use <a href="http://us3.php.net/manual/en/function.json-encode.php" rel="noreferrer">json_encode()</a>

<pre><code>&lt;?php
$arr = array('a' =&gt; 1, 'b' =&gt; 2, 'c' =&gt; 3, 'd' =&gt; 4, 'e' =&gt; 5);

echo json_encode($arr);
?&gt;
</code></pre>

Later just use <a href="http://us3.php.net/manual/en/function.json-decode.php" rel="noreferrer">json_decode()</a> to decode the string from your DB.
Anything else is useless, JSON keeps the array relationship intact for later usage!

blocks|key|255611|text|json_encode($data)+//converts+an+array+to+JSON+string
json_decode($jsonString)+//converts+json+string+to+php+array|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|255612|为什么使用JSON+:您可以在大多数编程语言中使用它，由php的serialize()函数创建的字符串只能在PHP中读取，并且您不会喜欢将这些内容存储在数据库中，特别是当使用不同编程语言编写的应用程序共享数据库时|unstyled|255613|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>json_encode($data) //converts an array to JSON string
json_decode($jsonString) //converts json string to php array
</code></pre>

WHY JSON : You can use it with most of the programming languages, string created by serialize() function of php is readable in PHP only, and you will not like to store such things in your databases specially if database is shared among applications written in different programming languages

blocks|key|3151130|text|最好的方法之一：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3151131|echo+print_r($array,+true);|code-block|syntax|javascript|3151132|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

One of the Best way:

<pre><code>echo print_r($array, true);
</code></pre>

blocks|key|255516|text|不，您不希望将其作为单个字符串存储在数据库中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|255517|您可以使用serialize()，但这将使您的数据更难搜索，更难处理，并浪费空间。|offset|length|style|CODE|255518|你也可以做一些其他的编码，但是它通常容易出现同样的问题。|255519|你有一个数据库的全部原因是这样你就可以很容易地完成这样的工作。您不需要一个表来存储数组，您需要一个可以表示为数组的表。|255520|示例：|255521|id+%7C+word
1++%7C+Sports
2++%7C+Festivals
3++%7C+Classes
4++%7C+Other|code-block|syntax|javascript|255522|您只需使用SQL从表中选择数据，而不是拥有一个如下所示的表：|255523|id+%7C+word
1++%7C+Sports%7CFestivals%7CClasses%7COther|255524|这不是任何人在关系数据库中设计模式的方式，它完全违背了它的目的。|255525|entityMap^0|0|5|B|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|16|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|17|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|V|5|P|7|19|8|@]|9|@]|A|$Q|R]]|$1|W|3|X|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Z|$]]

No, you don't want to store it as a single string in your database like that.

You could use <code>serialize()</code> but this will make your data harder to search, harder to work with, and wastes space.

You could do some other encoding as well, but it's generally prone to the same problem.

The whole reason you have a DB is so you can accomplish work like this trivially. You don't need a table to store arrays, you need a table that you can represent as an array.

Example:

<pre><code>id | word
1 | Sports
2 | Festivals
3 | Classes
4 | Other
</code></pre>

You would simply select the data from the table with SQL, rather than have a table that looks like:

<pre><code>id | word
1 | Sports|Festivals|Classes|Other
</code></pre>

That's not how anybody designs a schema in a relational database, it totally defeats the purpose of it.

blocks|key|256703|text|implode()|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|256704|<?php
$string+=+implode('%7C',$types);|code-block|syntax|javascript|256705|然而，隐姓埋名是正确的，您可能不想以这种方式存储它--这完全是对数据库的关系功能的浪费。|256706|如果您执着于序列化，那么您也可以考虑使用json_encode()|256707|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/implode|1|http://www.php.net/json_encode^0|0|9|0|0|0|0|K|D|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

<a href="http://php.net/implode">implode()</a>:

<pre><code>&lt;?php
$string = implode('|',$types);
</code></pre>

However, Incognito is right, you probably don't want to store it that way -- it's a total waste of the relational power of your database.

If you're dead-set on serializing, you might also consider using <a href="http://www.php.net/json_encode">json_encode()</a>

blocks|key|2936847|text|这个可以保存键和值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2936848|function+array2string($data){
++++$log_a+=+"";
++++foreach+($data+as+$key+=>+$value)+{
++++++++if(is_array($value))++++$log_a+.=+"[".$key."]+=>+(".+array2string($value).+")+\n";
++++++++else++++++++++++++++++++$log_a+.=+"[".$key."]+=>+".$value."\n";
++++}
++++return+$log_a;
}|code-block|syntax|javascript|2936849|希望这能帮助到别人。|2936850|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|$]]

This one saves KEYS &amp; VALUES

<pre><code>function array2string($data){
 $log_a = "";
 foreach ($data as $key =&gt; $value) {
 if(is_array($value)) $log_a .= "[".$key."] =&gt; (". array2string($value). ") \n";
 else $log_a .= "[".$key."] =&gt; ".$value."\n";
 }
 return $log_a;
}
</code></pre>

Hope it helps someone.

blocks|key|256776|text|$data+=+array("asdcasdc","35353","asdca353sdc","sadcasdc","sadcasdc","asdcsdcsad");

$string_array+=+json_encode($data);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|256777|现在您可以将此$string_array值插入到数据库中|unstyled|256778|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>$data = array("asdcasdc","35353","asdca353sdc","sadcasdc","sadcasdc","asdcsdcsad");

$string_array = json_encode($data);
</code></pre>

now you can insert this $string_array value into Database

blocks|key|2936863|text|对于存储关联数组，可以使用serialize|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2936864|$arr+=+array(
++++'a'+=>+1,
++++'b'+=>+2,
++++'c'+=>+3
);

file_put_contents('stored-array.txt',+serialize($arr));|code-block|syntax|javascript|2936865|并使用unserialize加载|2936866|$arr+=+unserialize(file_get_contents('stored-array.txt'));

print_r($arr);|2936867|但是如果需要使用数组创建动态.php文件(例如配置文件)，您可以使用var_export(...,+true);，如下所示：|2936868|保存在文件中：|2936869|$arr+=+array(
++++'a'+=>+1,
++++'b'+=>+2,
++++'c'+=>+3
);

$str+=+preg_replace('#,(\s%2B%7C)\)#',+'$1)',+var_export($arr,+true));
$str+=+'<?php'+.+PHP_EOL+.+'return+'+.+$str+.+';';

file_put_contents('config.php',+$str);|2936870|获取数组值：|2936871|$arr+=+include+'config.php';

print_r($arr);|2936872|entityMap^0|D|9|0|0|3|B|0|0|E|4|Y|M|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1D|8|@]|D|@]|E|$]]|$1|S|3|T|5|H|7|1E|8|@]|D|@]|E|$I|J]]|$1|U|3|V|5|6|7|1F|8|@]|D|@]|E|$]]|$1|W|3|X|5|H|7|1G|8|@]|D|@]|E|$I|J]]|$1|Y|3|-4|5|6|7|1H|8|@]|D|@]|E|$]]]|Z|$]]

For store associative arrays you can use <code>serialize</code>:

<pre><code>$arr = array(
 'a' =&gt; 1,
 'b' =&gt; 2,
 'c' =&gt; 3
);

file_put_contents('stored-array.txt', serialize($arr));
</code></pre>

And load using <code>unserialize</code>:

<pre><code>$arr = unserialize(file_get_contents('stored-array.txt'));

print_r($arr);
</code></pre>

But if need creat dinamic <code>.php</code> files with array (for example config files), you can use <code>var_export(..., true);</code>, like this:

Save in file:

<pre><code>$arr = array(
 'a' =&gt; 1,
 'b' =&gt; 2,
 'c' =&gt; 3
);

$str = preg_replace('#,(\s+|)\)#', '$1)', var_export($arr, true));
$str = '&lt;?php' . PHP_EOL . 'return ' . $str . ';';

file_put_contents('config.php', $str);
</code></pre>

Get array values:

<pre><code>$arr = include 'config.php';

print_r($arr);
</code></pre>

blocks|key|2936885|text|有很多方法，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2936886|两种最好的方法是|2936887|$arr+=+array('a'+=>+1,+'b'+=>+2,+'c'+=>+3,+'d'+=>+4,+'e'+=>+5);
echo+json_encode($arr);
//ouputs+as
{"a":1,"b":2,"c":3,"d":4,"e":5}


$b+=+array+('m'+=>+'monkey',+'foo'+=>+'bar',+'x'+=>+array+('x',+'y',+'z'));
$results+=+print_r($b,+true);+//+$results+now+contains+output+from+print_r|code-block|syntax|javascript|2936888|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

there are many ways ,

two best ways for this are

<pre><code>$arr = array('a' =&gt; 1, 'b' =&gt; 2, 'c' =&gt; 3, 'd' =&gt; 4, 'e' =&gt; 5);
echo json_encode($arr);
//ouputs as
{"a":1,"b":2,"c":3,"d":4,"e":5}


$b = array ('m' =&gt; 'monkey', 'foo' =&gt; 'bar', 'x' =&gt; array ('x', 'y', 'z'));
$results = print_r($b, true); // $results now contains output from print_r
</code></pre>

blocks|key|256815|text|您可以使用serialize|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|256816|$array+=+array('text'+=>+'Hello+world',+'value'+=>+100);
$string+=+serialize($array);+//+a:2:{s:4:"text";s:11:"Hello+world";s:5:"value";i:100;}|code-block|syntax|javascript|256817|并使用unserialize将字符串转换为数组：|256818|$string+=+'a:2:{s:4:"text";s:11:"Hello+world";s:5:"value";i:100;}';
$array+=+unserialize($string);+//+'text'+=>+'Hello+world',+'value'+=>+100|256819|entityMap^0|5|9|0|0|3|B|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

You can use <code>serialize</code>:
<pre><code>$array = array('text' =&gt; 'Hello world', 'value' =&gt; 100);
$string = serialize($array); // a:2:{s:4:&quot;text&quot;;s:11:&quot;Hello world&quot;;s:5:&quot;value&quot;;i:100;}
</code></pre>
and use <code>unserialize</code> to convert string to array:
<pre><code>$string = 'a:2:{s:4:&quot;text&quot;;s:11:&quot;Hello world&quot;;s:5:&quot;value&quot;;i:100;}';
$array = unserialize($string); // 'text' =&gt; 'Hello world', 'value' =&gt; 100
</code></pre>

blocks|key|2936987|text|还有另一种方式，使用短数组语法(方括号)的PHP+var_export()缩进了4个空格：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2936988|function+varExport($expression,+$return+=+true)+{
++++$export+=+var_export($expression,+true);
++++$export+=+preg_replace("/%5E([+]*)(.*)/m",+'$1$1$2',+$export);
++++$array+=+preg_split("/\r\n%7C\n%7C\r/",+$export);
++++$array+=+preg_replace(["/\s*array\s$$/",+"/$(,)?$/",+"/\s=>\s$/"],+[null,+']$1',+'+=>+['],+$array);
++++$export+=+join(PHP_EOL,+array_filter(["["]+%2B+$array));
++++
++++if+((bool)+$return)+return+$export;+else+echo+$export;
}|code-block|syntax|javascript|2936989|带上了here。|2936990|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/Bogdaan/ffa287f77568fcbb4cffa0082e954022^0|P|C|0|0|3|4|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

Yet another way, PHP <code>var_export()</code> with short array syntax (square brackets) indented 4 spaces:
<pre class="lang-php prettyprint-override"><code>function varExport($expression, $return = true) {
 $export = var_export($expression, true);
 $export = preg_replace(&quot;/^([ ]*)(.*)/m&quot;, '$1$1$2', $export);
 $array = preg_split(&quot;/\r\n|\n|\r/&quot;, $export);
 $array = preg_replace([&quot;/\s*array\s$$/&quot;, &quot;/$(,)?$/&quot;, &quot;/\s=&gt;\s$/&quot;], [null, ']$1', ' =&gt; ['], $array);
 $export = join(PHP_EOL, array_filter([&quot;[&quot;] + $array));
 
 if ((bool) $return) return $export; else echo $export;
}
</code></pre>
Taken <a href="https://gist.github.com/Bogdaan/ffa287f77568fcbb4cffa0082e954022" rel="nofollow noreferrer">here</a>.

blocks|key|3151309|text|如果您有一个数组(如$_POST)，并且需要保留键和值：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3151310|function+array_to_string($array)+{
+++foreach+($array+as+$a=>$b)+$c[]=$a.'='.$b;
+++return+implode(',+',$c);
}|code-block|syntax|javascript|3151311|结果类似："name=Paul，age=23，city=Chicago“|3151312|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|$]]

If you have an array (like $_POST) and need to keep keys and values:
<pre><code>function array_to_string($array) {
 foreach ($array as $a=&gt;$b) $c[]=$a.'='.$b;
 return implode(', ',$c);
}
</code></pre>
Result like: &quot;name=Paul, age=23, city=Chicago&quot;

What is the best method for converting a PHP array into a string? 
I have the variable <code>$type</code> which is an array of types. 

<pre><code>$type = $_POST[type];
</code></pre>

I want to store it as a single string in my database with each entry separated by <code>|</code> :

<blockquote>
 Sports|Festivals|Other
</blockquote>

Array to String PHP?

数据库

JSON

将PHP数组转换为字符串的最佳方法是什么？我有一个变量$type，它是一个类型数组。$type = $_POST[type];我想将它作为单个字符串存储在我的数据库中，每个条目用|分隔：体育|节日|其他

问数组转换为字符串PHP？
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数组转换为字符串PHP？EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数组转换为字符串PHP？
EN