Include() Or require() Question

[martinsandhu]

I'm using a config.php file which i use in my database class to change the values however this warning...

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/creative/public_html/demo1/classes/database.class.php on line 16

makes be believe that the functions are not picking up the values in teh config file. Could someone explain if i am not doing something right?

Thanks

<?php
    ob_start();
    session_start();
    

    // The $siteURL is the full URL of where the current site is...
    
    $site = 'demo1';
    
    
    // Database username, host, password and name
    $default_dbname = '*****';
    $dbhost = 'localhost';
    $dbusername = '*****';
    $dbpassword = '*****';


?>

<?php

require ('../config.php');
    
    
    class database
    {    
        
                    
        function databaseConnection()
        {
            
             $link_id = '';
            
            
            $link_id = mysql_pconnect($dbhost,$dbusername,$dbpassword);
            if (!$link_id){
                $MYSQL_ERRNO = 0;
                $MYSQL_ERROR = "Connection Failed to the host".$dbhost."";
                return 0;
            }
            else if (!mysql_select_db($default_dbname)){
                $MYSQL_ERRNO = mysql_errno();
                $MYSQL_ERROR = mysql_error();
                return 0;
            }
        }
        
        function sql_error()
        {
            if(empty($MYSQL_ERROR)){
                $MYSQL_ERRNO = mysql_errno();
                $MYSQL_ERROR = mysql_error();
            }
            return "$MYSQL_ERRNO: $MYSQL_ERROR" ;
        }
        
        
        function siteurl()
        {
        
            return $this->$site;
        
        }
        
        function setSiteUrl($site)
        {
            $this->site = $site;
        }
}
?>

[iktorn]

To get this working you need to add this piece of code in "databaseConnection" function body:

global $dbhost,$dbusername,$dbpassword,$default_dbname; 

[logic_earth]

or instead of using global make them constants.

define('SOMENAME', 'Some Value');
 
function foo() {
    print SOMENAME;
}
 
foo();

[TheRedDevil]

When you use include or require, its a good habit to either use the full path or that its a path from the current directory.

Instead of:
require ('../config.php');

Use:
require './../config.php';
Or
require '/fullpath/to/the/file/config.php';

If you do not do this, php will first look for the file in the global defined file areas, hence you will waste disk io looking in areas the file does not exist.

[martinsandhu]

To get this working you need to add this piece of code in "databaseConnection" function body:

PHP Code:
global $dbhost,$dbusername,$dbpassword,$default_dbname;

I've tried the above but i keep getting the error if i use the code below.

<?php

require ('./../config.php');
    
    
    class database
    {    
        
                    
        function databaseConnection()
        {
             global $dbhost, $dbusername, $dbpassword, $default_dbname;
             $link_id = '';
            
            
            $link_id = mysql_pconnect($dbhost,$dbusername,$dbpassword);
            if (!$link_id){
                $MYSQL_ERRNO = 0;
                $MYSQL_ERROR = "Connection Failed to the host".$dbhost."";
                return 0;
            }
            else if (!mysql_select_db($default_dbname)){
                $MYSQL_ERRNO = mysql_errno();
                $MYSQL_ERROR = mysql_error();
                return 0;
            }
        }
}

?>

[crowden]

If a function is expecting parameters, don't you need to tell the function what parameters to expect?

I'm still fairly new at custom class/function writing, so apologies if I'm off base.

function databaseConnection($dbhost, $dbusername, $dbpassword, $default_dbname)
{
  //CODE
} 

[martinsandhu]

join the club i'm pretty new to. In this case i wouldn't as its just a database connection script with local parameters. Still don't understand why its not working though.

[Kayzio]

Try this:

<?php

    require ('./../config.php');

    class database
    {
        /*
        * Database Connection Variables
        */
        public dbHost = "";
        public dbUser = "";
        public dbPass = "";
        public dbName = "";

        /*
        * Database Connection Function
        */
        function databaseConnection()
        {
            $link_id = '';
            $link_id = mysql_pconnect($this->dbHost,$this->dbUser,$this->dbPass);
            if (!$link_id)
            {
                $MYSQL_ERRNO = 0;
                $MYSQL_ERROR = "Connection Failed to the host" . $this->dbHost;
                return 0;
            }
            else if (!mysql_select_db($this->dbName))
            {
                $MYSQL_ERRNO = mysql_errno();
                $MYSQL_ERROR = mysql_error();
                return 0;
            }
        }
    }

    /*
    * Set Database Variables In Class
    */
    $DB->dbHost = $dbhost;
    $DB->dbUser = $dbusername;
    $DB->dbPass = $dbpassword;
    $DB->dbName = $default_dbname;

    /*
    * Connect To Database
    */
    $DB->databaseConnection();

?>

You can keep your config file the same.