PHP 調用 MySQL 預存程序並獲得傳回值的代碼

Employee listing 複製代碼 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: %s\n", 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()) { $row->employee_id, $row->surname, $row->firstname); '. '); printf(" \n", } } else { printf(" Error:%d (%s) %s\n", mysqli_errno($dbh), mysqli_sqlstate($dbh), mysqli_error($dbh)); } print (" Employee_id Surname Firstname %s %s %s "); $dbh->close(); } ?> 複製代碼

