如何通过会话值的存储过程将数据插入表？

Question

This is a stored procedure in mysql database.

I tried mysql_query($connection, "CALL xyz") but shows me error.

by store procedure I want to insert data to table

I want insert data from session values in my php page.

Answer 1

Stored procedures can be called using the CALL keyword. The first procedure you list would be called with parameters similar to this:

$mysqli = new mysqli('localhost', 'user', 'password', 'database');
$mysqli->query("CALL p_maintain_user('i', 123, 123, 'password', 'a')");

The PHP website provides an article with more information on this.