Server Side Includes

[cbesh2]

Can somebody tell me why I can't get this to work? I'm trying to use server side includes to keep from duplicating my code on multiple sites.

Here's my code:

Index.php FROM SITE (www.A.com)

<?php 
require_once (“http://www.b.com/DbConnector.php”);
?>

DbConnector.php FROM SITE (www.B.com)

<?php
require_once 'http://www.b.com/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);
}


}
?>

SystemComponent.php FROM SITE (www.B.com)

<?php
class SystemComponent {

var $settings;

function getSettings() {

// System variables
$settings['siteDir'] = 'http://www.a.com/';

// Database variables
$settings['dbhost'] = 'localhost';
$settings['dbusername'] = 'myusername';
$settings['dbpassword'] = 'mypassword';
$settings['dbname'] = 'nameofdatabase';

return $settings;

}

}
?>

Thanks for your help in advance.

[laserlight]

The thing is, once you involve URLs rather than file paths with the include/require family of constructs, the remote file is first parsed. In other words, you don't get the PHP script that you expect, but some HTML page. Read the PHP manual on [man]include[/man], in particular the section that talks about "URL fopen wrappers".

[NogDog]

(I must have started typing about the same time LL submitted his reply. 🙂 )

I did not take a close look at your code, but the first thing to consider is that including/requiring a file via a URL is not normally the same as including a file via the local file system. When you include a local file via a file system path (not via a URL), the source code is read into the including file and processed as though it was source code at that point in your script. When you call it via a URL, a HTTP request is sent, instead. In that case, the web server will process it as it would any other HTTP request, and only send the output. So assuming the web server considers it to be a PHP file, the including script will only receive the output from that script, as opposed to including the source PHP code at that point in the script.