Call to undefined method mysqli stmt get result

Question

Here s  my code   include  conn php    conn   new Connection     query    SELECT EmailVerified  Blocked FROM users WHERE Email     AND SLA     AND  Password         stmt    conn- gt mysqli- gt prepare  query    stmt- gt bind param  sss     POST  EmailID      POST  SLA      POST  Password      stmt- gt execute     result    stmt- gt get result      I get the error on last line as  Call to undefined method mysqli stmt  get result    Here is the code for conn php   define  SERVER    localhost    define  USER    root    define  PASS    xxxx    define  DB    xxxx    class Connection                  var Resource              var  mysqli   null       function   construct            try              if   this- gt mysqli                    this- gt mysqli   new MySQLi SERVER  USER  PASS  DB                   if   this- gt mysqli                      throw new Exception  Could not create connection using MySQLi    NO CONNECTION                                    catch Exception  ex               echo  ERROR     e- gt getMessage                        If I write this line    if  stmt  echo  Statement prepared   else echo  Statement NOT prepared     It prints  Statement NOT prepared   If I run the query directly in the IDE replacing   marks with values  it works fine  Please note that  conn object works fine in other queries in the project   Any help please

User · Answer

With PHP version 7 2 I just used nd mysqli instead of mysqli and it worked as expected   Steps to enable it into godaddy hosting server-   Login to cpanel  Click on  Select PHP version   As provided the snapshot of the latest configurations uncheck  mysqli  and enable  nd mysqli

User · Answer

I realize that it s been a while since there has been any new activity on this question   But  as other posters have commented - get result   is now only available in PHP by installing the MySQL native driver  mysqlnd   and in some cases  it may not be possible or desirable to install mysqlnd   So  I thought it would be helpful to post this answer with info on how get the functionality that get result   offers - without using get result     get result   is was often combined with fetch array   to loop through a result set and store the values from each row of the result set in a numerically-indexed or associative array   For example  the code below uses get result   with fetch array   to loop through a result set  storing the values from each row in the numerically-indexed  data   array    c 1000   sql  select account id  username from accounts where account id lt      stmt    mysqli- gt prepare  sql                     stmt- gt bind param  i    c                                                 stmt- gt execute     result    stmt- gt get result           while  data    result- gt fetch array MYSQLI NUM        print  data 0            data 1      lt BR gt  n        However  if get result   is not available  because mysqlnd is not installed   then this leads to the problem of how to store the values from each row of a result set in an  array  without using get result     Or  how to migrate legacy code that uses get result   to run without it  e g  using bind result   instead  - while impacting the rest of the code as little as possible   It turns out that storing the values from each row in a numerically-indexed array is not so straight-forward using bind result     bind result   expects a list of scalar variables  not an array    So  it takes some doing to make it store the values from each row of the result set in an array   Of course  the code could easily be modified as follows    c 1000   sql  select account id  username from accounts where account id lt      stmt    mysqli- gt prepare  sql                     stmt- gt bind param  i    c                                                 stmt- gt execute     stmt- gt bind result  data 0    data 1    while   stmt- gt fetch         print  data 0            data 1      lt BR gt  n        But  this requires us to explicitly list  data 0    data 1   etc  individually in the call to bind result    which is not ideal   We want a solution that doesn t require us to have to explicitly list  data 0    data 1        data N-1   where N is the number of fields in the select statement  in the call to bind results     If we re migrating a legacy application that has a large number of queries  and each query may contain a different number of fields in the select clause  the migration will be very labor intensive and prone to error if we use a solution like the one above   Ideally  we want a snippet of  drop-in replacement  code - to replace just the line containing the get result   function and the while   loop on the next line   The replacement code should have the same function as the code that it s replacing  without affecting any of the lines before  or any of the lines after - including the lines inside the while   loop   Ideally we want the replacement code to be as compact as possible  and we don t want to have to taylor the replacement code based on the number of fields in the select clause of the query   Searching on the internet  I found a number of solutions that use bind param   with call user func array    for example  Dynamically bind mysqli stmt parameters and then bind result  PHP    but most solutions that I found eventually lead to the results being stored in an associative array  not a numerically-indexed array  and many of these solutions were not as compact as I would like and or were not suited as  drop-in replacements    However  from the examples that I found  I was able to cobble together this solution  which fits the bill    c 1000   sql  select account id  username from accounts where account id lt      stmt    mysqli- gt prepare  sql                     stmt- gt bind param  i    c                                                 stmt- gt execute     data array    for   i 0  i lt  mysqli- gt field count  i            var    i        var   null        data  var     amp   var     call user func array array  stmt  bind result     data   while   stmt- gt fetch         print  data 0            data 1      lt BR gt  n        Of course  the for   loop can be collapsed into one line to make it more compact     I hope this helps anyone who is looking for a solution using bind result   to store the values from each row in a numerically-indexed array and or looking for a way to migrate legacy code using get result     Comments welcome

