首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >PHP在for()循环中从mysql获取结果

问PHP在for()循环中从mysql获取结果
EN

Stack Overflow用户
提问于 2016-09-29 05:09:05
回答 1查看 62关注 0票数 0

我有一个‘地图’的东西,我正在做的事情。我正在绘制每个瓷砖,然后检查数据库,看看是否有人位于该瓷砖。

代码可以工作,但只适用于db中的第一个结果。

有人能帮上忙吗。非常感谢。

代码语言:javascript
复制
$sqlw = "SELECT id, player_coord_x, player_coord_y FROM player_game WHERE     world_id='$world'";
$world_result = $player_stat->query($sqlw);


?>

<div class='map-grid'>

    <?
    $id = '';
    $size = 16;
    for($i = 1; $i <= $size; $i++) {
        echo "<div class='map-grid-row'>";
        for ($j=1; $j <= $size; $j++) {

            // check for player at location
            if ($world_result->num_rows > 0) {
                while($w_row = $world_result->fetch_assoc()) {

                    $player_coord_x = $w_row['player_coord_x'];
                    $player_coord_y = $w_row['player_coord_y'];
                    $id = $w_row['id'];

                }
            }

            if ($player_coord_x == $i and $player_coord_y == $j){

                echo "<div class='map-grid-cell high'>";
                echo "XXX";
                echo "</div>";
            }else{

                echo "<div class='map-grid-cell high'>";
                echo "<span class=\"map-small\">(x-$i y-$j)</span>";
                echo "</div>";
            }

        }
        echo "</div>";
    }
    ?>  

</div>
EN

回答 1

Stack Overflow用户

发布于 2016-09-29 15:29:24

代码语言:javascript
复制
$sqlw = "SELECT id, player_coord_x, player_coord_y FROM player_game WHERE world_id='$world'";
$world_result = $player_stat->query($sqlw);

if($world_result->num_rows > 0){
  while($w_row = $world_result->fetch_assoc()){
    //first type of array
    $player[] = array(
      'x'        => $w_row['player_coord_x'], //your player X record
      'y'        => $w_row['player_coord_y'], //your player Y record
      'id'       => $w_row['id'] //your player id
    );

    //second type of array
    // OR store player's X and Y as key of array
    $player[$w_row['player_coord_x'] . '-' . $w_row['player_coord_y']] = $w_row['id'];
    // This are only if the player record will never repeat
  }
}

?>

<div class="map-grid">
  <?php 
    $size = 16; 
    for($i = 1; $i <= $size; $i++){ 
      echo '<div class="map-grid-row">';
      for($j = 1; $j <= $size; $j++){
        //with first type of array
        $exists = false;
        foreach($player as $play){
          if($play['x'] == $i && $play['y'] == $j){
            $exists = true;
            break; // break the loop once you got the result.
          }
        }
        if($exists){ //Player exists? if no detect in foreach loop above, default exists would return false.
          echo '<div class="map-grid-cell high">';
          echo 'XXX';
          echo '</div>';
        } else {
          echo '<div class="map-grid-cell high">';
          echo '<span class="map-small">(x-' . $i . ' y-' . $j . ')</span>';
          echo '</div>';
        }



        //second type of array
        //Check if the key exists and if it's empty.
        if(isset($player[$i.'-'.$j]) && !empty($player[$i.'-'.$j])){
          echo '<div class="map-grid-cell high">';
          echo 'XXX';
          echo '</div>';
        } else {
          echo '<div class="map-grid-cell high">';
          echo '<span class="map-small">(x-' . $i . ' y-' . $j . ')</span>';
          echo '</div>';
        }
      }
    }
  ?>
</div>
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/39757697

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档