PHP calls the mysql stored procedure to return the result set

  $db = new mysqli('localhost', 'root','', 'mydatabase');

  $result = $db->query('CALL get_employees()');

  while (list($employee_id, $name, $position) = $result->fetch_row()) {
     echo '$employeeid, $name, $position ';
  }

?>

存储过程, php, mysql