主页 / 问题 / 871445
Accepted
Руслан
Asked:2020-08-21 20:29:08 +0000 UTC2020-08-21 20:29:08 +0000 UTC

使用post请求的php数据库查询

  • 772

请帮帮我。战斗的第二天，我根本赢不了（（我只是无法从数据库中拔出行。我不明白我在做什么错。对数据库的查询行没有执行，以及它后面的行。如果你用请求注释掉该行，它后面的行将被执行。行

<select size="1" name="region" onchange="javascript:selectCity();"></select>

同时补充了一个结束标签，不清楚如何

php文件代码

<?php

ini_set(default_charset,"UTF-8");

# include data base
require "mysql.inc.php";

switch ($_POST['action']){


    case "showRegionForInsert":

            echo '<select size="1" name="region" onchange="javascript:selectCity();">';
     $rows = $DB2->select('SELECT * FROM okmx_aaa_regions WHERE id_country=? ORDER BY region ASC' , $_POST['id_country']);

          foreach ($rows as $numRow => $row) {
               echo '<option value="'.$row['id'].'">'.$row['region'].'</option>';
           };

              echo '<option value="9999">post пришёл: '.$_POST['id_country'].'</option>';

            echo '</select5464>';
            break;

    case "showCityForInsert":

            echo '<select size="1" name="city">';
            $rows = $DB->select('SELECT * FROM okmx_aaa_cities WHERE id_region=? ORDER BY city ASC', $_POST['id_region']);
            foreach ($rows as $numRow => $row) {
                    echo '<option value="'.$row['id'].'">'.$row['city'].'</option>';
            };
            echo '</select>';
            break;

};

?>

一般来说，我需要从网站上的数据库中选择地区、城市

php

1 个回答

  1. Best Answer

    我解决了这个问题（有人可以告诉我如何改进代码 - 欢迎））））：

    <?php

ini_set(default_charset,'UTF-8');

# include data base
 require 'mysql.inc.php';


$link = mysqli_connect($db_host, $db_user, $db_password, $db_name) 
or die("Ошибка " . mysqli_error($link)); 


switch ($_POST['action']){


case "showRegionForInsert":
      echo '<select size="1" name="region" onchange="javascript:selectCity();">'; 
      $cntr = $_POST['id_country'];

      $query = "SELECT * FROM okmx_aaa_regions WHERE id_country=$cntr";

      $result = mysqli_query($link, $query) or die("Ошибка " . mysqli_error($link)); 

      while ($row = $result->fetch_assoc()) {

      print '<option value="'.$row['id'].'">'.$row['region'].'</option>';
      }

      $result->free(); 

      echo '</select>';
       $link->close();

      break;


    case "showCityForInsert": 

      echo '<select size="1" name="city" >'; 
      $rgn = $_POST['id_region'];

      $query = "SELECT * FROM okmx_aaa_cities WHERE id_region=$rgn";

      $result = mysqli_query($link, $query) or die("Ошибка " . mysqli_error($link)); 

      while ($row = $result->fetch_assoc()) {

      print '<option value="'.$row['id'].'">'.$row['city'].'</option>';
      }


      $result->free();

      echo '</select>';
      $link->close();

      break;

};

?>
    • 0

相关问题