php - 使用 php 和 jquery ajax 从 mysql 数据库获取数据？

Question

我已经使用 jvector map 创建了 map 。它运行良好。现在我想从数据库中获取国家/地区详细信息。我已经用 mysql 代码创建了 php 连接

数据库.php

 <?php

    $host     = "localhost";
    $port     = 3306;
    $user     = "root";
    $password = "";
    $dbname   = "mydatabase";


    $country = $_POST['canada'];
    $con = new mysqli($host, $user, $password, $dbname, $port, $socket)
        or die ('Could not connect to the database server' . mysqli_connect_error());

    //$con->close();

    $query = "SELECT countryId, country, pdogcoregion, comments, ccl, category 
              FROM   countrydetails 
              WHERE  country='canada' ";
    $countrydetails = '';

    $stmt->bind_param('s', $countrydetails);

    if ($stmt = $con->prepare($query)) {

        $stmt->execute();
        $stmt->bind_result($countryId, $country, $pdogcoregion, $comments, $ccl, $category);

        while ($stmt->fetch()) {

        }

        $stmt->close();
    }

    ?>

这是我的html代码:

  <script src="assets/jquery-jvectormap-world-mill-en.js"></script>
      <script>
        jQuery.noConflict();
        jQuery(function(){
          var $ = jQuery;
          $('#focus-single').click(function(){
            $('#map1').vectorMap('set', 'focus', {region: 'AU', animate: true});
          });
          $('#focus-multiple').click(function(){
            $('#map1').vectorMap('set', 'focus', {regions: ['AU', 'JP'], animate: true});
          });
          $('#focus-coords').click(function(){
            $('#map1').vectorMap('set', 'focus', {scale: 7, lat: 35, lng: 33, animate: true});
          });
          $('#focus-init').click(function(){
            $('#map1').vectorMap('set', 'focus', {scale: 1, x: 0.5, y: 0.5, animate: true});
          });
          $('#map1').vectorMap({
            map: 'world_mill_en',
            panOnDrag: true,
            focusOn: {
              x: 0.5,
              y: 0.5,
              scale: 1,
              animate: true
            },
            series: {
              regions: [{
                scale: ['#688FA0'],
                normalizeFunction: 'polynomial',
                values: {
              }]
            },
            onRegionClick: function (event, code) {
              var map = $('#map1').vectorMap('get', 'mapObject');
              var name = map.getRegionName(code);

              //alert(name);

              var labelText='Not Assign';

              // get from DB using ajax
              $.ajax({
                type: "POST",
                url: 'database.php',
                data: {country: 'canada'},
                dataType: "text",
                success: function(data){
                  alert(data);
              });
           });
         });

如何连接ajax和mysql php数据库？请帮忙..........

Answer 1

您需要在 database.php 上回显一些内容，以便 javascript 接收 php 操作的结果。输出的格式可以是你想要的，但需要回显或打印。