7 replies to this topic

[Stasonix]

public function UpdateMatches()
{
if ($result = $this->mysqli->prepare('SELECT * FROM `table` WHERE id=? LIMIT 1'))
{
$result->bind_param("i",$this->ID);
$result->execute();
// fetching all to object or associative array
while ($data = $result->fetch_assoc())
{
$obj[] = $data;
}
$result->close();
}

print_r($obj);
}

this is always returns me an error: Call to undefined method mysqli_stmt::fetch_assoc()

[gregwarner]

The variable $result is of type mysqli_stmt, not mysqli_result. The mysqli_stmt class doesn't have a method "fetch_assoc()" defined for it.

You can get a mysqli_result object from your mysqli_stmt object by calling its get_result() method.

[Stasonix]

Thank you gregwarner.
So anyway, I need an example of how to do it.

[Stasonix]

Found myself:

public function UpdateMatches()
{
$query = "SELECT * FROM `mytable` WHERE id=$this->ID LIMIT 1";
if ($result = $this->mysqli->query($query))
{
$obj = $result->fetch_object();
}
var_dump($obj);
}

[gregwarner]

That method gets rid of your use of prepared statements. I would recommend you stick with prepared statements.

There are lots of examples on the PHP documentation pages:

http://www.php.net/m....get-result.php

Look at Example #1. Also, reference the class synopsis to learn how to use its methods. In your case, all you have to do is call the "get_result()" method on your statement object:

mysqli_stmt

{

...

/* Methods */

...

mysqli_result get_result ( void )

...

}

Like this:

if ($stmt = $this->mysqli->prepare('SELECT * FROM `table` WHERE id=? LIMIT 1'))
{
    $stmt->bind_param("i",$this->ID);
    $stmt->execute();

    // This line is what you were missing.
    $result = $stmt->get_result();

    // fetching all to object or associative array
    while ($data = $result->fetch_assoc())
    {
        ...
    }
    $result->close();
}

[Stasonix]

To be honest I can't run a code:

public function UpdateMatches()
{

$stmt=$this->mysqli->stmt_init();
if ($stmt = $this->mysqli->prepare("SELECT * FROM `table` WHERE `id`=? LIMIT 1"))
{
$stmt->bind_param("i",$this->ID);
$stmt->execute();
$result = $stmt->get_result();
while ($data = $result->fetch_assoc())
{
$obj[]=$data;
}
}

var_dump($obj);
}

it is always Fatal Error: Call to undefined method mysqli_stmt::get_result()
But my post before works great. Yes, but bind_param seems still required.

[gregwarner]

What version of PHP are you running? mysqli_stmt::get_result() is only available for versions >= 5.3.0
http://www.php.net/m....get-result.php

[Stasonix]

PHP v.5.2.16.
I understand. Will updating.