blocks|key|1906896|text|您的解决方案似乎不会将数据发送两次。除非由于发出查询而出现具有相同值的记录。这可能意味着您应该在构建查询之前处理数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1906897|一种解决办法可以是：|1906898|$sql+=+array();

foreach($_POST['something']+as+$something){
++++foreach($_POST['example']+as+$example){
++++$sql[]+=+"INSERT+INTO+table+(row,+row2)+VALUES+('{$something}','{$example}')";
}
}

foreach($sql+as+$query){
++mysql_query($query);
}|code-block|syntax|javascript|1906899|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|$]]

Your solution does not seem to send the data twice. Unless if records with the same values appear as a result of issuing your queries. This might mean that you should process your data before constructing your queries.

One solution could be:

<pre><code>$sql = array();

foreach($_POST['something'] as $something){
 foreach($_POST['example'] as $example){
 $sql[] = "INSERT INTO table (row, row2) VALUES ('{$something}','{$example}')";
}
}

foreach($sql as $query){
 mysql_query($query);
}
</code></pre>

blocks|key|1550892|text|$cnt+=+count($_POST['something']);
$cnt2+=+count($_POST['example']);

if+($cnt+>+0+&&+$cnt+==+$cnt2)+{
++++$insertArr+=+array();
++++for+($i=0;+$i<$cnt;+$i%2B%2B)+{
++++++++$insertArr[]+=+"('"+.+mysql_real_escape_string($_POST['something'][$i])+.+"',+'"+.+mysql_real_escape_string($_POST['example'][$i])+.+"')";
++++}

++++$query+=+"INSERT+INTO+table+(column,+column2)+VALUES+"+.+implode(",+",+$insertArr);
++++mysql_query($query)+or+trigger_error("Insert+failed:+"+.+mysql_error());
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1550893|这是另一种方法。这种方法使用扩展的插入，因此应该更高效、更快，并且出于安全考虑使用mysql_real_escape_string。计数检查只是确保两个字段都有相同的计数，如果没有，我认为这是一个错误。如果允许它们有不同数量的字段，您只需使用isset()函数来检查，以确保它们包含一个值。|unstyled|offset|length|1550894|编辑|style|BOLD|1550895|当然，这是假设，您不希望对所有的“示例”值进行迭代，并将其分配给每个值。如果你想要那样的话，这是一个小小的改变。|1550896|添加了插入数组测试，如果没有不需要更新的元素。谢谢Gumbo的支持。|1550897|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/isset^0|0|3D|7|0|0|0|2|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|Z|8|@]|9|@$G|10|H|11|1|12]]|A|$]]|$1|I|3|J|5|F|7|13|8|@$G|14|H|15|K|L]]|9|@]|A|$]]|$1|M|3|N|5|F|7|16|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|17|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|F|7|18|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

<pre><code>$cnt = count($_POST['something']);
$cnt2 = count($_POST['example']);

if ($cnt &gt; 0 &amp;&amp; $cnt == $cnt2) {
 $insertArr = array();
 for ($i=0; $i&lt;$cnt; $i++) {
 $insertArr[] = "('" . mysql_real_escape_string($_POST['something'][$i]) . "', '" . mysql_real_escape_string($_POST['example'][$i]) . "')";
 }

 $query = "INSERT INTO table (column, column2) VALUES " . implode(", ", $insertArr);
 mysql_query($query) or trigger_error("Insert failed: " . mysql_error());
}
</code></pre>

Here is another method. This one uses extended inserts, so should be more efficient and quicker, and utilizes mysql_real_escape_string for security reasons. The count check is to just make sure that both fields have the same count, if not then I take this is a mishap. If they are allowed to have a different number of fields, you can simply use the <a href="http://www.php.net/isset" rel="nofollow noreferrer">isset()</a> function to check to make sure they contain a value. 

EDIT

This is assuming of course, that you do not want 'something' to iterate over all the 'example' values and be assigned to each one. If you want that well it is a bit of a change up.

Added an insert array test, if there are no elements no need to update. Thanks Gumbo for that.

blocks|key|1906944|text|你的意思是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1906945|foreach($_POST['something']+as+$key+=>+$something)+{+
++++$example+=+$_POST['example'][$key];
++++$query+=+mysql_query("INSERT+INTO+table+(row,+row2)+VALUES+('{$something}','{$example}')");+
}+|code-block|syntax|javascript|1906946|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|$]]

Do you mean something like:

<pre><code>foreach($_POST['something'] as $key =&gt; $something) { 
 $example = $_POST['example'][$key];
 $query = mysql_query("INSERT INTO table (row, row2) VALUES ('{$something}','{$example}')"); 
} 
</code></pre>

blocks|key|1906987|text|我认为最好的方法是作为一个单独的循环来构建查询。即使数组的长度不是相同的，这也是可行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1906988|$size1+=+count($_POST['something']);
$size2+=+count($_POST['example']);
if(+$size1+>=+$size2+)+{
+++++$size+=+$size1;
}+else+{
+++++$size+=+$size2;
}

$sql+=+"INSERT+INTO+table+(row,+row2)+VALUES";
$values+=+array();
for(+$i=0;+$i<$size;+$i%2B%2B+)+{
++++$values[]+=+"('"+.+mysql_real_escape_string($_POST['something'][$i])+.+"','"+.+mysql_real_escape_string($_POST['example'][$i])+.+"')";
}

$sql+.=+implode(",",+$values);

mysql_query($sql);|code-block|syntax|javascript|1906989|也更安全，因为它逃避你的输入。在PDO中使用占位符也会更容易。|1906990|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|$]]

I think the best way would be as a single loop to build a query. This should work even if your arrays are not the same length:

