php mysql 邮政编码检查

Question

你好，我才开始学习php，谁能帮忙。我需要能够检查数据库中的送货邮政编码。

我有一个名为“delivery”的表，其中有两列，一列是 ID，另一列是邮政编码。

数据库中将会有多个预先记录的邮政编码。我有一个表单供用户输入邮政编码。我需要使用数据库检查此邮政编码，如果存在则继续，如果不显示错误。

这是我到目前为止所拥有的。

<?php
include 'mysql_connect.php';

if(isset($_POST['submit'])){

        $postcodeQuery = sprintf("SELECT `Postcode` FROM delivery WHERE Postcode = '%s' LIMIT 1",
                    mysql_real_escape_string($_POST['inputPostcode']));

        $postcodeResult = mysql_query($postcodeQuery);
        $delivery           = mysql_fetch_array($postcodeResult, MYSQLI_ASSOC);

        if ($_POST['inputPostcode'] == 'postcode')

        echo 'We deliver to your area'.($_POST['postcode']);

        } else{

        echo 'We do not deliver to your area';

}

?>

请帮忙有点卡住了!!

Answer 1

<?php
include 'mysql_connect.php';

if(isset($_POST['submit'])) {
        echo 'Please enter an email address';

        $postcodeQuery = sprintf("SELECT `Postcode` FROM delivery WHERE Postcode = '%s' LIMIT 1",
                    mysql_real_escape_string($_POST['inputPostcode']));

        $postcodeResult = mysql_query($postcodeQuery);
        $delivery       = mysql_fetch_array($postcodeResult, MYSQLI_ASSOC);

        if ($_POST['inputPostcode'] == $delivery[0])
            echo 'We deliver to your area '.($_POST['postcode']);
        else
            echo 'We do not deliver to your area';

}

这个应该可以工作 - 看看 mysql_fetch_array() 的手册页举个例子。