PHP - Global Variables Null After Function Call

Hi guys, 

I am trying to install a script and I am getting this error when loading for the first time kindly assist anyone.

Hi guys,

I am trying to implement a Pagination class for a website displaying movies. I need to have the total number of posts, but on accessing the function row_count() from class Connection I get the error: "Fatal error: Uncaught Error: Call to a member function query() on null in ..\connection.php:30 Stack trace: #0 from ...\index.php(20): Connection->row_count() #1 ..."

I only found two posts concerning this issue, and they led me to think this might be a scope issue with $db variable; $db is defined in the constructor function of the same Connection class so I thought the scope would be ok; but apparently, not.

Can anybody help? This is a real show-stopper just now. Please let me know if you need any further information.

Thanks in advance.

Sept

connection.txt index.txt

Excerpts of code:

        function addUser() {
	    $username = $_POST['username'];
	    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
	    $bio = $_POST['bio'];
	    $email = $_POST['email'];
	    $c_status = 0;
            //$avatar = 

	    //$username_query = $pdo->prepare("SELECT * from profiles001 WHERE username=':username'");
            //$username_query->bindValue(':username', $username);
            //$username_query->execute();

            $query = $pdo->prepare("INSERT into profiles001 (username, password, email, c_status, bio) VALUES (:username, :password, :email, :cstat, :bio)");

            $query->bindValue(':username', $username);
            $query->bindValue(':password', $password);
            $query->bindValue(':email', $email);
            $query->bindValue(':cstat', $c_status);
            $query->bindValue(':bio', $bio);

            $query->execute();

            setAvatar();
        }

        function setAvatar() {
            // check if avatar is set, if not give default avatar
            if (isset($file) && $fileError === UPLOAD_ERR_OK) {
                $file = $_FILES['userfile'];
                $fileName = $file['name'];
                $fileTmpName = $file['tmp_name'];
                $fileSize = $file['size'];
                $fileError = $file['error'];
                $fileType = $file['type'];
                $fileExt = explode('.', $fileName);
                $fileActualExt = strtolower(end($fileExt));

                $allowedExtensions = array('jpg', 'jpeg', 'png');
            }

           

            // if user has not assigned avatar, assign the default.
            if (empty($file)) {
                $avatar = "assets/soap.jpg";
                
                $query = $pdo->prepare("INSERT INTO profiles001 (avatar) VALUES (:avatar)");

                $query->bindValue(':avatar', $avatar);
                $query->execute();
            }
        }

       addUser(); 
}

From the database file:

<?php
$host   = "localhost";
$database = "soapbox";
$username = "drb";
$password = "m1n3craft";

// Create connection
 		$pdo = new PDO('mysql:host=localhost;dbname=soapbox;', $username, $password);

/*

Print error message and or code to the screen if there is an error.

*/

?>

NOTE: I also require dbcon.php at the top of the confirmation.php file which is NOT included in the excerpt at the top.

Making pdo a global variable would probably fix it, but from what I heard globals are frowned upon.

i've tried whit a lot of solutions from other posts but nothing seems to be working 

this part is where im having trouble but i dont know how to get it to work
```
        $this->load->library('form_validation');
        $this->load->library('form');
```

