存储过程 mysql php_用 PHP 调用 MySQL 存储过程

MySQL 5.0 以上支持存储过程。

PHP 5.0 以上的 mysqli 系列函数可以支持操作 MySQL 的存储过程。

以下是一些简单的存储过程和用 PHP 调用的示例。     一、返回单个数据: 1: <?php

2: header("Content-Type:text/html;charset=utf-8");

3:

4: $host = "localhost";

5: $user = "root";

6: $password = "mypassword";

7: $db = "test_store_proc";

8: $dblink = mysqli_connect($host, $user, $password, $db) or die("can't connect to mysql");

9:

10: $dblink->query('SET NAMES UTF8');

11: if ($result = $dblink->query("CALL sp_test0(@num, @x, 123)"))

12: {

13: $rs = $dblink->query("select @num");

14: $row = $rs->fetch_array();

15: echo $row['@num'], '
';

16:

17: $rs = $dblink->query("select @x");

18: $row = $rs->fetch_array();

19: echo $row['@x'];

20:

21: mysqli_free_result($rs);

22: }

23: else

24: echo 'error...';

25: mysqli_close($dblink);

26:

27: /*

28: -- Procedure "sp_test0" DDL

29: CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test0`(OUT num INT, OUT x VARCHAR(16), IN n INT)

30: BEGIN

31: DECLARE nouse int;

32: DECLARE tmp int;

33:

34: SELECT nId INTO nouse from open_news WHERE nID=39;

35: SELECT count(*) INTO tmp from open_news;

36: SET num = tmp;

37:

38: SET x = 'XXX';

39: END;

40: */

41: ?>

42:

二、返回结果集:

1: <?php

2: header("Content-Type:text/html;charset=utf-8");

3:

4: $host = "localhost";

5: $user = "root";

6: $password = "mypassword";

7: $db = "te