如何使用插入查询仅循环复选框中的第一个值 [英] How to loop only first value from checkbox with insert query

问题描述

我有两个值类似的复选框

i have checkbox with two values like

<input type="checkbox" name="analysis[]" value="'.$rows['name'].'_'.$rows['cost'].'">

我只想用插入查询循环第一个值(名称)

i want loop only the first value (name) with insert query

这是我的代码，可以正常工作，但是每次只插入一条记录.循环不起作用

that is my code , working but it only insert one record every time . loop not working

$allAnalysis = $_REQUEST['analysis'];
foreach($allAnalysis as $analysis)
{
    $analysis = explode("_", $analysis);
    $analysis_name = $analysis[0];
    $analysis_insert = "INSERT INTO analysis (
                            analysis_id ,
                            analysis_name 
                        ) VALUES ( 
                            NULL ,
                            '".$analysis_name."'
                        )";         
}

推荐答案

请在foreach中添加SQL查询.

Please add SQL query inside foreach.

foreach (...){
....
 $analysis_insert = "INSERT INTO analysis (
                            analysis_id ,
                            analysis_name 
                        ) VALUES ( 
                            NULL ,
                            '".$analysis_name."'
                        )";         

/// add here your query
mysql_query( $analysis_insert);

}

这篇关于如何使用插入查询仅循环复选框中的第一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！