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