PHP5 OOP and ajax - database connection

[Alex1234]

Hi everyone

I am trying to use my function that is the database connection on an ajax page.

See the next code and if can help me will be great

Thanks community

config.php

<?php
require_once 'functions.php';
?>

functions.php

<?php
class User  {

    /* Variables */
    public $MySqlUserName = 'root';
    public $MySqlPassword = 'something';
    public $Con;

    public function DatabaseConnection() {
        $TryConnection = new PDO('mysql:host=localhost;dbname=something', $this->MySqlUserName,$this->MySqlPassword, array(PDO::ATTR_PERSISTENT => true));
    
        if ($TryConnection) {
            $this->Con = $TryConnection;
        }
        
        else {
            // Redirect
        }
        
        return $this->Con;
        
    }
}
?>

ajax.php

<?php
require 'config.php';
$SQL = $this->Con->prepare("the query");----> this query is what is not working it is because of the ($this->Con), i tried to add on the top of this file:
$UserClass = new User();
$UserClass = DatabaseConnection();

but it still not working, anyone can help me? Thanks Community
?>

index.php

<?php
 require_once 'config.php';
 $UserClass = new User();
 $UserClass->DatabaseConnection();
?>

[Belrick]

I wish i could help but:
a. your code seems really convoluted
b. its missing parts of its code anyway.

How can help tell what you've left out accidently apart from whats not there on purpose?