Okay Slight question,

I am working on a database class that will handle all information for users on one of my sites. And I would like to pass back to the main php script (not the class) the information from the SELECT query in my class. But with out adding in extra information

Current class return

PHP Code:

$subres = $this->query($res);
// echo "<br>";
// echo $subres;
$data = mysql_fetch_assoc($subres) or die(mysql_error());
global $cache ;
$data3 = serialize($data);
$cache = var_dump($data3,true);
return $data3; 


and gathering the info

PHP Code:

        $cache = explode(",",$cache);
        $print = sprintf("Username = %s <br> Password = %s",$cache[1],$cache[7]);
        $data2 = unserialize($data1);
        print_r($cache);
        $ndata = unserialize($data3);
        print_r($ndata); 


If i var_dump/export it passes the info but i am adding extra information that will be unpredictable to remove from the out put. and I tried serialize the info then unserialize the data back again wont work.

Any ideas how to get information from a class?

WTF is going on? Why don't you simply return an array or an object which represents a single record from your table and is a result of mysql_fetch_*() ? What are those *serialize() for?

OKay let me try and explain my crazy idiot logic here

I have a class, dbconnect.php that handles all my database queries, All the data gets inputed correctly and the query runs and gets the information.

And I was trying to find a way to get the data from the mysql_fetch_assoc function back to the script out side of the class. And when I try this

PHP Code:

        $subres = $this->query($res);
        $data = mysql_fetch_assoc($subres);
        
        return $data; 


All is i get is blank page with no data. but if I echo the $data in the class it will out put what i am looking for, but is still not accessible to the script out side of the class.

Var_export works but creates unanticipated data results. and makes it more dificult to replace the data with spaces or put into an array.

Very strange. Let me show you how I do it and everything works:

PHP Code:

$db = new DB();
$db->setup("localhost", "user", "pass", "dbname");
$sql = "select * from table where id > 10";
$objects = $db->fetch_objects($sql);
foreach ($objects as $o) {
   print "Name: {$o->name}<br />";
} 


DB class is attached. DB class contains methods to retrieve single value, array of values, single object and array of objects.

I still wondering why some people think classes useful.
Isnt this more simple?

PHP Code:

$db = db_connect("localhost", "user", "pass", "dbname"); 
$objects = arrayfromquery("select * from table where id > 10"); 
foreach ($objects as $key => $value) { 
   print "Name: {$value}<br />"; 
} 


Please be so kind to not call things useless only because you don't understand what they are made for.

Are we going to start a Einstein-bohr debate here?
Watch your dice, they are about to fall, if you want to always predict the results then just don't throw them, let that job for god

Its pretty clear, for me as long PHP runs on per request classes are completely redundant.

Its pretty clear, for me as long PHP runs on per request classes are completely redundant.

I could not object stronger as I do now.
If you think about your program before you actually write the code, classes have a monumental role to play.

I do nothing outside of classes, except calling classes methods, and since I took this way, my code became way more clear, re-usable, simpler to maintain and more organized.

The fact that it runs on a per request (fire and forget style) doesn't prevent this.
If you use the singleton design pattern for your classes, the state of your objects stay from calls to calls, and is way more elegant than several global variables.

OK, classes are the best... Happy now?
I can also say Bin Laden's america president too if you want...

I can also say Bin Laden's america president too if you want...

Do you always react like a spoiled child when someone have another opinion than you ?

My object oriented programming is not that strong, as I am more of a front-end developer, but every large, database driven site or application that I have ever worked in has used classes, not pure logic. It is much more logical, to me, from an organizational sense, to drive large sites with objects.

Originally Posted by ClaFanN1

Are we going to start a Einstein-bohr debate here?
Watch your dice, they are about to fall, if you want to always predict the results then just don't throw them, let that job for god

Its pretty clear, for me as long PHP runs on per request classes are completely redundant.

Originally Posted by ClaFanN1

OK, classes are the best... Happy now?
I can also say Bin Laden's america president too if you want...

IF you dont have anything constructive to my orginal question and are just looking start a flame war then stay out of it please.