显示来自MySQL的特定PHP数组

Question

现在，MySQL结果中的所有列都被转换为JSON并在屏幕上打印出来。我只想在屏幕上打印两列$row['name']和$row['gender']。有什么想法吗，伙计们

include('connect-db.php');

$result = mysql_query("SELECT * FROM patientvaccinedetail")


while($row = mysql_fetch_assoc( $result)) {

print_r(json_encode($row));}

Answer 1

以下是我的解决方案，用于从表中获取所有内容，并仅显示两个值……

include('connect-db.php');    
$result = mysql_query("SELECT * FROM patientvaccinedetail") //getting all the fields    

while($row = mysql_fetch_assoc( $result)) {
    $data = array('name' => $row['name'] , 'gender' => $row['gender']); //get the two values into one array

print_r(json_encode($data)); //printing the name and gender
}

如果您只想获取这两个字段，这里是另一个查询...

include('connect-db.php');    
$result = mysql_query("SELECT name,gender FROM patientvaccinedetail") //getting two the fields    

while($row = mysql_fetch_assoc( $result)) {     

print_r(json_encode($row)); //printing the name and gender
}

Answer 2

$result = mysql_query("SELECT name,gender FROM patientvaccinedetail")

Answer 3

如果你想要所有的数据，但是你必须只打印姓名和性别，那么分配一个单独的数组& ..Create name & gender...

$data_array = array();
while($row = mysql_fetch_assoc( $result)) {
 array_push($data_array,array("name"=>$row['name'],"gender"=>$row['gender']);
}
print_r(json_encode($data_array));