<pre><code>$size1 = count($_POST['something']);
$size2 = count($_POST['example']);
if( $size1 &gt;= $size2 ) {
 $size = $size1;
} else {
 $size = $size2;
}

$sql = "INSERT INTO table (row, row2) VALUES";
$values = array();
for( $i=0; $i&lt;$size; $i++ ) {
 $values[] = "('" . mysql_real_escape_string($_POST['something'][$i]) . "','" . mysql_real_escape_string($_POST['example'][$i]) . "')";
}

$sql .= implode(",", $values);

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

Also more secure because it escapes your input. This would also be even easier using placeholders with PDO.

blocks|key|353985|text|虽然您已经选择了一个答案，但是不要忘记，如果POST值不是数组，那么这段脚本可能会失败。您可以使用一小部分代码来克服这一问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|353986|$something+=+is_array($_POST['something'])+?+$_POST['something']+:+array();
$example+=+is_array($_POST['example'])+?+$_POST['example']+:+array();

/*+Get+all+the+keys+from+both+arrays
+*+If+they+don't+share+the+keys,+none+will+be+lost
+*/
$keys+=+array_merge(array_keys($something),array_keys($example));
$keys+=+array_unique();

if+(count($keys))+{
++++$sql+=+'INSERT+INTO+table+(row,+row2)+VALUES+';
++++$values+=+array();

++++foreach+($keys+as+$key)+{
++++++++//+Single+quotes+for+PHP,+we+are+not+expanding+variables
++++++++//+If+the+element+cannot+be+converted+into+a+string,+don't+show+the+error+on+screen
++++++++$values[]+=+'("'+.+@mysql_real_escape_string($something[$key])+.+'","'+.+@mysql_real_escape_string($example[$key])+.+'")';
++++}

++++$sql+.=+implode(',',+$values);
++++mysql_query($sql);
}|code-block|syntax|javascript|353987|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|$]]

Although you already selected an answer, don't forget this piece of script may fail if the POST values are not arrays. You can overcome this with a small piece of code:

<pre><code>$something = is_array($_POST['something']) ? $_POST['something'] : array();
$example = is_array($_POST['example']) ? $_POST['example'] : array();

/* Get all the keys from both arrays
 * If they don't share the keys, none will be lost
 */
$keys = array_merge(array_keys($something),array_keys($example));
$keys = array_unique();

if (count($keys)) {
 $sql = 'INSERT INTO table (row, row2) VALUES ';
 $values = array();

 foreach ($keys as $key) {
 // Single quotes for PHP, we are not expanding variables
 // If the element cannot be converted into a string, don't show the error on screen
 $values[] = '("' . @mysql_real_escape_string($something[$key]) . '","' . @mysql_real_escape_string($example[$key]) . '")';
 }

 $sql .= implode(',', $values);
 mysql_query($sql);
}
</code></pre>

blocks|key|1550951|text|多个数组的解决方案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1550952|试着-|1550953|1)|1550954|<?php
$ZZ+=+array('a',+'b',+'c',+'d');
$KK+=+array('1',+'2',+'3',+'4');

foreach($ZZ+as+$index+=>+$value)+{
++++echo+$ZZ[$index].$KK[$index];
++++echo+" ";
}
?>|code-block|syntax|javascript|1550955|或2)|1550956|<?php
$ZZ+=+array('a',+'b',+'c',+'d');
$KK+=+array('1',+'2',+'3',+'4');

for+($index+=+0+;+$index+<+count($ZZ);+$index+%2B%2B)+{
++echo+$ZZ[$index]+.+$KK[$index];
++echo+" ";
}
?>|1550957|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

SOLUTION FOR MULTIPLE Arrays

TRY -

1)

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

foreach($ZZ as $index =&gt; $value) {
 echo $ZZ[$index].$KK[$index];
 echo "&lt;br/&gt;";
}
?&gt;
</code></pre>

or 2)

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

for ($index = 0 ; $index &lt; count($ZZ); $index ++) {
 echo $ZZ[$index] . $KK[$index];
 echo "&lt;br/&gt;";
}
?&gt;
</code></pre>

blocks|key|1907014|text|具有多个数组的Foreach循环：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1907015|foreach($_POST['quantity']+as+$key=>$quantity)
{
+++$product_no=$_POST['product_id'][$key];
+++echo+$product_no;
+++echo+$quantity;
}|code-block|syntax|javascript|1907016|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|$]]

Foreach loop with multiple arrays:

<pre><code>foreach($_POST['quantity'] as $key=&gt;$quantity)
{
 $product_no=$_POST['product_id'][$key];
 echo $product_no;
 echo $quantity;
}
</code></pre>

This is what I want:

<hr>

<pre><code>foreach($_POST['something'] as $something){
 foreach($_POST['example'] as $example){
 $query = mysql_query("INSERT INTO table (row, row2) VALUES ('{$something}','{$example}')");
 }

}
</code></pre>

<code>$_POST['something']</code> and <code>$_POST['example']</code> are arrays from an input with

<code>name="something[]"</code> and <code>name="example[]"</code>.

The problem:

<hr>

In this way I will send the data twice to database. So I need a solution where I can loop trough 2 arrays without seding the data twice.

EDIT

<ul>
<li>The two array will always have the same size</li>
<li>In the mysql_query I will have other elements not just row, row2, and those will be static without any array.</li>
</ul>

Foreach loop with multiple arrays

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

，这就是我想要的：foreach($_POST['something'] as $something){    foreach($_POST['example'] as $example){        $query = mysql_query("INSERT INTO table (row, row2) VALUE...

问具有多个数组的Foreach循环
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问具有多个数组的Foreach循环EN