php bind parameters on SQL statement is not working

Question

I'm trying to do a select on php but I'm having problems passing bind parameters to a standard sql statement. I already have lost all my day with this and I can't find any solution. I have a sql statement and a parameter (this part is changing constantly)

Here I have my sql statement and the execution:

$mysqli=getDB();
    $stmt = $mysqli->prepare('SELECT nom from noms where id=?'); // cambiar select 
    $sql->bind_param($id);
    $result = $mysqli->query($sql);
    $results = array();
    while($row = mysqli_fetch_array($result)){
        $results[] = array( // modificar el que passa dintre del bucle
            'nom' => $row['nom']
         );
    }

   echo json_encode($results);

Here is how I connect with database (getDB()):

function getDB() {
    // Credencials
    $servername = "server";
    $username = "user";
    $password = "pswwd";
    $dbname = "database";


    $mysqli = new mysqli($servername, $username, $password, $dbname);
    if ($mysqli->connect_errno) {
        echo "Error al connectar: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
    }

    return $mysqli;

}

All this is actually a web service function, when I call it I get an 500 message error. I need to run the statement changing the $id value (this parameters come from outside). I'm only receiving a 500 error status from the JS console but I don't see any error message.

Edit:

I did a few changes on the statement and execution:

$mysqli=getDB();
        $stmt = $mysqli->prepare('SELECT nom from noms where id=?'); // cambiar select 
        $stmt ->bind_param($id);
        $result = $mysqli->query($stmt );
        $results = array();
        while($row = mysqli_fetch_array($result)){
            $results[] = array( // modificar el que passa dintre del bucle
                'nom' => $row['nom']
             );
        }

       echo json_encode($results);

The log still showing the same message: PHP Fatal error: Call to a member function bind_param() on a non-object

Funk Forty Niner · Accepted Answer · 2017-05-05 19:25:55Z

1

RTM: http://php.net/manual/en/mysqli-stmt.bind-param.php

The syntax is

$stmt->bind_param('types', $var1, $var2, etc....)

You only provided the $var1 portion, and forgot the types. You need to tell mysqli what TYPE your parameter is, e.g.

$stmt->bind_param('i', $id);
                  ^^^---missing in your version

And note that ANYtime you get a 500, you immediately go look at your webserver's error log for actual details. What you see in your browser is deliberately vague, since 500 errors can reveal core/configuration details that should never become public.

edited May 5, 2017 at 19:25

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Mar 8, 2016 at 15:19

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

3 Comments

jcobo1 Over a year ago

is not working but I will check the log's first. Thanks!

jcobo1 Over a year ago

I'm getting this message: PHP Fatal error: Call to a member function bind_param() on a non-object. So, I'm not using the bind_param() appropriately?

Marc B Over a year ago

that means your prepare call failed. e.g. you need to debug back up the call chain.

Collectives™ on Stack Overflow

php bind parameters on SQL statement is not working

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related