如何在php/mysql中调用过程 - How to call procedure in php/mysqli?

How to call procedure in php/mysqli?

本文关键字：调用过程 mysql php | 更新日期: 2023-09-27

我在MySQL中使用。但是我不能调用程序。

<?php
$mysqli = new mysqli("localhost", "user", "pass", "testDB");
$query = "SELECT * FROM testTable";
if ($result = $mysqli->query($query)) {
    $row = $result->fetch_assoc();
    header("Content-type: audio/mpeg"); 
    echo $row['audioData'];
    $result->free();
}
$mysqli->close();
?>

试试下面的代码:

<?php
//database gegevens
$servername = "localhost";
$username = "root";
$password = "mysql";
$dbname = "db";

//maak connectie met database
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$result = mysqli_query($conn, "SELECT * FROM testTable") or die(mysqli_error($conn));
if (mysqli_num_rows($result)>=1) {
    while($row = mysqli_fetch_array($result)) {
        $name = $row['name'];
   }   
  } 
 ?>

可以使用" call "关键字调用该过程。

$query = "CALL procedure_name(para_1,para_2);";

$result = $mysqli->query($query)