PHP bind_params with null

Question

I am trying to bind params to a INSERT INTO MySQLi prepared statement if that variable exists, otherwise insert null.

This is what I have, but it is not working:

if (!empty($name)) {
    $result->bind_param('ss', $name, $url_friendly_name);
} else {
    $result->bind_param('ss', null, null);
}

if (!empty($description)) {
    $result->bind_param('s', $description);
} else {
    $result->bind_param('s', null);
}

Does anyone know of a better way of doing this or is there just a minor issue with my code. I am doing the above for each variable in the prepared statement.

Are you trying to leave a field out of the query if it is empty? — Explosion Pills
– Explosion Pills, Commented Mar 7, 2011 at 0:50
@tandu yeah if I can leave a field out, that would be work too. Do you have a better way of doing it? — ATLChris
– ATLChris, Commented Mar 7, 2011 at 3:53
You would have to conditionally construct the query .. I think that is what I would do though. I don't use mysqli (that is what you're using, right?) So I don't know so much in this case.. — Explosion Pills
– Explosion Pills, Commented Mar 7, 2011 at 3:56

Charles · Accepted Answer · 2011-03-07 01:52:31Z

4

bind_param works by reference. That means that it takes a variable, then uses the value of that variable in execute.

null is not a variable.

Try setting a variable to null and then binding that variable instead.

(Also consider using PDO instead of mysqli, where the execute method can take a simple array and you can bypass wacky binding methodology of mysqli.)

answered Mar 7, 2011 at 1:52

Charles

51.5k13 gold badges107 silver badges146 bronze badges

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

Comments

Justo · Accepted Answer · 2013-12-30 16:57:54Z

1

Keep in mind that you can't use bind_param twice, because the last statement will replace the first. Try to find a way to use bind_param just once.

answered Dec 30, 2013 at 16:57

Justo

1,9111 gold badge11 silver badges6 bronze badges

Collectives™ on Stack Overflow

PHP bind_params with null

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related