blocks|key|5881630|text|if($_POST['submit']){
++++if(!empty($applicant_id)){
++++++++++++$sql+=+"UPDATE+play+SET+";
++++++++++++foreach($_POST+as+$key+=>+$value){
++++++++++++++++if(($key+!=+'submit')+&&+($key+!=+'applicant_id')){
+++++++++++++++++++++$sql+.=++$key+.+"+=+'"+.+($value+?+'on'+:+'off')+.+"',";
++++++++++++++++}
++++++++++++}
++++++++++++$sql+=+substr($sql,+0,+-1);
++++++++++++$sql+.=+"+WHERE+".$applicant_id."+=+$applicant_id";
++++++++++++$result+=+mysql_query($sql,$db)+or+die(mysql_error().+"<br+/>SQL:+$sql");+++
++++}+
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|5881631|上面假设你所有的输入都是复选框。如果它们不是，您将需要制定一个约定来区分它们。|unstyled|5881632|顺便说一句，您当前运行的UPDATE代码容易受到SQL+injection的攻击，因为您没有使用mysql_real_escape_string()清理输入。干杯。|offset|length|style|CODE|5881633|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL_injection^0|0|0|C|6|1C|Q|O|D|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|V|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|W|8|@$I|X|J|Y|K|L]|$I|Z|J|10|K|L]]|9|@$I|11|J|12|1|13]]|A|$]]|$1|M|3|-4|5|F|7|14|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

<pre><code>if($_POST['submit']){
 if(!empty($applicant_id)){
 $sql = "UPDATE play SET ";
 foreach($_POST as $key =&gt; $value){
 if(($key != 'submit') &amp;&amp; ($key != 'applicant_id')){
 $sql .= $key . " = '" . ($value ? 'on' : 'off') . "',";
 }
 }
 $sql = substr($sql, 0, -1);
 $sql .= " WHERE ".$applicant_id." = $applicant_id";
 $result = mysql_query($sql,$db) or die(mysql_error(). "&lt;br /&gt;SQL: $sql"); 
 } 
}
</code></pre>

The above assumes that all your inputs are checkboxes. If they aren't, you'll need to work out a convention to distinguish them.

Incidentally, your currently running <code>UPDATE</code> code is vulnerable to <a href="http://en.wikipedia.org/wiki/SQL_injection" rel="nofollow noreferrer">SQL injection</a> because you aren't sanitizing your inputs with <code>mysql_real_escape_string()</code>. Cheers.

blocks|key|3769640|text|解决方案是从array()或类似的可能复选框的已知列表开始。我可以假设您是用这样的列表生成表单的吗？如果不是，您可能应该这样做。然后，您可以在相同的数据上使用循环来检查每个复选框的存在。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3769641|其他一些提示：|3769642|不推荐使用isset($array[$key])。虽然它在大多数情况下都是可靠的，但如果$array[$key]为null，它将失败。正确的调用是array_key_exists($key,+$array)。|3769643|在为SQL组装字符串片段时，就像您正在做的那样，执行以下操作会更优雅：|3769644|+$sqlvalues+=+array();
+foreach(+$options+as+$field+)+{
++++if(+array_key_exists('checkbox_'.$field,+$_POST)+)
++++++++$sqlvalues[]+=+$field.'+=+\'on\'';
++++else
++++++++$sqlvalues[]+=+$field.'+=+\'off\'';
+}
+mysql_query('UPDATE+'.$table.'+SET+'.implode(',+',+$sqlvalues).'+WHERE+applicant_id+=+'.$applicant_id);|code-block|syntax|javascript|3769645|entityMap^0|6|7|0|0|5|J|18|C|1L|4|21|U|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|15|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|16|8|@]|D|@]|E|$O|P]]|$1|Q|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|R|$]]

The solution is to start with your known list of possible checkboxes in an <code>array()</code> or similar. Can I assume you generate the form with such a list? If not, you probably should. Then you can use a loop over the same data to check for the existence of each checkbox.

Some other hints:

<code>isset($array[$key])</code> is not recommended. Although it will be reliable most of the time, it will fail if <code>$array[$key]</code> is <code>null</code>. The correct call is <code>array_key_exists($key, $array)</code>.

When assembling string fragments for SQL, like you're doing, it is more elegant to do the following:

