vb.net 调用 mysql 存储过程并获得返回值_PHP 调用 MySQL 存储过程并获得返回值

Employee listing

Enter Department ID:

$hostname = "localhost";

$username = "root";

$password = "secret";

$database = "prod";

if (IsSet ($_POST['submit'])) {

$dbh = new mysqli($hostname, $username, $password, $database);

/* check connection */

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit ();

}

$dept_id = $_POST['dept_id'];

if ($result_set = $dbh->query("call employee_list( $dept_id )")) {

print ('

'

Employee_idSurnameFirstname');

while ($row = $result_set->fetch_object()) {

printf("

%s%s%s\n",

$row->employee_id, $row->surname, $row->firstname);

}

} else {

printf("

Error:%d (%s) %s\n", mysqli_errno($dbh),

mysqli_sqlstate($dbh), mysqli_error($dbh));

}

print ("

");

$dbh->close();

}

?>