阅读背景:

两个PHP数组没有返回,两个是

来源:互联网 

So here's the code:

这是代码:

function pullLists(){
  require ($_SERVER['DOCUMENT_ROOT'] . '/sql_connection/connect.php');
  $sql_sn = "SELECT sName FROM skills";
  $sql_st = "SELECT sType FROM skills";
  $sql_class = "SELECT class_name FROM class_info";
  $sql_race = "SELECT race_name FROM races";

  $r_sn = $link->query($sql_sn);
  $r_st = $link->query($sql_st);
  $classes = $link->query($sql_class);
  $races = $link->query($sql_race);

  $skillnames = array();
  $skilltypes = array();
  $classnames = array();
  $racenames = array();

  if ($r_sn->num_rows > 0){
    while ($row = $r_sn->fetch_assoc()){
      $skillnames[] = $row["sName"]; 
    } 
    echo $skillnames[1];
  } else {echo "No rows found for Skill Names.";}
  if ($r_st->num_rows > 0){
    while ($row = $r_st->fetch_assoc()){
      $skilltypes[] = $row["sType"];
    }
  } else {echo "No rows found for Skill Types.";}
  if ($classes->num_rows > 0){
    while ($row = $classes->fetch_assoc()){
      $classnames[] = $row["class_name"];
    }
  } else {echo "No rows found for Class Names.";}
  if ($races->num_rows > 0){
    while ($row = $races->fetch_assoc()){
      $racenames[] = $row["race_name"];
    }
  } else {echo "No rows found for Race Names.";}
  $resultArray = array($skillnames, $classnames, $racenames);
  echo json_encode($resultArray);
}
function pullLis



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: