Fatal error Call to a member function prepare on null

Question

I am trying to access a list of categories and their contents  I have a class called Categories  I keep getting this error  The weird thing is that I ve used this same exact code in two other places so far with no problems  All I did here was reuse the code and change all the variables   Fatal error  Call to a member function prepare   on null   Here is the code to my class        lt  php  class Category       public function fetch all             global  pdo            query    pdo- gt prepare  SELECT   FROM dd cat             query- gt execute             return  query- gt fetchAll               public function fetch data  cat id            global  pdo            query    pdo- gt prepare  SELECT   FROM dd cat WHERE cat id                 query- gt bindValue 1   cat id            query- gt execute             return  query- gt fetch               gt    And here is the code I am trying to call     lt  php session start      Add session start to top of each page   require once  includes config php    require once  includes header php    include once  includes category php       gt   lt link rel  stylesheet  href  css dd css  gt       lt div id  menu  gt           lt a class  item  href  drop index php  gt Home lt  a gt  -          lt a class  item  href  create topic php  gt Create a topic lt  a gt  -          lt a class  item  href  create cat php  gt Create a category lt  a gt           lt div id  userbar  gt   lt  php     if   user- gt is logged in                   echo  Hello       SESSION  user name        Not you   lt a href  logout php  gt Sign out lt  a gt              else               echo   lt a href  login php  gt Sign in lt  a gt  or  lt a href  index php  gt create an account lt  a gt              gt           lt  div gt       lt  div gt    lt  php   category   new Category   categories    category- gt fetch all       gt       lt div id   wrapper  gt           lt h1 gt Categories lt  h1 gt           lt section gt               lt ul gt                   lt  php foreach   categories as  category      gt                       lt li gt  lt a href  category php id  lt  php echo  category  cat id      gt   gt                           lt  php echo  category  cat title      gt  lt  a gt                        lt  li gt                   lt  php     gt               lt  ul gt           lt  section gt       lt  div gt   lt  php require once  includes footer php      gt

User · Accepted Answer

It looks like your  pdo variable is not initialized  I can t see in the code you ve uploaded where you are initializing it   Make sure you create a new PDO object in the global scope before calling the class methods   You should declare it in the global scope because of how you implemented the methods inside the Category class     pdo   new PDO  mysql host localhost dbname test    user   pass

User · Answer

You can try catch PDOExceptions  your configs could differ but the important part is the try catch    try            dbh   new PDO              DB TYPE     host     DB HOST     dbname     DB NAME     charset     DB CHARSET              DB USER              DB PASS                                PDO  ATTR PERSISTENT              gt  true                  PDO  ATTR ERRMODE                 gt  PDO  ERRMODE EXCEPTION                  PDO  MYSQL ATTR INIT COMMAND      gt   SET NAMES     DB CHARSET     COLLATE     DB COLLATE                                 catch   PDOException  e             echo  ERROR            print r   e            The print r   e    line will show you everything you need  for example I had a recent case where the error message was like unknown database  my db

User · Answer

In ---- model  Add use Jenssegers Mongodb Eloquent Model as Eloquent  Change the class ----- extends Model  to class ----- extends Eloquent

User · Answer

delato468 comment must be listed as a solution as it worked for me   In addition to defining the parameter  the user must pass it too at the time of calling the function  fetch data PDO  pdo   cat id

[php] Fatal error: Call to a member function prepare() on null

Examples related to php