<pre><code> $sqlvalues = array();
 foreach( $options as $field ) {
 if( array_key_exists('checkbox_'.$field, $_POST) )
 $sqlvalues[] = $field.' = \'on\'';
 else
 $sqlvalues[] = $field.' = \'off\'';
 }
 mysql_query('UPDATE '.$table.' SET '.implode(', ', $sqlvalues).' WHERE applicant_id = '.$applicant_id);
</code></pre>

blocks|key|587627|text|您可能正在运行HTML复选框行为:只有当复选框处于打开状态时，才会将其发送到服务器；如果它们处于关闭状态，则不会发送名称/值对。在上面的代码中，你会遇到关闭值的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|587628|因此，您需要遍历已知值列表，并在$_POST参数中检查它们。|587629|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You may be running to HTML checkbox behavior: Checkboxes are only sent to the server if they are on; if they are off, no name/value pair is sent. You are going to have trouble turning off values with the above code.

So you need to run through your known list of values and check for them in the $_POST parameters.

blocks|key|587653|text|删除上面的所有内容:-)命名所有的复选框，就像和在foreach中使用$_POST‘BUT’，但是！不要忘记黄金法则:不要相信用户。在写入数据库之前，请重新检查每个key=>value。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|587654|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|$]]

delete everything above :-)
name all you checkboxes like 
and in foreach work with $_POST['out']
BUT! don't forget the golden rule: DOn't belive to the user. re-check every key=>value before writing to the datebase.

blocks|key|2506629|text|您应该使用数组名称，它将是PHP中的数组。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2506630|正如ndp所说，如果未选中某个复选框，则不会传输其值。因此，您需要在复选框输入字段之前使用具有相同名称的隐藏输入字段，并使用"off“值。|2506631|<label+for="one">One</label>+
<input+type="hidden"+name="checkboxes[one]"+value="off"/>
<input+type="checkbox"+name="checkboxes[one]"+id="one"+value="on"/>|code-block|syntax|javascript|2506632|记住，如果checked=默认设置为on，请记住它是“checked”。|2506633|现在可以使用POST或GET循环复选框|2506634|foreach+($_POST['checkboxes']+as+$key+=>+$value)+{
++++//something
}|2506635|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|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$G|H]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You should use an array name and it will be an array in PHP.

As ndp said, if a checkbox is unchecked, its value will not be transmitted. So you need to use a hidden input field with the same name before the checkbox input field, with the "off" value.

<pre><code>&lt;label for="one"&gt;One&lt;/label&gt; 
&lt;input type="hidden" name="checkboxes[one]" value="off"/&gt;
&lt;input type="checkbox" name="checkboxes[one]" id="one" value="on"/&gt;
</code></pre>

Remember checked="checked" if it should be default to on.

You can now loop the checkboxes with POST or GET

<pre><code>foreach ($_POST['checkboxes'] as $key =&gt; $value) {
 //something
}
</code></pre>

I am having trouble getting a form to update the information passed from a check box. I was given this code.

<pre><code>$one = isset($_POST['one']) ? 'on' : 'off'; 
</code></pre>

This works great as long as I call each check box separately. My problem is I have approximately 200 checkboxes in total.

Here is the code I am using to <code>UPDATE</code> with. Can anyone help me to figure out where to insert the code I was given into my present code? I've tried all sorts of variations.

<pre><code>if($_POST['submit']){
 if(!empty($applicant_id)){
 $sql = "UPDATE play SET ";
 foreach($_POST as $key =&gt; $value){
 if(($key != 'submit') &amp;&amp; ($key != 'applicant_id')){
 $sql .= $key. " = '$value',";
 }
 }
 $sql = substr($sql, 0, -1);
 $sql .= " WHERE ".$applicant_id." = $applicant_id";
 $result = mysql_query($sql,$db) or die(mysql_error(). "&lt;br /&gt;SQL: $sql"); 
 } 
} 
</code></pre>

$_POST as $key => $value using checkboxes

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我在获取表单以更新从复选框传递的信息时遇到问题。我得到了这个代码。$one = isset($_POST['one']) ? 'on' : 'off'; 只要我单独调用每个复选框，这就很有效。我的问题是我总共有大约200个复选框。这是我用来UPDATE的代码。有没有人能帮我找出在我现在的代码中插入代码的位置？我尝试过各...

问使用复选框将$_POST as $key => $value
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用复选框将$_POST as $key => $valueEN