Question

我试图从多个检查箱中形成一个插座,用于查询我的数据库。

我有以下表格:

            <fieldset data-role="controlgroup">

            <input type="checkbox" name="wheat" id="checkbox-1a" class="custom" />
            <label for="checkbox-1a">Wheat Allergy</label>

            <input type="checkbox" name="yeast" id="checkbox-2a" class="custom" />
            <label for="checkbox-2a">Yeast Allergy</label>

            <input type="checkbox" name="sugar" id="checkbox-3a" class="custom" />
            <label for="checkbox-3a">Sugar Allergy</label>

            <input type="checkbox" name="dairy" id="checkbox-4a" class="custom" />
            <label for="checkbox-4a">Dairy Allergy</label>

我的购买力平价编码如下:

        if(isset($_POST[ wheat ]))
        {
            $str1 =  wheatfree = 1 ;
        }

        if(isset($_POST[ yeast ]))
        {
            $str2 =  yeastfree = 1 ;
        }

        if(isset($_POST[ sugar ]))
        {
            $str3 =  sugarfree = 1 ;
        }

        if(isset($_POST[ dairy ]))
        {
            $str4 =  dairyfree = 1 ;
        }

        $fullsearch = $str1.$str2.$str3.$str4;

        $str_SQL = "SELECT * FROM recipes WHERE ".$fullsearch;

        echo $str_SQL;

This is sort of doing what I require, but it s not very graceful.

单单单单单单单是这样:

SlectT * fromrecipes WHERE IXfree = 1dairyfree = 1

并且如果用户选择不选择一个I,则选择斜体时会出现不确定的变差。

不能真正确定如何解决这一问题或下一步工作。我在此赞同一些逻辑,即根据当时表格的核实,刚刚修改了扼杀,我可以与我的行竞争。但一米损失:

帮助?

Answer 1

如何做到这一点:

$options = array();
if(isset($_POST[ wheat ]))
{
    $options[] =  wheatfree = 1 ;
}

if(isset($_POST[ yeast ]))
{
    $options[] =  yeastfree = 1 ;
}

if(isset($_POST[ sugar ]))
{
    $options[] =  sugarfree = 1 ;
}

if(isset($_POST[ dairy ]))
{
    $options[] =  dairyfree = 1 ;
}

$fullsearch = implode(  AND  , $options);

$str_SQL = "SELECT * FROM recipes";
if ($fullsearch <>   ) {
    $str_SQL .= " WHERE " . $fullsearch;
}

echo $str_SQL;

Answer 2

Further to Dave s answer:

$options = Array();
$ingredients = Array( wheat ,  yeast ,  sugar ,  dairy );

foreach ($ingredients as $i)
   if (isset($_POST[$i]))
      $options[] = $i .  free = 1 ;

$sql = "SELECT * FROM recipes";
if (count($options))
   $sql .= " WHERE " . implode(  AND  , $options);

echo $sql;

但是,为什么有人用<条码>价值使用检查箱的财产?

<input type="checkbox" name="ingredients[]" value="wheat" />
<input type="checkbox" name="ingredients[]" value="sugar" />

等等。

然后:

$options = Array();
foreach ($_POST[ ingredients ] as $i)
   $options[] = $i .  free = 1 ; // don t forget to escape $i somehow!

$sql = "SELECT * FROM recipes";
if (count($options))
   $sql .= " WHERE " . implode(  AND  , $options);

echo $sql;

友情链接