Help with DbConnector.php

[Chris_C2]

Hello,

I've been working on a CMS that utilizes a MySQL Database for storing information. However, I am running into an error and I can't figure it out for the life of me. Any help would be greatly appreciated!

Here's the error it get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/ccamaj/public_html/mm/includes/DbConnector.php on line 50

Here's my DbConnector.php

<?php
////////////////////////////////////////////////////////////////////////////////////////
// Class: DbConnector
// Purpose: Connect to a database, MySQL version
///////////////////////////////////////////////////////////////////////////////////////
require_once 'SystemComponent.php';

class DbConnector extends SystemComponent {

var $theQuery;
var $link;

//*** Function: DbConnector, Purpose: Connect to the database ***
function DbConnector(){

// Load settings from parent class
$settings = SystemComponent::getSettings();

// Get the main settings from the array we just loaded
$host = $settings['dbhost'];
$db = $settings['dbname'];
$user = $settings['dbusername'];
$pass = $settings['dbpassword'];

// Connect to the database
$this->link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
register_shutdown_function(array(&$this, 'close'));

}

//*** Function: query, Purpose: Execute a database query ***
function query($query) {
    $this->theQuery = $query;
    return mysql_query($query, $this->link);
}

//*** Function: getQuery, Purpose: Returns the last database query, for debugging ***
function getQuery() {
    return $this->theQuery;
}

//*** Function: getNumRows, Purpose: Return row count, MySQL version ***
function getNumRows($result){
    return mysql_num_rows($result);
}

//*** Function: fetchArray, Purpose: Get array of query results ***
function fetchArray($result) {
    return mysql_fetch_array($result);
}

//*** Function: close, Purpose: Close the connection ***
function close() {
    mysql_close($this->link);
}


}

?>

The DbConnector.php checks SystemProcedure.php for the database info, here's the coding in the SystemProcedure.php:

<?php
class SystemComponent {

var $settings;

function getSettings() {

// System variables
$settings['siteDir'] = '/usr/home/ccamaj/public_html/mm/';

// Database variables
$settings['dbhost'] = 'localhost';
$settings['dbusername'] = 'ccamaj_news';
$settings['dbpassword'] = 'news';
$settings['dbname'] = 'ccamaj_news';

return $settings;

}

}
?>

Again, thanks!
Chris

[laserlight]

1. No connection to the database server.
2. Failure to select a database.
3. Incorrect SQL query.

[kimandrel]

Not sure what you was trying to do, but your code was long and unecessary advanced.

Try using this code:

/* Connecting, selecting database */

// Adds file with username and password
require("../files/main/dbinfo.php");
mysql_connect("localhost","$UserName","$Password") or die ("Cant connect to db");
mysql_select_db("$Database") or die ("Cant select db");

/* Performing SQL query for "Ruter" */
$query = "SELECT RuteID, RuteNr, DepartureID, dep_ICAO, DepartureTime, departure_time, departure_minutt, ArrivalID, arr_ICAO, ArrivalTime, arrival_time, arrival_minutt, FlyType, inuse";

/* Prints results */
$result = mysql_query($query) or die("Query Ruter failed");

		 while ($row = mysql_fetch_array($result)){


// Ends php code -->

And dbinfo.php is like this

$user = "*";
$password = "**";
$database = "database12";
$hostname = "yoursite.com";
$filesdir = "files/main";
$UserName = "*";
$Password = "**";
$Database = "database12";
$Hostname = "yoursite.com";

where ** is you password and * your username