connecting PHP to MySQL via code

Question

I have a .ini file for a configuration of my database and a constructor as follows:

function PHPRestSQL($iniFile = 'phprestsql.ini') {

    $this->config = parse_ini_file($iniFile, TRUE);

    if (isset($_SERVER['REQUEST_URI']) && isset($_SERVER['REQUEST_METHOD'])) {

        if (isset($_SERVER['CONTENT_LENGTH']) && $_SERVER['CONTENT_LENGTH'] > 0) {
            $this->requestData = '';
            $httpContent = fopen('php://input', 'r');
            while ($data = fread($httpContent, 1024)) {
                $this->requestData .= $data;
            }
            fclose($httpContent);
        }

        $urlString = substr($_SERVER['REQUEST_URI'], strlen($this->config['settings']['baseURL']));
   $urlParts = explode('/', $urlString);

   $lastPart = array_pop($urlParts);
   $dotPosition = strpos($lastPart, '.');
   if ($dotPosition !== FALSE) {
    $this->extension = substr($lastPart, $dotPosition + 1);
    $lastPart = substr($lastPart, 0, $dotPosition);
   }
   array_push($urlParts, $lastPart);

   if (isset($urlParts[0]) && $urlParts[0] == '') {
    array_shift($urlParts);
   }

        if (isset($urlParts[0])) $this->table = $urlParts[0];
        if (count($urlParts) > 1 && $urlParts[1] != '') {
            array_shift($urlParts);
            foreach ($urlParts as $uid) {
                if ($uid != '') {
                    $this->uid[] = $uid;
                }
            }
        }

        $this->method = $_SERVER['REQUEST_METHOD'];

    }
}

After the constructor is set, it tries to connect with the database through the connect method

 function connect() {
            $database = $this->config['database']['type'];
            require_once($database.'.php');
            $this->db = new $database(); 
            if (isset($this->config['database']['username']) && isset($this->config['database']['password'])) {
                if (!$this->db->connect($this->config['database'])) {
                    trigger_error('Could not connect to server', E_USER_ERROR);
                }
            } elseif (isset($_SERVER['PHP_AUTH_USER']) && isset($_SERVER['PHP_AUTH_PW'])) {
       $this->config['database']['username'] = $_SERVER['PHP_AUTH_USER'];
       $this->config['database']['password'] = $_SERVER['PHP_AUTH_PW'];
                if (!$this->db->connect($this->config['database'])) {
                    $this->unauthorized();
                    exit;
                }
            } else {
                $this->unauthorized();
                exit;
            }
        }

Here's a part of my .ini file config:

[database]
type = "mysql"
;type = "postgresql"
server = "neighborme.db.7346057.hostedresource.com"
database = "neighborme"
;username = "dbusername"
;password = "dbpassword"
foreignKeyPostfix = "_uid"

am I doing something wrong in the .ini file that makes it so that it can't connect?

Why is this if statement not returning true:

if (isset($this->config['database']['username']) && isset($this->config['database']['password']))

The Surrican · Accepted Answer · 2011-01-25 00:14:54Z

2

well... maby because you have commented out username in your ini file?

try changing ;username = "dbusername" to username = "dbusername"

to be honest didnt really look much at the rest of the code because its so much. maby you can try to reduce it to the essential parts necessary to reproduce the problem?

however what i mentioned above was what i saw at first sight

answered Jan 25, 2011 at 0:14

The Surrican

30k24 gold badges127 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

aherlambang Over a year ago

also in the .ini file there is a [settings] baseURL = "/phprestsql", what should I put in here based on the constructor above

The Surrican Over a year ago

probably the path where your program has its bootstrap

Gajahlemu · Accepted Answer · 2011-01-25 00:16:39Z

1

Try to remove commented username and password line in your config.ini

[database]
type = "mysql"
;type = "postgresql"
server = "neighborme.db.7346057.hostedresource.com"
database = "neighborme"
;username = "dbusername"
username = "dbusername"
;password = "dbpassword"
password = "dbpassword"
foreignKeyPostfix = "_uid"

answered Jan 25, 2011 at 0:16

Gajahlemu

1,2637 silver badges17 bronze badges

Comments

Roger Halliburton · Accepted Answer · 2011-01-25 00:14:28Z

0

I would guess the leading semicolons (;) act as comment markers in the ini file. So your username and password are commented out.

answered Jan 25, 2011 at 0:14

Roger Halliburton

2,0213 gold badges15 silver badges19 bronze badges

Collectives™ on Stack Overflow

connecting PHP to MySQL via code

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related