In PHP, the call to a stored procedure fails in PDO mode.

MYSQL, stored procedures

CREATE definer= ' trip_admin ' @ ' localhost ' PROCEDURE ' outtemp ' (out ' P_outtext ' VARCHAR ()) Proc:begin    set P_ outtext= ' testing ';    INSERT INTO TEMP (TP) value (P_outtext); END

Table temp, just a TP field.

Php,pdo way, call this stored procedure, no return value, table also does not add data.

$DSN = "$DBMS: host= $HOST;d bname= $DBName"; $pdo = new PDO ($DSN, $UserName, $PassWord); $pdo, query ("Set names Uft8"); $ result= $pdo->prepare ("Call Outtemp (?)"); $result->bindparam (1, $result _text,pdo::P aram_str,100); $result->execute ();

Environment:
Windows Server x64
MySQL 5.6.19
PHP 5.5.14

Reply to discussion (solution)

What's going on here. A stored procedure with multiple in and out parameters is also resolved, and the return value is called and obtained with PDO.

