{"id":114,"date":"2015-12-05T13:06:08","date_gmt":"2015-12-05T11:06:08","guid":{"rendered":"http:\/\/test01.georgebaciu.pro\/?p=114"},"modified":"2016-09-07T15:23:17","modified_gmt":"2016-09-07T13:23:17","slug":"how-to-get-stored-procedures-out-param-on-mysql-w-pdo","status":"publish","type":"post","link":"https:\/\/blog.georgebaciu.pro\/?p=114","title":{"rendered":"how to get stored procedures’ out param on mysql w\/ pdo"},"content":{"rendered":"

I found that mysql supports stored procedures and start working on them. Bad idea!<\/p>\n

On php site (http:\/\/php.net\/manual\/en\/pdo.prepared-statements.php<\/a>) you get this piece of code:
\nExample #4 Calling a stored procedure with an output parameter<\/em>
\n <?php<\/em>
\n$stmt\u00a0=\u00a0$dbh->prepare(\"CALL\u00a0sp_returns_string(?)\");<\/em>
\n$stmt->bindParam(1,\u00a0$return_value,\u00a0PDO::PARAM_STR,\u00a04000);\u00a0<\/em>
\n$stmt->execute();<\/em>
\nprint\u00a0\"procedure\u00a0returned\u00a0$return_value\\n\";<\/em>
\n?><\/em>
\n<\/code><\/p>\n

After spending a couple of hours on trial-error coding different solutions<\/em> I compiled this workaround:
\n<?php<\/em>
\n$stmt\u00a0=\u00a0$dbh->prepare(\"CALL\u00a0sp_returns_string(@out_param)\");<\/em>
\n$stmt->execute();<\/em>
\n$result =\u00a0 dbh->query(\"SELECT @out_param\")->fetch();<\/em>
\nprint\u00a0\"procedure\u00a0returned \". $result['@out_param'] .\"\\n\";<\/em>
\n?><\/em>
\n<\/code>
\nTo conclude: do not use mysql and php on any serious apps.
\nG.<\/p>\n","protected":false},"excerpt":{"rendered":"

I found that mysql supports stored procedures and start working on them. Bad idea! On php site (http:\/\/php.net\/manual\/en\/pdo.prepared-statements.php) you get this piece of code: Example #4 Calling a stored procedure with an output parameter <?php $stmt\u00a0=\u00a0$dbh->prepare(“CALL\u00a0sp_returns_string(?)”); $stmt->bindParam(1,\u00a0$return_value,\u00a0PDO::PARAM_STR,\u00a04000);\u00a0 $stmt->execute(); print\u00a0“procedure\u00a0returned\u00a0$return_value\\n”; ?> After spending a couple of hours on trial-error coding different solutions I compiled this workaround: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,5],"tags":[22,24,23],"_links":{"self":[{"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=\/wp\/v2\/posts\/114"}],"collection":[{"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=114"}],"version-history":[{"count":6,"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions"}],"predecessor-version":[{"id":127,"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions\/127"}],"wp:attachment":[{"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.georgebaciu.pro\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}