variety of values and convert to a boolean sql value

toSqlBoolean.php

<?php

function toSqlBoolean($value) {
    // Convert the value to a boolean first
    $booleanValue = filter_var($value, FILTER_VALIDATE_BOOLEAN, FILTER_NULL_ON_FAILURE);

    // Return SQL boolean equivalent
    return $booleanValue ? 1 : 0;
}





// Usage examples
echo toSqlBoolean(true);    // Outputs: 1
echo toSqlBoolean(false);   // Outputs: 0
echo toSqlBoolean("true");  // Outputs: 1
echo toSqlBoolean("false"); // Outputs: 0
echo toSqlBoolean("yes");   // Outputs: 1
echo toSqlBoolean("no");    // Outputs: 0
echo toSqlBoolean(1);       // Outputs: 1
echo toSqlBoolean(0);       // Outputs: 0
echo toSqlBoolean("1");     // Outputs: 1
echo toSqlBoolean("0");     // Outputs: 0
echo toSqlBoolean(null);    // Outputs: 0