Header is output before it should be

[Anon]

I'm having some puzzling issues regarding required / included files and the Header() function when used with classes. I have several self-contained classes, each in their own .php3 file. Each file contains ONLY that class and its member functions.

The classes work like a champ, but for some reason, even though the base classes don't output ANYTHING, there is always three to four lines of output sent to the browser.

I'm not sure where the output is coming from, but subsequent calls to Header (for instance, to send a picture) obviously fail.

Again, I'm very confused. I'm relatively new to using complex and multiple classes in PHP (I'm using version 3), and I'm rather baffled, because the class files don't include any functions that aren't members of the classes. Furthermore, they are sending output (blank lines) even if I don't create an instance of the class.

IE, If I include a file, say ... database.php3, and do NOT create a database object, it is sending output, even though all of the functions in the database.php3 file are members of the class, and I'm not using it.

I've checked the documentation -- and I'm still baffled. What is PHP (or am I) doing to output information without creating an object?

Some help would be appreciated.

Thanks.

--Anthony

[Anon]

Can you be more specific. Can you send part of your code?
And you cannot access none member method by your object (instant of your class).

[Anon]

Sure, some code ... here you go.

This is going to be messy, no tab's and all:

// file mysql_class.php3
<?

class MySQL {
	// Variables
	var $mysql_host;		
	var $mysql_database;
	var $mysql_user;
	var $mysql_pass;

	var $mysql_link;

	var $result;
	var $result_count;

	// MySQL Functions:
	//	MySQL ();
	//	SetHost ();
	//	Connect ();
	//	Disconnect ();
	//	Query ();
	//	Row_Count ();
	//	Row_Affected ();
	//	Row_Inserted ();
	//	Row ();
	//	Destroy_Query ();

	function MySQL ($dbHost = "") {
		// Set the Host
		$this->SetHost ($dbHost);
		$this->result_count = 0;
		$this->mysql_link = 0;
	}	// End of Constructor

	function SetHost ($dbHost) {
		$this->mysql_host = $dbHost;
	}	// End of SetHost ()

	function Connect ($dbName, $dbUserID, $dbPassWord, $persistant = false) {
		$this->mysql_database = $dbName;
		$this->mysql_user = $dbUserID;
		$this->mysql_pass = $dbPassWord;

		if ($persistant == false) {
			if (!($this->mysql_link = mysql_connect ($this->mysql_host, $this->mysql_user, $this->mysql_pass))) {
				return -1;
			} else {
				if (!mysql_select_db ($this->mysql_database, $this->mysql_link)) {
					return mysql_errno();
				}
			}
		} else {
			if (!($this->mysql_link = mysql_pconnect ($this->mysql_host, $this->mysql_user, $this->mysql_pass))) {
				return -1;
			} else {
				if (!mysql_select_db ($this->mysql_database, $this->mysql_link)) {
					return mysql_errno();
				}
			}
		}
	}	// End of Connect()

	function Query ($query) {
		// Query the database.  If successful, store pointer, and return it
		//	If failed, return -1
		if ($query) {
			if (!($this->result[$this->result_count++] = mysql_query ($query, $this->mysql_link))) {
				$this->result_count--;
				return 0;
			} else
				return $this->result[$this->result_count - 1];
		}
	}	// End of Query()

	function Row_Count ($result = -1) {
		if ($result == -1) {
			// Latest query
			if (($this->result_count - 1) >= 0)
				return mysql_num_rows ($this->result[$this->result_count - 1]);
		} else {
			// Another query
			if ($result <= $this->result_count)
				return mysql_num_rows ($this->result[$result]);
		}
	}	// End of Row_Count ()

	function Row_Affected ($result = -1) {
		return mysql_insert_id ($this->mysql_link);
	}	// End of Affected_Row ()

	function Row_Inserted () {
		return mysql_insert_id ($this->mysql_link);
	}	// End of Row_Inserted ()

	function Row ($result = -1) {
		if ($result == -1) {
			// Latest query
			if ($row = mysql_fetch_row ($this->result[$this->result_count - 1]))
				return $row;
			else
				return 0;
		} else {
			// Another query
			if ($result <= $this->result_count) {
				if ($row = mysql_fetch_row ($this->result[$result]))
					return $row;
				else
					return 0;
			}
		}		
	}	// End of Row ()

	function Row_Array ($result = -1) {
		if ($result == -1) {
			// Latest query
			if ($row = mysql_fetch_array ($this->result[$this->result_count - 1]))
				return $row;
			else
				return 0;
		} else {
			// Another query
			if ($result <= $this->result_count) {
				if ($row = mysql_fetch_array ($this->result[$result]))
					return $row;
				else
					return 0;
			}
		}		
	}	// End of Row ()

	function Row_Object ($result = -1) {
		if ($result == -1) {
			// Latest query
			if ($row = mysql_fetch_object ($this->result[$this->result_count - 1]))
				return $row;
			else
				return 0;
		} else {
			// Another query
			if ($result <= $this->result_count) {
				if ($row = mysql_fetch_object ($this->result[$result]))
					return $row;
				else
					return 0;
			}
		}		
	}	// End of Row_Object ()

	function Destroy_Query () {
		if ($this->result_count >= 0) {
			unset ($this->result[$this->result_count]);
			$this->result_count--;
			if ($this->result_count <= 0)
				$this->result_count = 0;
		}			
	}	// End of Destroy_Query ()

	function Disconnect () {
		if ($this->mysql_link)
			@mysql_close ($this->mysql_link);
	}	// End of DisConnect ()

}	// End of class MySQL definition

?>

// file database_class.php3
<?
class Database {
//
// Purpose:
// Wrapper for the database being used on the back end
// Version:
// .1
// Known Bugs:
// None.
//

	var $sql;

	function Database ($host, $db, $user, $pass, $persistant = false) {
		$this->sql = new MySQL ($host);
		if ($persistant == false)
			return ($this->sql->Connect ($db, $user, $pass, false));
		else
			return ($this->sql->Connect ($db, $user, $pass, true));
	} // End of Database ()

	function Query ($qry) {
		return ($this->sql->Query ($qry));
	} // End of Query ()

	function Size () {
		return ($this->sql->Row_Count ());
	} // End of Size ()

	function Affected () {
		return ($this->sql->Row_Affected ());
	} // End of Affected ()

	function Inserted () {
		return ($this->sql->Row_Inserted ());
	} // End of Inserted ()

	function Fetch () {
		return ($this->sql->Row ());
	} // End of Fetch ()

	function Fetch_Array () {
		return ($this->sql->Row_Array ());
	} // End of Fetch ()

	function Fetch_Object () {
		return ($this->sql->Row_Object ());
	} // End of Fetch ()

	function Backup () {
		return ($this->sql->Destroy_Query ());
	} // End of Backup ()

	function Disconnect () {
		return ($this->sql->Disconnect ());
	} // End of Disconnect ()

}	// End of Class Database	

?>

// A "master" include file
<?
$directory['home'] = "/home/glass/www/advertising/src/";
$directory['class'] = "classes/";

require ($directory['home'] . $directory['class'] . "mysql_class.php3");
require ($directory['home'] . $directory['class'] . "database_class.php3");
?>

// My "concerned" file
<?
//
// Functions for viewing the advertisements
//

require ("../classes/mysql_class.php3");

$dbUserID = "root";
$dbPassword = "";

$dbName = "USGlass";
$dbHost = "localhost";

$Advertising_Image_Table = "Advertisement_Image";

function View_Advertisement ($id) {
	global $dbHost, $dbName, $dbUserID, $dbPassword, $Advertising_Image_Table;

	$mysql = new MySQL ($dbHost);
	$mysql->Connect ($dbName, $dbUserID, $dbPassword);

	$query = "SELECT image_type, image_data FROM $Advertising_Image_Table WHERE id=$id";
	$mysql->Query ($query);

	$row = $mysql->Row_Object ();

	Header ("Content-type: $row->image_type");
	echo $row->image_data;
}

if ($id >= 0) {
	View_Advertisement ($id);
}	

?>

<b>If I include the the "master" include file, I get several lines of output (somewhere it's generating a header) -- regardless of whether or not I use the Database class. If I include ONLY the mysql_class.php3 file, it works like a champ.
</b>

Some help is appreciated ... I'm pretty confused.

[Anon]

Sure, some code ... here you go.

This is going to be messy, no tab's and all:

// file mysql_class.php3
<?

class MySQL {
	// Variables
	var $mysql_host;		
	var $mysql_database;
	var $mysql_user;
	var $mysql_pass;

	var $mysql_link;

	var $result;
	var $result_count;

	// MySQL Functions:
	//	MySQL ();
	//	SetHost ();
	//	Connect ();
	//	Disconnect ();
	//	Query ();
	//	Row_Count ();
	//	Row_Affected ();
	//	Row_Inserted ();
	//	Row ();
	//	Destroy_Query ();

	function MySQL ($dbHost = "") {
		// Set the Host
		$this->SetHost ($dbHost);
		$this->result_count = 0;
		$this->mysql_link = 0;
	}	// End of Constructor

	function SetHost ($dbHost) {
		$this->mysql_host = $dbHost;
	}	// End of SetHost ()

	function Connect ($dbName, $dbUserID, $dbPassWord, $persistant = false) {
		$this->mysql_database = $dbName;
		$this->mysql_user = $dbUserID;
		$this->mysql_pass = $dbPassWord;

		if ($persistant == false) {
			if (!($this->mysql_link = mysql_connect ($this->mysql_host, $this->mysql_user, $this->mysql_pass))) {
				return -1;
			} else {
				if (!mysql_select_db ($this->mysql_database, $this->mysql_link)) {
					return mysql_errno();
				}
			}
		} else {
			if (!($this->mysql_link = mysql_pconnect ($this->mysql_host, $this->mysql_user, $this->mysql_pass))) {
				return -1;
			} else {
				if (!mysql_select_db ($this->mysql_database, $this->mysql_link)) {
					return mysql_errno();
				}
			}
		}
	}	// End of Connect()

	function Query ($query) {
		// Query the database.  If successful, store pointer, and return it
		//	If failed, return -1
		if ($query) {
			if (!($this->result[$this->result_count++] = mysql_query ($query, $this->mysql_link))) {
				$this->result_count--;
				return 0;
			} else
				return $this->result[$this->result_count - 1];
		}
	}	// End of Query()

	function Row_Count ($result = -1) {
		if ($result == -1) {
			// Latest query
			if (($this->result_count - 1) >= 0)
				return mysql_num_rows ($this->result[$this->result_count - 1]);
		} else {
			// Another query
			if ($result <= $this->result_count)
				return mysql_num_rows ($this->result[$result]);
		}
	}	// End of Row_Count ()

	function Row_Affected ($result = -1) {
		return mysql_insert_id ($this->mysql_link);
	}	// End of Affected_Row ()

	function Row_Inserted () {
		return mysql_insert_id ($this->mysql_link);
	}	// End of Row_Inserted ()

	function Row ($result = -1) {
		if ($result == -1) {
			// Latest query
			if ($row = mysql_fetch_row ($this->result[$this->result_count - 1]))
				return $row;
			else
				return 0;
		} else {
			// Another query
			if ($result <= $this->result_count) {
				if ($row = mysql_fetch_row ($this->result[$result]))
					return $row;
				else
					return 0;
			}
		}		
	}	// End of Row ()

	function Row_Array ($result = -1) {
		if ($result == -1) {
			// Latest query
			if ($row = mysql_fetch_array ($this->result[$this->result_count - 1]))
				return $row;
			else
				return 0;
		} else {
			// Another query
			if ($result <= $this->result_count) {
				if ($row = mysql_fetch_array ($this->result[$result]))
					return $row;
				else
					return 0;
			}
		}		
	}	// End of Row ()

	function Row_Object ($result = -1) {
		if ($result == -1) {
			// Latest query
			if ($row = mysql_fetch_object ($this->result[$this->result_count - 1]))
				return $row;
			else
				return 0;
		} else {
			// Another query
			if ($result <= $this->result_count) {
				if ($row = mysql_fetch_object ($this->result[$result]))
					return $row;
				else
					return 0;
			}
		}		
	}	// End of Row_Object ()

	function Destroy_Query () {
		if ($this->result_count >= 0) {
			unset ($this->result[$this->result_count]);
			$this->result_count--;
			if ($this->result_count <= 0)
				$this->result_count = 0;
		}			
	}	// End of Destroy_Query ()

	function Disconnect () {
		if ($this->mysql_link)
			@mysql_close ($this->mysql_link);
	}	// End of DisConnect ()

}	// End of class MySQL definition

?>

// file database_class.php3
<?
class Database {
//
// Purpose:
// Wrapper for the database being used on the back end
// Version:
// .1
// Known Bugs:
// None.
//

	var $sql;

	function Database ($host, $db, $user, $pass, $persistant = false) {
		$this->sql = new MySQL ($host);
		if ($persistant == false)
			return ($this->sql->Connect ($db, $user, $pass, false));
		else
			return ($this->sql->Connect ($db, $user, $pass, true));
	} // End of Database ()

	function Query ($qry) {
		return ($this->sql->Query ($qry));
	} // End of Query ()

	function Size () {
		return ($this->sql->Row_Count ());
	} // End of Size ()

	function Affected () {
		return ($this->sql->Row_Affected ());
	} // End of Affected ()

	function Inserted () {
		return ($this->sql->Row_Inserted ());
	} // End of Inserted ()

	function Fetch () {
		return ($this->sql->Row ());
	} // End of Fetch ()

	function Fetch_Array () {
		return ($this->sql->Row_Array ());
	} // End of Fetch ()

	function Fetch_Object () {
		return ($this->sql->Row_Object ());
	} // End of Fetch ()

	function Backup () {
		return ($this->sql->Destroy_Query ());
	} // End of Backup ()

	function Disconnect () {
		return ($this->sql->Disconnect ());
	} // End of Disconnect ()

}	// End of Class Database	

?>

// A "master" include file
<?
$directory['home'] = "/home/glass/www/advertising/src/";
$directory['class'] = "classes/";

require ($directory['home'] . $directory['class'] . "mysql_class.php3");
require ($directory['home'] . $directory['class'] . "database_class.php3");
?>

// My "concerned" file
<?
//
// Functions for viewing the advertisements
//

require ("../classes/mysql_class.php3");

$dbUserID = "root";
$dbPassword = "";

$dbName = "USGlass";
$dbHost = "localhost";

$Advertising_Image_Table = "Advertisement_Image";

function View_Advertisement ($id) {
	global $dbHost, $dbName, $dbUserID, $dbPassword, $Advertising_Image_Table;

	$mysql = new MySQL ($dbHost);
	$mysql->Connect ($dbName, $dbUserID, $dbPassword);

	$query = "SELECT image_type, image_data FROM $Advertising_Image_Table WHERE id=$id";
	$mysql->Query ($query);

	$row = $mysql->Row_Object ();

	Header ("Content-type: $row->image_type");
	echo $row->image_data;
}

if ($id >= 0) {
	View_Advertisement ($id);
}	

?>

<b>If I include the the "master" include file, I get several lines of output (somewhere it's generating a header) -- regardless of whether or not I use the Database class, which I don't want. If I include ONLY the mysql_class.php3 file, it works like a champ.
</b>

Some help is appreciated ... I'm pretty confused.

[Anon]

I missed a post ... apparently I usually don't leave new-lines after the class and include files that I have, but for some reason, I left a single new line in one of my six included files ... which was causing the error. Guess you can't do that with a require() or include().