KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I try to use variable binding like this: $stmt = $mysqli->prepare("UPDATE mytable SET myvar1=?, myvar2=... WHERE id = ?")) { $stmt->bind_param("ss...", $_POST['myvar1'], $_POST['myvar2']...); but some of the $_POST['...'] might be empty so I don't want to update them in the DB. It's not practical to take into account all the different combination of empty $_POST['...'] and although I can build the string " UPDATE mytable SET..." to my needs, bind_param() is a different beast. I could try building its call as a string and use eval() on it but it doesn't feel right :(
Tags (comma-separated)
Save Edits
Cancel