another simple class problem

[viveleroi0]

I have learned a lot with the last class I worked on, and it works great! But I am trying to understand how to do mysql querys with a class. I know the database connection part works fine, but I have two problems.

class Jazit_Database_Class
{
// Database Connect & Query Variables
var $J_DB_Host;
var $J_DB_User;
var $J_DB_Pass;
var $J_DB_Database;

	var $J_Query;
	var $New_Query_1;
	var $num;
	var $row;

function Jazit_DB_Connect($J_DB_Host,$J_DB_User,$J_DB_Pass,$J_DB_Database)
{
// Connect to Database
$this->$link=mysql_connect("$J_DB_Host","$J_DB_User","$J_DB_Pass");
if(!$this->$link)die("Failed Connecting to $J_DB_Database");
mysql_select_db("$J_DB_Database") or die("Could not open database");
}

function Jazit_Query_1($J_Query)
{
// Query the Database
$this->$New_Query_1=mysql_query("$J_Query");
$this->$num=mysql_num_rows($this->$New_Query_1);
 while($this->$row = mysql_fetch_array($this->$New_Query_1)) {
 echo $this->$row["UserName"];
 echo $this->$row["UserPass"];
 }
}

}

// Code to Display

$MySql_Connect = new Jazit_Database_Class;
$MySql_Connect->Jazit_DB_Connect("localhost","jazbot","Jzb80032","jazbot");
$MySql_Connect->Jazit_Query_1("SELECT * FROM Orders");

First of all, I get an error saying line 30 is not a valid mysql result resource. Line 30 is
$this->$num=mysql_num_rows($this->$New_Query_1);

Second, right now the echo of the query results is in the class... how would I use them outside of the class?

[dbchip2000]

Okay, first of all, I advise you to read the following article at DevShed - PHP it is a good diving board to learn about Classes.

Regarding this class...when you call the DB_Connect class function, you use the variable names that you define directly above the function. I think that you are thinking this will save them to those variables, but when you call a function, it creates it's own variables. You'd have to explicitly say $this->J_DB_Host=$J_DB_Host for them to both be the same.

Also, you are still referring to variables in the class as $this->$link. There should be no second $ sign. It should be $this->link. This is why you are getting the database error since $this->$link is null.

To find the User and Pass outside of the class you can refer to the variable as $MySql_Connect->row["UserName"] and $MySql_Connect->row["UserPass"]

I recommend you checking the link I gave for an intro