Prepared Statement Not working

Question

if have a piece of code that is to hard for me to solve.. And i don't know how i can find the error more than this.

                while($this->_pathLus != $this->hoofdMap) { //loop works fine, tested and confirmd
                echo $this->_pathLus . 0; //$this->_pathLus = <data4>
                if ($stmtToegang = $db->prepare("SELECT <data>, <data2> FROM `<data3>` WHERE <data> = ? LIMIT 5")) {
                    $stmtToegang->bind_param("s",$this->_pathLus);

                    $stmtToegang->execute();

                    $stmtToegang->bind_result($<data>, $<data2>);

                    while ($stmtToegang->fetch()) {
                        echo $<data> . 1;

                        echo $stmtToegang->error . 2;

                    }
                } else { //to be sure if-stmt-prep is FALSE
                    echo $stmtToegang->error . 3;
                }
                $this->_pathLus = preg_replace("/(.*)\/(.*)\/(.*)\//", "$1/$2/", $this->_pathLus); // part of Loop and works
            }

What i did to find solution:

check if $stmtToegang is correct everywhere
check if the sql-select is correct
Check if _pathLus is correct
add else on if-stmt-prep to make sure is failed

Results:

<data4>03<data4>03<data4>03<data4>03<data4>03
<data4>03<data4>03<data4>03
<data4>03<data4>03<data4>03<data4>03
<data4>03<data4>03
<data4>03
<data4>03<data4>03

Note: <data>, <data2>, <data3> are replacements for this example

Thanks in advance

Edit: Correction

Edit:

mysqli_prepare() returns a statement object or FALSE if an error occurred.

But how get the error that Happens ?

If `` is an actual column name you might want to escape it using backticks ' ` ' (between the tab and esc key, used for inline code on SO). — x13, Nov 21 '15 at 11:01
@ThisNameBetterBeAvailable Thanks for your fast answer, and are actual column i use column name that cannot be conflicted. To be sure i backquoted the columns like you suggested with the same result. — , Nov 21 '15 at 11:05

score 1 · Accepted Answer · edited May 23 '17 at 11:51

How i did find the problem:

i altered echo $stmtToegang->error . 3; into echo $db->error . 3; This way i found the following error:

Commands out of sync; you can't run this command now

Where i found a solution: Answer here on SO

Problems was that this stmt-query (select type) was a part of another stmt-query (select type) because:

mysqli uses unbuffered queries by default (for prepared statements;)

So my code to debug a nested prepared statement (select-type) is as followed :

if($stmt = $mysqli->prepare($sql)) {
    <$stmt->bind_param()->execute()->bind_result() code>

    $stmt->store_result(); // store them !important

    while ($stmt->fetch()) {
        //code

        if($stmt2 = $mysqli->prepare($sql)) {
            <$stmt2->bind_param()->execute()->bind_result() code>

            $stmt2->store_result(); // store them !important

            while ($stmt2->fetch()) {
                //code
            }
            $stmt2->free_result(); // free them
            $stmt2->close(); // close them

            echo $stmt2->error; // report error
        }  else {
            echo $mysqli->error; // report error
        }
    }
    $stmt->free_result(); // free them
    $stmt->close(); // close them

    echo $stmt->error; // report error
} else {
    echo $mysqli->error; // report error
}

//edit: <$stmt->bind_param()->execute()->bind_result() code> for an better view

Hope it can help somone

Prepared Statement Not working

1 Answers1