{"id":8084,"date":"2021-07-23T13:28:06","date_gmt":"2021-07-23T18:28:06","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=8084"},"modified":"2021-07-23T13:28:06","modified_gmt":"2021-07-23T18:28:06","slug":"php-oci_bind_by_name-caveat-a-k-a-a-reminder-to-read-the-documentation","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=8084","title":{"rendered":"PHP oci_bind_by_name Caveat (a.k.a. a reminder to read the documentation)"},"content":{"rendered":"

This is readily apparent when you actually read the documentation for oci_bind_by_name<\/a> \u2026 but, if you quickly skim through the doc and get mostly what it\u2019s telling you, you can lose data when implementing oci_bind_by_name in your code. That\u2019s because the variable that gets bound into the name is a reference<\/em>. It\u2019s right there in the description<\/p>\n

<\/p>\n

And again in the more verbose part of the description<\/p>\n

<\/p>\n

Well? They really mean It!<\/p>\n

I usually iterate through arrays with for $x=0; $x<count($arrayOfData);$x++ — which is fine because $arrayOfData[$x] is a valid location in memory that contains the data I want. I had a program, though, that accepted user input. Input that frequently contains a bunch of extraneous newline characters in the middle of the data. To avoid making the users clean up their input, I just threw an array_filter on the input. But I don\u2019t need<\/em> the reorganized data, so I didn\u2019t \u201cwaste\u201d the cycles to re-index the filtered array. Instead, I used<\/p>\n

$iIterator=0;\r\nfor( $itemInput in array_filter( $arrayOfData ) ) {\r\n     oci_bind_by_name($stmt, \u2018:placeholder\u2019.$iIterator++, $itemInput);\r\n}<\/pre>\n
Which is fine in most circumstances. But, with oci_bind_by_name \u2026 the memory address where $inputItem happened to be stashed is bound to the names :placeholder0, :placeholder1, \u2026, :placeholdern<\/em> \u2013 that memory address happened<\/em> to still contain the last element of arrayOfData I happened to stash there because the server isn\u2019t so busy that memory is being reallocated a fraction of a second later. But this loop does not<\/em> bind each element of arrayOfData to its corresponding placeholder — instead of saying “select * from MyTable where ID IN (1,2,3,4,5)” … I had “select * from MyTable where ID IN (5,5,5,5,5)”.<\/p>\n
In this case you need<\/em> to use the array index<\/p>\n
for( $x = 0; $x < count( $arrayOfData ); $x++ ) {\r\n     $strPlaceholderName\u00a0=\u00a0\":inputclli\".$x;\r\n     oci_bind_by_name($stmt, $strPlaceholderName, $arrayOfData[$x]);\r\n}<\/pre>\n
So each unique memory address is bound to a placeholder.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is readily apparent when you actually read the documentation for oci_bind_by_name \u2026 but, if you quickly skim through the doc and get mostly what it\u2019s telling you, you can lose data when implementing oci_bind_by_name in your code. That\u2019s because the variable that gets bound into the name is a reference. It\u2019s right there in …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,1004],"tags":[1431,35,1432],"class_list":["post-8084","post","type-post","status-publish","format-standard","hentry","category-coding","category-oracle","tag-oci_bind_by_name","tag-php","tag-rtfm"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/8084","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8084"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/8084\/revisions"}],"predecessor-version":[{"id":8087,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/8084\/revisions\/8087"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}