如何在sql中插入关联数组？

Question

这是我的数组：

[abominado] => Array
    (
        [0] => réprobo
        [1] => réprobo
        [2] => abominado
        [3] => banido
        [4] => condenado
        [5] => detestado
        [6] => odiado
        [7] => precito
        [8] => renegado
        [9] => repudiado
    )

[abominar] => Array
    (
        [0] => repelir
        [1] => repelir
        [2] => abominar
        [3] => afastar
        [4] => afugentar
        [5] => arredar
        [6] => desalojar
        [7] => desviar
        [8] => detestar
        [9] => empuxar
        [10] => escorraçar
        [11] => espinafrar
        [12] => execrar
        [13] => exercer
        [14] => expulsar
        [15] => grimpar
        [16] => impugnar
        [17] => odiar
        [18] => rebater
        [19] => rechaçar
        [20] => recusar
        [21] => rejeitar
        [22] => relegar
        [23] => repudiar
    )

如何将其插入到sql中？

Answer 1

foreach ($abominado as $key=>$str)
{
    $string .= "$key:$str\n";
}

mysql_query("INSERT INTO strings VALUES ('".mysql_real_escape_string($string)."')");

Answer 2

当您获得它时，可以使用serialize将其转换为string和unserialize

Answer 3

首先，这些数组恰好是顺序的。

其次，在SQL表中，任何列都可以用作搜索条件，因此只需直接插入数据并在任何可搜索的列上建立索引即可。