等效mysqli

if($sql = $db->prepare(\'select zip from _zipcode where zip like ?\'))
{
    $sql->bind_param(\"s\", $consulta);
    $sql->execute();
    $sql->bind_result($zip);

    while ($sql->fetch()) {
        echo \"Zip: $zip\\n\";
    }

    $sql->close();
}

     $rs = mysql_query(\'select zip  from _zipcode where zip like \"\'.$consulta .\'%\"\');

        $query=\"select zip  from _zipcode where zip like \" .$consulta . \"%\";
        $rs = mysqli_query($connection_information,$query) or  die(mysqli_error($connection_information));
       $row_rs = mysqli_fetch_assoc($rs);
       $totalRows_rs = mysqli_num_rows($rs);

    do {  
        echo $row_rs[\'zip\'];

        } while ($row_rs = mysqli_fetch_assoc($rs));
          $rows = mysqli_num_rows($rs);
          if($rows > 0) {
           mysqli_data_seek($rs, 0);
           $row_rs = mysqli_fetch_assoc($rs);
                          }