Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > PHP code to call MySQL stored procedure and get the return value

PHP code to call MySQL stored procedure and get the return value

WBOY

Release： 2016-07-25 08:52:01

Original

808 people have browsed it

Employee listing
Enter Department ID:

复制代码

php代码

$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: %sn", mysqli_connect_error());
exit ();
}
$dept_id = $_POST['dept_id'];
if ($result_set = $dbh->query("call employee_list( $dept_id )")) {
print (' '.
'
');
while ($row = $result_set->fetch_object()) {
printf("
n",
$row->employee_id, $row->surname, $row->firstname);
}
} else {
printf("
Error:%d (%s) %sn", mysqli_errno($dbh),
mysqli_sqlstate($dbh), mysqli_error($dbh));
}
print ("

Employee_id Surname Firstname

%s %s %s

");
$dbh->close();
}
?>

复制代码

Related labels：

PHP 调用 MySQL 存储过程并获得返回值的代码

source：php.cn

Previous article：Understand and learn the PHP framework in all aspects Next article：Adjust PHP upload file size limit

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

PHP code to call MySQL stored procedure and get the return value

Employee listing