Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP 如何获取存储过程的返回值

PHP 如何获取存储过程的返回值

WBOY
Release： 2016-06-23 14:20:27
Original
1443 people have browsed it

	$query = "CALL T_PROCEDURE_GETPHONE($pid,@phone)";		$conn->query($query);		$query1 = 'SELECT @phone';		$result = $conn->query($query1);		$rr = $result->fetch_row();
Copy after login

$result->num_rows 返回是1

而且用cmd 来调用函数, 返回的是有号码的.
但是在PHP中,返回的就什么都没有了


回复讨论(解决方案)

$result->num_rows 返回是1 说明有一条记录 

echo $rr[0];
Copy after login

Related labels：
PHP 如何获取存储过程的返回值
source：php.cn
Previous article：请教php+mysql中文字符乱码问题，麻烦大家给提提建议 Next article：如何提升网站的访问量和文章收录呢？
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
Latest Articles by Author
Latest Issues
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Avoid including domain logic in the repository layer In my current application I need to create an apiGET route "/inactive-users" whi...
From 2024-04-02 00:02:19
0
1
418
How to get all values ​​from database and return to PHP code in XML field? I need some help with my application. I have this code: realtime.php $jogador=Jogador::get...
From 2024-03-30 16:09:24
0
1
397
How can we capture the resource usage of a specific stored procedure in mysql server How to capture the resource usage of a specific stored procedure in MYSQL server and how t...
From 2024-03-30 09:59:56
0
1
390
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template