[TenFormer]

Hey all,

Well I have tried to find a solution for the following all day long now, but don`t seem to get anywhere.

Following situation:
I have a function file, one function is responsible for getting data from a table. Simple you might say first, but the problem is, that if I want to get a whole bunch of rows, I will have a hard time generalizing that. Usually I call everything in a for loop directly in the code, but this time I want to have something like this:

1. The code calls the function with the SQL logic
2. The function executes the SQL command and saves one row per array
3. The function returns all arrays
4. The code takes care of further manipulation


Now here is the thing: Assume I call all rows from a table where gender == male. Of course that will be multiple. Somehow my function will have to save all this in an array row[1],row[2],row[3],...Now that not being enough, it will have to return all rows, so eg. return row;

Now the code has to go through all valid rows, for example

PHP Code:

for($i = 0, isset($row . $i), $i++) {

.

.

.

} 

But I do not seem to figure out how to all this. Following shows where I currently stand:

PHP Code:

class datstr {



    //Queries DB

    function qryDb($logic, $count, $list) {

        if(!isset($logic) {

            return "ERROR: No logic transfered";

        }

        

        require("config.cfg.php");

        mysql_connect($this->dbhost, $this->dbuser, $this->dbpass) or die("Could not connect to database");

        mysql_select_db($this->db) or die("Could not find database table");

        $result = mysql_query($logic) or die("Error with Query logic:<br />" . mysql_error());

        

        /*

        //Requesting Count?

        if($count == 1) {

            $rows = mysql_num_rows($result);

            mysql_close();

            return array($result, $rows);

        } else {

            mysql_close();

            return $result;

        }

        */

        

        foreach($row = mysql_fetch_object($result)) {

            return array(extract($result, EXTR_PREFIX_ALL, 'row'));

        }

        

    } 

Can someone help me with this?

Thanks a lot
Max

[Nico]

I think Variable Variables is what you're looking for.

However, using arrays is often a better practice.

[Jay6390]

Hi max, do you mean that you want to return an array of rows?

PHP Code:

        $retvals = array(); //initialise array to hold data
        foreach($row = mysql_fetch_object($result)) {
            //Add row array to $retvals array
            $retvals[] = array(extract($result, EXTR_PREFIX_ALL, 'row'));
        }
        return $retvals; 

Something like this?
The problem with your initial code is that it was returning just the initial row, and not all rows

Jay

[TenFormer]

Thank you Jay, this was exactly what I was looking for...





One more problem though, how do I merge two variables (hard to say), what I mean is actually editing a variable name with a dynamic extension:

PHP Code:

        for($i = 0, isset($row . $i), $i++) {

            echo $row . $i;

        } 

esp. row 1 : $row . $i

If for example $row == "test" and $i == "1" I want to get $row1 == "test".


Hard to explain, someone gets what I mean?


Thanks for the wonderfull help, finally a good forum
Greetings,
Max

[Jay6390]

Yes, it is a little vague um i think its going to be ${$row.$i}, although to be honest, nico was right in saying that you should use an array rather than dynamic variables, as they can get out of control. it would be better stored in something like
$row['test1']
Oh, and welcome to the forums. yes they are really useful. A lot of good coders on here

Jay

[Nico]

EDIT: Jay beat me to it.

With variable variables (more info in my first post above - the link):

PHP Code:

echo ${'row' . $i}; 

[TenFormer]

And thanks again guys.

One more problem though:

PHP Code:

53:        for($i = 0, isset(${$row . $i}), $i++) {

54:            echo ${'row' . $i};  

55:        } 

produces output:

Code:

Parse error: syntax error, unexpected ')', expecting ';' in C:\WAMP\www\scrimmfinder\query.php on line 53

How would I do this whole thing with an array? I am kind of scared of what that would actually mean. What I actually want to do here, is read out every row on its own, stored in one part of an array like returned from the function above.

Thanks again,
Max

[Jay6390]

i think you want something more like this, although i cant stipulate enough how BAD it is to use variable variables

PHP Code:

foreach($row as $r)
{
    foreach($i as $j)
    {
        if(isset(${$r.$j}))
        {
            echo ${$r.$j};
        }
    }
} 

[TenFormer]

ok so before I try this, how would you do something like that with arrays? I don't really see how to do that.

[Jay6390]

To be able to demonstrate how best to use it for arrays, it might be best if you describe what it is that this loop is meant to do