mysqli query Couldn t fetch mysqli

Question

Warning  mysqli  query    Couldn t fetch mysqli in C  Program Files  x86  EasyPHP-DevServer-13 1VC9 data localweb my portable files class EventCalendar php on line 43   The following is my connection file    lt  php if  isset   SESSION           session start             Create array to hold error messages  if any   ErrorMsgs   array        Create new mysql connection object  DBConnect    new mysqli  localhost   root localhost                NULL  Ladle        Check to see if connection errno data member is not 0  indicating an error  if   DBConnect- gt connect errno            Add error to errors array      ErrorMsgs    The database server is not available                     Connect Error is    DBConnect- gt connect errno                      DBConnect- gt connect error          gt    This is my class     lt  php      class EventCalendar           private  DBConnect   NULL           function   construct                    Include the database connection data             include  inc LadleDB php                 this- gt DBConnect    DBConnect                       function   destruct                 if    this- gt DBConnect- gt connect error                     this- gt DBConnect- gt close                                     function   wakeup                    Include the database connection data             include  inc LadleDB php                      this- gt DBConnect    DBConnect                         Function to add events to Zodiac calendar         public function addEvent  Date   Title   Description                   Check to see if the required fields of Date and Title have been entered             if    empty  Date    amp  amp    empty  Title                         if all fields are complete then they are                     inserted into the Zodiac event calendar table                     SQLString    INSERT INTO tblSignUps                                 EventDate  Title  Description                                  VALUES   Date     Title                                    Description                           Store query results in a variable                  QueryResult    this- gt DBConnect- gt query  SQLString     I m not great with OOP PHP and I m not sure why this error is being raised  I pulled this code from elsewhere and the only thing I changed was the  new mysqli parameters  Can anyone help me to understand what is going wrong

User · Accepted Answer

Probably somewhere you have DBconnection- gt close    and then some queries try to execute      Hint  It s sometimes mistake to insert    - gt close    in   destruct    because   destruct is event  after which there will be a need for execution of queries

User · Answer

I had the same problem  I changed the localhost parameter in the mysqli object to  127 0 0 1  instead of writing  localhost   It worked  I   m not sure how or why    db connection   new mysqli  127 0 0 1   root      db name      Hope it helps

User · Answer

Reason of the error is wrong initialization of the mysqli object  True construction would be like this    DBConnect   new mysqli  localhost   root      Ladle

User · Answer

Check if db name do not have     or  -   that helps in my case

[php] mysqli::query(): Couldn't fetch mysqli

Examples related to php

Examples related to mysql

Examples related to mysqli