Stored Procedures, MySQL and PHP

by

@michal kralik – unfortunately there’s a bug with the MySQL C API that PDO uses which means that running your code as above with some versions of MySQL results in the error:

“Syntax error or access violation: 1414 OUT or INOUT argument $parameter_number for routine $procedure_name is not a variable or NEW pseudo-variable”.

You can see the bug report on bugs.mysql.com. It’s been fixed for version 5.5.3+ & 6.0.8+.

To workaround the issue, you would need to separate in & out parameters, and use user variables to store the result like this:

$stmt = $dbh->prepare("CALL sp_takes_string_returns_string(:in_string, @out_string)");
$stmt->bindParam(':in_string', 'hello'); 

// call the stored procedure
$stmt->execute();

// fetch the output
$outputArray = $this->dbh->query("select @out_string")->fetch(PDO::FETCH_ASSOC);

print "procedure returned " . $outputArray['@out_string'] . "\n";

More Related Contents:

  1. How to call a MySQL stored procedure from within PHP code?
  2. How to write a stored procedure using phpmyadmin and how to use it through php?
  3. Store procedures in phpMyAdmin
  4. Calling stored procedure with Out parameter using PDO
  5. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  6. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  7. How to write a stored procedure in phpMyAdmin?
  8. Update Mysql except when field not null
  9. How can I prevent SQL injection in PHP?
  10. UTF-8 all the way through
  11. SQL injection that gets around mysql_real_escape_string()
  12. Can I mix MySQL APIs in PHP?
  13. jQuery Validate remote method usage to check if username already exists
  14. MySQL query to get column names?
  15. How do you connect to multiple MySQL databases on a single webpage?
  16. PDO get the last ID inserted
  17. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  18. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  19. Insert/update helper function using PDO
  20. MySQLi count(*) always returns 1
  21. Formulas to Calculate Geo Proximity
  22. Get all child, grandchild etc nodes under parent using php with mysql query results
  23. Laravel Migration table already exists, but I want to add new not the older
  24. Saving images in database mysql
  25. convert date string to mysql datetime field
  26. Set PDO to throw exceptions by default [duplicate]
  27. MySQL Alter Table Add Field Before or After a field already present
  28. mysql error ‘TYPE=MyISAM’
  29. Storing datetime as UTC in PHP/MySQL
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment