php 返回查询结果某个字段

    global $mysql;

//查询

    $sql = "select * from `bookTable` where student_id = "".$student_id.""";

    $student_value = $mysql->getLine( $sql );

//读值

    $period = $student_value["period"];

    $state = $student_value["state"];

//输出

    echo $period;

或者

   $sql = "SELECT * FROM  `cabinet` WHERE state_M =0 LIMIT 0 , 1";

   $data = $mysql->getData( $sql );

   $cabinet_id = $data[0]["cabinet_id"];