如果Bind Values等于Null则更改绑定值

Question

How I can achieve if the $_POST['sector'] is NULL , the bind value to be changed to 1

$stmt->bindValue(':sector', $_POST['sector'], PDO::PARAM_STR);

Answer 1

use this ternary condition, but you might want to use isset instead:

$stmt->bindValue(':sector', !is_null($_POST['sector']) ? $_POST['sector'] : "anotherValue", PDO::PARAM_STR);