使用pdo try / catch从函数返回值[关闭]

Question

I have a php function much like this:

function add($db, $value) { 
    try {
    $stmt = $db->prepare("INSERT INTO table(value) VALUES (?);");
    $stmt->execute(array($value));
}
catch(PDOException $e) {
    error_log($e->getMessage());
         // Error handeling
    }
}

If the query is successfull and there is no exception, shouldn't the function return TRUE?

The only way to get the function above return TRUE is if I modify the "try" section:

if ($stmt->execute(array($value))) {
return TRUE;
   }

What am I missing?

Answer 1

To quote the documentation:

If the return is omitted the value NULL will be returned.

Since NULL is evaluated as false in most contexts, then the answer is no, this function will not return TRUE unless you explicitly state it. E.g.:

function add($db, $value) { 
    try {
        $stmt = $db->prepare("INSERT INTO table(value) VALUES (?);");
        if ($stmt->execute(array($value))) {
            return TRUE;
        }
    }
    catch(PDOException $e) {
        error_log($e->getMessage());
        // Error handeling
    }
    // If we got here, the execute did not succeed
    return FALSE;
}