How to use rows of Mysql array in PHP function?

Question

I have a function in PHP and I would like to export an array from my MYSQL Database and then use the rows in a loop to do some stuff with them.

    $DB_Server = "XXX.XXX.XXX.XXX";
    $DB_Username = "XXXX";
    $DB_Password = "XXXXX";
    $DB_Database = "XXXXX";


    $conn = new mysqli($DB_Server, $DB_Username, $DB_Password, $DB_Database);

    $query = "Select Name, Wert from test.DBPBX";

function show(array $options) {
    global $showresult, $master, $conn, $query;
    $result = mysqli_query($conn, $query);

        while ($row = mysqli_fetch_assoc($result)) {
        $cnlongname =  $row["Name"];
        $usercontent = $row["Wert"];
        $cn = $cnlongname;
        $options['config']->value = 1;
        $config = $options["config"]->value;
        $show = new SimpleXMLElement("<show/>");
        $user = $show->addChild("user");
        $user->addAttribute("cn", $cn);
        if ($config)
            $user->addAttribute("config", "true");

        print "cmd: " . htmlspecialchars($show->asXML()) . "\n";

        $showresult = $master->Admin($show->asXML());
        print "result: " . htmlspecialchars($showresult) . "\n";

        $mod = "text=".$usercontent;
        $modify = new SimpleXMLElement("$showresult");

        $user = $modify->user;
        $path = explode("/device/hw/", $mod);
        $srch = $user;
        $nsegments = count($path);
        $i = 1;
        foreach ($path as $p) {
            if ($i == $nsegments) {
                // last part, the modification
                list($attr, $value) = explode("=", $p);
                $srch[$attr] = $value;
            } else {
                $srch = $srch->$p;
            }
            $i++;
        }
        $modify = new SimpleXMLElement("<modify>" . $user->asXML() . "</modify>");
        print "cmd: " . htmlspecialchars($cmd = $modify->asXML()) . "\n";

        // do it
        $result = $master->Admin($cmd);
        print "result: " . htmlspecialchars($result);
        }
    }

For $cn I would like to use $cnlongname (or $row["Name"]). And for $mod I would like to use $usercontent (or $row["Wert"]). However when I would like to use it I get an error after the first loop:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, string given in /sample.php on line 175

Line 175 is:

while ($row = mysqli_fetch_assoc($result)) {

Can you please help me?

The strange thing is, that the query works If I use it outside of the function. Also the first loop works, and after that the error display. Also error reporting doesn't show any errors. — triplus
– triplus, Commented Feb 23, 2015 at 13:16
possible duplicate of mysql_fetch_array() expects parameter 1 to be resource (or mysqli_result), boolean given — Jay Blanchard
– Jay Blanchard, Commented Feb 23, 2015 at 14:06
After further testing, I might have problems with the While Clause. If I declare a local array and use it in a foreach loop in the function it works. Very strange. And I even don't get any error messages. I'm trying it with PDO now. Maybe this might help. — triplus
– triplus, Commented Feb 23, 2015 at 14:28

sanados · Accepted Answer · 2015-02-23 14:54:37Z

1

Inside your while loop you overwrite your result, therefore you lose your mysql result and cannot query it any more.

// do it
$result = $master->Admin($cmd);

Use a different variable there. :)

answered Feb 23, 2015 at 14:54

sanados

1043 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

triplus Over a year ago

Thank you. I also tried it with PDO and this works fine as well and saves me some line of code ;)

Collectives™ on Stack Overflow

How to use rows of Mysql array in PHP function?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related