Fatal error Call to a member function query on null

Question

I m not sure what s going wrong here  I was just following a tutorial online and these errors popped up   I m getting the following errors  Error  Notice  Undefined variable  db in C  xampp htdocs wisconsindairyfarmers admin login php on line 7  Fatal error  Call to a member function query   on null in C  xampp htdocs wisconsindairyfarmers admin login php on line 7   Code   lt  php  db   new mysqli  127 0 0 1    root        wisconsindairyfarmers      gt    lt  php require     db connect php   require     functions general php        function user exists  username              username   sanitize  username            result    db- gt query  SELECT COUNT UserId  FROM users WHERE UserName     username             if  result- gt num rows           return  mysqli result  query  0     1    true   false          if empty   POST      false         username     POST  username         password     POST  password         if empty  username      true    empty  password      true            echo  You need to enter a username and password             else if user exists  username      false            echo  We can  t find that username               gt

User · Accepted Answer

First  you declared  db outside the function  If you want to use it inside the function  you should put this at the begining of your function code   global  db    And I guess  when you wrote   if  result- gt num rows           return  mysqli result  query  0     1    true   false    what you really wanted was   if   result- gt num rows  1    return true    else   return false

User · Answer

put this line in parent construct    this- load- database     function    construct         parent    construct         this- gt load- gt library  lib name         model array  model name         this- gt load- gt model  model        this- gt load- gt database        this way   it should work

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

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to database-connection