User · Answer

for those searching for an alternative to  result    stmt- gt get result   I ve made this function which allows you to mimic the  result- gt fetch assoc   but using directly the stmt object   function fetchAssocStatement  stmt        if  stmt- gt num rows gt 0                 result   array             md    stmt- gt result metadata             params   array            while  field    md- gt fetch field                   params      amp  result  field- gt name                     call user func array array  stmt   bind result     params           if  stmt- gt fetch                return  result             return null      as you can see it creates an array and fetches it with the row data  since it uses  stmt- gt fetch   internally  you can call it just as you would call mysqli result  fetch assoc  just be sure that the  stmt object is open and result is stored      mysqliConnection is your mysqli connection object if  stmt    mysqli connection- gt prepare  query          stmt- gt execute         stmt- gt store result         while  assoc array   fetchAssocStatement  stmt                   do your magic             stmt- gt close

User · Answer

So if the MySQL Native Driver  mysqlnd  driver is not available  and therefore using bind result and fetch instead of get result  the code becomes   include  conn php    conn   new Connection     query    SELECT EmailVerified  Blocked FROM users WHERE Email     AND SLA     AND  Password         stmt    conn- gt mysqli- gt prepare  query    stmt- gt bind param  sss     POST  EmailID      POST  SLA      POST  Password      stmt- gt execute     stmt- gt bind result  EmailVerified   Blocked   while   stmt- gt fetch            Use  EmailVerified and  Blocked       stmt- gt close     conn- gt mysqli- gt close

User · Answer

I have written two simple functions that give the same functionality as  stmt- gt get result     but they don t require the mysqlnd driver   You simply replace   result    stmt- gt get result    with  fields   bindAll  stmt     and    row   stmt- gt get result    with  row   fetchRowAssoc  stmt   fields      To get the numbers of returned rows you can use  stmt- gt num rows    You just have to place these two functions I have written somewhere in your PHP Script   for example right at the bottom   function bindAll  stmt         meta    stmt- gt result metadata         fields   array         fieldRefs   array        while   field    meta- gt fetch field                   fields  field- gt name                 fieldRefs      amp  fields  field- gt name              call user func array array  stmt   bind result     fieldRefs        stmt- gt store result          var dump  fields       return  fields     function fetchRowAssoc  stmt   amp  fields        if   stmt- gt fetch              return  fields            return false      How it works   My code uses the  stmt- gt result metadata    function to figure out how many and which fields are returned and then automatically binds the fetched results to pre-created references  Works like a charm

User · Answer

Please read the user notes for this method   http   php net manual en mysqli-stmt get-result php  It requires the mysqlnd driver    if it isn t installed on your webspace you will have to work with BIND RESULT  amp  FETCH   https   secure php net manual en mysqli-stmt bind-result php  https   secure php net manual en mysqli-stmt fetch php

User · Answer

I know this was already answered as to what the actual problem is  however I want to offer a simple workaround   I wanted to use the get results   method however I didn t have the driver  and I m not somewhere I can get that added   So  before I called    stmt- gt bind results  var1  var2  var3  var4   etc     I created an empty array  and then just bound the results as keys in that array    result   array     stmt- gt bind results  result  var1    result  var2    result  var3    result  var4     etc     so that those results could easily be passed into methods or cast to an object for further use   Hope this helps anyone who s looking to do something similar

User · Answer

Here is my alternative  It is object-oriented and is more like mysql mysqli things   class MMySqliStmt      private  stmt      private  row       public function   construct  stmt            this- gt stmt    stmt           md    stmt- gt result metadata             params   array            while  field    md- gt fetch field                   params      amp  this- gt row  field- gt name                     call user func array array  stmt   bind result     params  or die  Sql Error               public function fetch array            if  this- gt stmt- gt fetch                  result   array                foreach  this- gt row as  k   gt   v                    result  k     v                            return  result           else              return false                       public function free             this- gt stmt- gt close              Usage    stmt    conn- gt prepare  str        bind param    and so on if   stmt- gt execute   die  Mysql Query Execute  Error      str    result   new MMySqliStmt  stmt   while  row    result- gt fetch array         array push  arr   row         for example  use  row  id      result- gt free      for example  use the  arr

User · Answer

Your system is missing the mysqlnd driver   If you are able to install new packages on your  Debian Ubuntu-based  server  install the driver   sudo apt-get install php5-mysqlnd   and then restart your web server   sudo  etc init d apache2 restart

User · Answer

I was getting this same error on my server - PHP 7 0 with the mysqlnd extension already enabled   Solution was for me  thanks to this page  was to deselect the mysqli extension and select nd mysqli instead   NB - You may be able to access the extensions selector in your cPanel   I access mine via the Select PHP Version option

[php] Call to undefined method mysqli_stmt::get_result

Examples related to php

Examples related to mysqli