PHP的形式复选框搜索

debugcn 发表于 Dev

洛伦佐·瓦拉诺（Lorenzo Varano）

我已经创建此php代码以在mysql数据库中进行搜索。但是，我的复选框部分有问题。没有复选框部分，它可以正常工作，但是显示“未找到数据”。复选框的部分称为tarif-typ。

    <?php

    include "db_connect.inc.php";

$sql = "SELECT * FROM praemien";
$sql .= " where kanton like '" . $_POST["kanton"] . "' and franchise = ". $_POST["franchise"] ." and ";

switch($_POST["unfall"])
{ case 1:
    $sql .="unfalleinschluss like 'OHN-UNF'";
    break;
 case 2:
    $sql .="unfalleinschluss like 'MIT-UNF'";
} 

$sql .=" and tarif-typ like '" . $_POST["tb"] . "' ";


$sql .= " order by praemie";

$res = mysqli_query($con, $sql);
$num = mysqli_num_rows($res);
if ($num==0) echo "Keine Datensätze gefunden";

while ($dsatz = mysqli_fetch_assoc($res))
echo $dsatz["versicherungsnamen"] . ", "
    .$dsatz["kanton"] . ", "
    .$dsatz["tarif-typ"] . ", "
    .$dsatz["unfalleinschluss"] . ","
    . $dsatz["praemie"] . "<br />"; 

    mysqli_close($con);

    ?>
</body>

这是我的html表格

<html>
    <body>
    <form action ="db_eingabe.php" method="post">
        <p><input name="kanton" /> Kanton</p>
        <p><input name="franchise" /> Franchise</p>
        <p><input type="radio" name="unfall" value="1" checked="checked" />Unfall nein<br>
        <input type="radio" name="unfall" value="2" />Unfall ja</p>
        <br><p>
        <b>Tarif</b>
        </p>

    <p><input type="checkbox" name="tb1" value="TAR-BASE" checked="checked" />Grund</p>
    <p><input type="checkbox" name="tb2" value="TAR-HMO" />HMO</p>
    <p><input type="checkbox" name="tb3" value="TAR-HAM" />HAM</p>
    <p><input type="checkbox" name="tb4" value="TAR-DIV" />andere</p>

        <p><input type="submit" /> 
        <input type ="reset" /></p>
    </form>
    </body>
</html>

aequalsb

开始另一篇文章以保持事情清洁...

您的PHP代码：

<?php

include "db_connect.inc.php";

$sql = "
    SELECT
        *
    FROM
        `praemien`
    WHERE
        `kanton` LIKE '" . $_POST["kanton"] . "'
        AND `franchise` = '". $_POST["franchise"] ."'
        AND `unfalleinschluss` LIKE '" . $_POST["unfall"] . "'";

$tbs = array();

foreach( array( 'tb1', 'tb2', 'tb3', 'tb4' ) as $tb_key )
{
    if ( empty( $_POST[$tb_key] ) ) continue;

    $tbs[] = "`tarif-typ` LIKE '" . $_POST[$tb_key] . "'";
}
if ( !empty( $tbs ) )
{
    $sql .= ' AND ( ' . implode( ' OR ', $tbs ) . ' )';
}
$sql .= " ORDER BY praemie";

echo $sql;

$res = mysqli_query($con, $sql) or die( mysql_error() );
$num = mysqli_num_rows($res);
if ($num==0) echo "Keine Datensätze gefunden";

while ($dsatz = mysqli_fetch_assoc($res)) {
    echo $dsatz["versicherungsnamen"] . ", "
    .$dsatz["kanton"] . ", "
    .$dsatz["tarif-typ"] . ", "
    .$dsatz["unfalleinschluss"] . ","
    . $dsatz["praemie"] . "<br />";
}
mysqli_close($con);

?>

和您的HTML代码：

<html>
<body>
<form action ="db_eingabe.php" method="post">
    <p><input name="kanton" /> Kanton</p>
    <p><input name="franchise" /> Franchise</p>
    <p><input type="radio" name="unfall" value="OHN-UNF" checked="checked" />Unfall nein<br>
    <input type="radio" name="unfall" value="MIT-UNF" />Unfall ja</p>
    <p>
    <b>Tarif</b>
    </p>

    <p><input type="checkbox" name="tb1" value="TAR-BASE" checked="checked" />Grund</p>
    <p><input type="checkbox" name="tb2" value="TAR-HMO" />HMO</p>
    <p><input type="checkbox" name="tb3" value="TAR-HAM" />HAM</p>
    <p><input type="checkbox" name="tb4" value="TAR-DIV" />andere</p>

    <p><input type="submit" /> 
    <input type ="reset" /></p>
</form>
</body>
</html>