Controler
```
    <?php

namespace App\Controllers;

class Home extends BaseController
{
  public function __contruct()
{
    parent::__construct();// you have missed this line.
    
}
    public function index()
    {
        helper (['form']);
        return view('inicio');
    }
    public function descarga()
    {
        return view('filesnames');
    }
    public function conta()
    {
        $this->load->library('form_validation');
        $this->load->library('form');
        return view('contact/index');
    }
    public function pregu()
    {
        return view('preguntas');
    }
    public function dud(){
        return view('duda');
    }
    public function contact()
    {
    
        $autoload['libraries'] = array('session','Email','form','form_validation');
        $autoload['helper']=array('form', 'url');

    //Set form validation
    $this->form_validation->set_rules('name', 'Name', 'trim|required|min_length[3]|max_length[20]');
    $this->form_validation->set_rules('email', 'Email', 'trim|required|valid_email|min_length[0]|max_length[60]');
    $this->form_validation->set_rules('message', 'Message', 'trim|required|min_length[5]|max_length[200]');

    //Run form validation
    if ($this->form_validation->run() === FALSE)
    {
        $this->load->view('contacto');
    } else {

        //Get the form data
        $name = $this->input->post('name');
        $from_email = $this->input->post('email');
        $subject = $this->input->post('subject');
        $message = $this->input->post('message');

        //Web master email
        $to_email = 'admin@domain.com'; //Webmaster email, who receive mails

        //Mail settings
        $config['protocol'] = 'smtp';
        $config['smtp_host'] = 'ssl://smtp.gmail.com';
        $config['smtp_port'] = '465';
        $config['smtp_user'] = 'mail@domain.com'; // Your email address
        $config['smtp_pass'] = 'mailpassword'; // Your email account password
        $config['mailtype'] = 'html'; // or 'text'
        $config['charset'] = 'iso-8859-1';
        $config['wordwrap'] = TRUE; //No quotes required
        $config['newline'] = "\r\n"; //Double quotes required

        $this->email->initialize($config);                        

        //Send mail with data
        $this->email->from($from_email, $name);
        $this->email->to($to_email);
        $this->email->subject($subject);
        $this->email->message($message);
        
        if ($this->email->send())
        {
            $this->session->set_flashdata('msg','<div class="alert alert-success">Mail sent!</div>');

            redirect('contact');
        } else {
            $this->session->set_flashdata('msg','<div class="alert alert-danger">Problem in sending</div>');
            $this->load->view('contacto');
        }

    }
  }
}
```
view
```
    <body class="ecommerce">

  <div class="header">
    <div class="container">
      <a class="site-logo" href="<?= site_url('/'); ?>"><img src="assets/images/home/logou2.png" class="logosi" alt=""></a>

      <a href="javascript:void(0);" class="mobi-toggler"><i class="fa fa-bars"></i></a>
    </div>

    <!-- BEGIN NAVIGATION -->
    <div class="header-navigation">
      <ul>
        <li><a href="<?= site_url('/'); ?>">Inicio</a></li>
        <li><a href="<?php base_url()?>Asistentev16.apk" download="Asistentev16.apk">Descargar</a></li> 
        <li><a href="<?= site_url('/cont'); ?>">Contactanos</a></li>   
        <li><a href="<?= site_url('/faq'); ?>">Preguntas Frecuentes</a></li>         
        </ul>
    </div>
  </div><br>
<div class="container">
<h2>Contact</h2>
<div class="row">
  <?php $validation =  \Config\Services::validation(); ?>
    <div class="col-lg-6">
        <?php echo $_SESSION['msg']; ?>
        <form action="<?php echo base_url('/submit-form') ?>" method="post">
        <div class="form-group">Nombre
            <?php echo form_input(array('name' => 'name', 'id' => 'name', 'size' => '50', 'value' => set_value('name'))) ?>
            <?php if ($validation->getError('name')): ?>
               <div class="invalid-feedback">
                  <?= $validation->getError('name') ?>
               </div>                                
            <?php endif; ?>
        </div>
        <div class="form-group">Email
            <?php echo form_input(array('email' => 'email', 'id' => 'email', 'size' => '50', 'value' => set_value('email'))) ?>
            <?php if ($validation->getError('email')): ?>
               <div class="invalid-feedback">
                  <?= $validation->getError('email') ?>
               </div>                                
            <?php endif; ?>
        </div>
        <div class="form-group">Asunto
            <?php echo form_input(array('subject' => 'subject', 'id' => 'subject', 'size' => '50', 'value' => set_value('subject'))) ?>
            <?php if ($validation->getError('subject')): ?>
               <div class="invalid-feedback">
                  <?= $validation->getError('subject') ?>
               </div>                                
            <?php endif; ?>
        </div>
        <div class="form-group">Mensaje
            <?php echo form_input(array('message' => 'message', 'id' => 'message', 'value' => set_value('message'))) ?>
            <?php if ($validation->getError('message')): ?>
               <div class="invalid-feedback">
                  <?= $validation->getError('message') ?>
               </div>                                
            <?php endif; ?>
        </div>
        <button name="submit" type="submit" class="btn btn-primary" />Send</button>
        </form>
    </div>
</div>
</body>
```