Neat little trick to bind a null value without using an if clause.<\/p>\n\n\n\n
How often have you done something like this when a variable might be null:<\/p>\n\n\n\n
$sql = \"SELECT * FROM someTable WHERE col1 = :firstVar\";\nif ($secondVar !== null) {\n $sql.= \" AND col2 = :secondVar\";\n}\n...\noci_bind_by_name($stmt, ':firstVar', $firstVar);\nif ($secondVar !== null) {\n oci_bind_by_name($stmt, ':secondVar', $secondVar);\n}<\/code><\/pre>\n\n\n\nThen checkout this, which is quite a bit shorter and a lot easier to read:<\/p>\n\n\n\n
$sql = \"SELECT * FROM someTable WHERE col1 = :firstVar\n AND (col2 = :secondVar OR :secondVar IS NULL)\";\n...\noci_bind_by_name($stmt, ':firstVar', $firstVar);\noci_bind_by_name($stmt, ':secondVar', $secondVar);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Neat little trick to bind a null value without using an if clause. How often have you done something like this when a variable might be null: $sql = “SELECT * FROM someTable WHERE col1 = :firstVar”; if ($secondVar !== null) { $sql.= ” AND col2 = :secondVar”; } … oci_bind_by_name($stmt, ‘:firstVar’, $firstVar); if ($secondVar … <\/p>\n