[Resolved] Variables and Classes - What's wrong?

[Tomz]

I am using a class to retrieve values from a database and store them in variables. I want to use these variable in the calling PHP. Doesn't work, variables are empty.

Am just starting to use classes in my code. This is probably a 'stupid' beginners mistake 🙂

The Class:

?php

class engine{

var $prf_name;
var $frm_addr;
var $frm_name;
var $reply_to;
var $smtpserv;
var $smtpport;
var $listname;
var $del;
var $active;

function engine(){
    include ('functions/connectdb.php');

    $this->tbl_user		= "user";
    $this->tbl_profile	= "profiles";
    $this->userid		= $_SESSION['userid'];
}


function get_profile(){



	// requires $this->profileno AS id

    $query = "SELECT * FROM $this->tbl_profile WHERE id=$this->userid ";

    $result = mysql_query($query);
    	if (!$result){die ("Error performing query1 " . mysql_error() );}

    while ($row = mysql_fetch_array($result) ){
    	$prf_name 	= $row["name"];
        $frm_addr	= $row["frm_addr"];
        $frm_name	= $row["frm_name"];
        $reply_to	= $row["reply_to"];
        $smtpserv	= $row["smtpserv"];
        $smtpport	= $row["smtpport"];
        $listname	= $row["list"];
        $del	 	= $row["delimiter"];
        $active		= $row["active"];
        }

}
}

The calling PHP file:

<?php
session_start();


// get form values

include ('classes/engine.php');

$cgetprofile = new engine;

$cgetprofile->profileno = 1;
$cgetprofile->get_profile();

?>

// below the variables from the class are supposed to be echo'ed...

Thanks!

[ahundiak]

$prf_name = $row["name"];
should be:
$this->prf_name = $row["name"];

Keep in mind that the way your code is written, only the last row in the query will be saved.

And hey, as long as you are using objects then try:
$row = mysql_fetch_object($result) ;
$this->prf_name = $row->name;

[Tomz]

Ohh yes... like I said... beginners mistake 😉

And hey, as long as you are using objects then try:
$row = mysql_fetch_object($result) ;
$this->prf_name = $row->name;

That's something I didn't know. Thanks! 🙂

Thomas